$10,500,000

Estimated payment $56,170/month

Total Views 12,627
6 Beds
10 Baths
11,698 Sq Ft
$898 Price per Sq Ft

Highlights

  • Water Views
  • Home Theater
  • Outdoor Pool
  • Aspen Creek K-8 School Rated A
  • New Construction
  • Sauna

About This Home

Unparalleled Luxury Awaits in this stunning new custom estate expertly crafted by one of the area's premier builders, Nestled in the prestigious, gated Whistlepig Community. Spanning over 1.96 acres, this magnificent property boasts a breathtaking array of amenities designed to elevate your lifestyle. Step inside to discover a masterpiece of modern design. Entertain in style with spacious, open-concept living areas that seamlessly blend elegance and functionality. Indulge your culinary passions in a state-of-the-art kitchen featuring high-end appliances, custom cabinetry, massive center island, breakfast nook and huge walk-in pantry. Upstairs the luxurious primary retreat offers a serene sanctuary with a spa inspired bathroom, walk-in closets, sitting area opening to private deck with stunning views, three generously sized bedrooms suites, loft-lounge area and handy second laundry room. Lower level features sprawling rec room and spacious game room offering endless fun with room for pool table, arcade games, and more. Full wet bar ensures that every occasion with friends and family is catered to. Multiple sliders seamlessly connect to outdoor entertainment areas. For a more cinematic experience, retreat to the private theater room. Private guest suite has its own attached bath. Enjoy the huge exercise room for those seeking a high intensity workout, then indulge in ultimate relaxation in the attached spa bath featuring a sauna, steam shower, jetted tub, and a refreshing cold plunge tub. Elevator to all three levels. Step outside to your private oasis, complete with sparkling pool, rejuvenating spa, and multiple outdoor entertainment areas. The pool house offers a luxurious retreat with lounge area, full bar, and bathroom for ultimate convenience and relaxation. Secondary garage is large enough to ensure ample space for all your cars and toys. Truly a legacy estate offering an extraordinary living experience. Photos of home previous home built by Builder.

Listing Agent

Bonnie Peterson

Keller Williams Preferred Realty Brokerage Email: BONNIELPETERSON@GMAIL.COM,303-775-2250 License #40032205 Listed on: 05/15/2025

Keller Williams Preferred Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7

Year Built

  • New Construction

Lot Details

  • 1.96 Acre Lot
  • Property fronts a private road
  • Private Yard
  • Property is zoned R-PUD

HOA Fees

  • $500 Monthly HOA Fees

Parking

  • 15 Car Attached Garage
  • Parking Storage or Cabinetry
  • Heated Garage
  • Lighted Parking
  • Dry Walled Garage
  • Exterior Access Door
  • Circular Driveway
  • RV Garage

Property Views

  • Water
  • Mountain

Home Design

  • Frame Construction
  • Concrete Roof
  • Stone Siding
  • Radon Mitigation System
  • Stucco

Interior Spaces

  • 2-Story Property
  • Elevator
  • Open Floorplan
  • Wet Bar
  • Built-In Features
  • Bar Fridge
  • Vaulted Ceiling
  • Ceiling Fan
  • Entrance Foyer
  • Great Room
  • Family Room
  • Dining Room
  • Home Theater
  • Den
  • Loft
  • Bonus Room
  • Game Room
  • Utility Room
  • Laundry Room
  • Sauna
  • Home Gym

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Walk-In Pantry
  • Oven
  • Range with Range Hood
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • Primary Bedroom Suite
  • Walk-In Closet
  • Steam Shower

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Sump Pump
  • 1 Bedroom in Basement

Home Security

  • Radon Detector
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Outdoor Pool
  • Balcony
  • Deck
  • Covered Patio or Porch

Schools

  • Aspen Creek K-8 Elementary And Middle School
  • Broomfield High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Phone Available
  • Cable TV Available

Additional Features

  • Garage doors are at least 85 inches wide
  • Smoke Free Home

Listing and Financial Details

  • Assessor Parcel Number R8860844

Community Details

Overview

  • Association fees include reserves, ground maintenance, snow removal
  • Whistlepig Homeowners Association, Phone Number (303) 909-5054
  • Whistlepig Subdivision, Custom Luxury Home Floorplan

