Backing breathtaking water and mountain views, this stunning custom home sits on a nearly 17,000 sq ft lot in Northern Colorado's premier TPC Heron Lakes community, and it is a must-see! Bordering open space to the west and stepping directly onto the community trail, the setting alone is remarkable. The home itself takes it further. Soaring beamed ceilings, an open floor plan, and large windows frame your views at every turn. The gourmet kitchen impresses with dramatic granite, chef's appliances, a large pantry, and an oversized island built for gathering. The great room's floor-to-ceiling fireplace commands attention, while the luxurious main-floor primary retreat offers private deck access, heated floors, a soaking tub, and a spa-like bath with trough sink and leaded glass windows. Outside, two upper decks, one with an 8-foot gas fireplace, one with a built-in grilling station, make Colorado's outdoor lifestyle effortless! Add professional landscaping, two fountains, a custom fire pit, an enclosed dog run with turf, a hot Tub, and the backyard rivals any resort!! The finished walk-out basement with 10-foot ceilings brings even more to the table: a home theater, granite bar with seating for six, glass-enclosed wine room, two ensuite bedrooms, stained concrete floors, and a hidden safe. Captivating and dramatic, this home truly is an experience all its own.TPC Heron Lakes delivers the lifestyle to match: award-winning golf, a resort-style pool, lake recreation, miles of trails, and a world-class clubhouse and gym, all with convenient access to Denver, Boulder, and DIA. Come live a life of luxury!
Experience resort-style living every day in this show-stopping custom residence on a nearly 17,000 sq ft lot with panoramic views of the mountains. Bordering open space to the north and backing to the community trail, this property delivers privacy and convenience plus seasonal water views. Outside delivers the ultimate Colorado lifestyle w/ professionally designed landscaping, two tranquil fountains, a custom-built fire pit, and multiple seating areas to take in Colorado's stunning sunsets. Entertain with ease on two expansive upper decks-one featuring an 8-foot gas fireplace for uninterrupted mountain gazing, the other equipped with a built-in grilling station. A fully enclosed dog run w/ its own turf lawn & bonus -Hot tub included! Inside, luxury lives in the details. The chef's kitchen wows, dramatic granite backsplashes, an oversized island, a designer hood & lighted glass cabinetry. The great room features soaring beamed ceilings, a floor-to-ceiling fireplace w/ wood & tile accents and a dramatic custom antler chandelier in the entry. Retreat to the main floor primary suite w/ private deck access and a spa-like bathroom featuring a soaking tub, custom wood vanity w/ trough sink and handsome leaded glass windows. Even the powder room is a work of art, w/ a floating vanity, backlit shelving, and a sculptural vessel sink. Downstairs, the walk-out basement continues to showcase designer talent w/ stained concrete epoxy floors, two more ensuite bedrooms, a home theater, a massive granite bar w/ seating for six, a glass-enclosed wine room, and even a hidden safe. And yes-there are still mountain views from every window. Set in Northern Colorado's premier TPC Heron Lakes community-home to an award-winning golf course, miles of trails, lake recreation, and a world-class clubhouse and fitness center-you'll enjoy convenient access to DIA, Boulder, and Denver. Every corner has been curated, every finish considered. This is more than a home-it's a lifestyle.
IRES as Distributed by MLS Grid #982138
Feb 16, 2023
Sold
$2,513,232
$485/sq ft
Feb 16, 2023
Listed
$2,400,000
$463/sq ft
IRES as Distributed by MLS Grid #7676383
Feb 16, 2023
Sold
$2,400,000
$463/sq ft
Feb 16, 2023
Listed
$2,400,000
$463/sq ft
IRES as Distributed by MLS Grid #933476
Mar 10, 2021
Listing Removed
—
Feb 15, 2021
Listed
$1,550,000
$299/sq ft
IRES as Distributed by MLS Grid #916256
Dec 4, 2020
Sold
$400,000
$77/sq ft
Oct 10, 2020
Contingent
—
Jun 25, 2020
Listed
$400,000
$77/sq ft
Public Records
Aug 1, 2019
Sold
$15,000,000
$2,892/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$16,259 (+16.7%)
$40,269 + $49,869
$90,138
2024
$13,929 (+21.9%)
$40,269 + $49,869
$90,138
2023
$11,429 (+178.1%)
$32,656 + $50,498
$83,154
2022
$4,110 (−33.8%)
$32,656 + $37,875
$70,531
2021
$6,205 (+3.2%)
$16,819 + $7,784
$24,603
2020
$6,016 (+444.9%)
$37,961
2019
$1,104 (+28.0%)
$35,757
2018
$862 (+19.5%)
$6,670
2017
$721 (+11,921.5%)
$5,278
2016
$6
$5,278
Public record
Public record
Zoning
Beds
4
Baths
5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.39 Acres
Year renovated
2021
Finished Sq. Ft.
4,583
Unfinished Sq. Ft.
—
Total Sq. Ft.
4,583
Year built
2021
Style
Single Family Residential
County
Larimer County
APN
R1661586
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 30, 2026.
R1
Single Family District
The R1 District provides for the development of low to moderate density single family residential dwellings.
Permitted uses
Include but are not limited to:
Garden center
Infrastructure
Educational/school
Museum / gallery
Park & open space
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
2/10 Fire Factor
0.00% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 18 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
6 unhealthy days expected this year, 7 days in 30 years
Provided by First Street
Historical weather
Berthoud, CO • 80513
Average low and high temperatures (°F)
42
17
52
23
65
36
65
38
72
46
85
56
89
61
86
59
82
53
69
42
55
30
53
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
99/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in the zip code. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.3 hrs
6.4 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 2659 Heron Lakes Pkwy
$2,612,273
$138K under list price of $2.75M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $999K to $2.8M.