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

42 Holiday Hills Boulevard
Howard, CO 81233
Darcy Shaffer with First Colorado Land Office, Inc., original listing - (719) 539-6682

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 4
Baths: Full: 1, ¼: 1, ¾: 1
Status: Active
SqFt: 3720 Square Feet
Agency: First Colorado Land Office, Inc.
Agency Phone: (719) 539-6682

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Spacious Updated Home on 6.38 Acres with Stunning Mountain Views<br /> Escape to the tranquility of Howard, Colorado, where this beautifully updated 3,720 sq. ft. home on 6.38 acres offers space, comfort, and breathtaking views of Twin Sister peaks and Hayden Pass.<br /> <br /> The open-concept living area features soaring beamed ceilings, rich bamboo flooring, and a gourmet kitchen with Alder cabinetry, granite countertops, high-end appliances, and a whole-house water softener. A Lopi Endeavor wood stove and five zones of hot water baseboard heat ensure year-round comfort, while large Milgard windows fill the space with natural light.<br /> <br /> With four spacious bedrooms, including a primary suite with ensuite bath, plus an additional ¾ bath and laundry room with utility sink and urinal, there's room for all. A versatile bonus room with a separate entrance and 220-amp service is ideal for a workshop, studio, or small business. A radon mitigation system is also in place.<br /> <br /> Outside, enjoy irrigated fruit trees (apple, peach, cherry, and pear), a dedicated garden area, two storage sheds, two covered porch awnings, and an exterior spigot for vehicle washing. The property is supported by a commercially augmented well.<br /> <br /> Located just 15 minutes from Salida on a county and state maintained road, this home offers the perfect blend of rural serenity and easy access to Salida or Canon City. Most furnishings are negotiable, and the riding lawnmower is included.<br /> <br /> Don’t miss this incredible opportunity—schedule your private showing today!
MlsNumber: --
ListingId: 1931566


Listing Provided By: First Colorado Land Office, Inc., original listing
Phone: (719) 539-6682
Office Phone: (719) 539-6682
Agent Name: Darcy Shaffer
Disclaimer: Copyright © 2025 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