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

232 Stetson Drive
Edwards, CO 81632
Kyle Denton with Berkshire Hathaway - Vail VLG, original listing - (970) 329-2482

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,825,000
Beds: 4
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 2375 Square Feet
Agency: Berkshire Hathaway - Vail VLG
Agency Phone: (970) 329-2482

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Duplex
Year Built: 2017
Notes: Built in 2017, this newly constructed 4-bedroom home provides easy mountain living. It was designed with an incredible sustainable building package. This modern home was constructed with energy efficiency in mind, to keep you warm in winter and cool in summer. The home uses passive solar, allowing natural light to stream through the large windows, which also highlights the mountain views. Lives like a single family with separate entry, garage, and yard. Custom interior doors that are sound sealed. The home resides on the quiet street of Stetson Drive within the coveted Singletree neighborhood. The open concept floor plan flows seamlessly into two oversized patios, and is ideal for entertaining friends and family. Walk directly into your living space from your oversized 2-car garage. The home features natural hardwood floors, vaulted ceilings. The main level primary suite features two walk-in closets, a five-point bathroom and direct access onto one of the covered garden patios. Three additional bedrooms on the top floor enjoy open mountain views, and the comfort of a home that is fully air conditioned. There are numerous large additional storage spaces throughout the home for all the seasonal and secondary storage needs. Walk or bike directly to the Sonnenalp Club or Harvest restaurant, and you are minutes away from Arrowhead, Beaver Creek and downtown Edwards.
MlsNumber: --
ListingId: 1010972


Listing Provided By: Berkshire Hathaway - Vail VLG, original listing
Phone: (970) 329-2482
Office Phone: (970) 329-2482
Agent Name: Kyle Denton
Disclaimer: Copyright © 2025 Vail Board 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