Custom designed estate home in Heron Lakes at TPC Colorado. Located in the gated Rookery that comes with deeded membership to TPC Colorado. Recent appraisal in hand at $2.475M! The lowest price per finished SF in the neighborhood! 2-story home offering 6 bedrooms, 4 baths, over 6,500 SF of living space and an outdoor setup made to entertain. Beautiful, luxury design features and stained wood accents throughout. Custom barn door entrance to the study off the grand foyer. Open floorplan with cathedral ceilings in the expansive great room highlighted by the dramatic floor to ceiling stone fireplace, built-ins and abundance of natural lighting. Chef's kitchen with quartz countertops, custom Knotty Alder cabinetry with built-in appliances, a massive kitchen island with an apron sink, gas range and off-kitchen dining with back deck access. Formal dining room with a butler's bar and wine fridge that extends to one of the two covered back decks for al fresco dining. Main-level guest suite with a private bath. Upper-level primary retreat offering a coffee bar, unique see-thru fireplace, a private covered balcony, luxury bath with a steam shower, deep soaking tub and expansive walk-in closet with built-ins and a stacked washer/dryer setup. Forced walkout basement with a massive rec room, extended wet bar, two large bedrooms, additional covered patio and gas firepit area. Recreation ready heated garage with epoxy flooring, a storage wall, dog washing station and dog run access. Full property professional landscaping with a timeless water feature. Owners have access to luxury community amenities; a resort-style pool, fitness center, 65,000 SF clubhouse, 2 restaurants (3rd under construction), 8.7 miles of trails, 130 acres of open space, discounted lake club membership for reservoir access. Membership to TPC offers golf privileges, practice facility, golf simulator center, Men/Women locker rooms access, invitations to exclusive events and international golf.
Offered By
David Johnson 3034436161, LIV Sotheby's Intl Realty
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURES
Sink, Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
2+ Fireplaces, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2022
Builder Name
Custom On-Site Builders
Basement
Full, 90%+ Finished Basement
FINISHED BASEMENT SIZE
2252.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Tile
EXTERIOR FEATURES
Lighting, Balcony
Parking Features
Garage Door Opener, >8' Garage Door, Heated Garage, Oversized
Fence
Partial
Lot Features
Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Near Golf Course, Within City Limits, Marina in Community
Garage spaces
3
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, Hiking/Biking Trails, Gated
TAX AMOUNT
15395.0
LATEST UPDATE
2024-05-02T06:16:59.949Z
DAYS ON MARKET
29
PRICE CHANGE(S)
$2,475,000 Apr 4, 2024
CUMULATIVE DAYS ON MARKET
63
Property Details
Property TypeResidential
StatusActive
Bedrooms6
Bathrooms (Full)4
Property Sub TypeResidential-Detached
Square Feet6,567
MLS #1006462
Bathrooms (Half)1
AppliancesGas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESSink, Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES2+ Fireplaces, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2022
Builder NameCustom On-Site Builders
BasementFull, 90%+ Finished Basement
FINISHED BASEMENT SIZE2252.0
ARCHITECTURAL STYLEContemporary/Modern
RoofTile
EXTERIOR FEATURESLighting, Balcony
Parking FeaturesGarage Door Opener, >8' Garage Door, Heated Garage, Oversized
FencePartial
Lot FeaturesCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Near Golf Course, Within City Limits, Marina in Community
Garage spaces3
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails, Gated
TAX AMOUNT15395.0
LATEST UPDATE2024-05-02T06:16:59.949Z
DAYS ON MARKET29
PRICE CHANGE(S)
$2,475,000 Apr 4, 2024
CUMULATIVE DAYS ON MARKET63
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 10, 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.