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

3900 Dexter Drive
Granby, CO 80446

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,490,000
Beds: 6
Baths: 8
Status: Active
SqFt: 12287
Agency: Keller Williams Colorado West Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Stunning 6-bedroom estate home in the Dexter Meadows exclusive gated community within the 5-Star, 8,500+acre C Lazy U Guest Dude Ranch in Granby. PRIVACY and ANONYMITY to help you enjoy getting away from life stresses, or entertaining friends and family. Own this 39-acre legacy property with panoramic views of the Continental Divide, Indian Peaks mountain range. This grand 8,459 sq. ft. chalet-style home, constructed with Canadian Douglas fir logs post and beam, features an expansive Brazilian hardwood deck surrounding the home to enjoy the views. The interior welcomes you with a large foyer, fireplace, and grand great room where you can watch the Ranch's 200 horses from floor to ceiling windows run in the meadow below. Enjoy private fishing from the creek in your backyard and as a member of C LazyU Ranch access to the ORVIS-Endorsed Fly Fishing lodge. Willow Creek, 100ft away, flows into a reservoir for kayaking, boating, and more. The home has 6 ensuite bedrooms, 2 powder baths, gourmet kitchen, and entertainment rooms. Bonus ,large screened porch with fireplace pass thru BBQ bar on chilly fall nights.Amenities include ALDER DOORS and CABINETS, antler chandelier, hardwood floors, steel roof and home automation, and more. As a C LazyU Ranch member, enjoy fishing, Horseback riding, Spa services, Gym, Yoga, Tennis, Swimming, farm to table dining prepared by 5-Star Michelin Chefs, Enjoy winter Snowmobiling, Cross Country Skiing, Sledding, Iceskating. This one-of a-kind home designed and Built in 2006 by RMT Vail architects. This high quality unique home is asking price that is under the cost to build a home of this caliber today. Membership has a $50,000 initiation fee. Association has a required 1st right of refusal.
MlsNumber: 182225


Listing Provided By: Keller Williams Colorado West Realty, original listing
Name: Keller Williams Colorado West Realty
Phone: (970) 201-9100
Office Name: Keller Williams Colorado West GJ
Office Phone: (970) 256-9101
Agent Name: Lea Novgrad
Disclaimer: Copyright © 2024 Aspen/Glenwood Springs MLS. 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