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;

1838 E Longbow Drive
Como, CO 80432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $709,000
Beds: 2
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 1408 Square Feet
Agency: Jefferson Real Estate
Agency Phone: (719) 836-2615

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome to 1838 E Longbow Dr, a stunning log home that offers a rare chance to embrace the serene beauty of mountain living without sacrificing modern comforts. Nestled on 8.5 acres of picturesque Colorado landscape, this captivating retreat features breathtaking views of the Continental Divide and Eagle Rock. This meticulously maintained home seamlessly blends rustic charm with contemporary luxury. As you step inside, you`ll be greeted by an expansive open floor plan, featuring vaulted tongue-and-groove ceilings and beautiful hardwood floors. The home boasts 2 spacious bedrooms and 2 well-appointed bathrooms, including a private, high-end bath in the primary bedroom. The kitchen is a chef`s delight, with tons of custom cabinets, upgraded countertops, and a cozy breakfast bar, all situated in an impressive great room. An efficient wood-burning fireplace adds to the home`s comfort, offering cozy warmth during winter storms while you watch the snowfall. For those who love to entertain or simply relax, the home features both a front covered deck and an open rear deck, perfect for enjoying the stunning views of the Continental Divide and snow-capped mountain peaks. Also there is an excellent gathering spot around the fire pit to watch the stars and tell campfire stories! There are also 2 sheds 1 for tools and a 20x10 for toys. The property is equipped with a well, a septic system, and is connected to the grid. Located just 60 minutes from Breckenridge`s world-class skiing and Buena Vista`s whitewater rafting, this home offers easy access to a variety of outdoor activities. A short 5 min walk down the road brings you to the Pike National Forest, with its endless recreational opportunities. Additionally, fishing enthusiasts will appreciate being only 20 minutes away from Tarryall Reservoir and other nearby streams and reservoirs. Come see this beautiful log home for yourself and make an offer on this mountain paradise!
MlsNumber: --
ListingId: 9317454


Listing Provided By: Jefferson Real Estate, original listing
Phone: (719) 836-2615
Office Phone: (719) 836-2615
Agent Name: Kevin Copeland
Disclaimer: Copyright © 2024 ROCC/REcolorado. 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