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;

508 Ravenwood Circle
Grand Lake, CO 80447

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,900
Beds: 3
Baths: 3
Status: Active
SqFt: 1320
Agency: HomeSmart Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: Whether you're seeking a primary residence, a mountain getaway, or you're a savvy investor looking for short or long-term rental opportunities, this modern 3-bed 3-bath Grand Lake property offers unparalleled versatility and potential. Discover endless possibilities and experience mountain living at its finest in this stunning fully furnished home within the coveted Ravenwood Townhomes. Boasting high-quality finishes and abundant natural light, this corner unit is just steps away from the lake. Walk to downtown Grand Lake amenities and enjoy easy access to outdoor adventures such as hiking, biking, skiing, and snowboarding. Close proximity to Granby, Winter Park, and Rocky Mountain National Park ensures endless entertainment and exploration opportunities. Have to stay inside for the day? Fully outfitted with deluxe comforts, this townhome has you covered. The premium kitchen features hickory cabinets, stainless steel appliances, and granite countertops, while vaulted ceilings in the great room and a gas fireplace create a cozy ambiance. Enjoy wonderful views on the two balconies or relax inside as the hand-hewn walnut floors use radiant heat to maintain a perfect environment. With baths adorned with beautiful slate tile and in-floor radiant heat, comfort is paramount. Attached is an oversized heated tandem garage and within the complex is a serene picnic area overlooking the lake. Whether sipping morning coffee on the mountain-view balcony or grilling on a private gas grill, outdoor enjoyment is guaranteed. including a full kitchen and private balconies, this three-bedroom getaway ensures an unforgettable alpine escape.
MlsNumber: 1569704


Listing Provided By: HomeSmart Realty Group, original listing
Name: HomeSmart Realty Group
Phone: (303) 858-8100
Office Name: HomeSmart
Office Phone: (303) 858-8100
Agent Name: Christopher Chester
Disclaimer: Copyright © 2024 Pikes Peak Association 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