Property Details

Start of property details

share this property:

MY ACCOUNT

Dashboard

Viewed Properties Saved Properties

Recent Searches New Listing Alerts Saved Searches

Contact Agent Start A New Search

Existing Members Log in Here

Create Your Account

Log Out

SAVE SAVED SHARE PRINT

NEW SEARCH

See all 46 Photos

1 / 47

Show Map Show Gallery

Request a Showing

1800 Crestone Court

Longmont, CO 80504

FOR

SALE

$792,500

Active

6

Beds

3

Baths

2

Garage

4,102

Sq.Ft.

0.25

Acres

MLS# 4951584

Cumulative Days on Market: Less than 1 (since July 29th, 2025) Data provided by the MLS.

Request a Showing Request Info Contact Agent

Property Description

Stunning 6-Bedroom Home on a Corner Lot in Shadow Ridge!! 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 basementperfect 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 dedicated office, complete with a built-in bookcase and accent lighting. The basement also has a theater area with upgraded soundproofing throughout. Enjoy year-round comfort thanks to the whole-house humidifier. 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 locationdont miss the opportunity to make it yours!Video of Home:https: / / iframe.videodelivery.net / 6870ed9acfc2b30ddb0d5927822d147d

Get Directions

Print Flyer

Ask a Local Expert

Comments and Questions

*Your Name

Submit Question

Virtual Tour

Property Highlights

Price

$792,500

Property Type

Residential

Property Sub Type

Single Family Residence

Bedrooms

6

Total Bathrooms

3

Living Area

3,702

Price / Sq Ft

$214

Acres

0.25

Year Built

1997

Condition

Updated/Remodeled

Location

County

Boulder

Subdivision

Shadow Ridge

Property Details

Condition

Updated/Remodeled

Price

$792,500

Property Sub Type

Single Family Residence

Property Type

Residential

Building

Levels

Two

Structure Type

House

Total Area

4,102

Community

Local Schools

Elementary School

Alpine

High School

Skyline

Middle School

Timberline

School District

St. Vrain Valley RE-1J

Interior Features

Bedrooms and Bathrooms

1/2 Bathrooms

1

Bathrooms on Main Level

2

Bedrooms

6

Bedrooms on Main Level

1

Full Bathrooms

2

Total Bathrooms

3

Rooms and Basement

Basement Features

Bath/Stubbed, Finished, Full, Interior Entry, Sump Pump

Has Basement

Yes

Area and Spaces

Above Grade Finished Area

2,502

Below Grade Finished Area

1,200

Appliances

Appliances

Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Range, Self Cleaning Oven

Interior Features

Fireplace Features

Family Room, Gas Log

Flooring

Carpet, Wood

Interior Features

Breakfast Bar, 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, Smart Light(s), Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)

Laundry Features

Sink, In Unit

Security Features

Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell

Window Features

Double Pane Windows, Egress Windows, Skylight(s), Window Coverings

Heating and Cooling

Fireplaces

2

Heating Features

Forced Air

Building Details

Construction

Year Built

1997

Materials

Construction Materials

Brick, Frame

Roof

Shingle

Terms

Terms

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

Ownership

Individual

Special Conditions

None

Special Terms

Cash, Conventional, FHA, Jumbo, VA Loan

Taxes

Tax

Tax (Annual)

$3,557

Heating, Cooling & Utilities

Cooling Features

Central Air

Utilities

Sewer

Public Sewer

Utilities

Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected

Water Source

Public

Lot

Acres

25

Lot Features

Corner Lot, Landscaped, Level, Master Planned, Secluded, Sprinklers In Front, Sprinklers In Rear

Lot Size

10,948

Lot Size Area Sq Ft

10,948

Exterior Features

Exterior Features

Garden, Lighting, Private Yard, Water Feature

Fencing

Full

Patio And Porch Features

Front Porch, Patio

Parking

Parking Features

Concrete, Lighted

Total Parking Spaces

2

Pool Features

Spa Features

Bath

Listed by Re/max Professionals, jeannepitre@yahoo.com, 720-971-2572.

Listing Data last updated 07/29/2025 02:20 pm

Get a Link to this Property: Copy To Clipboard

Save Property

View Census Data

View Schools

Phone:

Connect with:

Request a Showing

Contact Agent

Payment Calculator

per month. fixed. % interest.

Home Price Loan Type Rate

$

10 year 15 year 20 year 25 year 30 year 40 year

%

Down Payment

$

%

Principal & Interest

+ Home Insurance

+ Property Tax

+ HOA Fees

Total interest paid over s will be:

