Better than new! Move in ready! Over $100k in professional landscaping. This beautiful custom home in Heron Lakes offers incredible views in a luxury setting. This stunning 2 story with a walk-out basement is an entertainer's dream with luxury finishes throughout. The gourmet kitchen is impressive with a large island, JennAir appliances, and a walk-in pantry. The great room features a gorgeous 2 story contemporary fireplace and large windows to showcase breathtaking mountain views. The private primary bedroom offers a soaking tub, heated floors, and a large walk in closet complete with a custom closet system. This home has an office located near the front entrance. Hardwood flooring throughout the main level, with the exception of the laundry/mudroom. On the second level, you will find 2 bedrooms (one can function as a 2nd primary), a loft area with a wet bar and a balcony for entertaining or relaxing. Washer & dryer on the main and second levels. The finished basement offers a family room, large rec space with LVP flooring for game tables, wet bar with full sized fridge, and the 4th bedroom with a 3/4 bath and another powder bath. Enjoy Colorado sunsets on your covered deck, basement patio, or upstairs balcony! The 4 car garage is fully insulated, painted epoxy flooring and roughed in for a heater. This cul-de-sac is elevated above the other lots below so you see up and over the other homes. Don't miss this opportunity to live in a world class community that has so many amenities to offer-resort style pool, lake access for motorized and non-motorized watercraft, walking trails, work out facilities, and TPC Golf Course. Call for your own private showing!
2 or more H20 Heaters, Gas Range/Oven, Continuous-cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURES
Sink, Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
2+ Fireplaces, Family/Recreation Room Fireplace, Great Room
Heating
2 or more Heat Sources, Humidity Control
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2023
Builder Name
Ridgeway Custom Homes
Basement
Full, Partially Finished, Walk-Out Access, Rough-in for Radon
FINISHED BASEMENT SIZE
2165.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Concrete
EXTERIOR FEATURES
Lighting, Balcony
Parking Features
Garage Door Opener, Oversized
Fence
Fenced, Other
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Corner Lot, Near Golf Course
Garage spaces
4
View
Mountain(s), Water
CITY
Berthoud
SUBDIVISION
Heron Lakes, TPC at Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Pool, Fitness Center, Hiking/Biking Trails
TAX AMOUNT
6613.0
LATEST UPDATE
2025-01-27T16:54:07.457Z
DAYS ON MARKET
6
PRICE CHANGE(S)
$2,395,000 Jan 22, 2025
CUMULATIVE DAYS ON MARKET
6
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)1
Property Sub TypeResidential-Detached
Square Feet6,150
MLS #1024990
Bathrooms (¾)3
Bathrooms (Half)2
FlooringWood Floors
Appliances2 or more H20 Heaters, Gas Range/Oven, Continuous-cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURESSink, Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES2+ Fireplaces, Family/Recreation Room Fireplace, Great Room
Heating2 or more Heat Sources, Humidity Control
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2023
Builder NameRidgeway Custom Homes
BasementFull, Partially Finished, Walk-Out Access, Rough-in for Radon
FINISHED BASEMENT SIZE2165.0
ARCHITECTURAL STYLEContemporary/Modern
RoofConcrete
EXTERIOR FEATURESLighting, Balcony
Parking FeaturesGarage Door Opener, Oversized
FenceFenced, Other
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Corner Lot, Near Golf Course
Garage spaces4
ViewMountain(s), Water
CITYBerthoud
SUBDIVISIONHeron Lakes, TPC at Heron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Hiking/Biking Trails
TAX AMOUNT6613.0
LATEST UPDATE2025-01-27T16:54:07.457Z
DAYS ON MARKET6
PRICE CHANGE(S)
$2,395,000 Jan 22, 2025
CUMULATIVE DAYS ON MARKET6
Market Trends
New Properties On Market
55
244%
Increase In New Listings
Average Asking Price
$910,164
$116,705 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$281
$8 Decrease In List Price/Sq. Ft.
Average Days On Market
20
22 Day
Decrease In Days On Market
Data as of Feb 24, 2025.
Remaining statistics above are calculated on activity within the period from Dec 01, 2024 to Jan 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.