Experience the beauty of riverfront living in this unique 3-story condo just 8 minutes from town! Featuring 2 bedrooms, 1.5 baths, and a flexible bonus loft perfect for a home office, guest space, or creative studio, this home offers comfort, convenience, and incredible natural surroundings.A standout feature of this property is the enclosed front sitting area—the only unit in the community with a completely covered patio overlooking the Umpqua River. Enjoy year-round relaxation in this private space, whether you're sipping morning coffee, watching the sunset, or soaking in the peaceful views.Outdoor enthusiasts will love the private boat slip, RV parking, and immediate access to world-class fishing just steps from your door.Whether you're looking for a full-time home, weekend retreat, or investment opportunity, this riverfront gem delivers unmatched charm and location.Don’t miss your chance to own the only unit with a completely covered patio in this serene Umpqua River community!
Head East On OR-38 E For 8 Miles Location On The Left Of Main Highway
Dwelling Type: Residential
Subdivision:
Year Built: 1980, County: US
Head East On OR-38 E For 8 Miles Location On The Left Of Main Highway
Listing is courtesy of Central Coast Realty
1 x Application (96.16%) | 453.30ms |
1 x Booting (3.79%) | 17.88ms |
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` = '262477528' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 483075 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/262477528" "PATH_INFO" => "/web/single-property/details/262477528" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/262477528" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "22076" "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.243" "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" => "2641407-202-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/262477528" "SCRIPT_URL" => "/index.php/web/single-property/details/262477528" "UNIQUE_ID" => "aGZsRn8r4WECHv7qdqD9XAAADhE" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/262477528" "REQUEST_TIME_FLOAT" => 1751542854.2773 "REQUEST_TIME" => 1751542854 "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 => "Thu, 03 Jul 2025 11:40:54 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlNKTjhwOThEU2U0RjRnMTBsOGVjb3c9PSIsInZhbHVlIjoiQmhmbVF5VlpSaGluM0dkOXJTY2xJQy91c0ZicFY4bXFycUxvWGtTTGFGVmVLRVFaS292V2dmR1lXQ2llTlo4TmVwWnpvR0NGOFQ1UHVPWjdIUGxEdTJMWHd1QzRRYllUbW1GanovblhSOXNXU0FPUXd0Znkyd1V4bUtpL1oxY0oiLCJtYWMiOiJhZGMzNWQ3MzZkZDc0NzA2ODdmOWU5NWNhMTI1NWJjNjM2YmUwYWU3ZWViMTZhMjA5N2Y3M2MzYzZkYWQ3NjNlIiwidGFnIjoiIn0%3D; expires=Thu, 03-Jul-2025 17:30:54 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlNKTjhwOThEU2U0RjRnMTBsOGVjb3c9PSIsInZhbHVlIjoiQmhmbVF5VlpSaGluM0dkOXJTY2xJQy91c0ZicFY4bXFycUxvWGtTTGFGVmVLRVFaS292V2dmR1lXQ2llTlo4TmVwWnpvR ▶" 1 => "us_metro_realty_session=eyJpdiI6InViUW9GUmdqSU9WRHNQdXF6NXVVVUE9PSIsInZhbHVlIjoibWFFcDlxcU13eWJEMmNENGYzb1lsTVcxT1BLQWNmeWYvNXkrYjdwOUpRSjd0OWJUUGhHT0JBeGxmaEorS3RCQWQ3NEdaNGtsL3o0eXN2SDloajkzQytVZ3kwTnh3anQ5QVluUnVYNXlXV2Urc0NwYTdlVnYrRmU2Q0xMTDUvWTMiLCJtYWMiOiJjMTlkOGI0NjM2NDNlMzc2NjNhNWNlOTBiMTI4M2UyNmU2Mzg3NDZhNWEwODE4YmNhOGVhNDFiYWE5ZTJjNzYyIiwidGFnIjoiIn0%3D; expires=Thu, 03-Jul-2025 17:30:54 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6InViUW9GUmdqSU9WRHNQdXF6NXVVVUE9PSIsInZhbHVlIjoibWFFcDlxcU13eWJEMmNENGYzb1lsTVcxT1BLQWNmeWYvNXkrYjdwOUpRSjd0OWJUUGhHT0JBeGxmaEor ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlNKTjhwOThEU2U0RjRnMTBsOGVjb3c9PSIsInZhbHVlIjoiQmhmbVF5VlpSaGluM0dkOXJTY2xJQy91c0ZicFY4bXFycUxvWGtTTGFGVmVLRVFaS292V2dmR1lXQ2llTlo4TmVwWnpvR0NGOFQ1UHVPWjdIUGxEdTJMWHd1QzRRYllUbW1GanovblhSOXNXU0FPUXd0Znkyd1V4bUtpL1oxY0oiLCJtYWMiOiJhZGMzNWQ3MzZkZDc0NzA2ODdmOWU5NWNhMTI1NWJjNjM2YmUwYWU3ZWViMTZhMjA5N2Y3M2MzYzZkYWQ3NjNlIiwidGFnIjoiIn0%3D; expires=Thu, 03-Jul-2025 17:30:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlNKTjhwOThEU2U0RjRnMTBsOGVjb3c9PSIsInZhbHVlIjoiQmhmbVF5VlpSaGluM0dkOXJTY2xJQy91c0ZicFY4bXFycUxvWGtTTGFGVmVLRVFaS292V2dmR1lXQ2llTlo4TmVwWnpvR ▶" 1 => "us_metro_realty_session=eyJpdiI6InViUW9GUmdqSU9WRHNQdXF6NXVVVUE9PSIsInZhbHVlIjoibWFFcDlxcU13eWJEMmNENGYzb1lsTVcxT1BLQWNmeWYvNXkrYjdwOUpRSjd0OWJUUGhHT0JBeGxmaEorS3RCQWQ3NEdaNGtsL3o0eXN2SDloajkzQytVZ3kwTnh3anQ5QVluUnVYNXlXV2Urc0NwYTdlVnYrRmU2Q0xMTDUvWTMiLCJtYWMiOiJjMTlkOGI0NjM2NDNlMzc2NjNhNWNlOTBiMTI4M2UyNmU2Mzg3NDZhNWEwODE4YmNhOGVhNDFiYWE5ZTJjNzYyIiwidGFnIjoiIn0%3D; expires=Thu, 03-Jul-2025 17:30:54 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6InViUW9GUmdqSU9WRHNQdXF6NXVVVUE9PSIsInZhbHVlIjoibWFFcDlxcU13eWJEMmNENGYzb1lsTVcxT1BLQWNmeWYvNXkrYjdwOUpRSjd0OWJUUGhHT0JBeGxmaEor ▶" ] ]
0 of 0array:4 [▼ "_token" => "eweWxy4C3YD1Ly1o10UZ7dliLKSxO9eyzfKxZBxF" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/262477528" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]