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 = 2232 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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 = 2232 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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 = 2232 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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;

29495 Knight Rd
Hermiston, OR 97838
David Smith with Land and Wildlife LLC - Medford, original listing - (866) 559-3478

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $835,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 4374 Square Feet
Agency: Land and Wildlife LLC - Medford
Agency Phone: (866) 559-3478

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Discover this expansive estate sitting on 4.45 acres with full water rights, featuring a spacious 4374-square-foot home. The adjacent property is also for sale. Step through the landscaped entry to a large foyer leading to the main level, where you'll find two generous living rooms, two dining areas, an updated kitchen, laundry facilities, a main bathroom, two guest bedrooms, and a luxurious master bedroom with bath. The lower level is designed to accommodate various activities, including a movie theatre, workout room, and office space. Additional rooms provide ample storage, along with specialized areas for canning or reloading. A bar setup, full bathroom, spare room, and fourth bedroom with garage access complete this versatile space. Outdoors, enjoy the in-ground concrete pool, fully fenced for safety, perfect for relaxation and recreation. The property also includes a barn with four stalls, a loft, hay storage, and water access, with a sliding door leading to the pasture equipped with solid set sprinklers. Garden enthusiasts will appreciate the planter boxes to the west of the house, ideal for cultivating a large garden, alongside a greenhouse that awaits minor repairs. For the hobbyist or entrepreneur, a (approx) 2400-square-foot shop awaits, featuring three 12-foot roll-up doors, heated space, a loft area, and a full wall of cabinets. Two dedicated office rooms, a full bath, and laundry connections add to its appeal. Adjacent to the shop, you'll find ample parking space for RVs, complete with sewer hookup and both 30 and 50 amp power connections. This remarkable property offers endless possibilities for living, entertaining, and pursuing hobbies in a picturesque setting. Seize this rare opportunity to combine this property with the adjacent acreage and home for sale to build your dream retreat.
MlsNumber: --
ListingId: 24296057


Listing Provided By: Land and Wildlife LLC - Medford, original listing
Phone: (509) 540-4708
Office Phone: (866) 559-3478
Agent Name: David Smith
Disclaimer: Copyright © 2024 LandLeader. 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