EXQUISITE custom-built estate with breathtaking views of the Rocky Mountains, Lonetree Lake, and the renowned TPC Golf Course. This is a rare opportunity to live your Colorado dream in a masterfully designed home. Enjoy the stunning scenery from both main level primary suites, dining room, kitchen, and great room. Unwind on the expansive covered deck, perfect for watching sunsets and thunderstorms, or for exceptional entertaining. There is no shortage of function here with TWO main level primary suites, and flexible use rooms. Both primary suites include walk-in showers for easy accessibility. The set up could be perfect for multigenerational living, or even live-in care, and if that wasn't enough, the walk-out basement offers an additional kitchenette, game room, and full bathroom with the ability to add another. Hone your skills on the private 3-hole putting green in the backyard as you admire the incredible location. This turn-key home is located in the exclusive TPC golf community of Heron Lakes, which affords a lifestyle that offers access to lakes, a clubhouse with exceptional dining and event spaces, and a seasonal resort-style pool with a swim-up bar and cabana kitchen. Enjoy the State-of-the-art gym with classes, and massage services. All this available as a resident WITHOUT a TPC membership. Membership available for those who enjoy golf and want unlimited access beyond individual games on the course. Motorized boating is also available with a private Lake membership.
Parking FeaturesGarage Door Opener, >8' Garage Door, Oversized, Tandem
FencePartial, Metal Post Fence
Lot FeaturesCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Cul-De-Sac, On Golf Course, Near Golf Course, Lake Access, Marina in Community
Garage spaces4
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Recreation Room, Gated
TAX AMOUNT9879.0
LATEST UPDATE2025-01-04T16:31:23.709Z
DAYS ON MARKET10
PRICE CHANGE(S)
$2,499,900 Dec 26, 2024
CUMULATIVE DAYS ON MARKET10
Market Trends
New Properties On Market
23
21%
Decrease In New Listings
Average Asking Price
$966,860
$133,244 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$270
$5 Increase In List Price/Sq. Ft.
Average Days On Market
15
15 Day
Decrease In Days On Market
Data as of Jan 14, 2025.
Remaining statistics above are calculated on activity within the period from Nov 01, 2024 to Dec 31, 2024.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.