Backing breathtaking water and mountain views, this stunning custom home sits on a nearly 17,000 sq ft lot in Northern Colorado's premier TPC Heron Lakes community, and it is a must-see! Bordering open space to the west and stepping directly onto the community trail, the setting alone is remarkable. The home itself takes it further. Soaring beamed ceilings, an open floor plan, and large windows frame your views at every turn. The gourmet kitchen impresses with dramatic granite, chef's appliances, a large pantry, and an oversized island built for gathering. The great room's floor-to-ceiling fireplace commands attention, while the luxurious main-floor primary retreat offers private deck access, heated floors, a soaking tub, and a spa-like bath with trough sink and leaded glass windows. Outside, two upper decks, one with an 8-foot gas fireplace, one with a built-in grilling station, make Colorado's outdoor lifestyle effortless! Add professional landscaping, two fountains, a custom fire pit, an enclosed dog run with turf, a hot Tub, and the backyard rivals any resort!! The finished walk-out basement with 10-foot ceilings brings even more to the table: a home theater, granite bar with seating for six, glass-enclosed wine room, two ensuite bedrooms, stained concrete floors, and a hidden safe. Captivating and dramatic, this home truly is an experience all its own.TPC Heron Lakes delivers the lifestyle to match: award-winning golf, a resort-style pool, lake recreation, miles of trails, and a world-class clubhouse and gym, all with convenient access to Denver, Boulder, and DIA. Come live a life of luxury!
Gas Range, Dishwasher, Refrigerator, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Circulating
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available
WATER SOURCE
City
Year Built
2023
Builder Name
Solace Custom Homes
Basement
Partially Finished
FINISHED BASEMENT SIZE
2593.0
Roof
Composition
EXTERIOR FEATURES
Sprinkler System
Parking Features
Attached
Fence
Fenced
Garage spaces
3
View
Hills
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Clubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s), Gated
TAX AMOUNT
16259.0
LATEST UPDATE
2026-06-02T09:23:02.555Z
DAYS ON MARKET
19
PRICE CHANGE(S)
$2,790,000 May 6, 2026
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)2
Property Sub TypeSingle Family Residence
Square Feet5,186
MLS #1058283
Bathrooms (¾)2
Bathrooms (Half)2
AppliancesGas Range, Dishwasher, Refrigerator, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURESCirculating
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available
WATER SOURCECity
Year Built2023
Builder NameSolace Custom Homes
BasementPartially Finished
FINISHED BASEMENT SIZE2593.0
RoofComposition
EXTERIOR FEATURESSprinkler System
Parking FeaturesAttached
FenceFenced
Garage spaces3
ViewHills
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s), Gated
TAX AMOUNT16259.0
LATEST UPDATE2026-06-02T09:23:02.555Z
DAYS ON MARKET19
PRICE CHANGE(S)
$2,790,000 May 6, 2026
Market Trends
New Properties On Market
71
15%
Increase In New Listings
Average Asking Price
$1,202,365
$330,664 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$339
$69 Increase In List Price/Sq. Ft.
Average Days On Market
8
24 Day
Decrease In Days On Market
Data as of Jun 03, 2026.
Remaining statistics above are calculated on activity within the period from Apr 01, 2026 to May 31, 2026.
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.