A lock-and-leave retreat with lake views. Wake up to open fairways, a tranquil lake and the Front Range on the horizon in this 2024 Toll Brothers Lory plan, set right on the course at TPC Colorado in Heron Lakes. Built for easy, resort-style living, it puts the essentials on the main floor. The private primary suite opens to gorgeous lake views, and the flex room sits behind French doors with mountain views, an inspiring spot for a home office or reading room. A powder room and laundry/mud room round out the main level. Two bedrooms, a full bath and a loft upstairs give guests their own space. The great room centers on a gas fireplace with floor-to-ceiling Saluzzo stacked stone and a black-stained mantel, all framed by golf course and lake views. The dining area was expanded 10 feet and opens to a covered deck, a natural spot for morning coffee or sunset entertaining. The kitchen pairs stacked cabinetry, a contrasting island and Vallejo Gold quartz with a herringbone backsplash that runs to the ceiling, a white cast-iron farmhouse sink and KitchenAid appliances: a 36" five-burner gas cooktop, combination microwave/wall oven, canopy hood and counter-depth French door refrigerator. The primary bath feels like a spa, with a freestanding soaking tub, a frameless glass shower and dual sinks. Matte black fixtures, 30 added recessed lights and custom closets complete the finishes. The full walkout basement has 1' higher ceilings, great views and direct access to a patio, plus a bath rough-in, so there’s plenty of room to grow. It’s turnkey and can be sold furnished! Low-maintenance and with a fenced yard, 3-car garage, tankless water heater and impact Resistent roof. The HOA covers grounds care and snow removal, so you can arrive, unwind and leave without a to-do list. You’ll have a clubhouse, pool, fitness center, trails and dining close by. Golf Membership available but not mandatory. DIA Airport & the Rocky Mountains less than an hour away.
Single-familyProperty Type
2024Year Built
5,680 sq ftLot Size
$281Price/Sq.Ft.
$125/moHOA Dues
3 car garageParking
Listed by Kristen Danzig• JPAR Modern Real Estate
Listed by Osmirelly Kidwell• Coldwell Banker Realty 24
A lock-and-leave retreat with lake views. Wake up to open fairways, a tranquil lake and the Front Range on the horizon in this 2024 Toll Brothers Lory plan, set right on the course at TPC Colorado in Heron Lakes. Built for easy, resort-style living, it puts the essentials on the main floor. The private primary suite opens to gorgeous lake views, and the flex room sits behind French doors with mountain views, an inspiring spot for a home office or reading room. A powder room and laundry/mud room round out the main level. Two bedrooms, a full bath and a loft upstairs give guests their own space. The great room centers on a gas fireplace with floor-to-ceiling Saluzzo stacked stone and a black-stained mantel, all framed by golf course and lake views. The dining area was expanded 10 feet and opens to a covered deck, a natural spot for morning coffee or sunset entertaining. The kitchen pairs stacked cabinetry, a contrasting island and Vallejo Gold quartz with a herringbone backsplash that runs to the ceiling, a white cast-iron farmhouse sink and KitchenAid appliances: a 36" five-burner gas cooktop, combination microwave/wall oven, canopy hood and counter-depth French door refrigerator. The primary bath feels like a spa, with a freestanding soaking tub, a frameless glass shower and dual sinks. Matte black fixtures, 30 added recessed lights and custom closets complete the finishes. The full walkout basement has 1' higher ceilings, great views and direct access to a patio, plus a bath rough-in, so there's plenty of room to grow. It's turnkey and can be sold furnished! Low-maintenance and with a fenced yard, 3-car garage, tankless water heater and impact Resistent roof. The HOA covers grounds care and snow removal, so you can arrive, unwind and leave without a to-do list. You'll have a clubhouse, pool, fitness center, trails and dining close by. Golf Membership available but not mandatory. DIA Airport & the Rocky Mountains less than an hour away.
Public Records
Nov 19, 2024
Sold
$1,963,835
$432/sq ft
Public Records
May 26, 2022
Sold
$14,525,000
$3,197/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,111 (+69.1%)
$30,463 + $3,419
$33,882
2024
$3,614 (+5.5%)
$30,463 + $3,419
$33,882
2023
$3,425 (+520.2%)
$20,618
2022
$552 (+2.2%)
$20,032
2021
$540 (+99.5%)
$3,306
2020
$271
$3,306
Public record
Public record
Zoning
Beds
3
Baths
2.5
Stories
1.5
Lot width
—
Lot depth
—
Lot size
5,680 Sq. Ft.
Year renovated
2024
Finished Sq. Ft.
2,687
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,687
Year built
2024
Style
Single Family Residential
County
Larimer County
APN
R1671700
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 21, 2026.
R2
Limited Multi-Family District
The R2 District provides for the development of areas containing low to moderate density with both single and multi-family residential uses.
Permitted uses
Include but are not limited to:
Garden center
Housing-Group
Housing-Single unit
Housing-Multiple units
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
4/10 Fire Factor
2% 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
91
62
86
59
79
52
69
42
55
30
53
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 1% for direct sun exposure in Berthoud. 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 2878 Newfound Lake Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $729,000 and $1,575,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $729K to $1.6M.