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

37215 Dead End Lane
Burns, OR 97720
Robert Paramore with Paramore Real Estate, original listing - (541) 573-3639

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,499,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2483 Square Feet
Agency: Paramore Real Estate
Agency Phone: (541) 573-3639

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 957 sqft
Garage: Garage
Property Type: Residential-Mobile Home
Year Built: 2016
Notes: Beautiful Burns Oregon alfalfa farm! This place has it all. 957 deeded acres with 5, seven tower pivots and 2 seven tower half pivots with auto reverse. Very productive farm with good water source. Sit in the comfort of your 2,485 Sq, Ft. 2016 Marlette, MF home with large attached 40'x48' shop/garage addition and watch your hay grow. The home sits right in the middle of the farm with pivots surrounding it. But wait there is more... Wait till you see the shop! Newly built 70'x110' shop with roll up doors on one side and a 24'x16' hydraulic automatic hanger door on the other, large enough for tractors, diesels and swathers. All heated concrete floors with a large office and bathroom. This shop is truly amazing, you may never leave it. Or you just may find time to work on things! A brand new hay barn as well measuring 62'x144' next to the shop to keep your hay dry. There is also a bunk house with kitchen, bathroom and living area. Separate tack room, chicken coop, garden shed, greenhouse and garden area. Don't forget about the working corrals and horse area. The property is fenced and cross fenced to run cattle and your hay production all at the same time. The pivots are run off of two wells that connect the pivots. One well is 785ft deep and was tested at over 2000 GPM. The other well is 685ft deep and was tested at 2800 GPM. Many of the fences are new. There are multiple tax lots on this farm. This truly is a beautiful farm located just 20 minutes from Burns Oregon. All kinds of wildlife, deer, antelope, waterfowl, birds of prey of all types. Beautiful peaceful location with a view of the Steens Mountains. Come take a look today! These numbers are estimates, contact selling broker for more info.
MlsNumber: --
ListingId: 11349051


Listing Provided By: Paramore Real Estate, original listing
Phone: (541) 573-3639
Office Phone: (541) 573-3639
Agent Name: Robert Paramore
Disclaimer: Copyright © 2024 My State MLS. 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