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 = 2207 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 = 2207 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 = 2207 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;

66845 Nehalem Hwy
Vernonia, OR 97064
Kelly Hagglund with The Kelly Group Real Estate, original listing - (503) 730-9999

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 4
Baths: Full: 2, ½: 4
Status: Active
SqFt: 5273 Square Feet
Agency: The Kelly Group Real Estate
Agency Phone: (503) 730-9999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 103 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Complete homesteading experience and lifestyle property awaits to welcome you home to an enchanted setting complete with panoramic views and a half mile of Nehalem River Frontage. With 103.62 acres comprised of gardens, fruit trees, 20 acres of pasture cross-fenced for cattle and approximately 71 acres of timber, the property presents a diverse landscape for agricultural income and self-subsistent living. The beautiful custom inn harmonizes seamlessly with surrounding country aesthetic and boasts environmentally conscious finishes such solar powered hydronic heating and energy efficient appliances. Accommodations include the main inn with four bedrooms and accompanying half baths, a charming bunk house, and a meditation treehouse studio. Outdoor amenities abound, including an indulgent outdoor soaking spa, a turn-of-the century barn with hand-hewn timbers and excellent hunting and fishing opportunities. Nature enthusiasts will delight at the extensive wildlife in the area with sightings of Roosevelt elk, black tail deer, coyotes, bobcats, black bear and the occasional cougar. Despite the tranquil, secluded setting, this property is conveniently located just an hour from Portland. Enjoy the pastoral splendor with multiple ecotourism opportunities by returning this private oasis to an operable destination inn within easy access to an abundance of state and county parks, including the Banks-Vernonia Liner Trail, Crown Zellerbach Trail and the Salmonberry Trail system currently under development. Embark on a journey towards sustainable living and discover the unparalleled charm of this remarkable property, an investment in both lifestyle and legacy awaits!
MlsNumber: --
ListingId: 24566925


Listing Provided By: The Kelly Group Real Estate, original listing
Phone: (503) 730-9999
Office Phone: (503) 730-9999
Agent Name: Kelly Hagglund
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