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 = 296 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 296 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 296 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;

4009 St Andrews Dr
Pueblo, CO 81001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $697,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2699
Agency: HomeSmart Preferred Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Stunning new construction 4 bed, 3 bath home offers an array of impressive features. The oversized 3 car garage (33x31) is fully finished including additional outlets for a workshop area. This home boasts 10' ceilings, 9' doorways and an expansive living room, creating a spacious feel. Exterior synthetic stucco and Andersen double-pane vinyl windows help with energy savings. The open concept kitchen flows seamlessly into the informal dining area and living room. The kitchen is equipped with granite countertops, tile flooring, a hidden pantry room (accessed via pass-through cupboards), as well as dove-tailed cabinets with crown molding. Stainless appliances complete the modern look. Formal dining area is adjacent the kitchen, while the laundry room is conveniently located off the garage with quality cabinets, tile flooring, and granite counters - no detail was missed in this home. Another energy efficient feature is the tankless on-demand water heater. A split bedroom design provides privacy. The primary bedroom has its own patio, trayed ceiling, and ensuite 5 piece bath featuring a custom shower and huge soaking tub. Its walk-in closet is enormous and conveniently located off the ensuite. Lastly, a covered patio accessed via sliding doors from living room provides a comfortable outdoor space with amazing mountain views. The home is situated in the Walking Stick Vistas subdivision, which includes a shared community park. Minutes to CSU-P & shopping. Schedule to see it today!
MlsNumber: 219078


Listing Provided By: HomeSmart Preferred Realty, original listing
Name: HomeSmart Preferred Realty
Phone: (719) 582-1046
Office Name: HomeSmart Preferred Realty
Office Phone: (719) 582-1046
Agent Name: Elizabeth Daniel
Disclaimer: Copyright © 2024 Pueblo 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