All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 29-Jul-2025 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified. See assumptions and disclosures

Assumptions and Disclosures

×

• Interest rates and APRs presented are based on current market rates, are for informational purposes only, are subject to change without notice and may be subject to pricing add-ons related to property type, loan amount, loan-to-value, credit score and other variables - call for details.
• This is not a credit decision or a commitment to lend.
• Depending on loan guidelines, mortgage insurance may be required
• If mortgage insurance is required, the mortgage insurance premium could increase the APR and the monthly mortgage payment. Additional loan programs may be available.
• APR (annual percentage rate) reflects the effective cost of your loan on a yearly basis, taking into account such items as interest, most closing costs, discount points (also referred to as "points"), and loan-origination fees. One point is 1% of the mortgage amount (e.g., $1,000 on a $100,000 loan).
• Your monthly payment is not based on APR, but instead on the interest rate on your Note.
• Adjustable Rate Mortgage (ARM) rates assume no increase in the financial index after the initial fixed period. ARM rates and monthly payments are subject to increase after the fixed period.
• These special rates presented here are only available when you pre-qualify and are not guaranteed until lock-in.
• Amounts may be rounded up. Additional fees and closing costs apply. If the down payment is less than 20%, mortgage insurance may be needed, which could increase the monthly payment and APR.
• Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
• Please contact a loan specialist to get specific payment examples and information regarding your particular needs.

Get Walk Score Content

Property History

Today

Property information last updated

Today

Status Active. This is the date the listing was placed on market.

Cumulative Days on Market: Less than 1 (since July 29th, 2025) Data provided by the MLS.

Similar Properties

Listings courtesy of REcolorado as distributed by MLS GRID. IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MLS GRID. Based on information submitted to the MLS GRID as of 07/29/2025 02:20 pm. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.

DMCA Notice

Privacy Policy

Listing Data last updated: 07/29/2025 02:20 pm

Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.

Save Property Saved!

Share

Email to a friend Share on Facebook Copy Link for Instagram Share on Twitter Share on Pinterest! Copy Direct Link

Actions For Property

Request a Tour Request Info Notes Property Alerts Send to Friend My Account

1800 Crestone Court - MLS#4951584 - $792,500

Listed by Re/max Professionals

{"property_id":"denver_4951584","AboveGradeFinishedArea":"2502","AccessibilityFeatures":"","Appliances":"Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Range, Self Cleaning Oven","ArchitecturalStyle":"","AssociationAmenities":"","AssociationFee":"0.00","AssociationFeeFrequency":"","AssociationFeeIncludes":"","AssociationYN":"0","AttributionContact":"jeannepitre@yahoo.com, 720-971-2572","Basement":"Bath\/Stubbed, Finished, Full, Interior Entry, Sump Pump","BasementYN":"1","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1200","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","BuyerFinancing":"","CapRate":"0.00","CityRegion":"","CommonInterest":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Brick, Frame","Contingency":"","Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":"0","CurrentFinancing":"","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"Alpine","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","ExteriorFeatures":"Garden, Lighting, Private Yard, Water Feature","Fencing":"Full","FireplaceFeatures":"Family Room, Gas Log","FireplaceYN":"","FireplacesTotal":"2","Flooring":"Carpet, Wood","FoundationDetails":"","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Forced Air","HighSchool":"Skyline","HorseAmenities":"","HorseYN":"","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"Breakfast Bar, 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, Smart Light(s), Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)","InternetAddressDisplayYN":"","LaundryFeatures":"Sink, In Unit","Levels":"Two","ListAgentFullName":"Jeanne Pitre","ListAgentEmail":"","ListingTerms":"Cash, Conventional, FHA, Jumbo, VA Loan","LivingArea":"0.00","LotFeatures":"Corner Lot, Landscaped, Level, Master Planned, Secluded, Sprinklers In Front, Sprinklers In Rear","LotSizeArea":"10948.00","LotSizeDimensions":"","LotSizeSquareFeet":"10948.00","MainLevelBathrooms":"2","MainLevelBedrooms":"1","MiddleOrJuniorSchool":"Timberline","Model":"","NewConstructionYN":"","NumberOfUnitsTotal":"0","OtherParking":"","Ownership":"Individual","ParkingFeatures":"Concrete, Lighted","ParkingTotal":"2","PatioAndPorchFeatures":"Front Porch, Patio","PoolFeatures":"","PoolYN":"","PoolPrivateYN":"","PropertyAttachedYN":"0","PropertyCondition":"Updated\/Remodeled","public_remarks":"Stunning 6-Bedroom Home on a Corner Lot in Shadow Ridge!!  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 basementperfect 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 dedicated office,  complete with a built-in bookcase and accent lighting. The basement also has a theater area with upgraded soundproofing throughout. Enjoy year-round comfort thanks to the whole-house humidifier. 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 locationdont miss the opportunity to make it yours!Video of Home:https:\/\/iframe.videodelivery.net\/6870ed9acfc2b30ddb0d5927822d147d","Roof":"Shingle","RoomsTotal":"0","SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell","SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":"","SpaFeatures":"Bath","SpaYN":"","SpecialListingConditions":"None","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"House","TaxAnnualAmount":"3557.00","Utilities":"Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected","View":"","ViewYN":"","VirtualTourURLUnbranded":"https:\/\/www.listingsmagic.com\/sps\/tour-slider\/index.php?property_ID=275825&ld_reg=Y","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"","WindowFeatures":"Double Pane Windows, Egress Windows, Skylight(s), Window Coverings","YearBuilt":"1997","Zoning":"","ZoningDescription":"","property_uid":"REC2048639301","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"4951584","acreage":"","acres":"0.25","address":"","address_direction":"","address_flg":"1","address_num":"1800","agent_id":"030271","area":"","baths_total":"3.00","bedrooms_total":"6","car_spaces":"2","city":"Longmont","coseller_id":"","coagent_id":"047461","days_on_market":"0","finished_sqft_total":"3702","geocode_address":"1800 Crestone Court","geocode_status":"","lat":"40.19169236","lon":"-105.0867397","map_flg":"true","office_id":"REM46","office_name":"RE\/MAX Professionals","orig_price":"792500","photo_count":"46","photo_count_lac":"46","previous_price":"0","price":"792500","prop_img":"\/listing\/photos\/denver\/4951584-0.jpeg","property_type":"Residential","property_subtype":"Single Family Residence","sqft_total":"4102","state":"CO","street_type":"Court","street_name":"Crestone","sub_area":"Shadow Ridge","unit":"","zip_code":"80504","listing_dt":"0000-00-00","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"0000-00-00","sold_price":"0","webapi_update_dt":"2025-07-29 17:26:17","update_dt":"2025-07-29 20:26:27","create_dt":"2025-07-29 04:02:13","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}

