Skip the long wait and step right into this newer Platinum-level Earth Advantage home, crafted by the award-winning Ichijo USA. This home is thoughtfully designed and impeccably maintained. From the moment you arrive, the sleek, modern exterior draws you in, leading to a bright and airy open concept living space. Strategically placed windows make the home feel expansive, while warm finishes and a cozy gas fireplace create an inviting ambiance—perfect for relaxing or entertaining. The kitchen offers quartz countertops, a spacious island, walk-in pantry, under-cabinet lighting, and stainless steel appliances. The open dining area flows effortlessly to the backyard through sliding glass doors, making indoor-outdoor living a breeze. Head upstairs to find a huge bonus flex space—ideal for a studio, gym, or home office—along with a convenient laundry room. The primary suite is a true haven, featuring Mt. Hood views, a spa-like ensuite with a soaking tub, walk-in shower, dual vanity, and his and her walk-in closets. With two additional bedrooms, a spacious loft, and a main-level den, you have endless possibilities for living, working, and entertaining. Out back, enjoy a low maintenance yard professionally landscaped by ValleyScapes and a covered patio—perfect for year round outdoor lounging. There is no shortage of storage here. From the oversized attached garage including hanging overhead storage to the countless closets inside. Designed with modern Japanese inspired elegance, this home features folding closet doors, dual-slide windows & doors, piano finish cabinets, and more. The amount of natural light and incredible views of Mt. Adams and the surrounding trees create a serene and picturesque setting, bringing the beauty of the outdoors inside.
172nd Ave, West on Huckleberry or Foster Rd South on 172nd to Huckleberry
Dwelling Type: Residential
Subdivision: Grand View Meadows
Year Built: 2021, County: US
172nd Ave, West on Huckleberry or Foster Rd South on 172nd to Huckleberry
Listing is courtesy of John L. Scott Portland Central
1 x Application (94.6%) | 454.12ms |
1 x Booting (5.35%) | 25.70ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
select * from `agents` where `id` is null limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `resoapi_properties` where `ListingId` = '293711402' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 622878 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:59 [▼ "USER" => "rootusmrcom" "HOME" => "/home/rootusmrcom" "PATH_TRANSLATED" => "redirect:/index.php/single-property/details/293711402" "PATH_INFO" => "/web/single-property/details/293711402" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/293711402" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "24794" "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.62" "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" => "3102308-255-7" "H2_STREAM_ID" => "7" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "usmetrorealty.com" "HTTPS" => "on" "SCRIPT_URI" => "https://usmetrorealty.com/index.php/web/single-property/details/293711402" "SCRIPT_URL" => "/index.php/web/single-property/details/293711402" "UNIQUE_ID" => "aG21YKJRRJO6cPOFGMGYvwAAlg4" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/293711402" "REQUEST_TIME_FLOAT" => 1752020320.8434 "REQUEST_TIME" => 1752020320 "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 => "Wed, 09 Jul 2025 00:18:40 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFDYVZueUR4UjUzWEo2d0h5NFk1Unc9PSIsInZhbHVlIjoiOFJrcmRiMWxYV1p4ZTRQTStMMVU3Q0dEU2lFaHQzek5ta3dXRjBUaElzMzJkOThKeUNMdjhCSnhOKzRxdkRYeXQyZ240SmZ6YnE5akhIOVBzYUkxdHhGRjY0dGlTaUxHNlZvbnc2dzgzbDVnVXZ6c3Q5RUQyendMck5YZ1BFT0kiLCJtYWMiOiI1MDc4ZDNlZjk0NzQwZDFlMjI3YjZmNDYzM2JhOGEwODg3OGI2OGQxY2U1OWUwOTkwZjg5ZmFhMDM3MDhmYTU5IiwidGFnIjoiIn0%3D; expires=Wed, 09-Jul-2025 06:08:41 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkFDYVZueUR4UjUzWEo2d0h5NFk1Unc9PSIsInZhbHVlIjoiOFJrcmRiMWxYV1p4ZTRQTStMMVU3Q0dEU2lFaHQzek5ta3dXRjBUaElzMzJkOThKeUNMdjhCSnhOKzRxdkRYeXQyZ240S ▶" 1 => "us_metro_realty_session=eyJpdiI6IjFzNVhsamNydUREdVJCU0NFdDRGQXc9PSIsInZhbHVlIjoiSU1xQk9xakozTGRlU2VBZFQvdmM1VDNSY3NFVG9NQ2JkRGVUZ1BqM0dHVXo0YkpWZmg5Mjg5bEFYcUxXVkpNS2lnM0VpQUtxQkR3MDhqamsveDN1anhaWk1vZHV5cHkwY1U5NEpkNGJ3R0VqODl6TElHZ2tqeW9FVjcxY2tWSGciLCJtYWMiOiIzZGE5NTEwZjBiMmM3MjFmMzNkZTNmOGQwNDBjNjBjOTk4MTY0YjM5NzQ3M2IyM2IxZmE5NzI0ZTE0ZjJjNWVlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Jul-2025 06:08:41 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IjFzNVhsamNydUREdVJCU0NFdDRGQXc9PSIsInZhbHVlIjoiSU1xQk9xakozTGRlU2VBZFQvdmM1VDNSY3NFVG9NQ2JkRGVUZ1BqM0dHVXo0YkpWZmg5Mjg5bEFYcUxX ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFDYVZueUR4UjUzWEo2d0h5NFk1Unc9PSIsInZhbHVlIjoiOFJrcmRiMWxYV1p4ZTRQTStMMVU3Q0dEU2lFaHQzek5ta3dXRjBUaElzMzJkOThKeUNMdjhCSnhOKzRxdkRYeXQyZ240SmZ6YnE5akhIOVBzYUkxdHhGRjY0dGlTaUxHNlZvbnc2dzgzbDVnVXZ6c3Q5RUQyendMck5YZ1BFT0kiLCJtYWMiOiI1MDc4ZDNlZjk0NzQwZDFlMjI3YjZmNDYzM2JhOGEwODg3OGI2OGQxY2U1OWUwOTkwZjg5ZmFhMDM3MDhmYTU5IiwidGFnIjoiIn0%3D; expires=Wed, 09-Jul-2025 06:08:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkFDYVZueUR4UjUzWEo2d0h5NFk1Unc9PSIsInZhbHVlIjoiOFJrcmRiMWxYV1p4ZTRQTStMMVU3Q0dEU2lFaHQzek5ta3dXRjBUaElzMzJkOThKeUNMdjhCSnhOKzRxdkRYeXQyZ240S ▶" 1 => "us_metro_realty_session=eyJpdiI6IjFzNVhsamNydUREdVJCU0NFdDRGQXc9PSIsInZhbHVlIjoiSU1xQk9xakozTGRlU2VBZFQvdmM1VDNSY3NFVG9NQ2JkRGVUZ1BqM0dHVXo0YkpWZmg5Mjg5bEFYcUxXVkpNS2lnM0VpQUtxQkR3MDhqamsveDN1anhaWk1vZHV5cHkwY1U5NEpkNGJ3R0VqODl6TElHZ2tqeW9FVjcxY2tWSGciLCJtYWMiOiIzZGE5NTEwZjBiMmM3MjFmMzNkZTNmOGQwNDBjNjBjOTk4MTY0YjM5NzQ3M2IyM2IxZmE5NzI0ZTE0ZjJjNWVlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Jul-2025 06:08:41 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IjFzNVhsamNydUREdVJCU0NFdDRGQXc9PSIsInZhbHVlIjoiSU1xQk9xakozTGRlU2VBZFQvdmM1VDNSY3NFVG9NQ2JkRGVUZ1BqM0dHVXo0YkpWZmg5Mjg5bEFYcUxX ▶" ] ]
0 of 0array:4 [▼ "_token" => "Dcvxs39qwxTLYtZJp6KTfRcbVyhOIYF1hA8NZOkL" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/293711402" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]