OPEN HOUSE Saturday 5/4 from 1-4PM! Gorgeous custom built home with STUNNING views of the Rocky Mountains, Lonetree Lake and the TPC Golf Course. This is an incredible and rare opportunity to live your Colorado dream in this beautifully designed estate. Enjoy the scenery from both of the main level primary suites, as well as from the dining room, kitchen and great room. Relax on the oversized covered deck to watch the sun set or a thunderstorm. Practice your putting on the 3-hole private green in the backyard. The exclusive TPC golf community, Heron Lakes (recently showcased on HGTV's "Rock the Block) is an entire lifestyle that includes access to lakes and an extensive clubhouse with amazing dining and event spaces. Enjoy the seasonal resort-style pool with a swim up bar and cabana kitchen or take in the scenery from the Hot Tub. Year-round, residents have use of a fully equipped state-of-the-art gym with classes offered, or schedule a massage! A TPC membership can be acquired, or individual games are available for the course as well. Motorized boating available with additional membership to the Lake Club.
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Sloped, On Golf Course, Near Golf Course, Within City Limits, Lake Access, Marina in Community
Garage spaces
4
View
Mountain(s), Foothills View, Plains 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, Gated
TAX AMOUNT
9093.0
LATEST UPDATE
2024-05-08T14:16:33.468Z
DAYS ON MARKET
84
PRICE CHANGE(S)
$2,799,000 Feb 14, 2024
$2,749,000 Mar 13, 2024
$2,725,000 Mar 21, 2024
$2,699,000 Mar 28, 2024
CUMULATIVE DAYS ON MARKET
84
Property Details
Property TypeResidential
StatusActive
Bedrooms6
Bathrooms (Full)2
Property Sub TypeResidential-Detached
Square Feet7,506
MLS #1003181
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, Great Room
HeatingForced Air, Zoned, 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, Sloped, On Golf Course, Near Golf Course, Within City Limits, Lake Access, Marina in Community
Garage spaces4
ViewMountain(s), Foothills View, Plains View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Gated
TAX AMOUNT9093.0
LATEST UPDATE2024-05-08T14:16:33.468Z
DAYS ON MARKET84
PRICE CHANGE(S)
$2,799,000 Feb 14, 2024
$2,749,000 Mar 13, 2024
$2,725,000 Mar 21, 2024
$2,699,000 Mar 28, 2024
CUMULATIVE DAYS ON MARKET84
Market Trends
New Properties On Market
55
6%
Increase In New Listings
Average Asking Price
$897,962
$89,468 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$299
$10 Decrease In List Price/Sq. Ft.
Average Days On Market
12
16 Day
Decrease In Days On Market
Data as of May 09, 2024.
Remaining statistics above are calculated on activity within the period from Mar 01, 2024 to Apr 30, 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.