Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2210 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2210 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2210 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

346 Winchuck River Rd
Brookings, OR 97415
Joy Wells with eXp Realty, LLC, original listing - (888) 814-9613

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5582 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 814-9613

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Outstanding quality and a spectacular custom home nestled 4 miles up the Winchuck river, and only 10 minutes to town. This warm and sunny location offers coastal country living with all the amenities and out of the fog. Boasting a colossal gourmet kitchen w/40' Italian 6 burner Dual-Fuel range with two ovens, an eat-at island, trash compactor, garden window, and tons of storage. One-of-a-kind 5 bedroom, 4.5 bath estate is like Disney Land for the entire family. With three Master En Suites and two additional bedrooms, there's room for everyone. Vaulted & tall 9' ceilings with custom trim and doors throughout. Private patios, decks, and covered porches all around. Downstairs you'll find a Professional Home Theatre with sound system, a 96" screen that comes complete with 6 leather recliners and elevated seating. A second Great Room that's 43' X 26' with large windows capturing all the natural light, a wine storage room with mini fridge, and additional flex area that's pre-plumed for a second kitchen & laundry should anyone want to add it. Outside you have your own personal putting green with tee box, and a Marquis 17' Aquatic swim spa with Covana electric cover. Salmon & Steelhead fishing from your back yard, fantastic garden w/raised planters, mature blueberry patch, a chicken coup, three exterior sheds with lights and power to each, and plenty of room to roam. Close to town for shopping, restaurants, beaches, parks, art galleries, and more. Just a short drive east is the National Forestry access. Custom Built by Jim Barnes Construction. A pure labor of love in the quality and care that went into this build, and it shows in every facet. This home is comfortable, quiet, and energy efficient. There's over 200 yards of concrete in the foundation and 12" thick walls, finished with fiber cement siding, a 50-year architectural roof, top of the line septic system and it has a remarkable 70 GPM well. Broker is related to seller.
MlsNumber: --
ListingId: 24077139


Listing Provided By: eXp Realty, LLC, original listing
Phone: (888) 814-9613
Office Phone: (888) 814-9613
Agent Name: Joy Wells
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App