Property Attributes
- MLS#2683816
- TypeSingle Family
- Listing Status Active
- CountyWELD
- CityFrederick
- AreaGreeley-Weld
- NeighborhoodDreamers Ridge Ph 1
- Zip80504
- StyleContemporary
- Year Built2023
- Taxes$ 9032
- Price$ 1,750,000
- Bedrooms7
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage5124
- Lot Size1.18 Acres
Data Source:
Information and Real Estate Services (IRES)
Property Description
Colorado views, privacy & luxury on 1.18 acres! Nestled in an exclusive community, this exceptional Longmont estate backs to open farmland with no immediate rear neighbors and offers stunning views of Longs Peak, Eldora Ski Resort, and the Flatirons. The open-concept home features soaring ceilings, abundant natural light, a main-level primary suite, six additional bedrooms, a loft, and a finished basement with a home theater and Sonos sound. The professionally landscaped backyard is built for entertaining with a remote-operated louvered pergola, Bullfrog Spa, oversized gas fire pit, in-ground trampoline, and irrigated raised garden beds. Additional highlights include dual HVAC, tankless water heater, EV charger, permanent JellyFish lighting, and space for a future 1,200 SF outbuilding, RV garage, pool, or putting green. Covenants allow up to four hens. A rare blend of acreage, privacy, panoramic views, and Colorado lifestyle-all minutes from I-25.
| Elementary School | Middle School | High School |
|---|---|---|
| Legacy Elementary School | Coal Ridge Middle School | Mead High School |
| Price History | |
|---|---|
| 9/23/2026 | Listed $1,750,000 |
General Features
| Living Area | 5124 |
|---|---|
| Sewer | Septic Tank |
| Heating | Forced Air |
| Cooling | Central Air,Ceiling Fan(s) |
| Roof | Composition |
| Appliances | Double Oven,Dishwasher,Refrigerator,Washer,Dryer,Microwave,Freezer,Disposal |
| Garage Spaces | 3 |
| Patio/Porch Features | Patio,Deck |
| Architectural Style | Contemporary |
| Construction Materials | Frame,Stucco |
| Exclusions | Sellers personal items,car lift,outdoor furniture |
| Year Built | 2023 |
| View | Mountain(s),Plains View |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| County | Weld |
| New Construction | Yes |
| Property Type | Residential |
| HOA | No |
| Energy Efficient | Windows |
| Subdivision Name | Dreamers Ridge Ph 1 |
| Full Baths | 3 |
| Status | Active |
| Directions | From Highway 52,north on Aggregate Blvd. Drive west on Co Rd 5. Turn right onto Godding Hollow Pkwy then Turn Right to the Dreamers Ridge Subdivision. |
| High School | Mead |
| City | Frederick |
| High School District | ST Vrain Dist RE 1J |
| MLS Area | Greeley/Weld |
| Elementary School | Legacy |
| Property Attached Y/N | No |
| Tax Annual Amount | 9032 |
| Middle/Junior High School | Coal Ridge |
| Standard Status | Active |
| Expected Active Date | 2026-09-23 |
| AttributionContact | kristincohomes@gmail.com,303-917-1191 |
Interior Features
| Interior Amenities | Pantry,Walk-In Closet(s),Wet Bar,Jack & Jill Bathroom |
|---|---|
| Basement | Full,Partially Finished,Structural Floor,Sump Pump |
| Window Features | Window Coverings |
| Above Grade Finished Area | 3440 |
| Half Baths | 1 |
| Total Bedrooms | 7 |
| Room Type | Loft,Media Room |
| LivingAreaSource | Assessor |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Sprinkler System,Hot Tub,>8' Garage Door,Oversized Garage |
|---|---|
| Parking Features | Attached |
| Lot Features | House Faces South,Paved |
| Water Source | Public |
| Lot Size Area | 51531 |
| Lot Size Acres | 1.18 |
| Waterfront Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Information deemed reliable but not guaranteed by the MLS. © 2026 Information and Real Estate Services, LLC.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES.
The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.
The IRES, LLC Data on this
The real estate listing information and related content displayed on this site 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. This information and related content is deemed reliable but is not guaranteed accurate by elevateMLS.
Copyright © 2026 Altitude MLS, Inc., a wholly owned subsidiary of Altitude REALTORS®. All rights reserved. The information being provided is for the consumer's non-commercial, personal use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. The information provided is not guaranteed and should be independently verified. You may not reprint or redistribute the information, in whole or in part, without the expressed written