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

466 Arrowhead Trail
Rifle, CO 81650

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 6
Baths: 4
Status: Active
SqFt: 3956
Agency: Cheryl&Co. Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Welcome to your dream oasis nestled on nearly 40 acres of picturesque land! This rustic retreat is adjacent to BLM on two sides. Enjoy multi generational living accommodations with the additional 2 bedroom cabin, plus storage and shop advantages of 6000 sq ft building on site.The stunning 4-bedroom, 3-bathroom home boasts 2696 square feet of luxurious living space, offering both comfort and style in every corner.Upon entering, you'll be greeted by the spaciousness of this home, featuring a large primary suite that has been beautifully remodeled to create a serene retreat. The remodeled bathroom is a highlight, showcasing modern finishes and amenities that elevate your daily routine.Entertain with ease in the gourmet kitchen, complete with granite counters and a charming rustic island that adds character to the space. The see-through gas fireplace adds warmth and ambiance, creating a cozy atmosphere for gatherings with family and friends.For those who love to entertain, the wet bar is a perfect addition, providing convenience and sophistication for hosting guests. Step outside through the covered breezeway and discover the impressive 1680 square foot 4-car garage, complete with 10-foot doors and built-in shelving for all your storage needs.But that's not all - this property also includes a separate 2-bedroom, 1-bathroom additional dwelling unit (ADU) spanning 1260 square feet, offering additional multi-generational living space or rental income potential.Outdoor enthusiasts will delight in the expansive grounds, featuring a chicken coop, two storage sheds, and a 6000 square foot shop. The shop is a hobbyist's paradise, boasting 14-foot doors, concrete floors, 220 electric, and insulation, providing ample space for projects and storage.Stay self-sufficient with a 1000-gallon cistern for water storage sourced from the well, ensuring peace of mind year-round. Plus, the fenced garden area allows you to cultivate your own fresh produce and enjoy farm-to-table living right at home.Don't miss this rare opportunity to own a slice of paradise where luxury meets functionality - schedule your private showing today and experience the beauty and serenity of country living at its finest!
MlsNumber: 183515


Listing Provided By: Cheryl&Co. Real Estate, LLC, original listing
Name: Cheryl&Co. Real Estate, LLC
Phone: (970) 625-4441
Office Name: Cheryl&Co. Real Estate, LLC
Office Phone: (970) 625-4441
Agent Name: Shannon Kyle
Disclaimer: Copyright © 2024 Aspen/Glenwood Springs MLS. 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