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;

946 Singletree Road
Hartsel, CO 80449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,500
Beds: 3
Baths: Full: 1, ½: 1, ¾: 1
Status: Active
SqFt: 2576 Square Feet
Agency: Coldwell Banker Collegiate Peaks Realty
Agency Phone: (719) 395-4700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Quality Built 2,576 Sq. Ft. Home with Incredibly Vast and Long Range Mountain, Valley and Lake Views! The views are perfectly captured in the home design as the Scenery flows right into the Living Room! The attention to detail, design and function of this home is unsurpassed! Long time respected custom home builder's personal residence! The main level features ground level access under a covered patio. Upon entry into the Main Level Living Room, you will first notice the beautiful vaulted ceiling with Tongue and Groove Knotty Pine that is expertly stained and finished. Open Floor Plan Design has plenty of room for friends and family to enjoy the Open Kitchen and Dining Area all in one large room. The Double Patio Door leads to a large outdoor deck with those amazing views to the East. The Main Level also boasts a Spacious Primary Bedroom, Primary Bath, a 1/2 Bath Powder Room for guests, a mud/laundry room with cabinetry and seating with storage. The well appointed Kitchen has Knotty Hickory Cabinetry, tons of counter space, drawers over doors, 2 Lazy Susan corner cabinets and an elevated island bar accommodating 4 barstools. The Lower level walk-out Basement has yet another Spacious Family Room with a beautiful Rock Fireplace accented with Recessed Lighting. A Double Patio Door leads outside to a brand new Paver Patio with a private Forested Setting. The Basement Level boasts 9 Ft. Ceilings, 2 spacious Guest rooms with Mountain and Forest Views and a Full Bathroom with Tile Accents. Your Guests Will Be Very Comfortable in a Very Spacious and Private Retreat! The Oversized Garage is Heated, Insulated and Drywalled with 9 Ft. Ceilings and an Oversized Garage door and 220 Volt power. Private large RV pad with hook-ups and County Approved Septic System good for a large motorhome! Passive radon mitigation built-in! Great Water and Well at 15 GPM. Off Site 25 acre Private Fishing Lake only for owners and guests! 1.2 miles off Hwy 285! Just Minutes to Buena Vista!
MlsNumber: --
ListingId: 1839643


Listing Provided By: Coldwell Banker Collegiate Peaks Realty, original listing
Phone: (719) 221-4146
Office Phone: (719) 395-4700
Agent Name: Mark Fickle
Disclaimer: Copyright © 2024 ROCC/REcolorado. 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