This gorgeous 3,199 sq. ft. home is a dream come true! Nestled on a nearly 1/2 acre lot with an additional .13-acre parcel included, this property offers breathtaking views of the Siuslaw River from almost every room.The primary suite is a luxurious retreat, featuring cedar-lined dual walk-in closets, a tile shower, and a soaking tub. The heated tile floors in the primary and junior suite bathrooms add a touch of comfort. The main living areas showcase hand scraped hickory wood floors and an elegant arched entryway that leads to the stunning "River Room" with soaring 14-foot ceilings.The kitchen is a chef’s paradise, complete with limestone countertops, a Wolf range, and a SubZero refrigerator. A large bar area off the living room boasts Brazilian Cherry floors, perfect for entertaining. Some of the other features include an additional 400 sq ft of separate living quarters with studio bedroom ensuite bath as well as a kitchenette. A large executive office with custom built-ins and a copper tile ceiling, an enclosed courtyard, a wine cellar, and a built in hot tub room. With a 4-car garage and high-end finishes throughout, this property is both functional and breathtaking. Don’t miss your chance to own this one-of-a-kind home!
Rhododendron Dr N to Wildwinds. North on Marielle. Home at the end.
Dwelling Type: Residential
Subdivision: WILD WINDS
Year Built: 2002, County: US
Rhododendron Dr N to Wildwinds. North on Marielle. Home at the end.
Listing is courtesy of Coldwell Banker Coast Real Est
1 x Application (97.63%) | 465.21ms |
1 x Booting (2.34%) | 11.17ms |
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` = '24146355' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 616913 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/24146355" "PATH_INFO" => "/web/single-property/details/24146355" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/index.php/web/single-property/details/24146355" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REMOTE_PORT" => "1236" "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.141" "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" => "2587519-447-5" "H2_STREAM_ID" => "5" "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/24146355" "SCRIPT_URL" => "/index.php/web/single-property/details/24146355" "UNIQUE_ID" => "aG00WtawFXMzu1rHGJ2-GAAASg8" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php/web/single-property/details/24146355" "REQUEST_TIME_FLOAT" => 1751987290.2508 "REQUEST_TIME" => 1751987290 "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 => "Tue, 08 Jul 2025 15:08:10 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklodEFIaWFrMFhaSDV6a1UwTmExNVE9PSIsInZhbHVlIjoid1RlNnFLSDRIUWpVN1VwbGlOaFhLNnJiaHl0U05EaFUrdEIyaUtmdWsyL3UvdGdsSVVEM0hNTjBQbGE2TFVwY2dMRGtBT1RrY3hBUW9TSHRpMmRDRTlkQzdEYWhPTzdScmhJckg5cnBaUHIwRm83WFUvWFdRQmlRZjBiYjgxdGIiLCJtYWMiOiJiMjE4YzFlMzlhMjIyZTY3MzUyNGE3ZjViYzVkMjA2M2ExNWQwZTFmYzM3Y2E1OGVjNmM4NzJmZDI3M2IxNmRjIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 20:58:10 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IklodEFIaWFrMFhaSDV6a1UwTmExNVE9PSIsInZhbHVlIjoid1RlNnFLSDRIUWpVN1VwbGlOaFhLNnJiaHl0U05EaFUrdEIyaUtmdWsyL3UvdGdsSVVEM0hNTjBQbGE2TFVwY2dMRGtBT ▶" 1 => "us_metro_realty_session=eyJpdiI6ImlnaGxXOG1VdHlZaFc1VzdSZkN5WVE9PSIsInZhbHVlIjoic2xKRkk1SURNWktQaTkxenBEbTN4bzV3c0VabEZPcmxqZ015dWUxdEtVa2lpM2RFY1JKeWhsT0lWM2hQZkxRdmp3SUZsVEIxcU9DY3F2TGNwMHRhbjNyTXBUU2pwd2J6UFB6aHNKeWJBWTljWUszUkVMZFJNNlhtTnQrTXpSbWsiLCJtYWMiOiIxZjBmODU5YmE4ZDVmNzdmYmYzMjFhMGFmODg4MjAyODEwOThhOTE5MjJlMTdjODc2MzQ2ZGExMTM3ZTk5NzBjIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 20:58:10 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6ImlnaGxXOG1VdHlZaFc1VzdSZkN5WVE9PSIsInZhbHVlIjoic2xKRkk1SURNWktQaTkxenBEbTN4bzV3c0VabEZPcmxqZ015dWUxdEtVa2lpM2RFY1JKeWhsT0lWM2hQ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklodEFIaWFrMFhaSDV6a1UwTmExNVE9PSIsInZhbHVlIjoid1RlNnFLSDRIUWpVN1VwbGlOaFhLNnJiaHl0U05EaFUrdEIyaUtmdWsyL3UvdGdsSVVEM0hNTjBQbGE2TFVwY2dMRGtBT1RrY3hBUW9TSHRpMmRDRTlkQzdEYWhPTzdScmhJckg5cnBaUHIwRm83WFUvWFdRQmlRZjBiYjgxdGIiLCJtYWMiOiJiMjE4YzFlMzlhMjIyZTY3MzUyNGE3ZjViYzVkMjA2M2ExNWQwZTFmYzM3Y2E1OGVjNmM4NzJmZDI3M2IxNmRjIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 20:58:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IklodEFIaWFrMFhaSDV6a1UwTmExNVE9PSIsInZhbHVlIjoid1RlNnFLSDRIUWpVN1VwbGlOaFhLNnJiaHl0U05EaFUrdEIyaUtmdWsyL3UvdGdsSVVEM0hNTjBQbGE2TFVwY2dMRGtBT ▶" 1 => "us_metro_realty_session=eyJpdiI6ImlnaGxXOG1VdHlZaFc1VzdSZkN5WVE9PSIsInZhbHVlIjoic2xKRkk1SURNWktQaTkxenBEbTN4bzV3c0VabEZPcmxqZ015dWUxdEtVa2lpM2RFY1JKeWhsT0lWM2hQZkxRdmp3SUZsVEIxcU9DY3F2TGNwMHRhbjNyTXBUU2pwd2J6UFB6aHNKeWJBWTljWUszUkVMZFJNNlhtTnQrTXpSbWsiLCJtYWMiOiIxZjBmODU5YmE4ZDVmNzdmYmYzMjFhMGFmODg4MjAyODEwOThhOTE5MjJlMTdjODc2MzQ2ZGExMTM3ZTk5NzBjIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 20:58:10 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6ImlnaGxXOG1VdHlZaFc1VzdSZkN5WVE9PSIsInZhbHVlIjoic2xKRkk1SURNWktQaTkxenBEbTN4bzV3c0VabEZPcmxqZ015dWUxdEtVa2lpM2RFY1JKeWhsT0lWM2hQ ▶" ] ]
0 of 0array:4 [▼ "_token" => "01OQ0onIRnklnxpxwzkDRzhUIO3arzyG9oiq4vOW" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/index.php/web/single-property/details/24146355" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]