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;

4812 County Road 88
Guffey, CO 80820
Stacey Lehner ABR MRP SRES with Your Neighborhood Realty, Inc., original listing - (719) 445-0234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 6016 Square Feet
Agency: Your Neighborhood Realty, Inc.
Agency Phone: (719) 235-2409

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 80 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Set on 80 acres of rolling, scenic land with a live creek, this exceptional mountain log home combines rustic elegance with modern sustainability. Crafted from durable square logs and featuring rich hickory flooring, this residence exudes warmth and quality throughout. The great room, complete with a fireplace and wood stove, creates an inviting space perfect for cozy gatherings. The spacious kitchen is designed for both function and charm, showcasing an island, ample storage, and a breakfast nook that opens onto a composite, covered deck. This outdoor space is ideal for savoring mountain views and peaceful surroundings.<br /> Wood-framed windows throughout the home frame breathtaking vistas and invite natural light. A versatile sitting room or office, equipped with a wood-burning stove and deck access, provides a quiet retreat or workspace. The primary bedroom offers comfort and storage with double closets, one of which is a walk-in. The adjoining primary bath features a large standing shower and a classic clawfoot tub for a touch of timeless luxury. The junior suite includes an en-suite bath, providing privacy and convenience for guests or family.<br /> The upper level, currently unfinished, holds potential for transformation into two additional bedrooms and a spacious family room. The walk-out basement, also unfinished and complete with a half bath, offers flexibility for a range of uses, from recreational space to guest accommodations.<br /> Active solar energy and hot water baseboard heating throughout the home ensure energy efficiency and year-round comfort. With ample space, stunning natural landscapes, and equestrian potential, this property is ideal for horse enthusiasts or those seeking a private mountain retreat. Don’t miss this rare opportunity to own an 80-acre sanctuary that blends rustic charm, modern amenities, and limitless possibilities.
MlsNumber: --
ListingId: 9123218


Listing Provided By: Your Neighborhood Realty, Inc., original listing
Phone: (719) 684-3457
Office Phone: (719) 445-0234
Agent Name: Stacey Lehner ABR MRP SRES
Disclaimer: Copyright © 2025 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