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 another bathroom and laundry room.
Offered By
Aubrie Larsen aubslong@gmail.com,720-483-2237, Neuhaus Real Estate, Inc.
Lot FeaturesLawn Sprinkler System, Cul-De-Sac, Sloped, On Golf Course, Near Golf Course, Abuts Public Open Space
Garage spaces4
ViewMountain(s), Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
HOA1
TAX AMOUNT9093.0
HOA FEE1500.0
HOA FREQUENCYAnnually
LATEST UPDATE2024-10-13T13:20:44.688Z
DAYS ON MARKET241
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
$2,689,000 May 18, 2024
$2,675,000 May 24, 2024
$2,670,000 Jun 20, 2024
$2,665,000 Jul 11, 2024
$2,599,999 Jul 31, 2024
$2,599,000 Aug 8, 2024
$2,598,000 Aug 15, 2024
$2,499,000 Sep 14, 2024
CUMULATIVE DAYS ON MARKET241
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.