RECENTLY COMPLETED! Elegant & sophisticated custom walk-out ranch, built by Shaub Ent. in private gated community surrounded by Conservation Land & Open Space. 10 Minutes to Boulder & 20 to Denver, this property boasts amazing attention to detail w/ unsurpassed custom wood work, tile & finish throughout. Features clean, understated elegance in finish, 800 sq ft covered deck for entertaining, 6 car heated garage, beautiful community with lake usage! Don't miss this Shaub Enterprise masterpiece!
Gas Range, Dishwasher, Refrigerator, Bar Fridge, Microwave, Fire Alarm
FIREPLACE FEATURES
Two or More, Living Room, Family Room, Bedroom, Basement
Heating
Forced Air, 2 or more Heat Sources, 2 or more H20 Heaters
Utility Features
Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2014
Builder Name
Shaub Enterprises
Basement
Partially Finished, Walk-Out Access
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
Roof
Tile
EXTERIOR FEATURES
Oversized Garage
Lot Features
Sloping Lot, Paved
Garage spaces
6
View
Mountain(s), Hills
CITY
Broomfield
SUBDIVISION
Whistlepig
COUNTY
Broomfield
AREA
Broomfield
STATE
CO
COMMUNITY FEATURES
Park
HOA
1
TAX AMOUNT
6.0
HOA FEE
375.0
HOA FREQUENCY
Monthly
LATEST UPDATE
2026-01-23T13:26:45.079Z
PRICE CHANGE(S)
$2,785,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms5
Bathrooms (Full)3
Property Sub TypeSingle Family Residence
Square Feet7,500
MLS #744172
Bathrooms (¾)2
Bathrooms (Half)2
FlooringWood
AppliancesGas Range, Dishwasher, Refrigerator, Bar Fridge, Microwave, Fire Alarm
FIREPLACE FEATURESTwo or More, Living Room, Family Room, Bedroom, Basement
HeatingForced Air, 2 or more Heat Sources, 2 or more H20 Heaters
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWERPublic Sewer
WATER SOURCECity
Year Built2014
Builder NameShaub Enterprises
BasementPartially Finished, Walk-Out Access
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
RoofTile
EXTERIOR FEATURESOversized Garage
Lot FeaturesSloping Lot, Paved
Garage spaces6
ViewMountain(s), Hills
CITYBroomfield
SUBDIVISIONWhistlepig
COUNTYBroomfield
AREABroomfield
STATECO
COMMUNITY FEATURESPark
HOA1
TAX AMOUNT6.0
HOA FEE375.0
HOA FREQUENCYMonthly
LATEST UPDATE2026-01-23T13:26:45.079Z
PRICE CHANGE(S)
$2,785,000 Oct 21, 2025
Market Trends
New Properties On Market
44
110%
Increase In New Listings
Average Asking Price
$788,838
$295,389 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$279
$15 Increase In List Price/Sq. Ft.
Average Days On Market
14
22 Day
Decrease In Days On Market
Data as of Apr 13, 2026.
Remaining statistics above are calculated on activity within the period from Feb 01, 2026 to Mar 31, 2026.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.