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;

470 Cr 570
Red Wing, CO 81040
JACKIE SHEPHERD with UC WAPITI RANCH REALTY & AUCTION LLC, original listing - (719) 783-9052

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,790,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: UC WAPITI RANCH REALTY & AUCTION LLC
Agency Phone: (719) 783-9052

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 165 acre(s)
Property Type: Farm-Other
Year Built: 2017
Notes: This stunning newly built 2-story barn/house rests on 165 acres of fertile, lush land. The home boasts a 1600 SF living space upstairs, with a 900 SF suite downstairs and 2 bathrooms. The primary bedroom features a spacious deck overlooking the majestic Huerfano River. The open design kitchen includes energy-efficient appliances and knotty alder custom cabinetry. Heavy-duty composite flooring enhances both durability and aesthetic appeal throughout the home. In-floor radiant heat keeps the home nice and warm in the cold winter months. A cozy 2nd home, built in early 1900s, contains an additional 2,171 sf of living space, including 4 bedrooms and 2 baths, which provides ample living room for all your family & guests. The wood stove, a highly efficient wall heater and baseboard heaters warm the house. This property is a perfect place for a small cow/calf ranching operation. With three fenced pastures, a good set of working pens, 2 large corrals & a cattle chute, it can accommodate a variety of livestock pursuits. The 16x50 barn contains a drive-through shop with 12x12 doors & 4 horse stalls. A 50 x 50 hay barn and a second pole barn are ideal for extra hay storage. The land boasts pinons and cedars for shelter for calving, an apple orchard, flowing streams, 80 acres of hay fields with Senior Water Rights & a livestock well. The Property has over 1/8 mile of trees along the banks of the Huerfano River allowing cattle to water year-round or hosting Family picnics in the shade.
MlsNumber: --
ListingId: 71811


Listing Provided By: UC WAPITI RANCH REALTY & AUCTION LLC, original listing
Phone: (214) 577-5421
Office Phone: (719) 783-9052
Agent Name: JACKIE SHEPHERD
Disclaimer: Copyright © 2024 Royal Gorge 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