Elegant Rocky Mountain estate in Legend Ridge with resort-like pool and spa. The entry opens to a classic sitting room with vaulted ceilings and fireplace. Step into the formal dining room where 10+ can gather at the table. The chef's kitchen is complete with Wolf and Sub-Zero Appliances, wine cooler, island with secondary prep sink, double-oven, eat-in kitchen and counter seating. A stone hearth and fireplace compliment the living room. Exposed beams, sumptuous built-ins and a fireplace grace the office/den. The main-level primary suite offers a fireplace, 5-piece bath with walk-in shower, and access to the pool. The 3 upstairs bedrooms each have ensuite bathrooms, decks, and walk-in closets. The home theater in the walkout basement has a full-size bar, kitchenette and wine cellar. The 2 bedrooms in the basement also have bathrooms. Outdoor fireplace, fire pit, water feature and exquisite stone work. Four-car garage. Close to Boulder and Longmont. Video: https://youtu.be/QNqJ3QxIt_I
Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Trash Compactor, Freezer, Gas Bar-B-Q, Water Purifier Owned, Disposal, Fire Alarm
BATH FEATURES
Bath
FIREPLACE FEATURES
Two or More, Gas, Gas Log, Multi-Sided, Living Room, Family Room, Bedroom
Heating
Forced Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2006
Basement
Partially Finished, Walk-Out Access
FINISHED BASEMENT SIZE
3725.0
Roof
Tile
EXTERIOR FEATURES
Sprinkler System, Balcony, Hot Tub, Oversized Garage
Parking Features
Garage Door Opener
Fence
Fenced, Metal
Garage spaces
4
View
Mountain(s), Plains View
CITY
Niwot
SUBDIVISION
Legend Ridge
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
COMMUNITY FEATURES
Trail(s)
HOA
1
TAX AMOUNT
17372.02
HOA FEE
300.0
HOA FREQUENCY
Quarterly
LATEST UPDATE
2026-01-23T07:24:59.808Z
PRICE CHANGE(S)
$3,200,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms6
Bathrooms (Full)3
Property Sub TypeSingle Family Residence
Square Feet8,343
MLS #962013
Bathrooms (¾)3
Bathrooms (Half)1
FlooringWood
AppliancesGas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Trash Compactor, Freezer, Gas Bar-B-Q, Water Purifier Owned, Disposal, Fire Alarm
BATH FEATURESBath
FIREPLACE FEATURESTwo or More, Gas, Gas Log, Multi-Sided, Living Room, Family Room, Bedroom
HeatingForced Air
Utility FeaturesNatural Gas Available, Electricity Available
SEWERPublic Sewer
WATER SOURCECity
Year Built2006
BasementPartially Finished, Walk-Out Access
FINISHED BASEMENT SIZE3725.0
RoofTile
EXTERIOR FEATURESSprinkler System, Balcony, Hot Tub, Oversized Garage
Parking FeaturesGarage Door Opener
FenceFenced, Metal
Garage spaces4
ViewMountain(s), Plains View
CITYNiwot
SUBDIVISIONLegend Ridge
COUNTYBoulder
AREASuburban Plains
STATECO
COMMUNITY FEATURESTrail(s)
HOA1
TAX AMOUNT17372.02
HOA FEE300.0
HOA FREQUENCYQuarterly
LATEST UPDATE2026-01-23T07:24:59.808Z
PRICE CHANGE(S)
$3,200,000 Oct 21, 2025
Market Trends
New Properties On Market
50
257%
Increase In New Listings
Average Asking Price
$905,186
$756,242 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$352
$164 Decrease In List Price/Sq. Ft.
Average Days On Market
13
34 Day
Decrease In Days On Market
Data as of Feb 06, 2026.
Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 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.