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

4236 Tranquil Way
Crestone, CO 81131

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2160
Agency: eXp Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1997
Notes: Welcome to the Tranquil Lighthouse, a successful Air BnB vacation rental home for large groups, with stunning panoramic views of the Sangre De Cristo range & mystic San Luis Valley. You will feel on top of the world as you gaze out of the floor to ceiling windows, boasting incomparable, panoramic vistas from this secluded retreat at the end of the Baca Grande. Sitting on 4 consolidated lots, totalling 2.61 acres, this home boasts 4 bedrooms, an office, together with 3 bathrooms & room for expansion. Enter on the upper level to a bright & airy, open plan kitchen & spacious living area, with awe inspiring views. The fully stocked kitchen with island, combined with the cozy fireplace & picture windows make the expansive top floor ideal for entertaining. A spiral staircase leads you down to the first floor with separate entryway mudroom, 4 bedrooms, bathroom & a reading nook/lounge area that opens onto a peaceful balcony beneath the trees. The master bedroom features an attached bathroom with jetted soaking tub & private work station, with cozy bay window seating for your enjoyment. The spectacular views & unique, peaceful location, nestled in the foothills of the Sangre de Cristo mountains, make this property extra special. 3 private upper level decking areas are ideal for lounging while drinking in the breathtaking natural surrounds, or star gazing. This home has been remodelled & upgraded to boast a modern, fresh vibe with new flooring, appliances, paint & furnishings. Offering plenty of storage space, including an oversized walk in pantry for food storage, mud room, 4 ft tall crawl space & shed with electric, which could be converted to a guest space. Cottonwood creek flows only 100 yards away, while the hiking trail to the Tashi Gomag Stupa is a few steps from your door. Take advantage of the abundance of income producing potential, with this thriving B&B business or escape to this mountain refuge & make it home. The possibilities are endless.
MlsNumber: 5525880


Listing Provided By: eXp Realty, LLC, original listing
Name: eXp Realty, LLC
Phone: (303) 803-6663
Office Name: eXp Realty - ROCC
Office Phone: (888) 440-2724
Agent Name: Niamh Kelly-Weston
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