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
Offered By
Lisa Pentz 3037335335, Porchlight RE Group-Boulder
Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Trash Compactor, Freezer, Water Purifier Owned, Disposal
BATH FEATURES
Bath
LAUNDRY FEATURES
Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
2+ Fireplaces, Gas, Gas Logs Included, Double Sided, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
City Sewer
WATER SOURCE
City Water, Left Hand Water
Year Built
2006
Basement
90%+ Finished Basement, Walk-Out Access
FINISHED BASEMENT SIZE
3725.0
Roof
Concrete
EXTERIOR FEATURES
Gas Grill, Balcony, Hot Tub Included
Parking Features
Garage Door Opener, Oversized
Fence
Fenced, Metal Post Fence
Lot Features
Lawn Sprinkler System
PRIVATE POOL
1
Garage spaces
4
View
Mountain(s), Plains View
CITY
Niwot
SUBDIVISION
Legend Ridge
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Hiking/Biking Trails
HOA
1
TAX AMOUNT
17372.02
HOA FEE
300.0
HOA FREQUENCY
Quarterly
LATEST UPDATE
2024-08-02T00:42:05.211Z
DAYS ON MARKET
15
PRICE CHANGE(S)
$3,200,000 Dec 8, 2022
CUMULATIVE DAYS ON MARKET
15
Property Details
Property TypeResidential
StatusClosed
Bedrooms6
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet8,978
MLS #962013
Bathrooms (¾)3
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Trash Compactor, Freezer, Water Purifier Owned, Disposal
BATH FEATURESBath
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURES2+ Fireplaces, Gas, Gas Logs Included, Double Sided, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available
SEWERCity Sewer
WATER SOURCECity Water, Left Hand Water
Year Built2006
Basement90%+ Finished Basement, Walk-Out Access
FINISHED BASEMENT SIZE3725.0
RoofConcrete
EXTERIOR FEATURESGas Grill, Balcony, Hot Tub Included
Parking FeaturesGarage Door Opener, Oversized
FenceFenced, Metal Post Fence
Lot FeaturesLawn Sprinkler System
PRIVATE POOL1
Garage spaces4
ViewMountain(s), Plains View
CITYNiwot
SUBDIVISIONLegend Ridge
COUNTYBoulder
AREASuburban Plains
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESHiking/Biking Trails
HOA1
TAX AMOUNT17372.02
HOA FEE300.0
HOA FREQUENCYQuarterly
LATEST UPDATE2024-08-02T00:42:05.211Z
DAYS ON MARKET15
PRICE CHANGE(S)
$3,200,000 Dec 8, 2022
CUMULATIVE DAYS ON MARKET15
Market Trends
New Properties On Market
54
108%
Increase In New Listings
Average Asking Price
$1,096,858
$161,669 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$321
$39 Decrease In List Price/Sq. Ft.
Average Days On Market
19
30 Day
Decrease In Days On Market
Data as of Apr 21, 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.