Property Attributes
- MLS#1062442
- TypeSingle Family
- Listing Status Active
- CountyWELD
- CityFrederick
- AreaGreeley-Weld
- NeighborhoodHauck Meadows
- Zip80504
- StyleContemporary
- Year Built2027
- Taxes$ 6
- Price$ 2,049,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage7440
- Lot Size0.83 Acres
Data Source:
Information and Real Estate Services (IRES)
Property Description
House is under construction with an estimated completion date of January-February 2027. Welcome to a rare opportunity to own a stunning contemporary farmhouse crafted by ELMC, one of the region's most respected builders. Ideally situated between Longmont, Niwot, Erie, and Frederick, this property offers the best of Colorado living - sweeping mountain views and a thoughtfully designed floor plan with high quality finishes. Set on a generous .83-acre lot, the home captures the Front Range's most iconic peaks and foothills from nearly every angle. The main floor is designed for both comfort and flexibility. A private primary suite, an open-concept living, dining, and kitchen area with soaring 20-foot ceilings, and a dedicated home office anchor the space. The well-appointed kitchen includes stylish Cafe appliances and a large island, perfect for the home chef. A spacious laundry and mudroom adds everyday practicality, while a thoughtfully appointed guest wing - complete with its own bedroom, bathroom, living area, and kitchenette - offers exceptional versatility for multi-generational living or long-term guests. A covered deck off the main floor dining area extends the living space outdoors, creating the perfect setting for entertainment. Upstairs, a loft lounge area, three large bedrooms and two more bathrooms make this home ideal for any group. The unfinished 2,929 sq ft basement offers a blank canvas ready to become whatever you envision: a recreation room, home theater, gym, or additional living quarters. A three-car garage with 11-foot ceilings rounds out this exceptional property, providing ample room for vehicles, gear, and all the toys Colorado living demands. High efficiency HVAC units will make for low monthly bills. Additional outbuilding is allowed up to 800 sq ft.
| Elementary School | Middle School | High School |
|---|---|---|
| Grand View Elementary School | Erie Middle School | Erie High School |
| Price History | |
|---|---|
| 6/21/2026 | Listed $2,049,000 |
General Features
| Living Area | 4511 |
|---|---|
| Heating | Forced Air |
| Cooling | Central Air |
| Utilities | Natural Gas Available,Electricity Available |
| Roof | Composition |
| Appliances | Gas Range,Dishwasher,Refrigerator,Bar Fridge,Microwave |
| Zoning | RES |
| HOA Fee | 80 |
| Garage Spaces | 3 |
| Association Fee Includes | Common Amenities |
| Patio/Porch Features | Patio,Deck |
| Architectural Style | Contemporary |
| Construction Materials | Frame |
| Year Built | 2027 |
| Electric | United Power |
| View | Mountain(s),Hills |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2024 |
| Parcel Number | R8974577 |
| Accessibility | Level Lot |
| Assoc Fee Paid Per | Monthly |
| County | Weld |
| New Construction | Yes |
| Property Type | Residential |
| HOA | Yes |
| Energy Efficient | Windows |
| Subdivision Name | Hauck Meadows |
| Possible Use | Single Family |
| Full Baths | 4 |
| Status | Active |
| High School | Erie |
| City | Frederick |
| Disclosures | Seller's Property Disclosure |
| Association Name | Hauck Meadows II |
| High School District | ST Vrain Dist RE 1J |
| MLS Area | Greeley/Weld |
| Elementary School | Grand View |
| Property Attached Y/N | No |
| Tax Annual Amount | 6 |
| Middle/Junior High School | Erie |
| Builder Name | Erie Land Management |
| Standard Status | Active |
| Expected Active Date | 2026-06-21 |
| AttributionContact | 3038091717 |
Interior Features
| Interior Amenities | Eat-in Kitchen,Separate Dining Room,Cathedral Ceiling(s),Open Floorplan,Pantry,Walk-In Closet(s),Washer/Dryer Hookup,Jack & Jill Bathroom,Kitchen Island |
|---|---|
| Basement | Unfinished |
| Fireplace Features | Living Room |
| Above Grade Finished Area | 4511 |
| Half Baths | 1 |
| Total Bedrooms | 5 |
| LivingAreaSource | Plans |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Oversized Garage |
|---|---|
| Parking Features | Garage Door Opener,Attached |
| Lot Features | Paved |
| Water Source | City |
| Lot Size Area | 36338 |
| Lot Size Acres | 0.83 |
| Road Surface Type | Asphalt |
| Waterfront Y/N | No |
| Road Frontage Type | Priv Rd up to County Standards |
| Irrigation Water Rights 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.