Title Page Background
DEBUG FN args: Array ( [0] => 2215 [1] => [2] => [3] => agent ) BEFORE: Site: 2215 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2215 Igate: njhud LocID: 2215 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2215 [1] => [2] => [3] => lender ) BEFORE: Site: 2215 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2215 Igate: njhud LocID: 2215 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2215 [1] => [2] => [3] => other ) BEFORE: Site: 2215 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2215 Igate: njhud LocID: 2215 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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: $3,995,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 © 2025 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