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

612 W County Road 74
Wellington, CO 80549

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Nestled amongst the scenic Northern Front Range of Colorado with 35+/- Acres, 612 W County Road 74 features a custom-built home that integrates luxury with natural beauty. The residence boasts expansive windows framing breathtaking mountain views. Outside, a meticulously designed horse barn and arena compliments the property, complete with spacious stalls and a tack room, while a serene fishing pond offers a tranquil location to cast a line. The property sits in a desirable location with a private driveway and excellent fencing and cross-fencing between the pastures. There are 4 separate pastures each with a loafing sheds and automated water tanks. Most of the ground is well-established pasture consisting of native grasses and mature trees. The landscaping around the property is exceptionally designed with a large yard surrounding the house/ pond with a sprinkler system and numerous mature trees. Perhaps the greatest asset of the property is the fine custom home with 2,700+/- SF and 4BR & 4BA. The house was recently updated with a beautiful open concept with large kitchen/ living area and excellent flow throughout from room to room. With large, covered porches one can take in the views in all directions of the foothills and fully landscaped property. Another feature of this property is a meticulously designed Cleary equine barn, offering superior structural engineering with durability and utility. Spanning 60'x80', it houses 6 spacious stalls equipped with fans, along with a wash bay providing comfortable accommodation for your horses. The loft area of the barn could easily be transformed into living quarters and features a large walk out deck overlooking the roping arena. Additional storage space is available for hay, feed, and equipment, keeping everything organized and easily accessible. Adjacent to the barn, discover a professionally constructed roping arena, perfect for honing your roping skills or hosting events. The arena is equipped with a squeeze chute and full lighting. Also adding to the improvements is a nice 30'x50' pole barn for the storage of tools and equipment with an included compressor recently installed. Both buildings have concrete floors in good condition. In the heart of the property is a fishing pond, professionally designed and constructed with a plastic liner and aeration system to maintain optimal water quality and fish health. The pond offers exceptional fishing for bass and is an extremely rare asset for a property in this area. Boasting a large custom built horse barn, roping arena, and fishing pond the property is unmatched as a front-range recreational retreat. Blessed with an abundance of groundwater the property is truly unique with a 360+/- gpm well servicing the property providing necessary water to irrigate the grounds, water livestock, and maintain the water level of the deep lined fishing pond. Conveniently located just 6+/- miles northwest of Wellington, CO and 12+/- miles from Fort Collins, this property offers the tranquility of rural living without sacrificing access to essential amenities and services.
MlsNumber: --
ListingId: 11327792


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Duncan Clark
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 = 280 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;
Real Estate Expert Photo for KEVIN WEIMER
KEVIN WEIMER
ASCIICOLDWELL BANKER REALTOR
Call Today!: (970) 481-3823

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App