Start of property details

share this property:

MY ACCOUNT

Dashboard

Viewed Properties Saved Properties

Recent Searches New Listing Alerts Saved Searches

Contact Agent Start A New Search

Existing Members Log in Here

Create Your Account

Log Out

SAVE SAVED SHARE PRINT

NEW SEARCH

See all 46 Photos

1 / 47

Show Map Show Gallery

Request a Showing

1800 Crestone Court

Longmont, CO 80504

FOR

SALE

$792,500

Active

6

Beds

3

Baths

2

Garage

4,102

Sq.Ft.

0.25

Acres

MLS# 4951584

Cumulative Days on Market: Less than 1 (since July 29th, 2025) Data provided by the MLS.

Request a Showing Request Info Contact Agent

Property Description

Stunning 6-Bedroom Home on a Corner Lot in Shadow Ridge!! 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 basementperfect 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 dedicated office, complete with a built-in bookcase and accent lighting. The basement also has a theater area with upgraded soundproofing throughout. Enjoy year-round comfort thanks to the whole-house humidifier. 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 locationdont miss the opportunity to make it yours!Video of Home:https: / / iframe.videodelivery.net / 6870ed9acfc2b30ddb0d5927822d147d

Get Directions

Print Flyer

Ask a Local Expert

Comments and Questions

*Your Name

Submit Question

Virtual Tour

Property Highlights

Price

$792,500

Property Type

Residential

Property Sub Type

Single Family Residence

Bedrooms

6

Total Bathrooms

3

Living Area

3,702

Price / Sq Ft

$214

Acres

0.25

Year Built

1997

Condition

Updated/Remodeled

Location

County

Boulder

Subdivision

Shadow Ridge

Property Details

Condition

Updated/Remodeled

Price

$792,500

Property Sub Type

Single Family Residence

Property Type

Residential

Building

Levels

Two

Structure Type

House

Total Area

4,102

Community

Local Schools

Elementary School

Alpine

High School

Skyline

Middle School

Timberline

School District

St. Vrain Valley RE-1J

Interior Features

Bedrooms and Bathrooms

1/2 Bathrooms

1

Bathrooms on Main Level

2

Bedrooms

6

Bedrooms on Main Level

1

Full Bathrooms

2

Total Bathrooms

3

