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

76707 Highway 207
Echo, OR 97826
Kelly Dynes with eXp Realty, LLC, original listing - (888) 814-9613

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2240 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 814-9613

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 1998
Notes: Here’s your very own mini-ranchette! This triple-wide sits atop the hillside away from the road and overlooks foothills and fields with a spectacular sunset scene. The parcel has a total of 7.56ac with water rights through Westland Irrigation for 2.8ac. Includes a single pivot circle - great for growing alfalfa or grass. Another chunk of the land is bare and would make a great location for your dream shop/barn! Surrounding the home are cherry and apple trees, a manicured lawn with timed underground sprinklers and drip lines. On the East side is a covered patio to provide shade and space for a table and lounge chairs. Inside the home are two separate living rooms offering space to gather or spread out for privacy...and a beautiful fireplace (propane) to enjoy on chilly nights. The expansive kitchen is equipped with all you need: island with eating bar, tons of cabinets and counter space and the appliances are included (all less than 1 yr old). Besides 3 bedrooms, there is an extra room to use as your office, exercise equipment or crafts. The laundry room has a half-bath which sits next to an exit door so you don’t have to drag dirty clothes or shoes through the home! Primary bath has been updated with dual sinks, tub and a walk-in tile shower. Detached from the home is a 30x40 metal garage. It has two automated roll-up doors fully insulated with power and concrete floors. A finished 9x14 work/storage room with wall heat is within the garage. This is a MUST SEE country property! *School Boundary is for Desert View Elementary/Armand Larive Middle School/Hermiston High School
MlsNumber: --
ListingId: 24113402


Listing Provided By: eXp Realty, LLC, original listing
Phone: (888) 814-9613
Office Phone: (888) 814-9613
Agent Name: Kelly Dynes
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. 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