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;

201 Sterling Blvd
White Salmon, WA 98672
Julie Gilbert with Copper West Real Estate, original listing - (541) 386-2330

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome to your dream home in the highly sought-after Sterling Estates neighborhood of White Salmon. This stunning Modern Farmhouse, built in 2021, offers 2752 square feet of thoughtfully designed living space on a beautifully landscaped 0.89-acre corner lot. Enjoy breathtaking views of the Columbia River and Mt. Hood from nearly every room. With 4 bedrooms and 2.5 luxurious bathrooms, this home seamlessly blends comfort, style, and modern convenience with the charm of farmhouse aesthetics. As you step into the spacious living room with vaulted ceilings, you’ll immediately notice the attention to detail, including a gas fireplace, a TV that lowers for easy viewing, and a design that maximizes the surrounding views. The gourmet kitchen is a chef's dream, featuring open shelving, stainless steel appliances, a Thermador gas range and range hood, quartz countertops, a walk-in pantry, and a butler's pantry complete with a wine fridge, prep sink, second refrigerator, and stunning views of Mt. Hood. The dining room opens effortlessly through accordion sliding doors to the expansive back deck, making it perfect for entertaining or simply enjoying the natural beauty. The primary en-suite is a true retreat, offering panoramic windows that perfectly frame those breathtaking views. For added convenience, a washer and dryer are located just off the primary bedroom, with additional hookups available on the lower level. The property also includes a detached two-car garage and a large deck, ideal for taking in the magnificent surroundings of Mt. Hood and the Columbia River. Don’t miss this rare opportunity to own an exceptional home that offers a perfect blend of modern luxury and natural beauty, within a short distance of everything the Columbia Gorge and White Salmon have to offer. Schedule a viewing today and make this dream home yours.
MlsNumber: --
ListingId: 24504234


Listing Provided By: Copper West Real Estate, original listing
Phone: (541) 386-2330
Office Phone: (541) 386-2330
Agent Name: Julie Gilbert
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