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

10541 W Lake Boreham Rd
Duchesne, UT 84021

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,268,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 181 acre(s)
Property Type: Farm And Agriculture
Year Built: --
Notes: Established on 181 +/- acres, Lakeview Farm consists of a newly remodeled residence that is encompassed by irrigated farmland. With approximately 78 +/- acres under sprinkler irrigation, the farm consistently produces 5 tons to the acre due to the climate, soils and good dependable water. Additionally, the property borders the Lake Boreham recreation area and provides great views of the lake right from the door step! Lakeview Farm features a beautiful 2,171 square-foot, single floor farmhouse that has been recently remodeled, along with a detached 2 car garage. The interior of the house is comprised of 3 bedrooms, 2 full baths, a family room with picture windows that provide views of the irrigated fields behind the house, a living room with a dining area, kitchen, laundry room, a raised lounging area, and a fireplace that efficiently heats the house. As a result of the owner's extensive efforts to renovate the residence over the course of the last few years, the house has new laminate flooring all throughout except 1 bathroom with tile flooring, new baths installed in both bathrooms, a recently replaced water heater, and much more! As of 2023, the remodeling process was completed. The 26x24 detached garage boasts 624 sq-ft, providing ample space for 2 vehicles, storage along the walls, and plenty of walking room. Additionally, there is a small storage shed and 2 lean-to shelters with corrals located adjacent to the house and garage.   Due to the location of the farm, there are numerous recreational opportunities within close distance. Located on Ute Tribal grounds, Lake Boreham is stocked with numerous species of fish including smallmouth bass, largemouth bass, walleye, and rainbow trout. In order to access the area, visitors must obtain a permit and follow Ute fishing proclamation rules. In 1996, The Utah state record smallmouth bass was caught in the lake, weighing 7 lbs. 6 ounces. The farm is also just a short distance from several National Forest access points along with multiple lakes and rivers such as Starvation Reservoir, the Duchesne River, and the well known Strawberry River, all of which have excellent fishing.         Historically, Lakeview Farm averages 4 cuttings a year producing 5 ton to the acre! After the last cutting, the fields continue to be irrigated and used as fall pasture. The fields currently consist of alfalfa, grass, oats, and are irrigated from side roll sprinklers. The farms water comes from 86.5 shares out of the Duchesne irrigation canal.           Duchesne, UT is approximately 20 minutes to the west. Head east roughly 20 minutes and you will find Roosevelt, UT. The larger town of Vernal, UT is just under 1 hour east of the Farm and Salt Lake City is approximately 2 hours to the west.   Proof of Buyers financial capability must be provided and approved before all showings.
MlsNumber: 11176161


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (970) 674-1990
Office Name: Hayden Outdoors Real Estate
Office Phone: (970) 674-1990
Agent Name: Lonnie Gustin
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.


Local Real Estate Expert

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 = 2782 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;
Real Estate Expert Photo for Bonnie & Tracy Ross
Bonnie & Tracy Ross
ASCIIRealty ONE Group Signature Vernal
Call Today!: (801) 380-4617

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App