Date
Details
Price
Change
Source
7/31/2026
Listed
$3,500,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/43
$3,500,000 New to Website
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/43
Property Description
Stunning, one-of-a-kind modern luxury retreat perfectly positioned on the peninsula in Heron Lakes at TPC Colorado, where dramatic floor-to-ceiling windows frame breathtaking panoramic views. Meticulously designed with exceptional craftsmanship and timeless finishes, this home features zero-threshold living, imported Spanish porcelain flooring throughout, and a sleek, sophisticated aesthetic. The thoughtfully designed main level offers two bedrooms, a private den, a cozy breakfast nook, spacious living and dining areas, and a chef's kitchen equipped with premium Gaggenau appliances, induction range and a Fisher & Paykel CoolDrawer. Additional highlights include a partially heated driveway and a private elevator providing effortless access to the walkout lower level. Designed for both entertaining and everyday luxury, the lower level features a golf simulator, wet bar, expansive family room, two additional bedroom suites, a private office, and a powder bath, seamlessly extending to the outdoor living spaces. TPC Colorado offers resort-style living with a golf course, clubhouse, second restaurant, pool, state-of-the-art-gym, lakes and walking trails.
Full Property Details
Full Property Details for 2467 Heron Lakes Pkwy
General
- Price: $3,500,000
- Taxes: $18,095 (2025)
- Status: Active
- Type: Single Family
- Source: IRES
- MLS ID: 1065460
- Updated: 7/31/2026
- Added to Site: 2 day(s) ago
Interior
- Interior Features: Eat-In Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Washer/Dryer Hookup, Skylights, Kitchen Island, Two Primary Suites, High Ceilings
- Fireplace: Yes
- Fireplace(s): Two or More
- Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave
Rooms
Bathrooms
- Total Bathrooms: 6
- 3/4 Bathrooms: 4
- Half Bathrooms: 2
Bedrooms
- Total Bedrooms: 4
Exterior
- Exterior Features: Sprinkler System, Balcony
- Porch/Patio/Deck: Patio, Deck
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Parking Features: Attached
- Garage Description: Attached
Location
- Area: Berthoud
- County: Larimer
- Subdivision: Heron Lakes 3rd Filing
School Information
- School District: Thompson R2-J
- Elementary School: Berthoud
- Middle School: Berthoud Jr/Sr
- High School: Berthoud
Community
- Assoc. Fees Include: Management
Heating & Cooling
- Cooling Type: Central Air, Ceiling Fan(s)
- Heating Type: Forced Air, Zoned
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: District
- Utility Description: Natural Gas Available, Electricity Available, High-Speed Internet Available
Structural Information
- Architectural Style: Contemporary
- Builder: Masterpiece Custom Build
- Construction: Stone, Stucco
- Exterior Const.: Stone, Stucco
- Basement: Yes
- Basement Desc.: Full, Partially Finished, Walk-Out Access
- Roof: Tile, Rubber
- Windows: Skylight(s), Window Coverings
- Square Feet: 6,767
- Sq. Ft. Source: Plans
- Living Area: 5,568 Sq. Ft.
- Year Built: 2021
Lot Features
- Property View: Mountain(s), Hills
- Mountain views: Yes
- Lot Size (Acres): 0.28
- Lot Size (Sq. Ft.): 12,109
- Fence: Yes
- Lot Features: Cul-De-Sac, Deciduous Trees, Native Grass, Golf Course Neighborhood, Abuts Pond/Lake, House Faces East, Paved
- Potential Use: Single-Family
- Zoning: RES
- Fencing (Description): Fenced
Green Features
- Energy Efficient: Southern Exposure
Financial Considerations
- Tax Amount: $18,095
- Tax Year: 2025
- Terms: Cash, Conventional
Disclosures and Reports
- Special Conditions: Private Owner
- Exclusions: Eames chair in Den, "Orbiter" light in Den, Piano, bear statue, 2 exterior porch chairs and table, carved chest in primary, white duck in primary, wood stool in 2nd primary, black desk chair in lower level office, and artwork.
- Property ID: R1661572
Listed by Group Centerra (970) 613-0700
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 2467 Heron Lakes Pkwy —
Group Centerra
970-613-0700
9702272747
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 2467 Heron Lakes Pkwy
School District:Thompson School District R-2j
| Name | Grades | Distance |
|---|---|---|
Berthoud Elementary School 560 Bunyan Avenue, Berthoud, CO 80513 | PK-5 | 2.2 mi |
Turner Middle School 950 Massachusetts Avenue, Berthoud, CO 80513 | 6-8 | 2.3 mi |
Berthoud High School 850 Spartan Avenue, Berthoud, CO 80513 | 9-12 | 2.8 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2467 Heron Lakes Pkwy
Tax History
Tax History for 2467 Heron Lakes Pkwy
Year
Property Taxes
Change
Tax Assessment
Change
2025
$18,095
16%
$100,319
8%
2024
$15,569
3%
$92,514
—
2023
$15,188
270%
$92,514
268%
2021
$4,105
-75%
$25,111
-74%
2022
$16,401
300%
$98,183
175%
2021
$4,105
272%
$35,757
436%
2019
$1,104
28%
$6,670
26%
2018
$862
20%
$5,278
—
2017
$721
11917%
$5,278
52680%
2016
$6
—
$10
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 2467 Heron Lakes Pkwy
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 5Beds
- 6Total Baths
- 7,158Sq. Ft.
- MLS # 1056389
Listed by eXp Realty LLC
- Single Family
- Active
- 5Beds
- 5Total Baths
- 6,655Sq. Ft.
- MLS # 1040214
Listed by Group Harmony
- Single Family
- Active
- 4Beds
- 5Total Baths
- 5,666Sq. Ft.
- MLS # 1022299
Listed by C3 Real Estate Solutions, LLC
- Single Family
- Active
- 3Beds
- 4Total Baths
- 7,772Sq. Ft.
- MLS # 2154403
Listed by Engel & Volkers Denver
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Mobile Home
- Active
- Updated 1 day ago
- 3Beds
- 2Total Baths
- 2,052Sq. Ft.
- MLS # 1065462
Listed by The Key Group (970) 667-2707
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 3Total Baths
- 2,440Sq. Ft.
- MLS # 1065448
Listed by Marie Warren (303) 884-2111
- Single Family
- Active
- Updated 21 hours ago
- 2Beds
- 1Total Bath
- 768Sq. Ft.
- MLS # 1065573
- Single Family
- Active
- Updated 1 day ago
- 5Beds
- 3Total Baths
- 4,340Sq. Ft.
- MLS # 1065435
Listed by Glen Marketing
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 3Total Baths
- 2,847Sq. Ft.
- MLS # 1063115
Listed by Vicky Rath (970) 481-4160
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 4Total Baths
- 3,721Sq. Ft.
- MLS # 4522718
Listed by AK Riley (720) 289-2929
- Single Family
- Active
- Updated 12 hours ago
- 3Beds
- 2Total Baths
- 1,396Sq. Ft.
- MLS # 1059240
Listed by Katie Hinkle (970) 290-6394
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 3Total Baths
- 1,686Sq. Ft.
- MLS # 1061587
Listed by Group Harmony
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 5Beds
- 7Total Baths
- 7,146Sq. Ft.
- MLS # 1050119
Listed and Sold by LIV Sotheby's Intl Realty D
- Single Family
- Closed
- 5Beds
- 4Total Baths
- 5,250Sq. Ft.
- MLS # 1058219
Listed by Kentwood RE Northern Prop Llc
Sold by Group Centerra
Sold by Group Centerra
- Single Family
- Closed
- 3Beds
- 4Total Baths
- 5,184Sq. Ft.
- MLS # 1038736
Listed by WK Real Estate Longmont and WK Real Estate
Sold by KL Realty
Sold by KL Realty
- Single Family
- Closed
- 4Beds
- 4Total Baths
- 5,417Sq. Ft.
- MLS # 1038814
Listed by Kentwood Real Estate Boulder Valley
2467 Heron Lakes Pkwy, Berthoud, CO 80513 (MLS# 1065460) is a Single Family property with 4 bedrooms, 0 full bathrooms and 6 partial bathrooms. 2467 Heron Lakes Pkwy is currently listed for $3,500,000 and was received on July 31, 2026. Want to learn more about 2467 Heron Lakes Pkwy? Do you have questions about finding other Single Family real estate for sale in Berthoud? You can browse all Berthoud real estate or contact a Coldwell Banker agent to request more information.