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

Tbd Whetstone Drive
Silverthorne, CO 80498
Morgan Storch with Coldwell Banker Distinctive Properties, original listing - (970) 367-7977

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,770,000
Beds: 5
Baths: Full: 1, ½: 1, ¾: 4
Status: Active
SqFt: 4590 Square Feet
Agency: Coldwell Banker Distinctive Properties
Agency Phone: (970) 879-8814

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Introducing The Overlook at Summit Sky Ranch! Located on over 340 acres of pristine natural beauty in the heart of Colorado’s Blue River Valley, The Overlook offers a unique lifestyle that provides residents with a sense of privacy from their neighbors while still being fully connected to all the amenities and outdoor adventures offered at Summit Sky Ranch. These homes provide breathtaking views that blend seamlessly with the contemporary design and natural beauty of the mountain surroundings. This west-facing homesite has views of the Gore Range and backs up to the National Forest. The Alder floor plan, located on Lot 6, boasts a spacious living area that centers around a beautiful floor-to-ceiling stone fireplace with various stone options. The main level welcomes you with 12' vaulted ceilings, an oversized kitchen complete with a full butler's pantry, and top-of-the-line Wolf® and Sub-Zero® appliances. The living area is perfect for hosting family gatherings, and there are five generously sized bedrooms with dedicated bathrooms that provide privacy for your family. You'll also find spacious mud and laundry rooms, a heated three-car garage, a stunning primary suite with 10' ceilings, a five-piece bathroom with a free-standing tub, and two walk-in closets. The upper level has three of the four guest bedrooms and a rec room with sweeping views, abundant natural light, and ample space for relaxation and entertainment. The developer is offering a $150,000 credit to the first four buyers and two are already under contract! This homesite is a must see and you won't want to miss out on this incredible property.
MlsNumber: --
ListingId: S1048897


Listing Provided By: Coldwell Banker Distinctive Properties, original listing
Phone: (303) 895-0272
Office Phone: (970) 367-7977
Agent Name: Morgan Storch
Disclaimer: Copyright © 2024 Altitude 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