- 5 beds
- 3 baths
- 3,617 sqft
- 11,116 sqft lot
- $221 per sqft
- 1995 build
- – on site
Tucked away on a cul-de-sac in quiet NE Longmont sits charming 1806 Crestone Ct. This IMMACULATE 5 bedroom, 3 Bathroom, full brick, ranch home with a 3 car garage immediately welcomes you with its impressive curb appeal. As you enter, you'll notice that this home is heads above the competition with its gracious floorplan offering a relaxed sitting area and lovely dining room anchored by extended real oak flooring accented by upgraded trim details and a modern stair handrail. The well thought out and top of the line kitchen will far exceed your expectations with an exceptional walnut lower offset by white upper cabinet package, Caesarstone countertops, Bosch Benchmark Series and Jenn-Air appliances along with a custom solid surface backsplash. Flow through the living room complete with a gas fireplace and vaulted ceilings to the flat and meticulously maintained yard offering accent lighting, extended patio space and an inviting hot tub... you'll want to spend time here. The primary suite offers oak flooring under foot along with a luxurious bathroom boasting in-floor radiant heat under travertine floors as a base for the custom bamboo vanity and solid surface countertops. A poured pan shower with custom details and a frameless glass shower surround offer a quality of finish uncommon in today's homes. The fully finished basement offers a large rec room with two additional bedrooms perfect for guests or a home gym. This home is impeccable from top to bottom and offers that unique opportunity to simply move in and enjoy! Let's Get You Home!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 26, 2025
•
MLS# 1037346 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:1995
-
New Construction:false
-
Construction Materials:Brick/Brick Veneer
-
Architectural Style:Cottage/Bung
-
Total SqFt:4,034 Sqft
-
Building Area Total:2017
-
Roof:Composition
-
Levels:One
-
Basement:Full
-
Stories:1
-
Direction Faces:West
-
Window Features:Window Coverings
-
Patio And Porch Features:Patio
-
Door Features:French Doors
-
Above Grade Finished Area:2017
-
Below Grade Finished Area:2017
Interior
-
Interior Features:Study Area
-
Flooring:Wood Floors
-
Fireplace:true
-
Fireplace Features:Gas
-
Living Room Level:Main
-
Living Room Features:Other Floor
-
Kitchen Level:Main
-
Kitchen Features:Other Floor
-
Dining Room Level:Main
-
Dining Room Features:Other Floor
-
Family Room Level:Main
-
Family Room Features:Other Floor
-
Laundry Features:Sink
Room Dimensions
-
Living Area:3617
-
Study Length:14
-
Living Area Units:Square Feet
-
Living Area Source:Assessor
-
Main Floor SqFt:2017
-
Living Room Area:156
-
Living Room Length:13
-
Living Room Width:12
-
Kitchen Length:19
-
Kitchen Area:228
-
Kitchen Width:12
-
Dining Room Area:195
-
Dining Room Length:15
-
Dining Room Width:13
-
Family Room Area:320
-
Family Room Length:20
-
Family Room Width:16
-
Rec Room Length:26
-
Master Bedroom Area:208
-
Master Bedroom Width:13
-
Master Bedroom Length:16
-
Bedroom 2 Area:143
-
Bedroom 2 Length:13
-
Bedroom 3 Length:12
-
Bedroom 2 Width:11
-
Bedroom 4 Length:15
-
Bedroom 3 Area:120
-
Bedroom 3 Width:10
-
Bedroom 5 Length:15
-
Bedroom 4 Area:225
-
Bedroom 4 Width:15
-
Bedroom 5 Area:195
-
Bedroom 5 Width:13
-
Laundry Room Length:8
-
Laundry Room Width:5
Financial & Terms
-
Listing Terms:Cash
Location
-
Coordinates:-105.08705, 40.19182
-
Latitude:40.19182
-
Longitude:-105.08705
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Parcel Number:R0115701
-
Lot Features:Curbs
-
Lot Size Acres:0.26
-
Lot Size SqFt:11,116 Sqft
-
Lot Size Area:11116
-
Lot Size Units:Square Feet
-
Zoning:SFR
-
Possible Use:Single Family
-
Horse:false
-
Fencing:Fenced
-
Waterfront:false
-
Road Frontage Type:City Street
-
Road Surface Type:Paved
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$4,307
Beds
-
Bedrooms Total:5
-
Bedroom 2 Level:Main
-
Bedroom 2 Features:Other Floor
-
Bedroom 3 Level:Main
-
Bedroom 3 Features:Other Floor
-
Bedroom 4 Level:Basement
-
Bedroom 4 Features:Other Floor
-
Bedroom 5 Level:Basement
-
Bedroom 5 Features:Other Floor
-
Master Bedroom Level:Main
-
Master Bedroom Features:Other Floor
Baths
-
Total Baths:3
-
Three Quarter Baths:1
-
Full Baths:2
The Listing
-
Virtual Tour URL Unbranded:https://www.zillow.com/view-imx/392a21b9-5502-4a34-8e41-7917d5eb88b5?initialViewType=pano
-
Special Listing Conditions:Private Owner
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Utilities:Natural Gas Available
-
Gas:Natural Gas, Xcel Energy
-
Electric:Electric, city - Longmont
-
Sewer:City Sewer
-
Water Source:City Water, city of Longmont
Appliances
-
Appliances:Electric Range/Oven
Schools
-
Elementary School:Alpine
-
Middle School:Heritage
-
High School:Skyline
-
High School District:ST Vrain Dist RE 1J
The Community
-
Association:false
-
Subdivision Name:Stoney Ridge 8th Filing
-
Spa:false
-
Senior Community:false
Parking
-
Parking Features:Garage Door Opener
-
Garage Spaces:3
-
Garage:true
-
Garage SqFt:726 Sqft
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:3
Monthly cost estimate

Asking price
$799,900
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$4,283
|
Taxes | $358 |
Insurance | $219 |
Utilities | $162 See report |
Total | $5,022/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/20/25
Jun 20, 2025
|
Listed / Active | IRES | $799,900 |