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','wihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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','wihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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','wihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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 Upper Lakeview Rd
White Salmon, WA 98672
Ashley Troy with Redfin, original listing - (503) 353-6673

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,169,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 4000 Square Feet
Agency: Redfin
Agency Phone: (360) 558-3945

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to your dream retreat at 232 Upper Lakeview Dr. This stunning 4-bedroom, 3-bathroom home offers the perfect blend of luxury and nature, nestled in a serene neighborhood just minutes from the vibrant downtown White Salmon and the breathtaking White Salmon River. Upon entering, be welcomed by the expansive living room, where abundant natural light floods through large windows, illuminating the impressive stone fireplace. This centerpiece sets a warm, inviting tone perfect for family gatherings or solitary relaxation. The grand heated tile floor kitchen, equipped with a large island and two ovens, beckons culinary exploration and seamless entertaining with its wrap-around deck, ideal for enjoying idyllic indoor/outdoor living while savoring picturesque views year-round. The main-floor primary suite epitomizes luxury with its sophisticated layout featuring a double sink vanity, indulgent walk-in tile shower, serene soaking tub and an expansive walk-in closet – a true haven of privacy and relaxation . Additional perks include an office space, theater-equipped family room with patio access and plumbed for wet bar or kitchenette with many rooms for storage and versatile laundry options. Car enthusiasts or those in need of toy storage will appreciate the 3-car extra-large garage, boasting full attic trusses ready for future ADU or flex space expansion. The property is bordered by a year-round creek and forest offering a serene backdrop and a sense of endless natural beauty. This home is more than just a place to live; it's a place to thrive. Experience firsthand the unmatched ambiance of this remarkable property. Contact us to embark on the journey to find your forever home amongst the gentle whispers of the surrounding trees and streams.
MlsNumber: --
ListingId: 293801008


Listing Provided By: Redfin, original listing
Phone: (503) 353-6673
Office Phone: (503) 353-6673
Agent Name: Ashley Troy
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