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

4482 County Road 100
Carbondale, CO 81623

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,599,000
Beds: 3
Baths: 6
Status: Active
SqFt: 6958
Agency: The Property Shop LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Property Type: Residential
Year Built: 2009
Notes: Mountain Luxury at its finest... The current owners purchased this home as an unfinished shell and have transformed it into a masterpiece with the perfect combination of mountain comfort and luxury in a setting second to none. Situated on 35 acres with pinons and rolling irrigated pastures, the Sopris views from this home will take your breath away. The setting affords complete privacy and is conveniently located a short drive from both Carbondale and El Jebel between Glenwood Springs and Aspen. Enjoy a versatile floorplan complete with 3 spacious suites, a custom office/study/library, a theatre room, a home gym, and a wine cellar with all of the essentials located on the main level. The primary suite, also located on the main level, is both extravagant and comfortable offering a private deck, custom dual closets, a steam shower, make-up vanity, and Miele coffee bar. Take in the views from the covered decks, patios, hot tub, fenced yard complete with trees, and perennial gardens. Not a detail was missed in the customization of this home with finishes including Taj Mahal quartzite throughout, Wolf, Cove, and Sub-Zero appliances, a whole house Crestron system, ACT altitude control system in the primary bedroom, hospital-grade HVAC air filtration systems, and much more. There is plenty of room for your vehicles and toys with a 3-car attached and 2+ car detached garage, ample concrete parking, and a large storage shed. You must see this home for yourself to appreciate the rare setting and quality, call today!
MlsNumber: 179838


Listing Provided By: The Property Shop LLC, original listing
Name: The Property Shop LLC
Phone: (970) 947-9300
Office Name: The Property Shop
Office Phone: (970) 947-9300
Agent Name: Amy Luetke
Disclaimer: Copyright © 2024 Aspen/Glenwood Springs 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