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

31055 Deerwood Ranch Road
Oak Creek, CO 80467
David Baldinger Jr. with Steamboat Sotheby's International Realty, original listing - (970) 879-8100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,000,000
Beds: 3
Baths: Full: 5
Status: Active
SqFt: 6220 Square Feet
Agency: Steamboat Sotheby's International Realty
Agency Phone: (970) 879-8100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Discover the luxurious custom estate at Silver Moose Ranch, nestled in the prestigious Deerwood Ranches. Located less than 15 minutes south of Steamboat Springs, this magnificent property spans 35 acres & offers privacy, panoramic views, & exceptional indoor & outdoor living spaces, perfect for entertaining. The main/entry level is on the second floor & features a grand living room with high vaulted ceilings, 24+’ stone fireplace, exquisite wood floors, & floor-to-ceiling windows that invites the natural beauty into the home. At the heart of the home is a central kitchen, equipped with granite countertops, 48” Sub Zero refrigerator, 8-burner Wolf stove with two oven compartments, Bosch dishwasher, under counter microwave, island with prep sink & breakfast bar, & an open layout that seamlessly connects to the living & dining rooms. The expansive primary suite, also on the main level, has air-conditioning & boasts two large walk-in closets & a large ensuite bath complete with separate his & hers vanities, soaking tub & steam shower. There is in-floor/radiant heating throughout this floor & the first floor. The walkout first floor is an entertainer’s dream, with an open layout, a large bar, full bath, & ample space for fun with friends. The upper level (3rd floor) houses two generously sized ensuite bedrooms each with their own air-conditioning & heat controls. Every level of the home is easily accessible with the convenient elevator. Enjoy your morning coffee or evening glass of wine on one of the two oversized decks, each offering breathtaking views. For stargazing enthusiasts, the property includes an observatory just steps from the home, making it a prime location for celestial observation. The detached three-car garage provides ample space for vehicles & all your outdoor equipment. This property is ideal for equestrians, gentleman ranchers, or anyone seeking an incredible private retreat. Come experience the unmatched serenity & luxury of Silver Moose Ranch.
MlsNumber: --
ListingId: S1048981


Listing Provided By: Steamboat Sotheby's International Realty, original listing
Phone: (970) 846-2560
Office Phone: (970) 879-8100
Agent Name: David Baldinger Jr.
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