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

20864 County Road 32.2
Sterling, CO 80751
Chase Hinson with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 80 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2001
Notes: Logan County 80 is a sportsman's paradise partnered with high yielding productive farm ground just a mile from Sterling, Colorado. Nestled along the South Platte River, it features a spacious 1900 sq. ft. modular home, installed in 2001, and a newly built 40x60 shop with a poured floor. The property is renowned for its impressive whitetail deer, exceptional waterfowl hunting, and excellent spring turkey hunting opportunities. This property features over 70 acres of tillable farm ground equipped with a drip irrigation system, making it ideal for various farming practices. It comes with two shares of Low Line Irrigation Water and a high-capacity well, offering excellent irrigation options. Previously farmed for hemp, it has a history of cash crops, including beans and corn, making it a versatile opportunity for buyers or investors. Whether you're looking to expand your operation or add to your portfolio, Logan County 80 is a perfect candidate for either. The house features approximately 1,800 square feet of comfortable living space, including 3 bedrooms and 2 bathrooms. A spacious sunroom offers stunning views to the south, overlooking the river, making it a perfect spot for relaxation. Additionally, there's a newly constructed shop with poured floors, ideal for accommodating large machinery and providing extra dry storage. This combination of living space and functional outbuildings makes it an excellent choice for both comfortable living and practical farming needs. Logan County 80 is an exceptional recreational property, perfectly situated next to thousands of acres of public river access. With excellent waterfowl hunting opportunities in the agricultural fields and quick access to the South Platte River, it's a paradise for outdoor enthusiasts. Located in Colorado Big Game Unit 92, the property boasts outstanding trophy deer hunting potential, with white-tailed deer exceeding 170 harvested in previous years. Additionally, the strong population of turkeys makes spring turkey hunting a fantastic bonus. Sterling, Colorado features a semi-arid climate characterized by hot summers and cold winters, with ample sunshine year-round. Situated on the high plains, it experiences moderate rainfall, primarily during the spring and summer months, making it suitable for agriculture. The area is known for its expansive open skies, while the nearby South Platte River adds to its natural beauty. This climate supports a variety of crops and offers ample opportunities for outdoor activities, from farming to hunting. Sterling, Colorado, is conveniently located along Interstate 76, providing easy access to major amenities. It's approximately 90 miles east of Fort Collins and 130 miles northeast of Denver, making it a manageable drive for those seeking urban conveniences. The town offers essential services, including grocery stores, restaurants, schools, and medical facilities. Additionally, nearby recreational opportunities abound, with parks, the South Platte River, and various outdoor activities just a short drive away, enhancing the appeal of this welcoming community.
MlsNumber: --
ListingId: 11355410


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