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

4505 Mountain View Trail
Walsenburg, CO 81089
Amanda Salas with Code of the West Real Estate LLC, original listing - (719) 742-3626

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,490,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 5290 Square Feet
Agency: Code of the West Real Estate LLC
Agency Phone: (719) 742-3626

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 165 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Nestled against a picturesque backdrop of the majestic Spanish Peaks, this unparalleled property offers the perfect combination of land and luxury. This custom home presents an idyllic retreat from the hustle and bustle of everyday life offering over 5,000 sqft of living space situated within 165 fully fenced acres. The interior blends elegance and practicality with a combination of finishes that offer both durability and aesthetic appeal. Inside, modern comforts await with tasteful and spacious interior with expansive room to entertain. This fully furnished home has been filled with tasteful furnishings that have been hand selected for every single room with high quality pieces from Restoration Hardware, Pottery Barn, Neiman Marcus and antiques that boast elegance and beauty. The home itself is spacious, offering plenty of room for relaxation, entertainment, and personal pursuits. Enjoy the fully equipped personal gym as an added bonus. Meticulously cared for and minimally occupied less than a week per year. This is truly a sought after turn key opportunity. Beyond the home you will enjoy beautiful pasture and mature trees overlooking the picturesque Cuchara River Valley. The highlight of the property is its expansive wrap-around porch, a perfect spot to unwind and soak in breathtaking views of the surrounding peaks , valleys and unobstructed 360 degree views. Fully fenced, surveyed and offering mineral rights. Continued in agent remarks.
MlsNumber: --
ListingId: 223127


Listing Provided By: Code of the West Real Estate LLC, original listing
Phone: (719) 742-3626
Office Phone: (719) 742-3626
Agent Name: Amanda Salas
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