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;

614 Palomino Way
Crestone, CO 81131
Niamh Kelly-Weston with eXp Realty - ROCC, original listing - (888) 440-2724

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 4
Baths: Full: 1, ½: 1, ¾: 1
Status: Active
SqFt: 4090 Square Feet
Agency: eXp Realty - ROCC
Agency Phone: (888) 440-2724

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Welcome to your luxurious mountain sanctuary with unmatched views & endless potential! This remarkable 4 BD, 3 BA, 4,090-sq ft custom home is set on nearly an acre of pristine, partially wooded land in Chalet 1. A rare jewel in the heart of the Baca, it embodies mountain luxury, craftsmanship, & high-end features. Built with exceptional quality, this home offers a rare opportunity to own something far below the cost of replacement. The center compression joint & oversized foundation allow for no load-bearing walls on the 2nd floor, maximizing design flexibility. Designed for relaxation and versatility, it offers the opportunity to create 2 distinct living spaces, perfect for multi-generational living, or rental potential. The upper-level great room, an approximate 1100-sq ft sunlit space, boasts panoramic views of the mountains & San Luis Valley. Perfect for entertaining, with a gourmet kitchen featuring a Café 6-burner range, with dramatic copper hood, Viking refrigerator, Café dishwasher, granite countertops, walk-in pantry, and even your own sauna! The wrap-around deck is the ideal spot for morning coffee or evening wine as the golden sunrise & sunset hues light up the sky. The primary suite is your private retreat, complete with a balcony perfect for stargazing and a spa-like 5-piece bath, featuring a soaking tub, full body shower, dual vanities, and a cozy propane fireplace. Downstairs, 3 spacious bedrooms, and a second kitchen with induction cooktop, fridge, & freezer provide a separate living space option. The large entry space downstairs can be a second family room, home theater, or creative studio, all wired for surround sound. Outside, Pinon pines offer privacy, while the landscaped yard includes fenced garden beds. The oversized two-car garage has an RV hookup with 500 amps and ample storage for all your gear. This serene mountain sanctuary blends luxurious living with nature's beauty. A rare find, this home offers peace, beauty, and boundless potential.
MlsNumber: --
ListingId: 5517570


Listing Provided By: eXp Realty - ROCC, original listing
Phone: (719) 480-5347
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