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

64 Spruce Ridge Lane
Snowmass Village, CO 81615

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $18,000,000
Beds: 5
Baths: 6
Status: Active
SqFt: 5321
Agency: Engel & Völkers Aspen

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Other
Year Built: 1999
Notes: Spruce Ridge Retreat is a secluded mountain escape in the Pines at Owl Creek. This luxurious Snowmass Village estate offers privacy and exclusivity, making it the perfect location for adventurous vacations, family reunions, and other special events, no matter the season. With versatile indoor and outdoor spaces, this property offers stunning mountain views and ample space for memorable gatherings.<br /> <br /> In the summer, the property's outdoor spaces come to life, providing the perfect setting for barbecues, outdoor games, and relaxation in the sunshine. You'll be just steps away from the amenities of Base Village, including hiking and biking trails, live music events, and family-friendly activities.<br /> <br /> In the winter, you'll love the property's ski-in/ski-out access, allowing for easy access to world-class skiing on Snowmass and an incredible nordic skiing network. The cozy fireplaces, hot tub and fire pit provide the perfect places to warm up and apres after a day on the slopes. Plus, you'll be located in close proximity to the dining, shopping, and entertainment options of Aspen.<br /> <br /> This retreat is just a short drive from the Aspen airport, making it a convenient destination for those traveling from afar. With a gourmet kitchen and spacious living areas, Spruce Ridge is the ultimate destination for those seeking a luxurious and unforgettable mountain experience, year-round. Don't miss out on the opportunity to own a one-of-a-kind mountain retreat in Snowmass Village.
MlsNumber: 174458


Listing Provided By: Engel & Völkers Aspen, original listing
Name: Engel & Völkers Aspen
Office Name: Engel & Völkers Aspen
Office Phone: (970) 925-8400
Agent Name: Melissa Temple
Disclaimer: Copyright © 2024 Engel & Völkers. 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