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

1492 Wagon Wheel Road
Hartsel, CO 80449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $879,900
Beds: --
Baths: --
Status: Active
SqFt: --
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: Land-Other
Year Built: 2013
Notes: Rancho de Verano is the perfect stepping stone for your ultimate horse and recreation headquarters. Complete with an improved barn, several RV sites with hookups, 60 foot round pen and incredible views of the Mosquito mountain range, South Park, and Antero Reservoir.35 acres which has been manicured to maximize the access on horseback. The pasture has been over-seeded each year, and the property has been fire mitigated with low hanging limbs removed on the trees to give free range for horses. With the utilities running under-ground, there is nothing to interfere with the extensive views of the valley and surrounding mountains. The improved barn is a Red Steel building that is built to last and provide years of maintenance free use. Its footprint is 3600 square foot, allowing for covered motorhome parking as well as horse stalls. The living space features a natural stone, wood burning fireplace and an extravagant bar with full back bar, upstairs loft can be utilized as a bedroom with 1/2 bath, and an additional guest bathroom on the main floor. Complete the picture with a large workshop with oversized garage door, for machinery maintenance. The utilities are fully in place for the addition of the home of your dreams. With the exempt domestic well you have access to water for a home, large garden, and your horses, and the septic system is sized for the addition of a 3 bedroom home. There are several RV sites on the property with a couple featuring full hookups (water, power and sewer), and one having water and power. All water and power for the sites are underground, and built for year round use. Rancho de Verano is your ready to use horse property, and with no covenants your recreational uses are only bounded by your imagination. In addition, for a fee to the Ranch of the Rockies association, you can enjoy the amenities of the Ranch of the Rockies which include hiking trails, recreational facilities, and a private fishing lake which boasts some very large rainbow trout. Additionally, central Colorado is home to some amazing recreation. Public fishing opportunities within a short drive include Antero Reservoir, Elevenmile Reservoir, Spinney Mountain Reservoir and gold medal stream and river fishing on the South Platte and Arkansas Rivers. There are hundreds of miles of ATV trails and roads in the surrounding Pike and San Isabel National forests. For hunting, the forests around the property provide access to elk, mule deer, antelope, bear, mountain lion, and Rocky Mountain bighorn sheep. Skiers are within an hour and a half of many resorts, including Breckenridge, Monarch, and Ski Cooper. Cross country skiing is available on most of the forests as well as mountain climbing, hiking and river rafting opportunities which abound in the area.
MlsNumber: --
ListingId: 11111478


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