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

41381 Martin Canyon N Rd
Wilbur, WA 99185
Brandon Marchand with Keller Williams Spokane - Main, original listing - (509) 458-4000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 5
Baths: --
Status: Active
SqFt: 3200 Square Feet
Agency: Keller Williams Spokane - Main
Agency Phone: (509) 458-4000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: Discover Your Homestead Dream Just North of Creston! Welcome to 3.5 acres of open skies and picturesque pastures, perfect for your homestead ambitions. This charming 5-bedroom, 3-bathroom home offers plenty of space and character. With two kitchens, spacious bedrooms, and abundant natural light, you'll have the freedom to spread out and find your perfect spot. The home boasts new carpet and appliances, updated sewer lines, and a covered deck ideal for relaxing outdoors. The two-car garage, which can double as a workshop, adds versatility to the property. Outside explore the pig pen and an intriguing historical feature: an old schoolhouse, originally built in 1883 and moved from town, adding a unique touch to your land. Additionally, the massive shop off the circle drive is heated and ready to accommodate your farming equipment or any other hobbies you may pursue. Come explore and breathe in the fresh air of your future homestead!
MlsNumber: --
ListingId: 202422010


Listing Provided By: Keller Williams Spokane - Main, original listing
Phone: (509) 458-4000
Office Phone: (509) 458-4000
Agent Name: Brandon Marchand
Disclaimer: Copyright © 2024 Spokane Association of REALTORS®. 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