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

129 Indian Hill Road
Mosca, CO 81146
Michelle Pyle with eXp Realty - ROCC, original listing - (888) 440-2724

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2860 Square Feet
Agency: eXp Realty - ROCC
Agency Phone: (888) 440-2724

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Step into this amazing Custom-Built Straw Home featuring a Unique construction using straw bales, providing excellent insulation and eco-friendly living. With just under 3000sft of living space, there is an abundance of room for the entire family<br /> Complete with all the amenities you need for ultimate comfort, 2 wood burning stoves joined together with radiant heat floors, guarantee warmth and comfort on cold snowy mornings.<br /> Saltillo Tile Floors upstairs add character and style to the living spaces, while downstairs entertains concrete finished floors with endless possibilities. You can cover them with a floating wood floor, carpet, tile or just enjoy the maintenance free concrete.<br /> Custom solid wood cabinetry in the kitchen accompanied by tile back splashes can only be compliment by the amazing views of the mountains surrounding the house. The buyer has the choice of a propane stove or electric, the seller chose to leave the choice to the buyers. <br /> There are a few drawers that need replacing and we are currently working on finding a craftsman that can tackle the job with a seamless integration.<br /> Custom tile work in the guest and master baths elevates their aesthetic appeal, adding a touch of luxury and sophistication to these tranquil retreats. The master bath promises relaxation with a jetted tub beneath a window looking out over the great sand dunes and Mnt. Blanca<br /> Incredible Mountain Views won’t be missed with large picture windows offer stunning views of Mt. Blanca and the Great Sand Dunes from every room.<br /> Two Balconies: Enjoy clear views of the sand dunes and Mt. Blanca from two balconies, perfect for soaking in the natural beauty.<br /> Open-Concept Living Space: High ceilings and an open floor plan create a spacious and inviting atmosphere perfect for both relaxation and entertaining.<br /> Step outside into the front yard fully fenced along with 2 large kennels for more running space. This property is also horse friendly
MlsNumber: --
ListingId: 3239018


Listing Provided By: eXp Realty - ROCC, original listing
Phone: (480) 220-3613
Office Phone: (888) 440-2724
Agent Name: Michelle Pyle
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