Recreation

  • Trails

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$7

Year Built

New Construction

Lot Details

0

HOA Fees

$500 per month

Parking

15

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Two
  • Year Built: 2026
  • Above Grade Finished Sq Ft: 6837
  • Exclusions: None
  • Living Area: 11698
  • Property Condition: New Construction
  • Directions: From Dillon Road and Aspen St, South on Aspen to Whistlepig Lane, West, then South on Whistlepig Ln to Property.
  • SubdivisionName: Whistlepig
  • Ownership: Builder
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 4
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Special Features: NewHome

Interior Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Microwave, Oven, Range, Range Hood, Refrigerator, Sump Pump, Tankless Water Heater, Wine Cooler
  • Interior Amenities: Breakfast Bar, Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Elevator, Entrance Foyer, Five Piece Bath, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Sauna, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Tile, Wood
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Basement: Exterior Entry, Finished, Full, Interior Entry, Sump Pump, Walk-Out Access
  • Basement: Yes
  • Three Quarter Bathrooms: 6
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 4861
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 1
  • Spa Features: Bath

Exterior Features

  • Foundation Details: Structural
  • Roof: Concrete
  • Construction Materials: Frame, Stone, Stucco
  • View: Mountain(s), Water
  • Exterior Features: Balcony, Private Yard
  • Patio and Porch Features: Covered, Deck, Front Porch, Patio
  • Pool Features: Outdoor Pool
  • Road Frontage Type: Private Road
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Circular Driveway, Concrete, Dry Walled, Exterior Access Door, Finished Garage, Heated Garage, Lighted, Oversized, Oversized Door, RV Garage, Storage
  • Attached Garage: Yes
  • Garage Spaces: 15
  • Total Parking Spaces: 15

Utilities

  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Laundry Features: Sink
  • Security: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Reserves, Maintenance Grounds, Snow Removal
  • Association Name: Whistlepig Homeowners Association
  • Association Fee Frequency: Monthly
  • Association Amenities: Gated, Trail(s)
  • Association Fee: 500
  • Phone: 303-909-5054
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 6000.00
  • REC_AssociationFeeTotalAnnual: 6000.00
  • REC_AssociationManagementType: Self Managed

Schools

  • Middle Or Junior School: Aspen Creek K-8

Lot Info

  • Parcel Number: R8860844
  • Lot Size Acres: 1.96
  • Building Area Total: 11698
  • Lot Size Sq Ft: 85377.6

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 7

MLS Schools

  • Elementary School: Aspen Creek K-8
  • High School: Broomfield

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7 $20 $20 --
2024 $7 $20 $20 --
2023 $7 $20 $20 --
2022 $7 $20 $20 $0
2021 $7 $20 $20 $0
2020 $7 $20 $20 $0
2019 $7 $20 $20 $0
2018 $7 $20 $20 $0
2017 $7 $20 $20 $0
2016 $7 $20 $20 $0
2015 $7 $10 $10 $0
2014 $6 $10 $10 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/15/2025 05/15/25 For Sale $10,500,000 +1300.0% $898 / Sq Ft
10/30/2023 10/30/23 Sold $750,000 0.0% --
05/17/2023 05/17/23 Pending -- -- --
06/20/2022 06/20/22 For Sale $750,000 0.0% --
06/13/2022 06/13/22 Pending -- -- --
06/03/2022 06/03/22 For Sale $750,000 +11.1% --
05/21/2021 05/21/21 Sold $675,000 -1.4% --
04/07/2021 04/07/21 Pending -- -- --
04/01/2021 04/01/21 Price Changed $684,900 -2.1% --
12/08/2020 12/08/20 Price Changed $699,900 -6.7% --
09/11/2020 09/11/20 For Sale $750,000 -- --
Source: REcolorado®

Purchase History

Date Type Sale Price Title Company
Warranty Deed $750,000 Land Title
Special Warranty Deed $675,000 None Available
Special Warranty Deed $335,000 Land Title
Special Warranty Deed $300,000 Land Title Guarantee Company
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $472,500 New Conventional
Source: Public Records

Source: REcolorado®

MLS Number: 7004700

REcolorado®

APN: 1575-24-2-01-007