NOT LISTED FOR SALE

6659 Legend Ridge Trail Niwot, CO 80503

Niwot Neighborhood

Estimated Value: $5,088,810 - $5,730,000

6 Beds
9 Baths
11,562 Sq Ft
$470/Sq Ft Est. Value

Last Sold September 07, 2021

Last sale price $4,800,000 $415 Per Sq Ft

Est. 13% increase in value since last sale

Current estimated payment $32,485/month

2 Days on Market

Highlights

  • Private Pool
  • Sauna
  • Mountain View
  • Niwot Elementary School Rated A
  • Open Floorplan
  • Contemporary Architecture

About This Home

As of September 2021

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.

Last Agent to Sell the Property

Tim Goodacre

milehimodern - Boulder Listed on: 06/29/2021

milehimodern - Boulder

Last Buyer's Agent

Elaine Collins

WK Real Estate

WK Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,719

Year Built

  • Built in 2001

Lot Details

  • 0.86 Acre Lot
  • Open Space
  • Cul-De-Sac
  • Fenced
  • Rock Outcropping
  • Sprinkler System
  • Wooded Lot
  • Property is zoned PUD

HOA Fees

  • $100 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Garage Door Opener
  • Driveway Level

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Concrete Roof
  • Wood Siding
  • Stucco
  • Stone

Interior Spaces

  • 11,562 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Beamed Ceilings
  • Cathedral Ceiling
  • Multiple Fireplaces
  • Gas Fireplace
  • Window Treatments
  • Great Room with Fireplace
  • Family Room
  • Dining Room
  • Home Office
  • Recreation Room with Fireplace
  • Sauna
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven or Range
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • Steam Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Balcony
  • Patio
  • Outdoor Gas Grill

Schools

  • Niwot Elementary School
  • Sunset Middle School
  • Niwot High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Radiant Heating System

Community Details

  • Association fees include common amenities, management
  • Built by David Ellis - Ellis Build
  • Legend Ridge Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0143765

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,719

Year Built

Built in 2001

Lot Details

0

HOA Fees

$100 per month

Parking

4

Listing Details

  • Year Built: 2001
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.86
  • Road Frontage Type: Priv Rd up to County Standards
  • Road Surface Type: Asphalt
  • Subdivision Name: Legend Ridge
  • Above Grade Finished Sq Ft: 7628
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 11562
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: Yes
  • Appliances: 2 or more H20 Heaters, Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Disposal
  • Accessibility Features: Level Drive, Main Level Laundry
  • Has Basement: Full, 90%+ Finished Basement, Walk-Out Access
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 3
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 3934
  • Fireplace Features: 2+ Fireplaces, Gas, Family/Recreation Room Fireplace, Great Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: 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
  • Living Area: 11562
  • Window Features: Window Coverings
  • Bedroom Features: Carpet
  • Room Bedroom4 Area: 252
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Room Bedroom3 Area: 289
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 272
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 24
  • Room Family Room Area: 294
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Wood Floor
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Family Room Level: Main
  • Room Bedroom5 Area: 289
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Wood Floor
  • Room Kitchen Area: 336
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 504
  • Room Dining Room Area: 294
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Concrete
  • Builder Name: David Ellis - Ellis Build
  • Fencing: Fenced
  • Lot Features: Lawn Sprinkler System, Cul-De-Sac, Wooded, Rock Outcropping, Abuts Public Open Space
  • Pool Features: Private
  • Pool Private: Yes
  • View: Mountain(s), Foothills View, Plains View
  • Waterfront: No
  • Construction Type: Wood/Frame, Stone, Stucco, Wood Siding
  • Exterior Features: Gas Grill, Balcony, Hot Tub Included
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: Garage Door Opener
  • IRESDS_Garage Sq Ft: 1458
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Xcel
  • Heating: Forced Air, Zoned, Radiant
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: District Sewer
  • Water Source: District Water, Left Hand
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Senior Community: No
  • Association Fee: 300
  • Association Fee Frequency: Quarterly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Niwot
  • HighSchool: Niwot
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Sunset Middle

