Public Remarks: Located within the Rookery, last available WATERFRONT lot within the first phase. Build your own dock to access Lonetree Reservoir! Heron Lakes at TPC Colorado is unlike any other community! Stunning views of the Front Range paired with the abundant green spaces of the championship-level golf course overlooking 3 large bodies of water! Amenities include access to the 60,000 sq. ft. Clubhouse (Phase 1 completed now!), future resort-style pool, future Lake Club, and much more!
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
6
Baths
5.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.37 Acres
Year renovated
2021
Sq. Ft.
6,905
Year built
2021
Style
Single Family Residential
County
Larimer County
APN
R1675119
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 21, 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
Property details
Exterior
Exterior Features
Lighting
Land Information
Road Surface Type: Paved
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Sloped, Near Golf Course
Road Frontage Type: Priv Rd up to County Standards
Zoning: R1
Property Information
Property Type: Land
Property Sub Type: Unimproved Land
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Heron Lakes Third Filing
MLS Area Major: Loveland/Berthoud
Building Information
Development Status: Building Permit Ready
Financial
Tax Information
Tax Annual Amount: 721.29
Tax Year: 2017
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric
Gas: Natural Gas
Sewer: City Sewer
Location
HOA Information
Association: No
Association Fee Includes: Security, Management
Community Features: Clubhouse, Pool, Fitness Center, Park
School Information
High School District: Thompson R2-J
Elementary School: Carrie Martin
Middle or Junior School: Bill Reed
High School: Thompson Valley
Location Information
Directions: From Highway 287 and Berthoud Parkway, head north on Berthoud Parkway and then west onto Grand Market Avenue and take a left onto TPC Parkway to arrive at the TPC Colorado Clubhouse.
Unparsed Address: 2737 Blue Water Rd Berthoud CO 80513
Street Number: 2737
Street Name: Blue Water
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.118693,40.337759
Latitude: 40.337759
Longitude: -105.118693
Public facts
Beds: 6
Baths: 5.5
Sq. Ft.: 6,905
Stories: 1.0
Lot Size: 0.37 acres
Style: Single Family Residential
Year Built: 2021
Year Renovated: 2021
County: Larimer County
APN: R1675119
Home facts updated by county records on Oct 21, 2026
Other
Listing Information
Attribution Contact: 9702049393
Close Price: $625,000
Photos Count: 6
Possible Use: Single Family
Special Listing Conditions: Partnership
Standard Status: Closed
Listing Date Information
Close Date: Monday, January 20, 2020
Cumulative Days on Market: 446
Days on Market: 446
Listing Contract Date: Thursday, November 1, 2018
Modification Timestamp: Wednesday, July 31, 2024 1:54 AM
Around this home
Schools
Carrie Martin Elementary School
Public PreK-5 • Assigned • 1.4mi
8/10
Bill Reed Middle School
Public 6-8 • Assigned • 4.4mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.6mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
1% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 16 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
In this area, properties receive around 10.5 hours in
June and 5.9 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
5.9 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.02M – $2.44M
Reach more buyers when you sell with Redfin. Save up to $21,255 in fees.3 minutes to get started.