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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2947 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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;

232 Overlook Dr
Wishram, WA 98673

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 4546 Square Feet
Agency: Berkshire Hathaway HomeServices NW Real Estate
Agency Phone: (360) 574-1381

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Welcome to your own private retreat w/magnificent views of the Columbia River. This meticulously crafted custom home, built in 2005, offers the perfect blend of elegance, functionality, and tranquility. Set on over an acre this property provides ample space and privacy, with potential for dual living arrangements. The downstairs level features its own private entrance, patio and kitchen (wired & plumbed), making it an ideal space for an additional living quarter, in-law suite, or guest accommodation. Inside, you'll find a thoughtfully designed layout with 4 spacious bedrooms (2 on main and 2 on lower) and 3 full baths, ensuring comfort and convenience for all. The home boasts two thermostats, one for each level, allowing for personalized climate control throughout the year.The expansive deck invites you to savor the stunning river views and outdoor living, while the heated and air-conditioned garage ensures year-round comfort for your vehicles and hobbies. RV parking is also available, making it easy to bring along your adventures. With its blend of luxury and practicality, this home is perfect for those seeking a serene retreat with all the modern amenities. Located close to renowned wineries, this property is a wine enthusiast's dream, offering easy access to some of the region's best vineyards and tasting rooms. Whether you're looking for a prime Airbnb investment or a luxurious getaway, this home combines scenic beauty, modern amenities, and proximity to local attractions. Don’t miss the chance to own this exceptional property—schedule your showing today!
MlsNumber: --
ListingId: 24383619


Listing Provided By: Berkshire Hathaway HomeServices NW Real Estate, original listing
Phone: (360) 574-1381
Office Phone: (360) 574-1381
Agent Name: DeAnna Bryson
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