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

28360 County Road 3
Haxtun, CO 80731
Johnna Harris with Town Square Realty, original listing - (970) 522-2009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $974,900
Beds: 4
Baths: Full: 2, ¾: 1
Status: Active
SqFt: 4352 Square Feet
Agency: Town Square Realty
Agency Phone: (970) 522-2009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: This exceptional property features two beautiful homes, offering both modern luxury and classic charm. The main house, completed in 2021, boasts 4 spacious bedrooms and 3 bathrooms. The open-concept design showcases Pergo floors throughout, creating a sleek and low-maintenance living space. The primary suite is a true retreat with a striking cast iron clawfoot tub, an onyx stone shower, and a large walk-in closet. The gourmet kitchen is a chef's dream, complete with granite countertops and high-end appliances, perfect for both everyday meals and entertaining. A dedicated office space provides an ideal spot for working from home. The fully finished 2-car attached garage adds convenience and extra storage. In the basement includes the third bath, fourth bedroom, and a rough-in for an additional bathroom and plumbing for a wet bar offer future possibilities for expansion. The charming farmhouse, which has undergone many thoughtful updates, adds additional living space and versatility to this unique property. Step outside and enjoy the fully organic garden area, perfect for growing your own food. Multiple outbuildings include two bunkhouses (one with heat), a 3+ car finished shop, and a barn with stalls, hay storage, and new electrical wiring, making this property ideal for livestock or hobby farming. Both homes are on their own well and septic systems and have been subdivided into four parcels-two 5-acre lots, the new house, and the farmhouse-providing endless potential for use or future development. Don't miss the opportunity to own this rare and expansive property, offering a perfect blend of modern living, rustic charm, and functional outdoor space.
MlsNumber: --
ListingId: 1025244


Listing Provided By: Town Square Realty, original listing
Phone: (970) 522-2009
Office Phone: (970) 522-2009
Agent Name: Johnna Harris
Disclaimer: Copyright © 2025 Information and Real Estate Services, LLC. 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