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;

59 Whip Way
Hartsel, CO 80449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $589,000
Beds: 3
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 1800 Square Feet
Agency: Coldwell Banker Collegiate Peaks Realty
Agency Phone: (719) 395-4700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Brand New Construction with an Excellent Floor Plan Design! One Level Ranch Style Home with NO STAIRS! Features include a Large Custom Built Kitchen, Tons of Cabinet and Countertop Space, Crafted in Solid Wood, Beetle Kill Cabinetry and Beautiful Hardwood Acacia Countertops giving this Kitchen True Colorado Style! Enjoy a Spacious Living Room with Cozy Wood Burning Stove, Beautiful Tongue and Groove Vaulted Ceilings, 9 Ft. Interior Walls throughout, Large Windows that let in Plenty of Natural Light, and Incredible Mountain and Valley Views to the West and Huge Sunsets! Enjoy 3 Spacious Bedrooms with the Primary Bedroom Suite split and separated from the Guest Bedrooms! Both bathrooms boast beautiful Above Counter Sinks and quality Acacia Hardwood Counter tops with Color Inlay! Must See! The Floor Plan Design and exceptional lay out utilizes all 1800 Square Feet to the best advantage feeling very spacious, practical and functional. The French Door in the Living Room leads to a large, Quality Built Deck with those Amazing Views of the countryside! Minimal traffic on Dead End Road! Metal Roof! The Subdivision includes Central Trash Service, a Pavilion, RV Storage, RV Water Fill and Dump Station, affordable Horse Boarding and a Large Private Fishing Lake for owners and guests! Full Time Ranch Manager on site also! There are 2 Forest Access Points in the Ranch and 3 Lakes close by. Hunt Draw Areas 49, 57 and 58 in minutes! Tons of Wildlife in the area! Located close to Buena Vista, the Collegiate Peaks Mountain Range and the World Famous Arkansas River! Short drives to Denver and Colorado Springs. This home is located in the Heart of everything Colorado has to offer! This is a Newly Constructed, move in ready home! Call Today for more information or to schedule a private viewing!
MlsNumber: --
ListingId: 5961773


Listing Provided By: Coldwell Banker Collegiate Peaks Realty, original listing
Phone: (719) 221-4146
Office Phone: (719) 395-4700
Agent Name: Mark Fickle
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