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

12595 Mccune Road
Black Forest, CO 80106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 4
Baths: 4
Status: Active
SqFt: --
Agency: Better Homes and Gardens Real Estate Kenney & Comp

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1995
Notes: A world apart!! Enjoy the SERENE COUNTRY LIVING lifestyle surrounded by trees only minutes from AWARD-winning D49 schools, shopping, and OPEN SPACE trails while living next to luxury homes but without the high taxes. This property boasts incredible mountain VIEWS and is an exceptional 4 bedroom, four bathroom, 3 car garage home w/ a unique 2-story CLEARY Building that will leave you amazed at every turn. The beautifully landscaped property spans over 4000 square feet and includes a walk-out APARTMENT! As you drive up the newly paved driveway, take in the breathtaking views of PIKES PEAK & the unobstructed front range. Inside, you'll find a grand living room with a wall of windows and a double-sided GAS FIREPLACE. The spacious EAT-IN KITCHEN offers ample storage and a peninsula bar. Step out from the kitchen onto the large FLAGSTONE PATIO, enjoy your morning coffee, or host a summer BBQ by the cozy pond. Once INSIDE, make your way to the main level, where you'll find the MASTER RETREAT with a 5-piece ensuite bath & walk-in closet. The main level also has a formal dining area and laundry room. Upstairs are two spacious bedrooms with walk-in closets that share a Jack & Jill bath. Head to the FULLY FINISHED BASEMENT & be surprised w/ another great room and an in-law's or out-of-town guest's small apartment-style setup that includes a full-size kitchen, a family room with a walk-out, a bedroom, an office, and a ¾ bath. In addition, this property offers ample storage space, including A GUN LOVERS SAFE DISCREETLY LOCATED. Don't miss the 3-car garage, features brand-new insulated doors, storage & cabinets. But the real showstopper is the impressive Cleary Building, boasting a massive 3,150 square feet of space complete w/ a 9,000-pound lift and multiple rooms, including a "man cave" and a fully equipped wood shop. The barn also comes equipped w/ a premium FIVE-SPEAKERS surround sound system, projector, and an array of heavy-duty tools for the WOOD SHOP and accessories.
MlsNumber: 3777091


Listing Provided By: Better Homes and Gardens Real Estate Kenney & Comp, original listing
Name: Better Homes and Gardens Real Estate Kenney & Comp
Phone: (719) 550-1515
Office Name: Better Homes and Gardens Real Estate Kenney &
Office Phone: (719) 550-1515
Agent Name: Sara Foxley Smith
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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 = 266 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 Cindy Rein
Cindy Rein
ASCIISherlock Holmes
Call Today!: (720) 272-4890

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App