Rooms and Basement

Basement Features

Bath/Stubbed, Finished, Full, Interior Entry, Sump Pump

Has Basement

Yes

Area and Spaces

Above Grade Finished Area

2,502

Below Grade Finished Area

1,200

Appliances

Appliances

Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Range, Self Cleaning Oven

Interior Features

Fireplace Features

Family Room, Gas Log

Flooring

Carpet, Wood

Interior Features

Breakfast Bar, 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, Smart Light(s), Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)

Laundry Features

Sink, In Unit

Security Features

Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell

Window Features

Double Pane Windows, Egress Windows, Skylight(s), Window Coverings

Heating and Cooling

Fireplaces

2

Heating Features

Forced Air

Building Details

Construction

Year Built

1997

Materials

Construction Materials

Brick, Frame

Roof

Shingle

Terms

Terms

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

Ownership

Individual

Special Conditions

None

Special Terms

Cash, Conventional, FHA, Jumbo, VA Loan

Taxes

Tax

Tax (Annual)

$3,557

Heating, Cooling & Utilities

Cooling Features

Central Air

Utilities

Sewer

Public Sewer

Utilities

Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected

Water Source

Public

Lot

Acres

25

Lot Features

Corner Lot, Landscaped, Level, Master Planned, Secluded, Sprinklers In Front, Sprinklers In Rear

Lot Size

10,948

Lot Size Area Sq Ft

10,948

Exterior Features

Exterior Features

Garden, Lighting, Private Yard, Water Feature

Fencing

Full

Patio And Porch Features

Front Porch, Patio

Parking

Parking Features

Concrete, Lighted

Total Parking Spaces

2

Pool Features

Spa Features

Bath

Listed by Re/max Professionals, jeannepitre@yahoo.com, 720-971-2572.

Listing Data last updated 07/29/2025 02:20 pm

Get a Link to this Property: Copy To Clipboard

Save Property

View Census Data

View Schools

Phone:

Connect with:

Request a Showing

Contact Agent

Payment Calculator

per month. fixed. % interest.

Home Price Loan Type Rate

$

10 year 15 year 20 year 25 year 30 year 40 year

%

Down Payment

$

%

Principal & Interest

+ Home Insurance

+ Property Tax

+ HOA Fees

Total interest paid over s will be:

All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 29-Jul-2025 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified. See assumptions and disclosures

Assumptions and Disclosures

×

• Interest rates and APRs presented are based on current market rates, are for informational purposes only, are subject to change without notice and may be subject to pricing add-ons related to property type, loan amount, loan-to-value, credit score and other variables - call for details.
• This is not a credit decision or a commitment to lend.
• Depending on loan guidelines, mortgage insurance may be required
• If mortgage insurance is required, the mortgage insurance premium could increase the APR and the monthly mortgage payment. Additional loan programs may be available.
• APR (annual percentage rate) reflects the effective cost of your loan on a yearly basis, taking into account such items as interest, most closing costs, discount points (also referred to as "points"), and loan-origination fees. One point is 1% of the mortgage amount (e.g., $1,000 on a $100,000 loan).
• Your monthly payment is not based on APR, but instead on the interest rate on your Note.
• Adjustable Rate Mortgage (ARM) rates assume no increase in the financial index after the initial fixed period. ARM rates and monthly payments are subject to increase after the fixed period.
• These special rates presented here are only available when you pre-qualify and are not guaranteed until lock-in.
• Amounts may be rounded up. Additional fees and closing costs apply. If the down payment is less than 20%, mortgage insurance may be needed, which could increase the monthly payment and APR.
• Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
• Please contact a loan specialist to get specific payment examples and information regarding your particular needs.

Get Walk Score Content

Property History

Today

Property information last updated

Today

Status Active. This is the date the listing was placed on market.

Cumulative Days on Market: Less than 1 (since July 29th, 2025) Data provided by the MLS.

Similar Properties

Listings courtesy of REcolorado as distributed by MLS GRID. IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MLS GRID. Based on information submitted to the MLS GRID as of 07/29/2025 02:20 pm. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.

DMCA Notice

Privacy Policy

Listing Data last updated: 07/29/2025 02:20 pm

Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.

Save Property Saved!

Share

Email to a friend Share on Facebook Copy Link for Instagram Share on Twitter Share on Pinterest! Copy Direct Link

Actions For Property

Request a Tour Request Info Notes Property Alerts Send to Friend My Account

1800 Crestone Court - MLS#4951584 - $792,500

Listed by Re/max Professionals

