**OPEN HOUSE SAT 10-1**PRICE REDUCED! YOU HAVE TO SEE THIS HOME AND THE UPGRADES...IT'S LIKE NO OTHER***Upon entering this impeccably designed ranch home, a sense of serenity washes over you. Featuring 5 bedrooms and 3.5 baths, this residence is expertly crafted for multi-generational living. Spanning 4157 square feet, the main level exudes a cozy yet rustically modern ambiance, adorned with 10' ceilings throughout, a vaulted living room reaching 20', solid cedar beams, and authentic stone accents. Delight in the display of golfers in action as you grill on the patio, commanding a stunning view of the picturesque 13th green at TPC Colorado. Membership is included, valued at $60,000, with only monthly dues required. The kitchen is a culinary haven, showcasing a custom metal hood and top-of-the-line Jenn-Air appliances, complemented by a generous 5' fridge/freezer by Electrolux. Quartz countertops grace every surface, with the kitchen island featuring an elegant waterfall design. Each of the two main level primary suites offer luxurious amenities, including large walk-in closets, dual head shower and heated floors for one, a steam shower for the other. A versatile flex room serves as a "Day Room," complete with a sink, microwave, and ample space for a fridge. The lower level presents an ideal entertainment retreat with a surround sound system, wet bar, two expansive bedrooms, a full bath, and the option for a third bedroom, catering perfectly to multi-generational lifestyles. Additional features include an oversized, heated 3-car garage and access to the TPC Colorado Clubhouse, featuring a resort-style pool, Fitness Center, private event spaces, and a golf shop. This exceptional property is crafted with uncompromised quality by Schroetlin Custom Homes, offering an unparalleled living experience. BONUS-Central Vacuum system, Concrete roof, South facing, NEST Thermostat & dual zone, main floor laundry room (washer & dryer included),
Offered By
Jeffrey Crase 720-217-5789, MB A PERFECT HOME 4 U REALTY
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer, Public Sewer
WATER SOURCE
City Water
Year Built
2018
Basement
Partially Finished
FINISHED BASEMENT SIZE
2532.0
ARCHITECTURAL STYLE
Ranch
Roof
Concrete
EXTERIOR FEATURES
Gas Grill
Fence
Fenced
Lot Features
Gutters, Lawn Sprinkler System, Level, Near Golf Course
Garage spaces
3
View
Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
TAX AMOUNT
12258.0
LATEST UPDATE
2025-01-12T13:08:57.792Z
DAYS ON MARKET
242
PRICE CHANGE(S)
$1,850,000 May 15, 2024
$1,799,000 Jun 5, 2024
$1,777,000 Aug 2, 2024
$1,699,900 Sep 20, 2024
CUMULATIVE DAYS ON MARKET
242
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)1
Property Sub TypeResidential-Detached
Square Feet5,064
MLS #6378480
Bathrooms (¾)2
Bathrooms (Half)1
AppliancesDishwasher, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESMain Level
FIREPLACE FEATURESLiving Room, Single Fireplace
HeatingForced Air, Radiator
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer, Public Sewer
WATER SOURCECity Water
Year Built2018
BasementPartially Finished
FINISHED BASEMENT SIZE2532.0
ARCHITECTURAL STYLERanch
RoofConcrete
EXTERIOR FEATURESGas Grill
FenceFenced
Lot FeaturesGutters, Lawn Sprinkler System, Level, Near Golf Course
Garage spaces3
ViewWater
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
TAX AMOUNT12258.0
LATEST UPDATE2025-01-12T13:08:57.792Z
DAYS ON MARKET242
PRICE CHANGE(S)
$1,850,000 May 15, 2024
$1,799,000 Jun 5, 2024
$1,777,000 Aug 2, 2024
$1,699,900 Sep 20, 2024
CUMULATIVE DAYS ON MARKET242
Market Trends
New Properties On Market
21
22%
Decrease In New Listings
Average Asking Price
$1,005,109
$160,451 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$269
$3 Increase In List Price/Sq. Ft.
Average Days On Market
23
16 Day
Decrease In Days On Market
Data as of Jan 25, 2025.
Remaining statistics above are calculated on activity within the period from Nov 01, 2024 to Dec 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.