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;

1023 Raven Way
Como, CO 80432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 2296 Square Feet
Agency: Jefferson Real Estate, Inc.
Agency Phone: (719) 836-2615

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Exquisitely finished by a master craftsman, the interior of this home is a showplace. From the stone finished atrium and sun room in the back, the elegant, rich woodwork and staircases, the curved archways, the crown molding, the wainscoting, to the stone base for the wood stove, the custom finishes go on and on. This is no ordinary cabin. The main level opens to the atrium, the perfect green space to take advantage of the ample Colorado sunshine. A stone archway leads to a great room and spacious kitchen. A bedroom and wainscoted bathroom which is functional as well as beautiful are tucked off to the side. Tile floors throughout and radiant heat will keep you warm all winter. Out the beautiful, custom front door is another sun room waiting for you to turn it into your favorite place to relax. The main level opens to a huge deck, perfect for taking in the stunning mountain and valley views. The upper level is pure bliss, a large bedroom, so warm and inviting, and a luxurious bathroom with a soaking tub. The lower level is a fully finished basement with an additional full bath. A spacious, bright and open living space with a cozy wood stove, plenty of windows, and walk out access can be used as a family room, office space, anything you can imagine. There is also a roomy utility/laundry room to make your life so convenient. This cabin is perfectly designed for family and friends - a mountain getaway or full time residence. The attention to detail in this home must be seen to truly be appreciated. All of this is situated on a 6 acre, beautifully treed lot at the end of a Cul-de-Sac which affords you ultimate privacy with a rolling slope to take full advantage of the massive views. All the power is trenched underground, and the property has a domestic well, so you are free to water outside. There is also an outdoor greenhouse and shed for additional storage. The exterior of the home needs some finishing, but this luxury mountain cabin is more than move in ready.
MlsNumber: --
ListingId: S1053422


Listing Provided By: Jefferson Real Estate, Inc., original listing
Phone: (719) 838-0117
Office Phone: (719) 836-2615
Agent Name: JoAnn MacDougall
Disclaimer: Copyright © 2024 Altitude 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