This newly constructed custom home is located in a gated community on a level, nearly 10,000-square-foot lot. The two-story residence offers approximately 3,400 square feet of living space, including four bedrooms and three bathrooms. Interior features include real hardwood flooring throughout, a modern floating staircase, formal dining, butlers pantry and an open-concept layout with a floor-to-ceiling slate gas fireplace. The kitchen is equipped with a built-in Sub-Zero refrigerator, high-end appliances, and modern cabinetry. The primary suite includes a bathroom with heated tile floors, a soaking tub, and a walk-in closet. The upper level features a bonus room with a built-in microwave, sink, and mini fridge, along with three additional bedrooms, each with a walk-in closet. Additional features: Three-car garage with EV charging, advanced HVAC system, central vacuum, and professionally designed landscaping. Located near recreation, shopping, entertainment, and a sought-after school district, this is the perfect place to call home!
North on NE 139th St to NE 10th Ave. Left on 149th St. Turn right onto NW 12th Ave
Dwelling Type: Residential
Subdivision: Martin Meadow
Year Built: 2025, County: US
North on NE 139th St to NE 10th Ave. Left on 149th St. Turn right onto NW 12th Ave
Listing is courtesy of Cascadia Real Estate Group
1 x Application (97.4%) | 411.62ms |
1 x Booting (2.57%) | 10.84ms |
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` = '495806160' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 530428 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/495806160" "PATH_INFO" => "/web/single-property/details/495806160" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/495806160" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "7778" "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.63" "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" => "4071881-576-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/index.php/web/single-property/details/495806160" "SCRIPT_URL" => "/index.php/web/single-property/details/495806160" "UNIQUE_ID" => "aGh29DhobiHzII_CiazVbQABABg" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/495806160" "REQUEST_TIME_FLOAT" => 1751676660.3211 "REQUEST_TIME" => 1751676660 "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 => "Sat, 05 Jul 2025 00:51:00 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkkrTGhHWG04L1djV3VtdVhBMmN4Q0E9PSIsInZhbHVlIjoiT0hGdkQ1bVFDWkZ1NU92a1VXbVJWN3hYa0MzVVhvMXgxUktoWjVmOEhRc3pyR2xlZkh3YzVBZWhBMGRBcnhGUlk3TFJ5V29VNDNUTm9kRDVoc3hCcWNxMGNLNDNzZ0J4dHpBYmxvWWZHYmNrTm9rOGF1YWpZblJ6ZXBMQVAwTGYiLCJtYWMiOiJlMTM3NDQ2MzlmOWY3NzlmYmJiODQyMTQwOGQ4ZDVjYjMxMTgzZDc1Yjc5NzdkNTM0Y2E2YzhmZTRjZGEwMWY0IiwidGFnIjoiIn0%3D; expires=Sat, 05-Jul-2025 06:41:00 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkkrTGhHWG04L1djV3VtdVhBMmN4Q0E9PSIsInZhbHVlIjoiT0hGdkQ1bVFDWkZ1NU92a1VXbVJWN3hYa0MzVVhvMXgxUktoWjVmOEhRc3pyR2xlZkh3YzVBZWhBMGRBcnhGUlk3TFJ5V ▶" 1 => "us_metro_realty_session=eyJpdiI6IjNLVHZsa251N3BCRkNMVjc2NnVBVGc9PSIsInZhbHVlIjoiQnY2UkFsU1Q0UWlSZWxaTUZ5MnY1R3ZybjcwU1VOUDZ2azRCYXM4M3dIR2pWVWVwNkJGMlArRFBsUHlEM0ZFRzBmSnB5c3k2VlQzSlc0L2hodjJiRStreGRWTzluWTdHUURocnpuUTl2STlzZjFod0E5dFVjamhFZnNRY01rY3UiLCJtYWMiOiIxNjBlODU2MWI5NGY5N2ZlYTg0N2RhMjI5MmFiMjhiYzUyMTRkZTYzYWM1ZTdkYzMxZTViYjg4MDQzZWNjY2I3IiwidGFnIjoiIn0%3D; expires=Sat, 05-Jul-2025 06:41:00 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IjNLVHZsa251N3BCRkNMVjc2NnVBVGc9PSIsInZhbHVlIjoiQnY2UkFsU1Q0UWlSZWxaTUZ5MnY1R3ZybjcwU1VOUDZ2azRCYXM4M3dIR2pWVWVwNkJGMlArRFBsUHlE ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkkrTGhHWG04L1djV3VtdVhBMmN4Q0E9PSIsInZhbHVlIjoiT0hGdkQ1bVFDWkZ1NU92a1VXbVJWN3hYa0MzVVhvMXgxUktoWjVmOEhRc3pyR2xlZkh3YzVBZWhBMGRBcnhGUlk3TFJ5V29VNDNUTm9kRDVoc3hCcWNxMGNLNDNzZ0J4dHpBYmxvWWZHYmNrTm9rOGF1YWpZblJ6ZXBMQVAwTGYiLCJtYWMiOiJlMTM3NDQ2MzlmOWY3NzlmYmJiODQyMTQwOGQ4ZDVjYjMxMTgzZDc1Yjc5NzdkNTM0Y2E2YzhmZTRjZGEwMWY0IiwidGFnIjoiIn0%3D; expires=Sat, 05-Jul-2025 06:41:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkkrTGhHWG04L1djV3VtdVhBMmN4Q0E9PSIsInZhbHVlIjoiT0hGdkQ1bVFDWkZ1NU92a1VXbVJWN3hYa0MzVVhvMXgxUktoWjVmOEhRc3pyR2xlZkh3YzVBZWhBMGRBcnhGUlk3TFJ5V ▶" 1 => "us_metro_realty_session=eyJpdiI6IjNLVHZsa251N3BCRkNMVjc2NnVBVGc9PSIsInZhbHVlIjoiQnY2UkFsU1Q0UWlSZWxaTUZ5MnY1R3ZybjcwU1VOUDZ2azRCYXM4M3dIR2pWVWVwNkJGMlArRFBsUHlEM0ZFRzBmSnB5c3k2VlQzSlc0L2hodjJiRStreGRWTzluWTdHUURocnpuUTl2STlzZjFod0E5dFVjamhFZnNRY01rY3UiLCJtYWMiOiIxNjBlODU2MWI5NGY5N2ZlYTg0N2RhMjI5MmFiMjhiYzUyMTRkZTYzYWM1ZTdkYzMxZTViYjg4MDQzZWNjY2I3IiwidGFnIjoiIn0%3D; expires=Sat, 05-Jul-2025 06:41:00 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IjNLVHZsa251N3BCRkNMVjc2NnVBVGc9PSIsInZhbHVlIjoiQnY2UkFsU1Q0UWlSZWxaTUZ5MnY1R3ZybjcwU1VOUDZ2azRCYXM4M3dIR2pWVWVwNkJGMlArRFBsUHlE ▶" ] ]
0 of 0array:4 [▼ "_token" => "S4wRAapwP6rigs8OnxsvTvqanr81bmi66MT9oDOJ" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/495806160" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]