Property Attributes
- MLS#2683816
- TypeSingle Family
- Listing Status Active
- CountyWELD
- CityFrederick
- NeighborhoodDreamers Ridge
- Zip80504
- StyleContemporary
- Year Built2023
- Taxes$ 9032
- Price$ 1,750,000
- Bedrooms7
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage5124
- Lot Size1.18 Acres
Data Source:
REColorado (MTOMLS)
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
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air |
| Cooling | Central Air |
| Possession | Close Plus 3 to 5 Days,Negotiable |
| Roof | Composition |
| Appliances | Dishwasher,Disposal,Double Oven,Dryer,Freezer,Microwave,Range,Refrigerator,Sump Pump,Tankless Water Heater,Washer |
| Garage Spaces | 3 |
| Patio/Porch Features | Covered,Deck,Front Porch |
| Architectural Style | Contemporary |
| Construction Materials | Frame,Stucco |
| Exclusions | Sellers personal items,car lift,outdoor furniture |
| Year Built | 2023 |
| View | Meadow,Mountain(s) |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Ownership | Individual |
| County | Weld |
| Property Type | Residential |
| HOA | No |
| Attached Garage | Yes |
| Subdivision Name | Dreamers Ridge Ph 1 |
| Facing Direction | South |
| 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 |
| Senior Community Y/N | No |
| High School District | St. Vrain Valley RE-1J |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 51531 |
| Listing Terms | Cash,Conventional,Jumbo,Other |
| Elementary School | Legacy |
| Tax Annual Amount | 9032 |
| Middle/Junior High School | Coal Ridge |
| Property Condition | New Construction |
| Structure Type | House |
| Standard Status | Active |
| Occupancy Type | Owner |
| Middle/Junior School District | St. Vrain Valley RE-1J |
| Elementary School District | St. Vrain Valley RE-1J |
Interior Features
| Interior Amenities | Ceiling Fan(s),Five Piece Bath,High Ceilings,Jack & Jill Bathroom,Pantry,Smoke Free,Sound System,Hot Tub,Walk-In Closet(s),Wet Bar |
|---|---|
| Basement | Finished,Full |
| Basement (Y/N) | Yes |
| Window Features | Double Pane Windows,Window Coverings |
| Above Grade Finished Area | 3440 |
| Half Baths | 1 |
| Laundry Features | Sink |
| Total Bedrooms | 7 |
| Below Grade Finished Area | 1684 |
| Main Level Bedrooms | 2 |
| Main Level Bathrooms | 2 |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Fire Pit,Spa/Hot Tub |
|---|---|
| Fencing | None |
| Parking Features | 220 Volts,Finished Garage,Floor Coating,Oversized,Oversized Door |
| Lot Features | Irrigated,Landscaped,Sprinklers In Front,Sprinklers In Rear |
| Water Source | Public |
| Total Parking | 3 |
| Lot Size Area | 51531 |
| Foundation Details | Structural |
| Building Area Total | 5124 |
| Lot Size Acres | 1.18 |
| Road Surface Type | Paved |
| Road Frontage Type | None |
| Horse 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
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (IDX) program of METROLIST, INC., DBA RECOLORADO©. Real estate listings held by brokers other than Moore At REMAX Alliance are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified. September 24, 2026 2:26 AM UTCd