Public Remarks: No detail spared in this elegant, Legend Ridge renovation. This extensive remodel offers features, finishes and amenities you'd be hard pressed to find elsewhere. Suited for both large size entertaining or intimate gatherings and perfectly appointed to maximize spectacular panoramic views of Colorado's captivating front range. Functional living and entertaining space for the most discerning buyer. Incredible landscaping, water features, black bottom pool, outdoor kitchen & entertaining spaces. Private location backing to open space. Minutes to downtown Boulder or Niwot, 40 minutes to DIA, downtown Denver & 2hrs hours to world-class skiing. See attached "Features List" in "Extras" for details on this incredible home.
Magnificent private estate w/expansive mountain views & approx. 2500 sq.ft. of covered outdoor living space.Pool w/rock waterfall & hot tub, fire-pit, outdoor kitchen. 6 en suite bedrooms, 9 baths, 7 fireplaces. Knotty alder cabinetry and custom finishes thruout.Sweeping 3 story circular staircase, gourmet kitchen w/Sub Zero, Wolf, & Thermador appliances inc. double oven & 2 dishwashers. Butler's kitchen, entertainment room kitchen w/ bar.Work out room & craft room. An absolutely exquisite home!
REColorado as Distributed by MLS Grid #1232530
Dec 31, 2013
Listing Removed
—
Sep 18, 2013
Listed
$2,895,000
$250/sq ft
IRES as Distributed by MLS Grid #695562
Nov 30, 2013
Listing Removed
—
Sep 13, 2013
Price Changed
$2,895,000
$250/sq ft
Nov 30, 2012
Listed
$2,995,000
$259/sq ft
REColorado as Distributed by MLS Grid #1095107
Oct 11, 2012
Listing Removed
—
Jul 17, 2012
Price Changed
$2,995,000
$259/sq ft
May 21, 2012
Listed
$3,490,000
$302/sq ft
IRES as Distributed by MLS Grid #661358
Oct 11, 2012
Listing Removed
—
Jul 16, 2012
Price Changed
$2,995,000
$259/sq ft
Jul 19, 2011
Listed
$3,490,000
$302/sq ft
REColorado as Distributed by MLS Grid #1054620
Feb 1, 2012
Listing Removed
—
Dec 11, 2011
Listed
$3,490,000
$302/sq ft
REColorado as Distributed by MLS Grid #970170
Jul 20, 2011
Listing Removed
—
Feb 18, 2011
Listed
$3,490,000
$302/sq ft
IRES as Distributed by MLS Grid #647727
Jul 14, 2011
Listing Removed
—
Feb 12, 2011
Listed
$3,490,000
$302/sq ft
IRES as Distributed by MLS Grid #457695
Nov 18, 2005
Sold
$2,850,000
$246/sq ft
Jul 1, 2005
Listed
$3,250,000
$281/sq ft
IRES as Distributed by MLS Grid #429298
Jan 17, 2005
Listing Removed
—
Sep 29, 2004
Listed
$3,250,000
$281/sq ft
IRES as Distributed by MLS Grid #373819
Aug 11, 2003
Sold
$2,745,742
$237/sq ft
May 6, 2003
Listed
$2,695,000
$233/sq ft
IRES as Distributed by MLS Grid #336728
Jun 19, 2002
Listing Removed
—
May 6, 2002
Listed
$2,200,000
$190/sq ft
IRES as Distributed by MLS Grid #251025
May 6, 2002
Listing Removed
—
Feb 23, 2001
Listed
$2,200,000
$190/sq ft
Public Records
Feb 16, 2000
Sold
$297,000
$26/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$36,318 (+1.6%)
$39,013 + $298,719
$337,732
2024
$35,748 (+1.3%)
$39,013 + $298,719
$337,732
2023
$35,273 (+39.9%)
$32,421 + $332,106
$364,527
2022
$25,219 (−1.3%)
$36,106 + $332,106
$368,212
2021
$25,554 (+17.7%)
$32,498 + $216,187
$248,685
2020
$21,719 (+0.3%)
$33,433 + $222,408
$255,841
2019
$21,654 (−2.3%)
$35,679 + $182,354
$218,033
2018
$22,161 (+6.5%)
$35,679 + $182,354
$218,033
2017
$20,808 (−9.6%)
$34,848 + $190,102
$224,950
2016
$23,027 (+36.8%)
$34,848 + $190,102
$224,950
2015
$16,831 (−7.5%)
$48,795 + $195,036
$243,831
2014
$18,196 (−0.3%)
$30,964 + $166,818
$197,782
2013
$18,256 (+22.3%)
$30,964 + $166,818
$197,782
2012
$14,924 (+6.9%)
$30,964 + $166,818
$197,782
2011
$13,958 (−20.8%)
$16,915 + $145,879
$162,794
2010
$17,616 (+1.8%)
$16,915 + $145,879
$162,794
2009
$17,297
$32,950 + $174,590
$207,540
Tax history for 6659 Legend Ridge Trl
Year
Property tax
Land + Additions
Assessment*
2025
$36,318 (+1.6%)
$39,013 + $298,719
$337,732
2024
$35,748 (+1.3%)
$39,013 + $298,719
$337,732
2023
$35,273 (+39.9%)
$32,421 + $332,106
$364,527
2022
$25,219 (−1.3%)
$36,106 + $332,106
$368,212
2021
$25,554 (+17.7%)
$32,498 + $216,187
$248,685
2020
$21,719 (+0.3%)
$33,433 + $222,408
$255,841
2019
$21,654 (−2.3%)
$35,679 + $182,354
$218,033
2018
$22,161 (+6.5%)
$35,679 + $182,354
$218,033
2017
$20,808 (−9.6%)
$34,848 + $190,102
$224,950
2016
$23,027 (+36.8%)
$34,848 + $190,102
$224,950
2015
$16,831 (−7.5%)
$48,795 + $195,036
$243,831
2014
$18,196 (−0.3%)
$30,964 + $166,818
$197,782
2013
$18,256 (+22.3%)
$30,964 + $166,818
$197,782
2012
$14,924 (+6.9%)
$30,964 + $166,818
$197,782
2011
$13,958 (−20.8%)
$16,915 + $145,879
$162,794
2010
$17,616 (+1.8%)
$16,915 + $145,879
$162,794
2009
$17,297
$32,950 + $174,590
$207,540
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
6
Baths
8
Stories
—
Lot width
—
Lot depth
—
Lot size
0.86 Acres
Year renovated
2015
Sq. Ft.
11,562
Year built
2001
Style
Single Family Residential
County
Boulder County
APN
R0143765
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
A
Agricultural District
Rural areas where conservation of agricultural resources is of major value, and where residential development compatible with agricultural uses is allowed.
Permitted uses
Include but are not limited to:
Agriculture
Equestrian facility
Livestock production
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Bed & breakfast
Educational/school
Kennel
Property details
Parking
Parking Features
Covered Spaces: 4
Garage: Yes
Attached Garage: Yes
Garage Spaces: 4
Parking Features: Garage Door Opener
Interior
Bathroom Information
Bathrooms (Full): 4
Bathrooms (Half): 2
Bathrooms (Three Quarter): 3
Bedroom Information
Bedrooms Total: 6
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air, Radiant
Interior Features
Accessibility Features: Level Drive, Main Level Laundry
2 or more H20 Heaters, Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Disposal
Fireplace: Yes
Fireplace Features: 2+ Fireplaces, Gas, Family/Recreation Room Fireplace, Great Room
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Sauna, Wet Bar, Kitchen Island, Steam Shower, 9ft+ Ceilings, Beamed Ceilings
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: Full, Walk-Out Access
Exterior
Exterior Features
Gas Grill, Balcony, Hot Tub Included
Fencing: Fenced
Patio and Porch Features: Patio
Roof: Concrete
Pool Information
Private Pool: Yes
Pool Features: Private
Spa: Yes
Land Information
Road Surface Type: Asphalt
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System, Cul-De-Sac, Wooded, Rock Outcropping, Abuts Public Open Space
Road Frontage Type: Priv Rd up to County Standards
Zoning: PUD
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Legend Ridge
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 7628
Below Grade Finished Area: 3934
Builder Name: David Ellis - Ellis Build
Building Area Total: 7628
Construction Materials: Wood/Frame, Stone, Stucco, Wood Siding
Financial
Tax Information
Parcel Number: R0143765
Tax Annual Amount: 21719
Tax Year: 2020
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,Xcel
Gas: Natural Gas,Xcel
Sewer: District Sewer
Location
HOA Information
Association: Yes
Association Fee: 300
Association Fee Frequency: Quarterly
Association Fee Includes: Common Amenities, Management
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Niwot
Middle or Junior School: Sunset Middle
High School: Niwot
Location Information
Unparsed Address: 6659 Legend Ridge Trl Niwot CO 80503
Street Number: 6659
Street Name: Legend Ridge
Street Suffix: Trl
City: Niwot
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.14849,40.09018
Latitude: 40.09018
Longitude: -105.14849
Public facts
Beds: 6
Baths: 8.0
Sq. Ft.: 11,562
Stories: —
Lot Size: 0.86 acres
Style: Single Family Residential
Year Built: 2001
Year Renovated: 2015
County: Boulder County
APN: R0143765
Home facts updated by county records on Sep 2, 2026
Other
Listing Information
Attribution Contact: 3034493434
Close Price: $4,800,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Tuesday, September 7, 2021
Cumulative Days on Market: 71
Days on Market: 71
Listing Contract Date: Tuesday, June 29, 2021
Modification Timestamp: Thursday, August 1, 2024 12:51 PM
Home Information
Levels: Two
Window Features: Window Coverings
Year Built: 2001
Around this home
Schools
Niwot Elementary School
Public PreK-5 • Assigned • 0.7mi
10/10
Sunset Middle School
Public 6-8 • Assigned • 4.0mi
6/10
Niwot High School
Public 9-12 • Assigned • 0.9mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
5/10 Fire Factor
6% chance of being in a wildfire in next 30 years
3/10 Heat Factor
6 days above 92° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
6/10 Air Factor
10 unhealthy days expected this year, 10 days in 30 years
Provided by First Street
Historical weather
Niwot, CO • 80503
Average low and high temperatures (°F)
43
18
52
26
64
37
64
39
71
46
83
56
90
62
86
59
78
52
69
43
55
31
53
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 6 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$5.12M – $6.20M
Reach more buyers when you sell with Redfin. Save up to $53,901 in fees.3 minutes to get started.