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

1880 Sw Barclay Ridge Drive
Pullman, WA 99163

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $969,000
Beds: 5
Baths: 4
Status: Active
SqFt: 3872
Agency: Coldwell Banker Tomlinson Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2009
Notes: MLS# 273277 Amazing home with panoramic views of Pullman, WSU Campus, Moscow Mountains and beyond. This 5BR/3+BA one story home with a bright daylight basement features age in place living areas with zero entry. Upscale finishes throughout this well appointed home. The tiled floor foyer with wall art niche in the entry welcomes you to a grand open space living room with spectacular views. Beautiful hardwood floors, large picture windows and an open floor plan concept. The living room has custom granite gas log fireplace with built in media cabinet and matching bookcases. Fabulous kitchen to entertain your guests, plenty of custom cabinets and granite counters, large kitchen island with a cook top and tiered counter space to include an eating bar. The laundry room and additional pantry space are conveniently located next to the kitchen. There is a flex room off the living room that could either incorporate a formal dining room, a den/office, or a spare bedroom. Large partly covered view deck also wraps around the side for garage and yard access. The primary bedroom is very spacious with vaulted ceilings, private view deck, luxurious bath with jetted tub, a custom tiled walk-in shower and large walk-in closet. The second bedroom with adjacent full bath is also on this level. The daylight basement features 9' coffered ceiling over the family room, a large recreational room for playing your favorite pool game, an exercise room, two large additional bedrooms and a full bathroom. There is a huge unfinished storage room that also incorporates the mechanical components. The family room has doors to the covered back patio and yard. The sprawling 1,000+SF three car garage has room to open all car doors, store your toys and even has a separate workspace or shop for power tools. Fresh exterior paint completed in September 2023. This home has everything you could imagine! A perfect floorplan with truly amazing views!/Mick Nazerali/206-794-7860/Coldwell Banker Tomlinson - Pullman//
MlsNumber: 273277


Listing Provided By: Coldwell Banker Tomlinson Associates, original listing
Name: Coldwell Banker Tomlinson Associates
Phone: (509) 334-0562
Office Name: Coldwell Banker Tomlinson - Pullman
Office Phone: (509) 334-0562
Agent Name: Mick Nazerali
Disclaimer: Copyright © 2024 PACMLS. 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