Property Attributes
- MLS#IR1064899
- TypeSingle Family
- Listing Status Active
- CountyWELD
- CityFrederick
- NeighborhoodHauck Meadows II
- Zip80504
- StyleHouse
- Year Built2025
- Taxes$ 4858
- Price$ 1,499,000
- Bedrooms5
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage4422
- Lot Size0.77 Acres
Data Source:
REColorado (MTOMLS)
Property Description
Experience exceptional craftsmanship in this like-new custom home on nearly an acre with breathtaking panoramic views, professionally designed low-maintenance landscaping, and a quiet cul-de-sac location. Plus---NO METRO and ability to add an ADU! This home is built by one of Northern Colorado's premier custom builders, Custom On Site Builders, this home showcases outstanding quality, thoughtful design, and luxury finishes throughout. The covered front porch welcomes you into an open floor plan with soaring ceilings, wood beams, hand-troweled walls, knotty alder cabinetry, extensive real wood trim, and a stunning wood-burning fireplace. The chef's kitchen features an oversized island with abundant storage, hidden walk-in pantry with space for a second refrigerator, under-cabinet lighting, and exceptional functionality for everyday living and entertaining.Expansive 12-foot glass doors open to the oversized covered patio, creating seamless indoor-outdoor living while capturing the incredible mountain views and peaceful surroundings.The luxurious primary suite offers a spa-inspired walk-in shower, dual vanities, and a spacious walk-in closet. The laundry room is beautifully appointed with floor-to-ceiling cabinetry, utility sink, generous counter space, and abundant storage.The partially finished basement is ideal for entertaining or multi-generational living with an impressive wet bar featuring a refrigerator, microwave, extensive counter space, and ready for a future fireplace. Additional features include dual-zone heating and cooling, tankless water heater, built-in storage throughout, and thoughtfully placed electrical outlets.Fall in love with the oversized 3+ car garage with dedicated workshop and storage space and pre- wired for an EV charger.Every detail reflects exceptional craftsmanship and pride of ownership, offering a rare opportunity to own a truly custom home in one of Northern Colorado's most desirable settings. Home is occupied
| Elementary School | Middle School | High School |
|---|---|---|
| Erie Elementary School | Erie Middle School | Erie High School |
| Price History | |
|---|---|
| 7/23/2026 | Listed $1,499,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air |
| Cooling | Ceiling Fan(s),Central Air |
| Utilities | Electricity Available,Natural Gas Available |
| Possession | Closing/DOD |
| Roof | Composition |
| Appliances | Bar Fridge,Dishwasher,Disposal,Microwave,Oven,Refrigerator |
| Zoning | RES |
| HOA Fee | 240 |
| Garage Spaces | 4 |
| Association Fee Includes | Reserves |
| Security Features | Smoke Detector(s) |
| Construction Materials | Stone,Frame |
| Year Built | 2025 |
| View | Mountain(s) |
| Levels | One |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Ownership | Individual |
| Assoc Fee Paid Per | Quarterly |
| County | Weld |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | Yes |
| Subdivision Name | Hauck Meadows II |
| Facing Direction | North |
| Possible Use | Residential |
| Full Baths | 2 |
| Status | Active |
| High School | Erie |
| City | Frederick |
| Association Name | Hauck Meadow |
| High School District | St. Vrain Valley RE-1J |
| Lot Size Square Feet | 33417 |
| Elementary School | Erie |
| Tax Annual Amount | 4858 |
| Middle/Junior High School | Erie |
| Property Condition | New Construction |
| Concessions | No |
| Virtual Tour | https://www.listingsmagic.com/sps/tour-slider/index.php?property_ID=284599 |
| Structure Type | House |
| Standard Status | Active |
| Occupancy Type | Owner |
| Elementary School District | St. Vrain Valley RE-1J |
Interior Features
| Interior Amenities | Eat-in Kitchen,Kitchen Island,Open Floorplan,Pantry,Radon Mitigation System,Vaulted Ceiling(s),Walk-In Closet(s) |
|---|---|
| Basement | Full |
| Flooring | Laminate |
| Fireplace Features | Living Room |
| Basement (Y/N) | Yes |
| Window Features | Double Pane Windows,Window Coverings |
| Above Grade Finished Area | 2292 |
| 3/4 Baths | 1 |
| Laundry Features | In Unit |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 1287 |
| Main Level Bedrooms | 3 |
| Main Level Bathrooms | 2 |
| Total Baths | 3 |
Exterior Features
| Parking Features | Oversized |
|---|---|
| Lot Features | Cul-De-Sac,Level,Sprinklers In Front |
| Total Parking | 4 |
| Foundation Details | Slab |
| Building Area Total | 4422 |
| Lot Size Acres | 0.77 |
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 Berkshire Hathaway HomeServices Colorado Real Estate - Erie 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
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