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

39858 Highway 24
Lake George, CO 80827

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 930 Square Feet
Agency: Keller Williams Clients Choice Realty
Agency Phone: (719) 535-0355

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 107 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Rare opportunity to acquire large " old ranch" acreage with live water and paved highway frontage. Includes turn-key vacation rental log-sided cabin, fully furnished with established cleaning service and current bookings. Private setting with unimpeded views of Pikes Peak from hot tub, BBQ deck and floor to ceiling cathedral window wall. Perfectly situated to enjoy beautiful Colorado sunrises and sunsets. Main level includes great room with wood stove and ceiling fan and a seated dining area that adjoins a compact kitchen with large bar counter, plenty of storage and bathroom access. The main bedroom has his/hers closets and a pass through to the bathroom that includes a walk-in shower and stacked laundry facility. Reach the spacious 2 bed view loft with seating area and big dormer windows via a beautiful log banister staircase. The interior is finished in beautiful knotty pine tongue and groove siding. There is a screen porch off the great room/kitchen end with access to the BBQ deck and hot tub. The attached two car garage makes this property very functionable year round. The 107 acre parcel can be split up into 3 thirty five acre plots. The east side is open rolling meadow with Pikes Peak view, the west is large rock formations and mature timber, the south has Twin Creek flowing through it and adjoins National Forest. The locked property gate is located on a paved US Hwy. Just ten minutes to Lake George or Florissant for groceries, gas, bars and restaurants. Lots of nearby National Forest with miles of trails. Close to Eleven Mile Canyon and Reservoir for gold medal fly fishing, marina and boating. 1 hour east to large urban area with major airport, one hour west to skiing and hot springs.
MlsNumber: --
ListingId: 1725948


Listing Provided By: Keller Williams Clients Choice Realty, original listing
Phone: (719) 963-4135
Office Phone: (719) 535-0355
Agent Name: John Magoon CNE
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