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

56494 County Road Aa
Moffat, CO 81143

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $555,000
Beds: 4
Baths: 2
Status: Active
SqFt: 3144
Agency: Western Mountain Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential
Year Built: 1999
Notes: *Seller Financing Available* Tastefully renovated home on 40 acres in the northern San Luis Valley. Ideal for a group retreat setting, multiple-unit/campsite rentals or a large family, with over 3,000 sq ft divided into 2 unique living spaces and outdoor utility hookups. Step inside to find a 600+/- sq ft living room, perfect for hosting, featuring loads of natural light, a vaulted ceiling and a freestanding wood stove to cozy up to on chilly evenings. High-end custom marble, porcelain and ceramic tile-work in the main kitchen and bathrooms. Enjoy stunning views of the Sangre de Cristo Mountains and the expansive San Luis Valley through the home’s many picture windows. 2 of the 4 bedrooms are on the upper level; 1 boasts attractive bamboo flooring and its own private balcony. The other features built-in shelving and a huge walk-in closet with a tongue-in-groove wood ceiling. An insulated concrete perimeter foundation was recently poured around the entire home. The garage has a new metal roof, a separate 200-amp electrical service, new flooring and an overhead door (currently under construction). 2 freshly installed septic systems service the garage and RV sites. The domestic well allows you to provide water to up to 3 households, livestock and an acre of outside irrigation. Plenty of space on 40 acres for more homes, workshops, barn structures, etc. Bring your vision! Located in unincorporated Saguache County, there is no HOA or covenants. It's a straight shot down Highway 285 from Denver, and only a 40-minute drive to Salida or Alamosa. Nearby several hot springs, the Great Sand Dunes National Park, world-class skiing, fishing, hunting, rafting, hot springs, mountain biking, 4-wheeling, horseback riding and endless miles of hiking trails. Bask in some of the most breathtaking sunsets and darkest night skies on the planet! This is a great value buy. Come fall in love with this special place for yourself. Call for a private showing today!
MlsNumber: 7920429


Listing Provided By: Western Mountain Real Estate, original listing
Name: Western Mountain Real Estate
Phone: (719) 539-1900
Office Name: Western Mountain Real Estate
Office Phone: (719) 539-1900
Agent Name: Michael Byer
Disclaimer: Copyright © 2024 ROCC/REcolorado. 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