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;

602 Wheatland Ct
Uniontown, WA 99179

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,500
Beds: 3
Baths: 2
Status: Active
SqFt: 1404
Agency: RE/MAX Home and Land

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2012
Notes: MLS# 274857 Your search is over. Come home to this well maintained three bedroom, two bath home. This home has a lovely primary bedroom with a separate full bath. A second full bath with an expansive countertop is available for guests or kids. Large living room dining and a separate laundry/mud room. The kitchen has ample counter space, and abundant beautiful cabinetry. There is even a breakfast bar counter. The best part of this home is the location, centrally located between Pullman and Lewiston/Clarkston with easy access to Moscow too. The second best feature is the large fenced backyard with a large gate big enough for a vehicle to use. A covered back and front porch gives you shade any time of day. Outside there is a large shed, a firepit and a built in sandbox too! This is a certified Energy Star home, including an innovative LifeBreath heat and energy recovery system designed to keep warm air inside in the winter and remove warm air during the summer to keep your home nice and cool. The K-12 School bus stop is right at the corner of the neighborhood. Fiber optic internet and natural gas available. House is already plumbed for a water softener. Garage has been converted to a fantastic workshop / storage area plus a bonus 12x12 insulated living space that could be used as a playroom, exercise space or home office. Buyer can easily remove the wall and convert back to a garage if needed. Square footage is estimated; buyer should measure to satisfy own needs. All appliances are included plus the large backyard shed. Chicken coop is negotiable./Kris Finch/509-432-1238/RE/MAX Home and Land//
MlsNumber: 274857


Listing Provided By: RE/MAX Home and Land, original listing
Name: RE/MAX Home and Land
Phone: (509) 332-4546
Office Name: RE/MAX Home and Land
Office Phone: (509) 332-4546
Agent Name: Kris Finch
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