- 6 beds
- 10 baths
- 11,698 sqft
- ~2 acre lot
- $897 per sqft
- – on site
Unparalleled Luxury Awaits in this stunning new custom estate expertly crafted by Flatiron Development & Custom Homes, 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. This extraordinary estate offers a truly exceptional living experience. Photos of home previous home built by Builder.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 16, 2025
•
MLS# 7004700 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2026
-
New Construction:true
-
Construction Materials:Wood/Frame
-
Total SqFt:11,698 Sqft
-
Building Area Total:6837
-
Roof:Concrete
-
Levels:Two
-
Basement:Full
-
Stories:2
-
Patio And Porch Features:Patio
-
Accessibility Features:Accessible Elevator Installed
-
Above Grade Finished Area:6837
-
Below Grade Finished Area:4861
Interior
-
Interior Features:Eat-in Kitchen
-
Kitchen Level:Main
-
Dining Room Level:Main
-
Family Room Level:Basement
-
Laundry Features:Upper Level
Room Dimensions
-
Living Area:11698
-
Living Area Units:Square Feet
-
Living Area Source:Plans
-
Kitchen Length:20
-
Kitchen Area:400
-
Kitchen Width:20
-
Dining Room Area:270
-
Dining Room Length:18
-
Dining Room Width:15
-
Family Room Area:924
-
Family Room Length:21
-
Family Room Width:44
-
Rec Room Length:18
-
Master Bedroom Area:378
-
Master Bedroom Width:21
-
Master Bedroom Length:18
-
Bedroom Area:224
-
Bedroom Length:16
-
Bedroom Width:14
-
Bedroom 2 Area:300
-
Bedroom 2 Length:20
-
Bedroom 3 Length:17
-
Bedroom 2 Width:15
-
Bedroom 4 Length:17
-
Bedroom 3 Area:238
-
Bedroom 3 Width:14
-
Bedroom 5 Length:16
-
Bedroom 4 Area:238
-
Bedroom 4 Width:14
-
Bedroom 5 Area:224
-
Bedroom 5 Width:14
-
Laundry Room Length:8
-
Laundry Room Width:10
Financial & Terms
-
Listing Terms:Cash
Location
-
Directions:From Dillon Road and Aspen St, South on Aspen to Whistlepig Lane, West, then South on Whistlepig Ln to Property.
-
Coordinates:-105.064156, 39.952072
-
Latitude:39.952072
-
Longitude:-105.064156
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Property Condition:New Construction
-
Lot Size Acres:1.96
-
Lot Size SqFt:85,378 Sqft
-
Lot Size Area:85378
-
Lot Size Units:Square Feet
-
Zoning:R-PUD
-
View:Mountain(s)
-
Exclusions:None
-
Horse:false
-
Exterior Features:Balcony
-
Waterfront:false
-
Road Surface Type:Paved
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$7
Beds
-
Bedrooms Total:6
-
Bedroom Level:Upper
-
Bedroom 2 Level:Main
-
Bedroom 3 Level:Upper
-
Bedroom 4 Level:Basement
-
Bedroom 5 Level:Upper
-
Master Bedroom Level:Upper
Baths
-
Total Baths:10
-
Three Quarter Baths:6
-
Full Baths:2
-
Half Baths:2
-
Master Bath Features:Full Primary Bath, 5 Piece Primary Bath
The Listing
-
Special Listing Conditions:Builder
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Utilities:Natural Gas Available
-
Gas:Natural Gas
-
Electric:Electric
-
Sewer:City Sewer
-
Water Source:City Water
Appliances
-
Appliances:Dishwasher
Schools
-
Elementary School:Aspen Creek K-8
-
Middle School:Aspen Creek K-8
-
High School:Broomfield
-
High School District:Boulder Valley RE 2
The Community
-
Community Features:Fitness Center
-
Association:true
-
Subdivision Name:Whistlepig
-
Association Fee:$500
-
Association Fee Frequency:Monthly
-
Association Fee Includes:Snow Removal
-
Spa:true
-
Spa Features:Bath
-
Senior Community:false
Parking
-
Parking Features:>8' Garage Door
-
Garage Spaces:15
-
Garage:true
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:15
Monthly cost estimate

Asking price
$10,500,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$56,224
|
Taxes | N/A |
Insurance | $2,887 |
HOA fees | $500 |
Utilities | N/A |
Total | $59,611/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
5/15/25
May 15, 2025
|
Listed / Active | IRES | $10,500,000 | 1300.0% (842.6% / YR) |
10/30/23
Oct 30, 2023
|
RECOLORADO | $750,000 | ||
9/15/23
Sep 15, 2023
|
RECOLORADO | $750,000 | 11.1% (4.8% / YR) |