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;

1321 Bristlecone Rd
Guffey, CO 80820

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,490,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3486 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Take a look at the Rockin Horse Ranch, located near the end of the road in one of Guffey's most friendly subdivisions. Featuring a 3486 square foot, 5-bedroom custom home and a 2160 square foot, 6-stall horse barn with fully insulated workshop. This fully fenced wooded property with a stream is perfect for horses. Add access to the stocked community fishing pond and the friendly neighborhood and you will feel right at home. The Rockin Horse Ranch sits on 38 acres in the Peak and Ponds Subdivision, which features 6 acres of common area including a stocked fishing pond. The property is mostly wooded and has a small stream running along its front edge.   The 5-bedroom custom home features alder cabinets, hickory flooring, and T&G ceilings for the complete mountain home feel. The full floor to ceiling wall of windows provides amazing views as well as the southern exposure to take advantage of the winter solar gain to reduce heating costs. This large home has an excellent layout for a large family or just space for entertaining many guests. The upper level features a large loft for entertaining and relaxing and a well sized bedroom with private deck. The main level consists of the main living floor with kitchen, dining area, 2 bedrooms, living room and just out the door is the wrap around deck for your outdoor living needs. The large walk-out basement allows for guest privacy as well as easy access to the rest of the property. The 2160 square foot barn features 6 elegant horse stalls with ample storage for feed above the stalls. Nearly half of the barn has been developed into a fully insulated workshop with ample space for all your projects and 220 volt electric to power your tools. Both sides of the barn have covered space for storage of equipment or additional animal space. Park County is the gem of Colorado outdoor recreation, with many options for the outdoor enthusiast including lake and stream fishing, hiking, mountain biking, and snowmobiling, as well as big and small game hunting. Add the ease of accessibility to Canon City for your shopping needs and the Guffey area is a recreational paradise.
MlsNumber: --
ListingId: 11262337


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