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 HomeSmart Preferred Realty 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 6:34 PM UTCd
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.
Pueblo Association of REALTORS®, Inc. All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2026 All rights reserved.
Westcliffe Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested