3,804 Sq. Ft.
$196 / Sq. Ft.
3,804
Sq. Ft.
$196
per Sq. Ft.

Description

Scenic Lodge Retreat by Crawford Reservoir Built in 1989, The Last Frontier Lodge sits on 9.7 acres just steps from Crawford Reservoir, offering breathtaking views of the reservoir and the West Elk Wilderness. This expansive 3,800+ square foot retreat combines rustic charm with modern potential, making it ideal for Airbnb hosting, hunter/outdoor excursions, or a one-of-a-kind getaway. Enjoy walking access to the reservoir, wide-open spaces for activities, and ample room to create income through rentals...Scenic Lodge Retreat by Crawford Reservoir Built in 1989, The Last Frontier Lodge sits on 9.7 acres just steps from Crawford Reservoir, offering breathtaking views of the reservoir and the West Elk Wilderness. This expansive 3,800+ square foot retreat combines rustic charm with modern potential, making it ideal for Airbnb hosting, hunter/outdoor excursions, or a one-of-a-kind getaway. Enjoy walking access to the reservoir, wide-open spaces for activities, and ample room to create income through rentals or guided experiences. Embrace a secluded lodge atmosphere with unparalleled natural beauty.
  1. Listed by Tristen Todd • Needlerock Mountain Realty and Land, LLC

Property Details for 40300 D Road

Water Front
No
Views
Lake/Pond/Reservoir, Mountains, Valley
Waterfront
Lake/Reservoir
Subdv Name
None
LISTING UPDATED: 04/05/2026 09:29 PM

Property Details for 40300 D Road

StatusNew
MLS #833259
Days on Market1
Taxes$2,900 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeRESIDENTIAL / Stick Built
Year Built1989
Lot Size9.70 AC / 422,531 SF
CountyDelta County

Location

Listing Courtesy of Needlerock Mountain Realty and Land, LLC, Tristen Todd
Add your commute

Building Information for 40300 D Road

Stories2Year Built1989Building Size-Lot Size9.70 AC / 422,531 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$3,993 per month

30 year fixed, 6.46% Interest

Principal and Interest

$3,751

Property Taxes

$242

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 40300 D Road

Summary
Location and General Information
  • Directions: From Hwy 92 turn right on to D RD. Drive straight for .5 miles.
Parking
  • RV Parking: No
  • Carport Y/N: No
  • Garage Y/N: No
School Information
  • Elementary School: Open Enrollment
  • Middle School: Open Enrollment
  • High School: Open Enrollment
Taxes and HOA Information
  • HOA Y/N: No
  • Tax Year: 2025
  • Total Taxes $: 2900.04
Property
Property and Assessments
  • Domestic Sewer Source: Septic System
  • FIPS Code: 08029
  • Legal/Lot Block: SEC 13 T51N R7W NMPM PT OF NE4NW4 SEC 13 BEG 140'E OF NW COR OF NE4NW4 SEC 13 TH S16*43' E799.47', TH N45* 40' E1058.2' TO N LINE OF SEC 13 TH W ON SEC LINE 970' TO POB BK 446. To be verified per the last vesting deed.
  • Foreign Owned Y/N: No
  • Photo Count: 33
  • New Construction Y/N: No
  • Livestock Allowed: Cattle, Horses, Poultry, Sheep, Swine
Lot Information
  • Special Assemnt Y/N: Yes
  • Water Rights/Irrigation: No
  • Lot Size/Acerage: 5-9.99
  • Current Property Use: Residential, Commercial
  • Possible Property Use: Residential, Horse/Equestrian, Livestock, Recreational, Mixed-Use
  • Parcel ID #: 3.50113200003E11
  • SqFt Source: Agent
  • Elevation: 6558
Green Features
  • Green Certification Y/N: No
  • HERS Rated Y/N: No
  • Energy Star Qualified Y/N: No
  • LEED for Homes Y/N: No
  • NAHB/NGBS-ICC 700 Y/N: No
Utilities
  • Internet Service Y/N: Yes
  • Internet Provider: Elevate
  • Water Heater: Electric Water Heater
  • Utilities: Electric, Internet
  • Addit Living Quarters: No
  • Water Well: No
Multi Family
Multi-Family Information
  • Residence Stories: Two Story
Interior and Exterior Features
Room Information
  • 1/2 Baths: 7
  • 3/4 Baths: 0
  • 1/4 Baths: 0
  • Total Bathrooms: 7.00
  • Bathrooms Descr: 5x5
  • Primary Bedroom Level: Upper Level
  • Bedroom #2 Dimensions: 13x10
  • Bedroom #3 Dimensions: 11x14
  • Bedroom #4 Dimensions: 11x14
  • Living Room Dimensions: 29x26
  • Kitchen Dimensions: 13x16
  • Dining: Kitchen Bar, Kitchen/Dining
  • Dining Room: Yes
  • Dining Room Dimensions: 19x13
  • Laundry/Util Dimensions: 16x12
  • Total Office/Den(s): 0
  • Office/Den Dimensions: 14x14
Interior Features
  • Furnished: Unfurnished
  • Main SF: 2022
  • Upper SF: 1731
  • Florring: Hardwood
  • Foundation/ Basement: Block, Crawl Space, Concrete
  • Heating Fuel/Source: Propane
  • Appliance Inclusions: Range/Oven, Refrigerator
  • Heating System: Forced Air
Exterior Features
  • Residence Style: Log
  • Construction Type: Log
  • Roof: Metal
  • Exterior Inclusions: Deck
  • Fence: Barbed Wire
  • Siding: Log
  • Exterior Structures: Barn, Shed

Property History for 40300 D Road

DateEvent & SourcePriceAppreciation
Apr 4, 2026

Listed (Active)

CRENMLS #833259

$745,000
Sep 7, 2006

Sold (Public Record)

Public Record #1106732846

$425,000
DateEvent & SourcePrice
04/04/2026

Listed (Active)

CRENMLS #833259

$745,000
09/07/2006

Sold (Public Record)

Public Record #1106732846

$425,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 40300 D Road

Taxable ValueLand$18,588Additions$27,563Total$46,151
Tax Record2025$2,900 ($242 / month)
Home Facts
Total Finished SqFt3,804 SqFtAbove Grade Finished SqFt3,804 SqFtStories2Lot Size422,532 SqFtStyleHotel / MotelYear Built1989CountyDELTAAPN350113200003

Schools near 40300 D Road

This home is within Delta County 50(J) School District.
Rating
School
Type
Grades
Distance
Public - PK to 8
Public - 9 to 12
Public - PK to 6
Public - PK to 6
Rating
School
Distance
Hotchkiss Elementary School
PublicPK to 8

Hotchkiss High School
Public9 to 12

North Fork Montessori @ Crawford School
PublicPK to 6

North Fork School Of Integrated Studies
PublicPK to 6

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

40300 D Road is a single family home for sale in Crawford, CO 81415. This property was listed for sale on April 5, 2026 by Needlerock Mountain Realty and Land, LLC, it's currently listed at $745,000. It has been on the market for a total of 1 days and was last sold on September 7, 2006. This listing's school district is Delta County 50(J) School District. Nearby schools include Hotchkiss Elementary School, Hotchkiss High School and North Fork Montessori @ Crawford School. 40300 D Road is a 9-bed, 7-bath, 3,804 sqft single family home built in 1989.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Needlerock Mountain Realty and Land, LLC, Tristen Todd

Based on information from one of the following Multiple Listing Services: CRENMLS, Telluride Association of REALTORS, Grand Junction Area REALTORS. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CRENMLS, Telluride Association of REALTORS, Grand Junction Area REALTORS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.