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

400 Cherry Hill Dr
Mosier, OR 97040
Maui Meyer with Copper West Real Estate, original listing - (541) 386-2330

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,295,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2278 Square Feet
Agency: Copper West Real Estate
Agency Phone: (541) 386-2330

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: A dream retreat in the heart of the Columbia River Gorge! Set on 7.64 peaceful acres, this one-of-a-kind property offers breathtaking panoramic views of the Columbia River, framed by blooming cherry trees and open county land. It feels like a secluded escape, yet you're just minutes from downtown Mosier. Inside the city limits and connected to public utilities, this property offers the ease of modern living with the charm of a countryside setting. Whether you're imagining a forever home for the whole family, a peaceful getaway, or a place to share with others, this special spot has something for everyone. The main home has timeless mid-century modern character, with cedar siding, four generous bedrooms, two full baths, and 2,278 square feet of spacious living space, A stunning floor-to-ceiling stone fireplace anchors the living room, adding warmth and charm. From the kitchen, step outside to an expansive deck— the ultimate place to relax or host friends while soaking in the incredible river views. If you have a love of entertaining, you’ll adore the in-ground pool and the cozy 1-bedroom pool house, ideal for guests. There's also a detached barn garage with a 1-bedroom apartment above, complete with its own private deck and those same jaw-dropping views— currently rented and ready for extended family, friends, or extra income. Inside the barn garage you will find a full bathroom and studio space that is perfect for a work-from-home set up! This property brings together the best of both worlds: peace, privacy, and space to roam, all with the convenience of being close to town. It's a the epitome of rare, offering comfort, character, and a setting that truly has to be seen to be believed.
MlsNumber: --
ListingId: 278087326


Listing Provided By: Copper West Real Estate, original listing
Phone: (541) 386-2330
Office Phone: (541) 386-2330
Agent Name: Maui Meyer
Disclaimer: Copyright © 2025 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