Much sought after Heron Lakes Villa with 200k in upgrades after the closing. This home backs to a lake and holes 2 and 3 at TPC Colorado. Amazing views right as you walk in greet you from the Kitchen, great room, ding and primary rooms. Large kitchen with gas cooktop, dual ovens, and large island. Plenty of room in the primary bedroom with 2 custom finished closets and large shower. Too many upgrades to list but a few include a new fireplace enlarging the great room area, custom closets inside the primary bedroom, electric window shades, casement trim around all windows and a custom barn door built in cabinets and wine fridge in the study. Perfect sized home for weekend getaways, summers, or full time with a blank canvas unfinished garden level basement. Ownership in Heron Lakes gets you multiple restaurants, workout room, resort style pool, access to Lonetree reservoir for boating, kayaking, paddleboards, and a discounted membership to TPC Colorado.
Single-familyProperty Type
2024Year Built
5,828 sq ftLot Size
$245Price/Sq.Ft.
$300/moHOA Dues
2 car garageParking
Listed by David Johnson• LIV Sotheby's Intl Realty D
Contact: 9702130648
Bought with Kathleen Haas• Colorado Realty 4 Less, LLC
Est. $3,314 per month, based on comparable rentals
Sale and tax history for 2978 Newfound Lake Rd
Sale History
Tax History
Date
Event
Price
IRES as Distributed by MLS Grid #1060485
Oct 9, 2026
Sold
$980,000
$245/sq ft
Aug 14, 2026
Contingent
—
May 30, 2026
Listed
$1,075,000
$269/sq ft
May 29, 2026
Coming Soon
$1,075,000
$269/sq ft
IRES as Distributed by MLS Grid #9567014
May 7, 2025
Sold
$899,995
$225/sq ft
Mar 25, 2025
Pending
—
Feb 17, 2025
Listed
$900,000
$225/sq ft
+27
IRES as Distributed by MLS Grid #1027489
May 7, 2025
Sold
$899,995
$225/sq ft
Mar 25, 2025
Pending
—
Feb 10, 2025
Listed
$900,000
$225/sq ft
+27
Public Records
May 20, 2024
Sold
$1,737,238
$434/sq ft
Public Records
May 26, 2022
Sold
$14,525,000
$3,629/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$12,653 (+250.1%)
$30,463 + $39,688
$70,151
2024
$3,614 (+5.5%)
$30,463 + $39,688
$70,151
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
2
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
5,828 Sq. Ft.
Year renovated
2024
Sq. Ft.
2,011
Year built
2024
Style
Single Family Residential
County
Larimer County
APN
R1671690
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 22, 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
Property details
Parking
Parking Information
Garage Type: Attached
Parking Features: Attached
Garage Spaces: 2
Interior
Virtual Tour
Bedroom Information
# of Bedrooms: 3
All Bedrooms Conform: 1
Bathroom Information
# of Full Baths (Total): 1
# of Three Quarter Baths (Total): 1
# of Full Baths (Main): 1
# of Three Quarters Baths (Main): 1
# of Baths Rough In: 1
Study Information
Has Study: 0
Family Room Information
Has Family Room: 0
Basement Information
Basement Features: Full, Unfinished
Fireplace Information
Fireplace Features: Gas
Heating & Cooling
Heating Information: Forced Air
Cooling Information: Central Air
Interior Features
Interior Features: Eat-in Kitchen, Open Floorplan, Kitchen Island
Window Features: Window Coverings
Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
Flooring: Wood
Exterior
Building Information
Construction Materials: Frame
Roof: Tile
Exterior Features
Exterior Features: Sprinkler System, Balcony
Fencing: Partial
Property Information
Levels: One
Has Improvements: No
Sq. Ft. Main Floor: 2001
New Construction Status: Not New, Previously Owned
Property Type: Residential
Property Sub Type: Single Family Residence
Above Grade Finished Area: 2,001
Zoning: RES
Land Information
Possible Use: Single Family
Lot Information
Flood Plain: Minimal Flood or C Rating
Lot Features: Rolling Lot, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet
Road Surface Type: Asphalt
Road Frontage Type: City Street
Financial
Tax Information
Tax Annual Amount: $12,653
Tax Year: 2025
Utilities
Utility Information
Water Source: Public
Has Water Rights: No
Is Water Meter Installed: Yes
Sewer: Public Sewer
Utilities: Natural Gas Available, Electricity Available, Cable Available
Gas: XCEL
Trash: Step Up Disposals
Location
HOA Information
Association Fee YN: Yes
Association Transfer Fee: Yes
Association Reserve: Yes
Association Fee2 YN: No
Association Transfer Fee2: No
Has HOA
Association Fee: $300
Association Fee Frequency: Monthly
Association Fee Includes: Common Amenities, Snow Removal, Maintenance Grounds, Management, Utilities
School Information
Elementary School: Carrie Martin
Middle Or Junior High School: Bill Reed
High School: Thompson Valley
High School District: Thompson R2-J
Community Information
Community Features: Clubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s), Gated
Public facts
Beds: 2
Baths: 2.0
Sq. Ft.: 2,011
Stories: 1.0
Lot Size: 5,828 square feet
Style: Single Family Residential
Year Built: 2024
Year Renovated: 2024
County: Larimer County
APN: R1671690
Home facts updated by county records on Oct 22, 2026
Other
Home Information
Builder Name: Toll Brothers
Around this home
Schools
Carrie Martin Elementary School
Public PreK-5 • Assigned • 0.8mi
8/10
Bill Reed Middle School
Public 6-8 • Assigned • 3.9mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.2mi
4/10
Provided by GreatSchools
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.2 hrs
6.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.00M – $1.21M
Reach more buyers when you sell with Redfin. Plus, you'll save $10,525 in fees.