Prime golf course lot with breathtaking mountain views, a sparkling pool, and a newly renovated interior! VA assumable loan. Our Preferred Lender is offering a 1-0 buy down on this property for qualified buyers! This exceptional 4-bedroom, 3-bath home features a spacious kitchen with ample counter space and storage, an oversized family room perfect for entertaining, and a large loft offering additional versatile living space. With one bedroom and a full bath conveniently located downstairs, this home is designed for both comfort and functionality. The expansive backyard is an outdoor oasis, ideal for relaxation or gatherings. Don't miss this rare opportunity!
Head east on N Sundance Pkwy toward S 228th Ave, turn left to Van Buren St, turn left to N 224th Ave, turn left to W Adams St, turn right to N 224th Ln, turn left to W Woodlands Ave, prop. on left
Dwelling Type: Residential
Subdivision: SUNDANCE PARCEL 17
Year Built: 2005, County:
Head east on N Sundance Pkwy toward S 228th Ave, turn left to Van Buren St, turn left to N 224th Ave, turn left to W Adams St, turn right to N 224th Ln, turn left to W Woodlands Ave, prop. on left
Listing is courtesy of Realty ONE Group
1 x Application (98.12%) | 1.04s |
1 x Booting (1.42%) | 15.15ms |
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` = '6828003' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 553304 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 `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/6828003" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6828003" "REMOTE_PORT" => "59816" "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" => "216.73.216.100" "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" => "3305910-1277-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/6828003" "SCRIPT_URL" => "/web/single-property/details/6828003" "UNIQUE_ID" => "aGfdnw7IXnFVM0yWpKwY5AAAkQw" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "3305910-1277-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/6828003" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6828003" "REDIRECT_UNIQUE_ID" => "aGfdnw7IXnFVM0yWpKwY5AAAkQw" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1751637407.5571 "REQUEST_TIME" => 1751637407 "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 => "Fri, 04 Jul 2025 13:56:47 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndQbk0xMjBPT09CWVVLSldjUzZ3Mnc9PSIsInZhbHVlIjoiSTRxUUc4eUtHZ1c2NmFRTm5HR2drWldPL043R0s2U2UwNUZJQTNUYjFYZWt0ZDEvV1N6b1U5aGJJcUhQTVFhbW9laVk5dk52YmErbmU5VnduWkcvSTYxd2hrTXBQWWNjeTc5akx6WFIyUlowR3JZOEYxNUtUNVF6UE50TElWdW0iLCJtYWMiOiJmZjNjYTk1Y2MyZGI0MTBlNTAxYmY1YzlmMGEyOTJiZWZmYTkwYjMwNGFkYjI2Mzc1NzZiZWUzZDk0ZTRmM2IwIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 19:46:48 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IndQbk0xMjBPT09CWVVLSldjUzZ3Mnc9PSIsInZhbHVlIjoiSTRxUUc4eUtHZ1c2NmFRTm5HR2drWldPL043R0s2U2UwNUZJQTNUYjFYZWt0ZDEvV1N6b1U5aGJJcUhQTVFhbW9laVk5d ▶" 1 => "us_metro_realty_session=eyJpdiI6InRxT1lFV0ZTZm1sZXp1c3RQRWx2MFE9PSIsInZhbHVlIjoieVpaQ1V0UTgwZmc5Q0dGM3RXait5TytSdTRJQldsWEhJUlBJSE1aQldKQ0hiU200QmIwVFUxZU9kVHREeE1LTUlFdDJsT2pOdVUrNVNMVWUyc0QzTnlpQjNXeTFHUnZ0cFFxV3pkV3R1em9tUE55N3NROGhVa0VScHB4ZXlkem0iLCJtYWMiOiI3MDU3ZTJlZmJhMTc0YzZjNTAzNTZmYmFmMWIwZDg0NTMwMzk4NmNlNjc2YjQxZWVkZTE4NGZmNTY5M2QxMjYzIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 19:46:48 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6InRxT1lFV0ZTZm1sZXp1c3RQRWx2MFE9PSIsInZhbHVlIjoieVpaQ1V0UTgwZmc5Q0dGM3RXait5TytSdTRJQldsWEhJUlBJSE1aQldKQ0hiU200QmIwVFUxZU9kVHRE ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndQbk0xMjBPT09CWVVLSldjUzZ3Mnc9PSIsInZhbHVlIjoiSTRxUUc4eUtHZ1c2NmFRTm5HR2drWldPL043R0s2U2UwNUZJQTNUYjFYZWt0ZDEvV1N6b1U5aGJJcUhQTVFhbW9laVk5dk52YmErbmU5VnduWkcvSTYxd2hrTXBQWWNjeTc5akx6WFIyUlowR3JZOEYxNUtUNVF6UE50TElWdW0iLCJtYWMiOiJmZjNjYTk1Y2MyZGI0MTBlNTAxYmY1YzlmMGEyOTJiZWZmYTkwYjMwNGFkYjI2Mzc1NzZiZWUzZDk0ZTRmM2IwIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 19:46:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndQbk0xMjBPT09CWVVLSldjUzZ3Mnc9PSIsInZhbHVlIjoiSTRxUUc4eUtHZ1c2NmFRTm5HR2drWldPL043R0s2U2UwNUZJQTNUYjFYZWt0ZDEvV1N6b1U5aGJJcUhQTVFhbW9laVk5d ▶" 1 => "us_metro_realty_session=eyJpdiI6InRxT1lFV0ZTZm1sZXp1c3RQRWx2MFE9PSIsInZhbHVlIjoieVpaQ1V0UTgwZmc5Q0dGM3RXait5TytSdTRJQldsWEhJUlBJSE1aQldKQ0hiU200QmIwVFUxZU9kVHREeE1LTUlFdDJsT2pOdVUrNVNMVWUyc0QzTnlpQjNXeTFHUnZ0cFFxV3pkV3R1em9tUE55N3NROGhVa0VScHB4ZXlkem0iLCJtYWMiOiI3MDU3ZTJlZmJhMTc0YzZjNTAzNTZmYmFmMWIwZDg0NTMwMzk4NmNlNjc2YjQxZWVkZTE4NGZmNTY5M2QxMjYzIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 19:46:48 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6InRxT1lFV0ZTZm1sZXp1c3RQRWx2MFE9PSIsInZhbHVlIjoieVpaQ1V0UTgwZmc5Q0dGM3RXait5TytSdTRJQldsWEhJUlBJSE1aQldKQ0hiU200QmIwVFUxZU9kVHRE ▶" ] ]
0 of 0array:4 [▼ "_token" => "zQMQGth19yVgj1Thzs7WyCP0734Mq4VqvCr1Ruos" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6828003" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]