Lot Info

  • Zoning: PUD
  • Lot Size Sq Ft: 37621
  • Parcel #: R0143765
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2020
  • Tax Annual Amount: 21719

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 29, 2021
Closed on
Sep 3, 2021
Sold by
Michael David Shehan Revocable Trust
Bought by
Della Clay and Cava Mia Della
Seller's Agent
Tim Goodacre
milehimodern - Boulder
Buyer's Agent
Elaine Collins
WK Real Estate
List Price
$4,800,000
Sold Price
$4,800,000
Current Estimated Value
$5,438,953

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$638,953
Avg. Annual Appreciation
3.17%
Original Mortgage
$3,000,000
Outstanding Balance
$2,729,773
Interest Rate
2.5%
Mortgage Type
New Conventional
Estimated Equity
$2,709,180

Purchase Details

Listed on
Jan 15, 2014
Closed on
Nov 7, 2014
Sold by
Giesbrecht Franklin B and Giesbrecht Serena
Bought by
Michael David Shehan Revocable Trust and Krisie Moss Shehan Revocable Trust
Seller's Agent
Bill Goodacre
milehimodern - Boulder
Buyer's Agent
Tim Goodacre
milehimodern - Boulder
List Price
$2,495,000
Sold Price
$2,350,000
Premium/Discount to List
-$145,000
-5.81%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.01%

Purchase Details

Closed on
Nov 18, 2005
Sold by
List Donna L
Bought by
Giesbrecht Franklin B

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,850,000
Interest Rate
5.87%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Oct 7, 2004
Sold by
List Donald
Bought by
List Donna L

Purchase Details

Closed on
Aug 6, 2003
Sold by
Franklund Scott
Bought by
List Donald and List Donna L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
4.62%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jul 22, 2003
Sold by
Showcase Master Builders Inc
Bought by
List Donald

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
4.62%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 21, 2003
Sold by
Showcase Master Builders Inc
Bought by
List Don and List Donna

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,525,000
Interest Rate
5.15%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Sep 12, 2002
Sold by
R Loran Construction Inc
Bought by
Showcase Master Builders Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,875,000
Interest Rate
6.5%
Mortgage Type
Construction

Purchase Details

Closed on
Jan 31, 2000
Sold by
Legend Ridge Ltd Partnership
Bought by
R Loran Construction Inc and Showcase Builders Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$222,750
Interest Rate
9.5%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Della Clay $4,800,000 Heritage Title Co
Michael David Shehan Revocable Trust $2,350,000 Heritage Title
Giesbrecht Franklin B $2,850,000 --
List Donna L -- --
List Donald -- Land Title Guarantee Company
List Donald $2,525,000 Land Title Guarantee Company
List Don $2,525,000 --
Showcase Master Builders Inc -- --
R Loran Construction Inc $297,000 Colorado National Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Della Clay $3,000,000
Previous Owner Giesbrecht Franklin B $2,892,500
Previous Owner Giesbrecht Franklin B $2,869,000
Previous Owner Giesbrecht Franklin B $2,850,000
Previous Owner List Donald $1,000,000
Previous Owner List Don $2,525,000
Previous Owner Showcase Master Builders Inc $85,000
Previous Owner Showcase Master Builders Inc $1,875,000
Previous Owner R Loran Construction Inc $1,630,800
Previous Owner R Loran Construction Inc $222,750
Closed List Donald $500,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/07/2021 12/07/21 Off Market $4,800,000 -- --
09/07/2021 09/07/21 Sold $4,800,000 0.0% $415 / Sq Ft
06/29/2021 06/29/21 For Sale $4,800,000 +104.3% $415 / Sq Ft
01/28/2019 01/28/19 Off Market $2,350,000 -- --
11/07/2014 11/07/14 Sold $2,350,000 -5.8% $203 / Sq Ft
10/08/2014 10/08/14 Pending -- -- --
01/15/2014 01/15/14 For Sale $2,495,000 -- $216 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $35,748 $337,732 $39,013 $298,719
2024 $35,748 $337,732 $39,013 $298,719
2023 $35,273 $364,527 $36,106 $332,106
2022 $25,219 $248,685 $32,498 $216,187
2021 $25,554 $255,841 $33,433 $222,408
2020 $21,719 $218,033 $35,679 $182,354
2019 $21,654 $218,033 $35,679 $182,354
2018 $22,161 $224,950 $34,848 $190,102
2017 $20,808 $248,694 $38,526 $210,168
2016 $23,028 $187,060 $39,800 $147,260
2015 $16,831 $197,782 $30,964 $166,818
2014 $18,256 $197,782 $30,964 $166,818
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 944564

IRES MLS

APN: 1315320-05-002