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;

12962 Sr 194
Pullman, WA 99163

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 5
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 3200 Square Feet
Agency: Coldwell Banker Tomlinson - Pullman
Agency Phone: (509) 334-0562

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1964
Notes: Homesteading Paradise! Located just outside of town and on both the Colfax & Pullman Bus Routes. This charming brick rancher was fully remodeled in 2003. Providing main floor living options plus a large basement this floor plan offers the perfect blend of comfort and functionality. A total of 3,200 sq ft featuring 5 bedrooms and 4 baths and 2 laundry rooms make this perfect for families or multi-generational living.The gourmet kitchen is a dream for cooking and entertaining. With a Viking propane stove, large island and a huge pantry you have the room and the tools to cook all day long. Relax by the wood fireplace in the inviting living room. Downstairs, a spacious family room with a mounted TV (included!) offers additional living and entertainment space. Inside has space for everyone but so does outside. This property is calling all nature lovers! This property boasts a garden paradise with raised beds, established fruit trees, berry bushes, and even maple trees tapped for your own private syrup production. Let your homesteading dreams flourish! Enjoy the fresh air on the expansive back deck, perfect for barbecues and gatherings. A front deck provides a charming welcome, and ample parking ensures space for everyone. Spread out on over 1.22 acres with no HOA or CC&Rs! The property offers additional peace and quiet. Plus, there's the potential to expand your domain - inquire about the additional acreage (and buildings) available across the road for a package sale.This is your chance to own a piece of Whitman County paradise! Don't miss out on this unique, and possibly income producing property. /Ashley Alred/CELL: 509-338-5306/Coldwell Banker Tomlinson - Pullman//
MlsNumber: --
ListingId: 275469


Listing Provided By: Coldwell Banker Tomlinson - Pullman, original listing
Phone: (509) 338-5306
Office Phone: (509) 334-0562
Agent Name: Ashley Alred
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