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

14285 County Road E 5
Antonito, CO 81120

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 3
Baths: 3
Status: Active
SqFt: 5110
Agency: Cool Sunshine Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential
Year Built: 2023
Notes: This 5000+ sqft newly built home is a rare find. This property consists of 38 fenced acres, a fully stand-alone guest house, a over 1000 sqft workshop (with kitchen, bathroom & laundry) and all are fed by a new domestic well. A fenced stable/shed is on the property to keep those critters. Take a very short walk down to the Rio San Antonio River for relaxation and some fishing. The main house consists of open floor living area, spacious kitchen, separate dining, 3 bd/2 baths on the main level, 840sqft upstairs and a separate studio (400 sqft) that has a bath, kitchen and living area. The oversized (685 sqft) heated garage contains the laundry & utility rooms. This well-built home and totally remodeled guest home have been used as short-term rentals (air bnb) since it’s completion last year. This amazing opportunity would make a great investment or a fabulous, secluded getaway spot during those cool summers or those “hot” hunting seasons. This is definitely a must see and the potentials are quite numerous. <br /> This incredible opportunity is located just minutes outside of Antonito, CO (home of the Toltec-Cumbres Scenic Railroad) and gateway to the Conejos Canyon (Conejos River, Platoro, Rio Grande & San Juan Nat’l forests, San Juan Wilderness & more). Just minutes from the New Mexico state line for everything northern NM has to offer (Taos, Santa Fe etc). Head north into the San Luis Valley to see all that it has to offer like the Great Sand Dunes (tallest dunes in North America), the Rio Grande River (it begins just above Creede), Mt Blanca (1 of 3 14’ers) and numerous other natural wonders and the local events always have something to other. Call today to set up your private tour of this gem!<br /> Google map pin https://maps.app.goo.gl/dA2JKYcrPwttLnRj6
MlsNumber: 2997714


Listing Provided By: Cool Sunshine Realty, original listing
Name: Cool Sunshine Realty
Phone: (719) 480-7110
Office Name: Cool Sunshine Realty
Office Phone: (719) 480-7110
Agent Name: Mike Lee
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