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

1830 Black Canyon Road
Crawford, CO 81415
LIZ HEIDRICK with NEEDLEROCK MOUNTAIN REALTY & LANDS, LLC, original listing - (970) 921-5331

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,615,000
Beds: 6
Baths: --
Status: Active
SqFt: --
Agency: NEEDLEROCK MOUNTAIN REALTY & LANDS, LLC
Agency Phone: (970) 921-5331

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Stunning VIEWS from this Hidden Hilltop location with Native Pinon Pine and Juniper private forest all around. Sprawling Custom Log Home with Generous Great Room and Spacious Kitchen, Dining, Library, Study, Exercise/Dance Room and Sun Room just to name a few of the features. APPRAISED RECENTLY FOR $1.7 Million. Multiple Domestic Water Taps currently on a meter set up with extra water storage, (3.4725 Taps Valued at $35,000 each) AKA 1389 Shares of Fruitland Domestic Water Company to be exact will allow for more homes to be built and the 400 Shares of Fruitland Irrigation water is ideal for the pasture down below if you love horses and or want to raise a few of your own livestock. This one of a kind home is ready for you to come and enjoy with everyone or perhaps a private lodge or Airbnb? Property can also be sub-divided. Various outbuildings including a shop/detached garage and barn shelter with irrigated pasture below the home that sits as a buffer from the outside world. The gorgeous land wraps around the back of the property with hidden meadows and your own private native forest teeming with WILDLIFE. Discover the breathtaking beauty of western Colorado with this stunning 60-acre estate located on Fruitland Mesa. This expansive property features 20 acres of irrigated hay ground, making it perfect for agricultural pursuits or livestock. Nestled amongst a picturesque forest of native juniper and Pinyon pine trees, this log home offers a serene retreat in nature. The residence boasts 6 spacious bedrooms and 5 bathrooms, providing ample space for family and guests. The heart of the home features a cozy wood-burning stove with a striking river rock fireplace and a grand mantle, perfect for gathering around on chilly evenings. Enjoy formal meals in the beautiful private dining area adjacent to a well-appointed kitchen with generous cabinetry. Spanning a substantial 6,038 sq. ft., this home, built in 1998, combines rustic charm with modern amenities. The oversized two-car garage offers plenty of storage, while the dedicated exercise or dance studio and multiple office spaces cater to your lifestyle needs. The property is equipped with 3½ domestic water taps from the Fruitland Domestic Water Company and 400 shares of Fruitland irrigation water, ensuring ample supply for all your needs. Additionally, there are excess water storage containers available for livestock or gardening purposes. Experience the perfect blend of tranquility, space, and custom fea
MlsNumber: --
ListingId: 20251148


Listing Provided By: NEEDLEROCK MOUNTAIN REALTY & LANDS, LLC, original listing
Phone: (970) 234-5344
Office Phone: (970) 921-5331
Agent Name: LIZ HEIDRICK
Disclaimer: Copyright © 2025 Grand Junction Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Mortgage Pro

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 = 260 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Michael Smith
Michael Smith
ASCIIABC Financial
Cell: (443) 603-8652

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App