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 = 280 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 280 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 280 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

1060 Marys Lake Rd
Estes Park, CO 80517

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,000
Beds: 8
Baths: 8
Status: Active
SqFt: 3868
Agency: First Colorado Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1900
Notes: Rocky Creek Lodge is a magical Retreat/Wedding Venue in Estes Park, 1 mile from Rocky Mountain National Park. You'll be transported into a mountain dream w/ towering Ponderosas, quaking aspen, burbling brook & peaks all around. This special boutique resort, near one of the most popular nat'l parks, is the perfect turnkey investment for someone wanting the Colorado Mountains lifestyle w/ the potential for lots of growth. Fantastic chance to own/operate a unique small Lodge that can cater to groups as large as 30 (perfect for weddings, reunions or retreats) or fill in with individual nightly rentals of the 3 smaller units & 4 BR Log Cabin. The centerpiece is the lovely historic log home built in 1900 of local logs & native stone. It retains a rustic mountain charm w/ modern conveniences. Its spacious family room is anchored by the local stone fireplace. The 1.74 acre property is a refuge, with wildlife passing through. And it's easy walking distance to the great restaurants & shopping that West Estes offers & just a short drive to downtown, wineries, breweries & events. The grounds provide room for weddings/events & the expansive patio is a great spot for al fresco dining & gathering, with views of Spruce Lake & Lumpy Ridge. Haven, the historic cabin, features 4 cozy BRs, 4 luxury baths, Family Room,TV room, Family-sized dining table in the wraparound porch, fully equipped kitchen, breakfast room, & laundry. LongView Chalet features a full kitchen, dining room w/ fireplace, beautiful Suite, a 2nd full bath w/ laundry & a big deck w/ BBQ & fire table. BrookSide Retreat has 2 Queen BRs & a shared 3/4 bath, kitchenette & dining area, & a large deck w/ BBQ & fire table overlooking the creek. The romantic SunBright Cottage provides a comfortable King bed, jetted tub for two, gas fireplace, kitchenette & private deck. Happy guests return year after year to this enchanting spot. Live in one unit & rent the rest. The lot is zoned A1 giving the possibility of future expansion.
MlsNumber: 1008343


Listing Provided By: First Colorado Realty, original listing
Name: First Colorado Realty
Phone: (970) 586-3333
Office Name: First Colorado Realty
Office Phone: (970) 586-3333
Agent Name: Tom Thomas
Disclaimer: Copyright © 2024 Information and Real Estate Services, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 280 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;
Real Estate Expert Photo for Seth McEwan
Seth McEwan
ASCIIFort Welcome Realty
Call Today!: (720) 955-4135

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App