Full of charm and personality, this cozy home is anything but cookie cutter! From the moment you arrive, the inviting covered front porch sets the tone — a perfect spot to sip your morning coffee or unwind in the evening. Inside, the warm and welcoming living room features a pellet stove and natural light. Laminate flooring runs through the main areas, while three carpeted bedrooms offer quiet comfort. Plant lovers will adore the kitchen's garden window, ideal for growing herbs or soaking up the sunshine. The family room opens to the back patio, making it easy to flow from indoor relaxation to outdoor living. Step into the beautifully fenced backyard, where mature bushes and trees provide shade and serenity — perfect for gardening, lounging, or weekend gatherings. Recent updates include a new garage door and a new AC mini-split system for year-round comfort. This home is full of heart and soul—perfect for someone who values cozy spaces, natural light, and spending time in the yard. Don't miss out!
McGillivray to Blairmont Dr. South to 20th St, turn right, it turns into 146th Ave
Dwelling Type: Residential
Subdivision: Cascade South East
Year Built: 1979, County: US
McGillivray to Blairmont Dr. South to 20th St, turn right, it turns into 146th Ave
Listing is courtesy of Keller Williams Realty
1 x Application (97.24%) | 396.98ms |
1 x Booting (2.73%) | 11.14ms |
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` = '359821521' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 526817 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/359821521" "PATH_INFO" => "/web/single-property/details/359821521" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/359821521" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "7682" "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.214" "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" => "858148-36-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/359821521" "SCRIPT_URL" => "/index.php/web/single-property/details/359821521" "UNIQUE_ID" => "aGoTvbxEIN1ExxKPCZJaUAAAxQo" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/359821521" "REQUEST_TIME_FLOAT" => 1751782333.6709 "REQUEST_TIME" => 1751782333 "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 => "Sun, 06 Jul 2025 06:12:13 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IllQcHhjbUNZT2hGNUtUaTB6MEpodEE9PSIsInZhbHVlIjoiMGl3bUlDQlB2dUVUemQwWGNWUjJaR0VxRUVYb1VoZjMwRldqZlgwbFFGSEdwQUhpVjR2R3JyQ3drT3J5Y2U5U1gyeXZpTEYvVmlBTTZUNmFFSGJwVFVrMGV2YklVbGo1TDdkTWpDc1VGdVJ2djZDYVdNV09iU1UxazU2cHA1NTgiLCJtYWMiOiJkN2Q0ZjM3NGYxYWNkZGM0YTNkNDU5M2IwYjVmMTA2ODdkODY2ZGIxNzA4MjAzOGQ3ZDBmOWQ4MDQwYWM0MzcyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Jul-2025 12:02:14 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IllQcHhjbUNZT2hGNUtUaTB6MEpodEE9PSIsInZhbHVlIjoiMGl3bUlDQlB2dUVUemQwWGNWUjJaR0VxRUVYb1VoZjMwRldqZlgwbFFGSEdwQUhpVjR2R3JyQ3drT3J5Y2U5U1gyeXZpT ▶" 1 => "us_metro_realty_session=eyJpdiI6Im91UzFZd3FKdmhTZlZWajlxS2hvR1E9PSIsInZhbHVlIjoic1N2S1pOMmNvQXhoeWhuNk41YkZsekx4WWRTaEhHR1BNbml3dTN2OGl5SStVaFoyYjJZM1hqcy81NmVBa3kvWmE5SDUrNjBmSWpDL3QxdENobmY2OGo5TDArZWpQS21ReWI5emxSQkhic3cxOEhVVHJYWmczaG5LazVORFZwanYiLCJtYWMiOiIyODAzY2YzNjZhM2Q4N2RjNDk2NzlkMGI0NjdhNjRmYTM0Y2E5Mjc2Mjk1ZGNlZDAxOGMwNmQwM2YyNTFiNDY3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Jul-2025 12:02:14 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6Im91UzFZd3FKdmhTZlZWajlxS2hvR1E9PSIsInZhbHVlIjoic1N2S1pOMmNvQXhoeWhuNk41YkZsekx4WWRTaEhHR1BNbml3dTN2OGl5SStVaFoyYjJZM1hqcy81NmVB ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IllQcHhjbUNZT2hGNUtUaTB6MEpodEE9PSIsInZhbHVlIjoiMGl3bUlDQlB2dUVUemQwWGNWUjJaR0VxRUVYb1VoZjMwRldqZlgwbFFGSEdwQUhpVjR2R3JyQ3drT3J5Y2U5U1gyeXZpTEYvVmlBTTZUNmFFSGJwVFVrMGV2YklVbGo1TDdkTWpDc1VGdVJ2djZDYVdNV09iU1UxazU2cHA1NTgiLCJtYWMiOiJkN2Q0ZjM3NGYxYWNkZGM0YTNkNDU5M2IwYjVmMTA2ODdkODY2ZGIxNzA4MjAzOGQ3ZDBmOWQ4MDQwYWM0MzcyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Jul-2025 12:02:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IllQcHhjbUNZT2hGNUtUaTB6MEpodEE9PSIsInZhbHVlIjoiMGl3bUlDQlB2dUVUemQwWGNWUjJaR0VxRUVYb1VoZjMwRldqZlgwbFFGSEdwQUhpVjR2R3JyQ3drT3J5Y2U5U1gyeXZpT ▶" 1 => "us_metro_realty_session=eyJpdiI6Im91UzFZd3FKdmhTZlZWajlxS2hvR1E9PSIsInZhbHVlIjoic1N2S1pOMmNvQXhoeWhuNk41YkZsekx4WWRTaEhHR1BNbml3dTN2OGl5SStVaFoyYjJZM1hqcy81NmVBa3kvWmE5SDUrNjBmSWpDL3QxdENobmY2OGo5TDArZWpQS21ReWI5emxSQkhic3cxOEhVVHJYWmczaG5LazVORFZwanYiLCJtYWMiOiIyODAzY2YzNjZhM2Q4N2RjNDk2NzlkMGI0NjdhNjRmYTM0Y2E5Mjc2Mjk1ZGNlZDAxOGMwNmQwM2YyNTFiNDY3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Jul-2025 12:02:14 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6Im91UzFZd3FKdmhTZlZWajlxS2hvR1E9PSIsInZhbHVlIjoic1N2S1pOMmNvQXhoeWhuNk41YkZsekx4WWRTaEhHR1BNbml3dTN2OGl5SStVaFoyYjJZM1hqcy81NmVB ▶" ] ]
0 of 0array:4 [▼ "_token" => "LAqTuN3a1lJWMoModMtk47ZcaBVeuCnVAsNE8c8y" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/359821521" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]