{"property_id":"denver_4951584","AboveGradeFinishedArea":"2502","AccessibilityFeatures":"","Appliances":"Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Range, Self Cleaning Oven","ArchitecturalStyle":"","AssociationAmenities":"","AssociationFee":"0.00","AssociationFeeFrequency":"","AssociationFeeIncludes":"","AssociationYN":"0","AttributionContact":"jeannepitre@yahoo.com, 720-971-2572","Basement":"Bath\/Stubbed, Finished, Full, Interior Entry, Sump Pump","BasementYN":"1","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1200","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","BuyerFinancing":"","CapRate":"0.00","CityRegion":"","CommonInterest":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Brick, Frame","Contingency":"","Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":"0","CurrentFinancing":"","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"Alpine","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","ExteriorFeatures":"Garden, Lighting, Private Yard, Water Feature","Fencing":"Full","FireplaceFeatures":"Family Room, Gas Log","FireplaceYN":"","FireplacesTotal":"2","Flooring":"Carpet, Wood","FoundationDetails":"","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Forced Air","HighSchool":"Skyline","HorseAmenities":"","HorseYN":"","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"Breakfast Bar, 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, Smart Light(s), Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)","InternetAddressDisplayYN":"","LaundryFeatures":"Sink, In Unit","Levels":"Two","ListAgentFullName":"Jeanne Pitre","ListAgentEmail":"","ListingTerms":"Cash, Conventional, FHA, Jumbo, VA Loan","LivingArea":"0.00","LotFeatures":"Corner Lot, Landscaped, Level, Master Planned, Secluded, Sprinklers In Front, Sprinklers In Rear","LotSizeArea":"10948.00","LotSizeDimensions":"","LotSizeSquareFeet":"10948.00","MainLevelBathrooms":"2","MainLevelBedrooms":"1","MiddleOrJuniorSchool":"Timberline","Model":"","NewConstructionYN":"","NumberOfUnitsTotal":"0","OtherParking":"","Ownership":"Individual","ParkingFeatures":"Concrete, Lighted","ParkingTotal":"2","PatioAndPorchFeatures":"Front Porch, Patio","PoolFeatures":"","PoolYN":"","PoolPrivateYN":"","PropertyAttachedYN":"0","PropertyCondition":"Updated\/Remodeled","public_remarks":"Stunning 6-Bedroom Home on a Corner Lot in Shadow Ridge!!  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 basementperfect 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 dedicated office,  complete with a built-in bookcase and accent lighting. The basement also has a theater area with upgraded soundproofing throughout. Enjoy year-round comfort thanks to the whole-house humidifier. 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 locationdont miss the opportunity to make it yours!Video of Home:https:\/\/iframe.videodelivery.net\/6870ed9acfc2b30ddb0d5927822d147d","Roof":"Shingle","RoomsTotal":"0","SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell","SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":"","SpaFeatures":"Bath","SpaYN":"","SpecialListingConditions":"None","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"House","TaxAnnualAmount":"3557.00","Utilities":"Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected","View":"","ViewYN":"","VirtualTourURLUnbranded":"https:\/\/www.listingsmagic.com\/sps\/tour-slider\/index.php?property_ID=275825&ld_reg=Y","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"","WindowFeatures":"Double Pane Windows, Egress Windows, Skylight(s), Window Coverings","YearBuilt":"1997","Zoning":"","ZoningDescription":"","property_uid":"REC2048639301","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"4951584","acreage":"","acres":"0.25","address":"","address_direction":"","address_flg":"1","address_num":"1800","agent_id":"030271","area":"","baths_total":"3.00","bedrooms_total":"6","car_spaces":"2","city":"Longmont","coseller_id":"","coagent_id":"047461","days_on_market":"0","finished_sqft_total":"3702","geocode_address":"1800 Crestone Court","geocode_status":"","lat":"40.19169236","lon":"-105.0867397","map_flg":"true","office_id":"REM46","office_name":"RE\/MAX Professionals","orig_price":"792500","photo_count":"46","photo_count_lac":"46","previous_price":"0","price":"792500","prop_img":"\/listing\/photos\/denver\/4951584-0.jpeg","property_type":"Residential","property_subtype":"Single Family Residence","sqft_total":"4102","state":"CO","street_type":"Court","street_name":"Crestone","sub_area":"Shadow Ridge","unit":"","zip_code":"80504","listing_dt":"0000-00-00","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"0000-00-00","sold_price":"0","webapi_update_dt":"2025-07-29 17:26:17","update_dt":"2025-07-29 20:26:27","create_dt":"2025-07-29 04:02:13","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}