Stunning Home on a Large Corner Lot in Stoney Ridge!! Close to walking paths, parks & schools. Welcome to this spacious and beautifully maintained 6-bedroom, 3-bath home located on a desirable corner lot in Longmont. Boasting an open floorplan ideal for both everyday living and entertaining, this home offers thoughtful design and high-end touches throughout. The main floor features a luxurious primary suite for convenient main-level living, while additional bedrooms are located upstairs and in the finished basement—perfect for guests, family, or a home gym. The gourmet kitchen shines with elegant quartz countertops, maple cabinetry, and ample prep space, making it the heart of the home. Work from home in style in the main floor office complete with a built-in bookcase and accent lighting, or transform it into a larger dining room off of the kitchen. The basement also has a theater area with upgraded soundproofing throughout as well as a large storage room. Step outside to your professionally landscaped backyard oasis, featuring a tranquil pond, mature plantings, and generous space for gatherings or quiet relaxation. This home combines comfort, style, and functionality in a prime location—don’t miss the opportunity to make it yours!
Video of Home:https://iframe.videodelivery.net/6870ed9acfc2b30ddb0d5927822d147d
For sale
$792,500
1800 Crestone Court, Longmont, CO 80504
6beds
4,102sqft
Est.:
Single Family Residence
Built in 1997
0.25 Acres Lot
$-- Zestimate®
$193/sqft
$-- HOA
What's special
Tranquil pondMain floor officeProfessionally landscaped backyardCorner lotLuxurious primary suiteTheater areaMature plantings
- 12 days
- on Zillow |
- 893 |
- 63 |
Zillow last checked: 7 hours ago
Listing updated: 9 hours ago
Listed by:
Jeanne Pitre 720-971-2572 jeannepitre@yahoo.com,
RE/MAX Professionals,
Jennifer Crow 720-987-8535,
RE/MAX Professionals
Source: REcolorado,MLS#: 4951584

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Open house
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 2
- Main level bedrooms: 1
Primary bedroom
- Level: Main
- Area: 229.5 Square Feet
- Dimensions: 17 x 13.5
Bedroom
- Level: Upper
- Area: 143.75 Square Feet
- Dimensions: 12.5 x 11.5
Bedroom
- Level: Upper
- Area: 120.75 Square Feet
- Dimensions: 10.5 x 11.5
Bedroom
- Level: Basement
- Area: 306 Square Feet
- Dimensions: 17 x 18
Bedroom
- Level: Upper
- Area: 166.75 Square Feet
- Dimensions: 14.5 x 11.5
Bedroom
- Level: Basement
- Area: 161 Square Feet
- Dimensions: 14 x 11.5
Primary bathroom
- Level: Main
Bathroom
- Level: Upper
Bathroom
- Level: Main
Bonus room
- Level: Upper
- Area: 320 Square Feet
- Dimensions: 20 x 16
Dining room
- Level: Main
Family room
- Level: Main
Great room
- Level: Basement
- Area: 780 Square Feet
- Dimensions: 26 x 30
Kitchen
- Level: Main
Laundry
- Level: Main
Office
- Level: Main
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Range, Self Cleaning Oven
- Laundry: In Unit
Features
- Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Wood
- Windows: Double Pane Windows, Skylight(s), Window Coverings
- Basement: Bath/Stubbed,Finished,Full,Interior Entry,Sump Pump
- Number of fireplaces: 2
- Fireplace features: Family Room, Gas Log
- Common walls with other units/homes: No Common Walls
Interior area
- Total structure area: 4,102
- Total interior livable area: 4,102 sqft
- Finished area above ground: 2,502
- Finished area below ground: 1,300
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Concrete, Lighted
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: Ground
- Patio & porch: Front Porch, Patio
- Exterior features: Garden, Lighting, Private Yard, Water Feature
- Fencing: Full
Lot
- Size: 0.25 Acres
- Features: Corner Lot, Landscaped, Level, Master Planned, Secluded, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R0115702
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick, Frame
Condition
- Updated/Remodeled
- Year built: 1997
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell
- Subdivision: Stoney Ridge
HOA
- Has HOA: No
Location
- Region: Longmont
Financial & listing details
- Price per square foot: $193/sqft
- Tax assessed value: $710,000
- Annual tax amount: $3,557
- Date on market: 7/29/2025
- Listing terms: Cash,Conventional,FHA,Jumbo,VA Loan
- Exclusions: Sellers Personal Property, Kitchen Refrigerator, Washer, Dryer, Freezer In Garage, Mini Fridge In Basement, Tv's & Brackets, Drapes In Upstairs Bedrooms And Main Floor Office, Mirrors Attached To Back Of Doors, Exterior Security Camera
- Ownership: Individual
- Electric utility on property: Yes
- Road surface type: Paved
- Loading
- Loading