EXQUISITE custom-built estate with breathtaking views of the Rocky Mountains, Lonetree Lake, and the TPC Golf Course. This is a rare opportunity to realize your Colorado dream in a masterfully designed home. Revel in the stunning scenery from the main level primary suites, dining room, kitchen, and great room. Unwind on the expansive covered deck, perfect for watching sunsets or thunderstorms. There is no shortage of space here with over 7,000 sqft finished, TWO main level primary suites, and flexible use rooms. The walk-out basement offers an additional kitchen, 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 peaks. This turn-key home is located in the exclusive TPC golf community of Heron Lakes, this lifestyle 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 year-round hot tub, state-of-the-art gym with classes, and massage services. Enjoy all this 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. Basement prepped for a second full bathroom in the basement, as well as a basement laundry room.
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, On Golf Course, Near Golf Course, Within City Limits, Lake Access, Marina in Community
Garage spaces
4
View
Mountain(s), Foothills View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Hot Tub, Pool, Fitness Center, Park, Recreation Room, Gated
TAX AMOUNT
9093.0
LATEST UPDATE
2024-11-12T13:05:48.951Z
DAYS ON MARKET
110
PRICE CHANGE(S)
$2,599,999 Jul 26, 2024
$2,599,000 Aug 8, 2024
$2,598,000 Aug 15, 2024
$2,499,000 Sep 14, 2024
CUMULATIVE DAYS ON MARKET
272
Property Details
Property TypeResidential
StatusActive
Bedrooms6
Bathrooms (Full)2
Property Sub TypeResidential-Detached
Square Feet7,506
MLS #1015181
Bathrooms (¾)1
Bathrooms (Half)1
FlooringWood Floors
AppliancesElectric Range/Oven, Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURESGas
HeatingForced Air, Humidity Control
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
Parking FeaturesGarage Door Opener, Oversized, Tandem
FencePartial, Metal Post Fence
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, On Golf Course, Near Golf Course, Within City Limits, Lake Access, Marina in Community
Garage spaces4
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Recreation Room, Gated
TAX AMOUNT9093.0
LATEST UPDATE2024-11-12T13:05:48.951Z
DAYS ON MARKET110
PRICE CHANGE(S)
$2,599,999 Jul 26, 2024
$2,599,000 Aug 8, 2024
$2,598,000 Aug 15, 2024
$2,499,000 Sep 14, 2024
CUMULATIVE DAYS ON MARKET272
Market Trends
New Properties On Market
45
18%
Increase In New Listings
Average Asking Price
$813,024
$378,981 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$232
$165 Decrease In List Price/Sq. Ft.
Average Days On Market
17
17 Day
Decrease In Days On Market
Data as of Nov 15, 2024.
Remaining statistics above are calculated on activity within the period from Sep 01, 2024 to Oct 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.