Stunning walkout ranch home for rent on the luxurious TPC Golf Course. Backing up to full golf course views, serene pond/water views as well as breathtaking mountain views. Home is patio style with open floor plan. Includes 3 bedrooms and 2 bathrooms, living area with a tile surround fireplace, kitchen with a large center island, upgraded custom cabinets, quartz countertops, and beautiful tile extending to the ceiling above the gas range. Built-in speakers and surround sound installed in the living area, primary bedroom, and deck. Dining area leads to an 8-foot-tall slider that opens 8+ feet wide to your private deck. The oversized primary bedroom includes two custom walk in closets, soaking tub and a beautiful tile shower. Large covered patio and very large walkout basement, unfinished but easily used for office space, game room, extra storage and/or workout area. The TPC at Heron Lakes is one of Colorado's premier neighborhoods, offering over 10+ miles of trails, several lakes, and access to Lonetree Reservoir for fishing, boating, paddleboarding, and more. **Included: golf access, main community clubhouse, resident only private club, private health club and gym, pool with a swim-up bar and multiple restaurants with resident discounts.
Stunning walkout ranch home for rent on the luxurious TPC Golf Course. Backing up to full golf course views, serene pond/water views as well as breathtaking mountain views. Home is patio style with open floor plan. Includes 3 bedrooms and 2 bathrooms, living area with a tile surround fireplace, kitchen with a large center island, upgraded custom cabinets, quartz countertops, and beautiful tile extending to the ceiling above the gas range. Built-in speakers and surround sound installed in the living area, primary bedroom, and deck. Dining area leads to an 8-foot-tall slider that opens 8+ feet wide to your private deck. The oversized primary bedroom includes two custom walk in closets, soaking tub and a beautiful tile shower. Large covered patio and very large walkout basement, unfinished but easily used for office space, game room, extra storage and/or workout area. The TPC at Heron Lakes is one of Colorado's premier neighborhoods, offering over 10+ miles of trails, several lakes, and access to Lonetree Reservoir for fishing, boating, paddleboarding, and more. **Included: golf access, main community clubhouse, resident only private club, private health club and gym, pool with a swim-up bar and multiple restaurants with resident discounts.
Avail #2
Sep 30, 2026
Rental Removed
$4,850
$1/sq ft
Sep 21, 2026
Listed for Rent
$4,850
$1/sq ft
REDFIN #1
Sep 20, 2026
Rental Removed
$4,850
$1/sq ft
Jul 25, 2026
Listed for Rent
$4,850
$1/sq ft
REColorado as Distributed by MLS Grid #3552387
Jul 25, 2026
Listing Removed
—
May 20, 2026
Price Changed
$1,060,000
$249/sq ft
May 4, 2026
Listed
$1,065,000
$250/sq ft
IRES as Distributed by MLS Grid #1042298
Jul 25, 2026
Listing Removed
—
May 20, 2026
Price Changed
$1,060,000
$249/sq ft
Apr 21, 2026
Price Changed
$1,065,000
$250/sq ft
Apr 14, 2026
Price Changed
$1,070,000
$251/sq ft
Feb 5, 2026
Listing Removed
—
Jan 5, 2026
Listing Removed
—
Nov 1, 2025
Listing Removed
—
Oct 14, 2025
Price Changed
$1,075,000
$252/sq ft
Oct 3, 2025
Price Changed
$1,090,000
$256/sq ft
Oct 1, 2025
Listing Removed
—
Aug 27, 2025
Listed
$1,095,000
$257/sq ft
REColorado as Distributed by MLS Grid #4746147
Nov 1, 2025
Listing Removed
—
Oct 14, 2025
Price Changed
$1,075,000
$252/sq ft
Oct 3, 2025
Listed
$1,090,000
$256/sq ft
IRES as Distributed by MLS Grid #1032089
Aug 27, 2025
Listing Removed
—
Aug 7, 2025
Price Changed
$1,100,000
$258/sq ft
May 29, 2025
Price Changed
$1,110,000
$260/sq ft
Apr 28, 2025
Price Changed
$1,130,000
$265/sq ft
Apr 24, 2025
Listed
$1,135,000
$266/sq ft
REColorado as Distributed by MLS Grid #7172692
Sep 1, 2025
Listing Removed
—
Aug 28, 2025
Price Changed
$1,095,000
$257/sq ft
Aug 27, 2025
Listing Removed
—
Aug 7, 2025
Price Changed
$1,100,000
$258/sq ft
May 29, 2025
Price Changed
$1,110,000
$260/sq ft
Apr 28, 2025
Price Changed
$1,130,000
$265/sq ft
Apr 24, 2025
Price Changed
$1,135,000
$266/sq ft
Dec 30, 2024
Price Changed
$1,140,000
$267/sq ft
Nov 14, 2024
Price Changed
$1,155,000
$271/sq ft
Nov 7, 2024
Price Changed
$1,175,000
$276/sq ft
Oct 21, 2024
Listed
$1,195,000
$280/sq ft
REColorado as Distributed by MLS Grid #IR1020954
Apr 24, 2025
Listing Removed
—
IRES as Distributed by MLS Grid #1020954
Apr 24, 2025
Listing Removed
—
Dec 30, 2024
Price Changed
$1,140,000
$267/sq ft
Nov 14, 2024
Price Changed
$1,155,000
$271/sq ft
Nov 7, 2024
Price Changed
$1,175,000
$276/sq ft
Oct 18, 2024
Listed
$1,195,000
$280/sq ft
Public Records
Feb 20, 2024
Sold
$2,029,925
$476/sq ft
Public Records
May 26, 2022
Sold
$14,525,000
$3,408/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$13,317 (+268.5%)
$30,463 + $43,369
$73,832
2024
$3,614 (+5.5%)
$30,463 + $43,369
$73,832
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,500 Sq. Ft.
Year renovated
2024
Finished Sq. Ft.
2,119
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,119
Year built
2024
Style
Single Family Residential
County
Larimer County
APN
R1671686
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.4 hrs
6.5 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 3010 Newfound Lake Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $770,000 and $1,180,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $770K to $1.2M.