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

1210 Engleman Road
Westcliffe, CO 81252
KEELY SMITH with CUSTER COUNTY REALTY, INC., original listing - (719) 783-9221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 5234 Square Feet
Agency: CUSTER COUNTY REALTY, INC.
Agency Phone: (719) 783-9221

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 70 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2007
Notes: Nestled amongst the serene beauty of aspen, fir, and pine trees, these two breathtaking homes offer everything you could want and more. The main home is a marvel with its accessibility features, including an elevator that connects all three floors, ensuring everyone can enjoy its luxurious amenities. The master suite is a true sanctuary, featuring a cozy fireplace that adds a touch of ambiance, and a walkout to a hot tub where you can soak. Whether you're curling up with a book in the library or tinkering away in the workshop, this home is designed for comfort and inspiration. The guest house is no less spectacular with 3 beds, 2 baths, it offers ample space for family and friends. Spanning 1,560 square ft, this charming abode also boasts beautiful views. Adding an artistic flair to these homes, you'll find hand-painted murals throughout, making each space uniquely enchanting Just 15 minutes from the quaint town of Westcliffe, CO, and its vibrant community, you'll have easy access to all the amenities you need while still enjoying the tranquility of mountain living. Westcliffe is renowned for its DARK SKY community, and nearby Sangre de Cristo Mountains with 52 high mountain lakes! Whether you're an artist enthusiast or simply someone who appreciates beauty and serenity, these homes offer a perfect blend of rustic elegance and modern convenience. Come see for yourself what makes these mountain retreats so special, and get ready to fall in love with your new haven.
MlsNumber: --
ListingId: 70979


Listing Provided By: CUSTER COUNTY REALTY, INC., original listing
Phone: (719) 214-2501
Office Phone: (719) 783-9221
Agent Name: KEELY SMITH
Disclaimer: Copyright © 2024 Royal Gorge 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