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;

400 Cr 570
Redwing, CO 81040
Mary Shepherd with Wapiti Ranch Realty and Auction LLC, original listing - (719) 783-9052

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,790,000
Beds: 6
Baths: Full: 2, ½: 1, ¼: 1, ¾: 1
Status: Active
SqFt: 4671 Square Feet
Agency: Wapiti Ranch Realty and Auction LLC
Agency Phone: (719) 783-9052

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 165 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Nestled on 165 acres of fertile land, this Ranch offers a rare blend of rustic charm and modern comfort. The barn/house main residence features 1,600 SF living space upstairs and an additional 900 SF in a downstairs suite, complete with 2 bathrooms. The open-concept kitchen boasts energy-efficient appliances, custom knotty alder cabinetry, and heavy-duty composite flooring that pairs durability with style. In-floor radiant heating ensures cozy winters throughout the home. The 2nd home, a 1907 farm house offers 4 additional bedrooms, 2 bathrooms, a cozy wood stove, and efficient heating systems. This property is a fully equipped ranching opportunity. With three fenced pastures, working pens, large corrals, and a cattle chute, the setup is ideal for a small cow/calf operation. The outbuildings include a 4-stall horse barn, a 50x50 hay barn, and a second pole barn for added storage. The towering pinions and cedars provide shelter for calving, while an apple orchard and flowing streams enhance the property's charm. Eighty acres of hay fields come with WATER RIGHTS, and over 1/8 mile of shaded riverbank along the Huerfano River creates a perfect spot for family picnics.
MlsNumber: --
ListingId: 2517065


Listing Provided By: Wapiti Ranch Realty and Auction LLC, original listing
Phone: (719) 783-9052
Office Phone: (719) 783-9052
Agent Name: Mary Shepherd
Disclaimer: Copyright © 2024 Westcliffe Listing Service. 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