Fantastic location on a quiet neighborhood street combined with an excellent layout and space for everything! Within minutes to nearby schools, parks, and the Rose City Park and Golf Course. Gorgeous hardwood floors throughout the main and upper levels. Living and dining room space with tons of character, built-in features, and beautiful fireplace makes entertaining a dream. Main level primary bedroom with 3 additional bedrooms on the upper level. Super cool upper loft area perfect for home office. Spacious basement space with large laundry area, plenty of storage, and family room, perfect for a media room, craft room, or additional living space. Desirable exterior access to basement gives great potential for separate living space in the basement. Mud room entrance from the driveway is a rare and welcome feature. Excellent 1-car detached garage with attached tool shed. Watch the neighborhood go by from the front porch or enjoy some privacy in the fenced backyard, ready for your Summer touches. Absolutely a must see home! [Home Energy Score = 2. HES Report at https://rpt.greenbuildingregistry.com/hes/OR10239096]
NE Fremont St to NE 52nd Ave
Dwelling Type: Residential
Subdivision:
Year Built: 1923, County: US
NE Fremont St to NE 52nd Ave
Listing is courtesy of Redfin
1 x Application (97.21%) | 404.34ms |
1 x Booting (2.77%) | 11.54ms |
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` = '375037738' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 527193 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/375037738" "PATH_INFO" => "/web/single-property/details/375037738" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/375037738" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "22714" "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-632-9" "H2_STREAM_ID" => "9" "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/375037738" "SCRIPT_URL" => "/index.php/web/single-property/details/375037738" "UNIQUE_ID" => "aGep4g7IXnFVM0yWpKzgPwAAhgc" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/375037738" "REQUEST_TIME_FLOAT" => 1751624163.4279 "REQUEST_TIME" => 1751624163 "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 10:16:03 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImFnQ1BJcCtzMDhCbTNjai9vRE0rUXc9PSIsInZhbHVlIjoiK3RxVDVGMEh2VGlFeG5iNCtKcWp5ZmRkS1lqdHo2UDFJTVhoREFRSTJMWFFxdkNkTzRtcEVqWXB5QXdpbG5PVlMrYlgybnYzeFVKc3V4SEMvalhVMmVGTUJlbzZwbXAwbGRDQXcrK0F1OUpZRXN2bVJTNEw0YllkK2JSVUhwLzEiLCJtYWMiOiJkYzEzNjEyNmQyMDM4ZTMwOGRkZWMwOTFmZDliNTI0OTYzOTlkNTk3NjY5NmYyYmY3NGIyYWViZmQ3YzAwZWNlIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 16:06:03 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImFnQ1BJcCtzMDhCbTNjai9vRE0rUXc9PSIsInZhbHVlIjoiK3RxVDVGMEh2VGlFeG5iNCtKcWp5ZmRkS1lqdHo2UDFJTVhoREFRSTJMWFFxdkNkTzRtcEVqWXB5QXdpbG5PVlMrYlgyb ▶" 1 => "us_metro_realty_session=eyJpdiI6IjFVc2hHaG9oaG5GdWR0bG5IcTVjSkE9PSIsInZhbHVlIjoiNVpRUnEwY3Q5M3VsQzdLK2tLTXg2U1pUN1JhTUJ2ci9TNEUva3k0ZjNja1ZkTTRmcG5RaStTY3BVNUJJN3VUaTFRdmJaUWFsZXNEdU4wKytEVVUvcytGTWFJRGluRDEzOHpLOTFTL1ZvTC9vMmxQZjlJWGhrT2xhZUozTUxpWkIiLCJtYWMiOiJkOGZiM2ZjYzVjZjk1ZTRhY2JlMzIzZTVlN2ZkZGJlZDY0ZDA5YmM1MGM2NDJjMTQ3YWJjODYxYWU5MGMzMjI4IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 16:06:03 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IjFVc2hHaG9oaG5GdWR0bG5IcTVjSkE9PSIsInZhbHVlIjoiNVpRUnEwY3Q5M3VsQzdLK2tLTXg2U1pUN1JhTUJ2ci9TNEUva3k0ZjNja1ZkTTRmcG5RaStTY3BVNUJJ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImFnQ1BJcCtzMDhCbTNjai9vRE0rUXc9PSIsInZhbHVlIjoiK3RxVDVGMEh2VGlFeG5iNCtKcWp5ZmRkS1lqdHo2UDFJTVhoREFRSTJMWFFxdkNkTzRtcEVqWXB5QXdpbG5PVlMrYlgybnYzeFVKc3V4SEMvalhVMmVGTUJlbzZwbXAwbGRDQXcrK0F1OUpZRXN2bVJTNEw0YllkK2JSVUhwLzEiLCJtYWMiOiJkYzEzNjEyNmQyMDM4ZTMwOGRkZWMwOTFmZDliNTI0OTYzOTlkNTk3NjY5NmYyYmY3NGIyYWViZmQ3YzAwZWNlIiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 16:06:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImFnQ1BJcCtzMDhCbTNjai9vRE0rUXc9PSIsInZhbHVlIjoiK3RxVDVGMEh2VGlFeG5iNCtKcWp5ZmRkS1lqdHo2UDFJTVhoREFRSTJMWFFxdkNkTzRtcEVqWXB5QXdpbG5PVlMrYlgyb ▶" 1 => "us_metro_realty_session=eyJpdiI6IjFVc2hHaG9oaG5GdWR0bG5IcTVjSkE9PSIsInZhbHVlIjoiNVpRUnEwY3Q5M3VsQzdLK2tLTXg2U1pUN1JhTUJ2ci9TNEUva3k0ZjNja1ZkTTRmcG5RaStTY3BVNUJJN3VUaTFRdmJaUWFsZXNEdU4wKytEVVUvcytGTWFJRGluRDEzOHpLOTFTL1ZvTC9vMmxQZjlJWGhrT2xhZUozTUxpWkIiLCJtYWMiOiJkOGZiM2ZjYzVjZjk1ZTRhY2JlMzIzZTVlN2ZkZGJlZDY0ZDA5YmM1MGM2NDJjMTQ3YWJjODYxYWU5MGMzMjI4IiwidGFnIjoiIn0%3D; expires=Fri, 04-Jul-2025 16:06:03 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IjFVc2hHaG9oaG5GdWR0bG5IcTVjSkE9PSIsInZhbHVlIjoiNVpRUnEwY3Q5M3VsQzdLK2tLTXg2U1pUN1JhTUJ2ci9TNEUva3k0ZjNja1ZkTTRmcG5RaStTY3BVNUJJ ▶" ] ]
0 of 0array:4 [▼ "_token" => "UXlq75w1d6tbKlBRp5dyErw76jxBhqStpiwgXXuP" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/375037738" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]