- 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
-
Builder Name:Flatiron Development & Custom Homes
-
Builder Model:Custom Luxury Home
-
Construction Materials:Frame, Stone, Stucco
-
Building Area Total:11698
-
Building Area Source:Plans
-
Structure Type:House
-
Roof:Concrete
-
Foundation Details:Structural
-
Levels:Two
-
Basement:true
-
Exterior Features:Balcony, Private Yard
-
Patio And Porch Features:Covered, Deck, Front Porch, Patio
-
Security Features:Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s)
-
Above Grade Finished Area:6837
-
Below Grade Finished Area:4861
-
Property Attached:false
Interior
-
Interior Features: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
-
Laundry Features:Sink
Room Dimensions
-
Living Area:11698
Financial & Terms
-
Ownership:Builder
Location
-
Latitude:39.95207169
-
Longitude:-105.0641576
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Parcel Number:R8860844
-
Property Condition:New Construction
-
Zoning:R-PUD
-
Lot Number:7
-
Lot Size Area:1.96
-
Lot Size Acres:1.96
-
Lot Size SqFt:85,377 Sqft
-
Lot Size Units:Acres
-
Exclusions:None
-
View:Mountain(s), Water
-
Road Responsibility:Private Maintained Road
-
Road Frontage Type:Private Road
-
Road Surface Type:Paved
Listing Agent
- Contact info:
- Agent phone:
- (303) 775-2250
- Office phone:
- (303) 452-3300
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$7
Beds
-
Bedrooms Total:6
-
Main Level Bedrooms:1
-
Upper Level Bedrooms:4
-
Basement Level Bedrooms:1
Baths
-
Total Baths:10
-
Full Baths:2
-
Three Quarter Baths:6
-
Half Baths:2
-
Main Level Baths:3
-
Upper Level Baths:4
-
Basement Level Baths:3
Heating & Cooling
-
Heating:Forced Air, Natural Gas
-
Cooling:Central Air
Utilities
-
Utilities:Cable Available, Electricity Available, Natural Gas Available, Phone Available
-
Sewer:Public Sewer
-
Water Included:Yes
-
Water Source:Public
Appliances
-
Appliances:Bar Fridge, Dishwasher, Disposal, Microwave, Oven, Range, Range Hood, Refrigerator, Sump Pump, Tankless Water Heater, Wine Cooler
Schools
-
Elementary School:Aspen Creek K-8
-
Elementary School District:Boulder Valley RE 2
-
Middle Or Junior School:Aspen Creek K-8
-
Middle Or Junior School District:Boulder Valley RE 2
-
High School:Broomfield
-
High School District:Boulder Valley RE 2
The Community
-
Subdivision Name:Whistlepig
-
Association Amenities:Gated, Trail(s)
-
Association:true
-
Association Name:Whistlepig Homeowners Association
-
Association Fee:$500
-
Association Fee Frequency:Monthly
-
Association Fee Annual:$6,000
-
Association Fee Total Annual:$6,000
-
Association Fee Includes:Reserves, Maintenance Grounds, Snow Removal
-
Senior Community:false
-
Spa Features:Bath
-
Pool Features:Outdoor Pool
Parking
-
Parking Total:15
-
Parking Features:Circular Driveway, Concrete, Dry Walled, Exterior Access Door, Finished Garage, Heated Garage, Lighted, Oversized, Oversized Door, RV Garage, Storage
-
Attached Garage:true
-
Garage 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).