Welcome to this Modern Farmhouse featuring 4-bedroom, 5-bathroom residence spanning 5,124 sq ft that epitomizes modern elegance, formerly a Parade of Homes model. Backing to the 11th tee box at TPC Colorado, this gem is back on the market below construction cost. The gourmet chef's kitchen commands attention on the main level, boasting 10-foot ceilings, stainless steel appliances, and a farm sink. The living room offers a stylish setting with a gas fireplace, coffered ceilings, and Arhaus light fixtures. The owner's suite exudes luxury with coffered ceilings, heated bathroom tiles, and French doors leading to a private patio. The lower level transforms into an entertainment paradise, featuring a cozy gas fireplace, wine/wet bar, two spacious bedrooms, and a versatile flex space. Step out onto the covered heated back patio with dual heaters and a built-in BBQ grilling area, opening to a beautifully landscaped, expansive yard. This property also boasts an oversized, heated 3-car garage. As a resident, you'll relish access to The TPC Colorado Clubhouse, offering a resort-style pool, Fitness Center, private event spaces, a golf shop, and more.
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURES
Sink, Main Level
FIREPLACE FEATURES
2+ Fireplaces
Heating
Forced Air, Humidity Control
Cooling
Central Air
Utility Features
Natural Gas Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town Of Berthoud
Year Built
2021
Builder Name
Ed Rust Lifestyle
Basement
Partially Finished, Sump Pump
FINISHED BASEMENT SIZE
2572.0
ARCHITECTURAL STYLE
Ranch
Roof
Concrete
EXTERIOR FEATURES
Gas Grill, Lighting
Parking Features
Garage Door Opener, Heated Garage, Oversized
Fence
Partial, Metal Post Fence
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Mineral Rights Excluded, Level
Garage spaces
3
View
Foothills View, Panoramic
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Pool, Fitness Center, Hiking/Biking Trails
TAX AMOUNT
11682.0
LATEST UPDATE
2025-04-15T15:09:37.600Z
DAYS ON MARKET
3
PRICE CHANGE(S)
$1,795,000 Apr 12, 2025
CUMULATIVE DAYS ON MARKET
3
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)4
Property Sub TypeResidential-Detached
Square Feet5,172
MLS #1031065
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURESSink, Main Level
FIREPLACE FEATURES2+ Fireplaces
HeatingForced Air, Humidity Control
CoolingCentral Air
Utility FeaturesNatural Gas Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town Of Berthoud
Year Built2021
Builder NameEd Rust Lifestyle
BasementPartially Finished, Sump Pump
FINISHED BASEMENT SIZE2572.0
ARCHITECTURAL STYLERanch
RoofConcrete
EXTERIOR FEATURESGas Grill, Lighting
Parking FeaturesGarage Door Opener, Heated Garage, Oversized
FencePartial, Metal Post Fence
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Mineral Rights Excluded, Level
Garage spaces3
ViewFoothills View, Panoramic
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Hiking/Biking Trails
TAX AMOUNT11682.0
LATEST UPDATE2025-04-15T15:09:37.600Z
DAYS ON MARKET3
PRICE CHANGE(S)
$1,795,000 Apr 12, 2025
CUMULATIVE DAYS ON MARKET3
Market Trends
New Properties On Market
69
64%
Increase In New Listings
Average Asking Price
$866,171
$165,424 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$268
$15 Decrease In List Price/Sq. Ft.
Average Days On Market
21
21 Day
Decrease In Days On Market
Data as of Apr 19, 2025.
Remaining statistics above are calculated on activity within the period from Feb 01, 2025 to Mar 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.