Welcome to Boulder County's finest mansion retreat featuring all the bells and whistles you can imagine from a private beach, koi pond, indoor heated swimming pool, sauna, putting green, ballroom, wine cellar, chef's kitchen, custom built in fish tanks, and movie theater, you'll have all the amenities you can think of. Enjoy the outdoors on the enormous, covered patios and plenty of room for toys in the attached 6 car garage. With 6 bedrooms, 10 bathrooms, 22,454 sq ft, soaring high ceilings, and a walk out basement this home has it all. Selective hand-picked imported tiles, custom doors, and cabinets throughout. Location is divine in a prestigious community with 360-degree views. If you're looking for the best, top of the line home that is currently on the market then this beautiful manor will not disappoint.
Electric Range/Oven, Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
FIREPLACE FEATURES
2+ Fireplaces
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
District Sewer
WATER SOURCE
District Water, Left Hand
Year Built
1999
Basement
Full, Walk-Out Access
FINISHED BASEMENT SIZE
5954.0
Roof
Composition
Garage spaces
6
View
Foothills View, Panoramic
CITY
Niwot
SUBDIVISION
Somerset Estates
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
SENIOR COMMUNITY
No
HOA
1
TAX AMOUNT
45405.0
HOA FEE
625.0
HOA FREQUENCY
Quarterly
LATEST UPDATE
2025-03-24T15:25:27.945Z
DAYS ON MARKET
176
PRICE CHANGE(S)
$7,495,000 Sep 30, 2024
$6,985,000 Feb 12, 2025
CUMULATIVE DAYS ON MARKET
176
Property Details
Property TypeResidential
StatusActive
Bedrooms6
Bathrooms (Full)6
Property Sub TypeResidential-Detached
Square Feet22,454
MLS #1019651
Bathrooms (¾)1
Bathrooms (Half)3
AppliancesElectric Range/Oven, Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
FIREPLACE FEATURES2+ Fireplaces
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERDistrict Sewer
WATER SOURCEDistrict Water, Left Hand
Year Built1999
BasementFull, Walk-Out Access
FINISHED BASEMENT SIZE5954.0
RoofComposition
Garage spaces6
ViewFoothills View, Panoramic
CITYNiwot
SUBDIVISIONSomerset Estates
COUNTYBoulder
AREASuburban Plains
STATECO
SENIOR COMMUNITYNo
HOA1
TAX AMOUNT45405.0
HOA FEE625.0
HOA FREQUENCYQuarterly
LATEST UPDATE2025-03-24T15:25:27.945Z
DAYS ON MARKET176
PRICE CHANGE(S)
$7,495,000 Sep 30, 2024
$6,985,000 Feb 12, 2025
CUMULATIVE DAYS ON MARKET176
Market Trends
New Properties On Market
54
108%
Increase In New Listings
Average Asking Price
$1,079,821
$140,978 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$318
$44 Decrease In List Price/Sq. Ft.
Average Days On Market
18
30 Day
Decrease In Days On Market
Data as of Apr 18, 2025.
Remaining statistics above are calculated on activity within the period from Feb 01, 2025 to Mar 31, 2025.
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.