Custom lakefront home built by Schroetlin Custom Homes. Located in the award-winning Heron Lakes community with a 65000 sq ft clubhouse, workout facility, resort style pool, multiple restaurants, boating on Lonetree Reservoir and home to TPC Colorado Golf Club. This ranch style home has everything you need, a chef's kitchen, primary bedroom suite, beautiful back deck, basement rec room with bar, and plenty of room for everyday life, entertaining, and guests. Soak up the views from your great room, kitchen, primary bedroom, rec room, guest suite, and back deck. Contains many of the little things that makes a home special, electric window coverings, Control 4 system, speakers on the back deck, garage shelving, epoxy garage floor, 220 car charger, and a built-in grill. Seller appreciates a previous days notice for all showings. Call agent for TPC Colorado membership details.
Offered By
David Johnson 3038933200, LIV Sotheby's Intl Realty D
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2018
Builder Name
Schroetlin
Basement
Full
FINISHED BASEMENT SIZE
2309.0
ARCHITECTURAL STYLE
Contemporary/Modern, Ranch
Roof
Tile
EXTERIOR FEATURES
Lighting, Balcony
Fence
Fenced
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Sloped, Near Golf Course
Garage spaces
3
View
Mountain(s), Foothills View, Plains View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Hot Tub, Pool, Fitness Center, Hiking/Biking Trails, Gated
TAX AMOUNT
12070.0
LATEST UPDATE
2025-06-16T22:03:31.333Z
DAYS ON MARKET
4
PRICE CHANGE(S)
$2,200,000 Jun 13, 2025
CUMULATIVE DAYS ON MARKET
4
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)2
Property Sub TypeResidential-Detached
Square Feet4,618
MLS #1036733
Bathrooms (¾)1
Bathrooms (Half)1
FlooringWood Floors
AppliancesRefrigerator
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURESGas
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2018
Builder NameSchroetlin
BasementFull
FINISHED BASEMENT SIZE2309.0
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofTile
EXTERIOR FEATURESLighting, Balcony
FenceFenced
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Sloped, Near Golf Course
Garage spaces3
ViewMountain(s), Foothills View, Plains View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Hiking/Biking Trails, Gated
TAX AMOUNT12070.0
LATEST UPDATE2025-06-16T22:03:31.333Z
DAYS ON MARKET4
PRICE CHANGE(S)
$2,200,000 Jun 13, 2025
CUMULATIVE DAYS ON MARKET4
Market Trends
New Properties On Market
58
5%
Increase In New Listings
Average Asking Price
$1,071,088
$95,895 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$325
$25 Increase In List Price/Sq. Ft.
Average Days On Market
23
23 Day
Decrease In Days On Market
Data as of Jun 29, 2025.
Remaining statistics above are calculated on activity within the period from Apr 01, 2025 to May 31, 2025.
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.