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;

56506 County Road Aa
Moffat, CO 81143

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1584
Agency: Pinon Real Estate Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 52 acre(s)
Property Type: Residential
Year Built: 2007
Notes: Come home to 360 degree mountain views in this recently renovated two bedroom, two bath southern style ranch home in the San Luis Valley. Enjoy incredible sunrises and sunsets from the wrap around deck and stay cozy by the fire pit just out back. Everything from outside to inside is newly updated including exterior stucco and paint, LVP flooring, new light fixtures in every room, fresh paint, and more! The master bedroom features a large walk-in closet and updated en suite bathroom. Attached to the home are a few more rooms set up to make all of your agricultural projects a success. Two fully-loaded greenhouses sit behind the home and include automatic light deprivation equipment, irrigation, heating and cooling. There's even a fenced area attached to the southern side of the house for chickens, other animals, or a garden. The lot expands to the east boasting an ATV track and views of the Great Sand Dunes National Park. The property also features a custom built 75k transformer with two pedestals, RV hookups, and an agriculture/domestic well that supports 1.3 acres of irrigation and 3 dwellings. All of this is just on the main 42 acre property. This listing also includes two 5+ acre lots to the north and south adjacent to the main 42 acres, both with immense opportunity for building equity. On the northern lot is a third fully-loaded greenhouse connected to an equally-sized quonset hut home ready to be developed and customized into an open floor plan dwelling. The southern lot has an 840 square foot cabin with French doors and oversized windows. This cabin is also ready to be customized. This homestead is centrally located in Saguache county, 15 minutes from Joyful Journey Hot Springs, 30 minutes from Hooper Hot Springs, 45 minutes from Salida and Alamosa, one hour from Monarch Mountain Ski Area, and an hour and a half from Wolf Creek Ski Area. Set up a showing today and see how special this opportunity really is!!!
MlsNumber: 9846046


Listing Provided By: Pinon Real Estate Group, original listing
Name: Pinon Real Estate Group
Phone: (719) 539-0200
Office Name: Pinon Real Estate Group LLC
Office Phone: (719) 539-0200
Agent Name: Joseph Rovinsky
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