PRICE IMPROVEMENT!! Welcome to your dream retirement home in the desirable Sundance Golf community! Meticulously cared for and upgraded! 2-bedroom, 2-bathroom single-story retreat PLUS a versatile den perfect for a home office, craft room, or guest space tailored to fit your lifestyle. This home is energy-efficient with solar panels and a new HVAC system (2022). Modern touches include water-resistant laminate plank flooring, elegant plantation shutters, and 3 security doors for added peace of mind. The chef's kitchen has all you need, offering granite countertops, a Whirlpool flat-top stove and microwave, and ample storage to make cooking a joy.The primary suite is your personal sanctuary, complete with a cozy bay window, a spacious walk-in closet, and two linen closets. Step outside to a serene backyard paradise with a sparkling saltwater pool and a covered patio perfect for relaxing afternoons or lively gatherings. Located in a peaceful cul-de-sac, this home offers the best of retirement living, with access to golf, shopping, dining, entertainment, and everything the vibrant Sundance community has to offer. Homes like at this price don't lastCome tour today and start your next chapter in style!
Dwelling Type: Residential
Subdivision: SUNDANCE PARCEL 14
Year Built: 2007, County: US
Listing is courtesy of
1 x Application (99.17%) | 1.29s |
1 x Booting (0.82%) | 10.59ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
select * from `agents` where `id` is null limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `resoapi_properties` where `ListingId` = '6803881' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 153240 and `reso_property_saves`.`ListingId` is not null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "usmetrorealty.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] ]
0 of 0array:71 [▼ "USER" => "rootusmrcom" "HOME" => "/home/rootusmrcom" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/web/single-property/details/6803881" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6803881" "REMOTE_PORT" => "30403" "SCRIPT_FILENAME" => "/home/rootusmrcom/public_html/index.php" "SERVER_ADMIN" => "webmaster@usmetrorealty.com" "CONTEXT_DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "REMOTE_ADDR" => "3.14.83.200" "SERVER_PORT" => "443" "SERVER_ADDR" => "67.222.9.129" "SERVER_NAME" => "usmetrorealty.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶" "HTTP_X_HTTPS" => "1" "HTTP_HOST" => "usmetrorealty.com" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "3834349-211-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "usmetrorealty.com" "HTTPS" => "on" "SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/6803881" "SCRIPT_URL" => "/web/single-property/details/6803881" "UNIQUE_ID" => "aBk3k4_0t8d1Pzwd6VbWvQAAVRQ" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "3834349-211-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "usmetrorealty.com" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/6803881" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6803881" "REDIRECT_UNIQUE_ID" => "aBk3k4_0t8d1Pzwd6VbWvQAAVRQ" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746483091.1773 "REQUEST_TIME" => 1746483091 "argv" => [] "argc" => 0 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 05 May 2025 22:11:31 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVTTW12aHhZcWt5dXBzQS9ORTRYSXc9PSIsInZhbHVlIjoiYVE0VUtycUtmQ0JJSmRGYTNEelU4aFp4UnBrOFY0YlZDVGNRYXhYRmtLUVV5QWFVRGl1QXlHQUZUMEQraDhPdm5SazdEMTFIbkEyRTlmV0IxdkhiMzV5TVUrTVRCYldOa2lFMENiUUdaL296NFpENUc5M1p0UTVZOFg4Yk5hd1giLCJtYWMiOiJhYjVlZDQ1NDg0NjQ4YzZkYjU5OTc2YmU4OTk2NjQyOGVlYzMyNmIxMjg1ZjRhYWVhZWYwZmJiODk1Yzc5OGFjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:01:32 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVTTW12aHhZcWt5dXBzQS9ORTRYSXc9PSIsInZhbHVlIjoiYVE0VUtycUtmQ0JJSmRGYTNEelU4aFp4UnBrOFY0YlZDVGNRYXhYRmtLUVV5QWFVRGl1QXlHQUZUMEQraDhPdm5SazdEM ▶" 1 => "us_metro_realty_session=eyJpdiI6IjRxYWt3c0U0R2JURzFJTEM2QUMvMXc9PSIsInZhbHVlIjoiU2NRZGNQN2d0Q2JKSW1FelZHcVJsanFZVjFvdnFQWVQ5N0lDbzdrZlRTeUNDeE5mMjdyRzJvM2trdjJsd0xmKzNkWmMrOVBDbzZjL1g4NTFaT2JNOTZTczZjcGhGVCttNk9XRitmRUZWWlNqQVVtaWVMWnp5QVk5NHRTZUxibVIiLCJtYWMiOiIxYTlhZDY2MzFiMzlkYTY0OTZkZmRmYjRkYmQ4OWViZGZkYzk3ZGUzM2M5YzMwMDVmODY2MjE1OWMxMDU0ODgxIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:01:32 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IjRxYWt3c0U0R2JURzFJTEM2QUMvMXc9PSIsInZhbHVlIjoiU2NRZGNQN2d0Q2JKSW1FelZHcVJsanFZVjFvdnFQWVQ5N0lDbzdrZlRTeUNDeE5mMjdyRzJvM2trdjJs ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVTTW12aHhZcWt5dXBzQS9ORTRYSXc9PSIsInZhbHVlIjoiYVE0VUtycUtmQ0JJSmRGYTNEelU4aFp4UnBrOFY0YlZDVGNRYXhYRmtLUVV5QWFVRGl1QXlHQUZUMEQraDhPdm5SazdEMTFIbkEyRTlmV0IxdkhiMzV5TVUrTVRCYldOa2lFMENiUUdaL296NFpENUc5M1p0UTVZOFg4Yk5hd1giLCJtYWMiOiJhYjVlZDQ1NDg0NjQ4YzZkYjU5OTc2YmU4OTk2NjQyOGVlYzMyNmIxMjg1ZjRhYWVhZWYwZmJiODk1Yzc5OGFjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:01:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVTTW12aHhZcWt5dXBzQS9ORTRYSXc9PSIsInZhbHVlIjoiYVE0VUtycUtmQ0JJSmRGYTNEelU4aFp4UnBrOFY0YlZDVGNRYXhYRmtLUVV5QWFVRGl1QXlHQUZUMEQraDhPdm5SazdEM ▶" 1 => "us_metro_realty_session=eyJpdiI6IjRxYWt3c0U0R2JURzFJTEM2QUMvMXc9PSIsInZhbHVlIjoiU2NRZGNQN2d0Q2JKSW1FelZHcVJsanFZVjFvdnFQWVQ5N0lDbzdrZlRTeUNDeE5mMjdyRzJvM2trdjJsd0xmKzNkWmMrOVBDbzZjL1g4NTFaT2JNOTZTczZjcGhGVCttNk9XRitmRUZWWlNqQVVtaWVMWnp5QVk5NHRTZUxibVIiLCJtYWMiOiIxYTlhZDY2MzFiMzlkYTY0OTZkZmRmYjRkYmQ4OWViZGZkYzk3ZGUzM2M5YzMwMDVmODY2MjE1OWMxMDU0ODgxIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 04:01:32 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IjRxYWt3c0U0R2JURzFJTEM2QUMvMXc9PSIsInZhbHVlIjoiU2NRZGNQN2d0Q2JKSW1FelZHcVJsanFZVjFvdnFQWVQ5N0lDbzdrZlRTeUNDeE5mMjdyRzJvM2trdjJs ▶" ] ]
0 of 0array:4 [▼ "_token" => "lRRLRvt3L4GA2XkJP54C2TQWcrgxMhQIlb2m3Cpm" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6803881" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]