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;

1023 Mexican Ridge Circle
Como, CO 80432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1100 Square Feet
Agency: Keller Williams Action Realty, LLC
Agency Phone: (303) 688-8300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 41 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Truly Superlative!*100% off-grid*Nestled amidst 41.55 acres of Colorado forest land, this contemporary Fully-Custom Log Cabin is a sanctuary for those seeking solace in nature's embrace. Can be Fully Furnished. Equestrian Friendly (zoned livestock). Hunting Permitted. 10 miles to Fairplay; 33 miles to Breckenridge. Whether you're seeking a weekend escape or a permanent residence, this is a rare opportunity to live amidst nature's splendor. Unparalleled privacy & breathtaking views of towering pines, golden aspens & majestic mountains! *2nd Bedroom Guest House Sleeps 2-4*Brand New Shipping Container w/Hand Painted Mural (Potential Guest House Sleeps 2). A fusion of traditional log cabin charm & contemporary aesthetics, you'll find an inviting ambiance that harmonizes with its natural surroundings*Porcelain Flooring*Quartz Countertops*High Altitude Windows/Doors*Wood Burning Fireplace. Explore the wilderness at your doorstep, hike among the trees, camp, enjoy wildlife & endless outdoor recreation opportunities*12x12 Trex deck camping platform near peak of property*18x17 Artificial turf. While secluded, this mountain oasis offers year-round accessibility, allowing you to enjoy all 4 seasons in unparalleled comfort & convenience. A masterpiece of modernity, the heart of this fully-custom cabin is state-of-the-art technology, seamlessly integrated to enhance home life. Smart tech allows you to control systems with a touch, while cutting-edge security features provide peace of mind while away.**Starlink High-Speed Internet*SimpliSafe Security System (window sensors, glass break sensors, cameras, water leak alarm)*2 Private Gates*Solar System (18 Panels-Qcell 350w)*Generac Generator*Gravity Septic (non powered)*Fully Lined/Spray Foam Insulated Crawl Space*Full Size Washer & Dryer *ASK FOR COMPLETE LIST OF FEATURES* A perfect blend of luxury, privacy & technology, your exquisite new *off-grid mountain retreat* is an unforgettable escape in the heart of Colorado's majesty!
MlsNumber: --
ListingId: 9181463


Listing Provided By: Keller Williams Action Realty, LLC, original listing
Phone: (303) 653-4709
Office Phone: (303) 688-8300
Agent Name: Angela Fezza
Disclaimer: Copyright © 2024 Pikes Peak Association of REALTORS. 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