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;

484 Gordon Dr
Walsenburg, CO 81089
Debra Gonzales with Code of the West Real Estate LLC, original listing - (719) 742-3626

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 1
Baths: Full: 2
Status: Active
SqFt: 1898 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: 152 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Located-10 miles east of Gardner, at the base of Silver Mountain sits a Custom Log Home on 152 Acres of Breathtaking Views!!! As you discover this acreage you will find trails to ride your 4x4, hike, shoot, hunt, look for sheds, camp, listen to Elk bugle, see the Deer play, hear the Turkeys gobble, watch the Big Horn Sheep teach their young to jump the rocks, survey the terrain for Bears, & see the Eagles soar from the rocks above! This can be your scenic playground, or take a hike up to the Members only-private access to BLM. The custom oak fence guides you to the driveway & a Private Retreat. This acreage boasts a Productive Well, 4k gal cisterns, 4 space RV park with pwr/wat, a bunkhouse, shower house, & 2-9'x40' Conex containers for your shop/barn/or garage. The interior of the home is AWE inspiring as you take in the huge logs & ponder the insulation factor that creates this highly efficient home. Cozy warmth radiates from 2 wood stoves but In Floor Radiant Heat is also available. The Baker's Dream kitchen will have aromas floating thru the home that make your mouth water, while the bedroom suite beckons you for relaxation, peace, & romance, as you absorb the Stunning Views while you soak in the tub or sip your morning coffee. The 1400'+ basement constructed w/ICF blocks provides ample space to create your own vision also housing the high end efficiency boiler & on demand heat utilities. Come and visit to experience this extraordinary property for yourself.
MlsNumber: --
ListingId: 229119


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