Don't miss your chance to own this meticulously designed residence that feels brand new! Every detail has been thoughtfully crafted for comfort and luxury. Step into the gourmet kitchen, featuring an extra-large island with a prep sink and disposal, perfect for culinary enthusiasts. Equipped with a premium Italian-made Fulgor gas stove, a spacious walk-in pantry, and a top-of-the-line refrigerator, this kitchen is a chef's dream. The custom tile backsplash adds a stylish touch, while quartz countertops throughout the kitchen, bathrooms, and wet bar elevate the home's elegance. The beautifully finished basement offers a true retreat, complete with a luxurious wet bar adorned with Italian tile, a relaxing 3-person sauna, and full sound insulation for ultimate privacy. An additional electrical panel ensures efficient power management without strain. Fully fenced backyard complete with sprinkler system and mature landscape. South facing orientation captures the Colorado sun to decrease icy driveways and optimize indoor natural light. Enjoy the future private clubhouse and pool! This home is truly a move in ready luxury home-no projects needed!
Offered By
Tracy Reilly 9704607600, Christopher & Co Real Estate
Gas Range/Oven, Down Draft, Self Cleaning Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURES
Sink, Washer/Dryer Hookups
FIREPLACE FEATURES
Gas
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2022
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
1566.0
ARCHITECTURAL STYLE
Ranch
Roof
Composition
EXTERIOR FEATURES
Lighting
Parking Features
Garage Door Opener
Fence
Fenced, Wood
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Garage spaces
3
CITY
Berthoud
SUBDIVISION
Farmstead
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Pool, Park
HOA
1
TAX AMOUNT
3264.0
HOA FEE
195.0
HOA 2 FEE
45.0
HOA FREQUENCY
Quarterly
HOA 2 FREQUENCY
Quarterly
LATEST UPDATE
2026-01-18T00:17:23.869Z
DAYS ON MARKET
11
PRICE CHANGE(S)
$645,000 Jan 7, 2026
CUMULATIVE DAYS ON MARKET
11
Property Details
Property TypeResidential
StatusActive Under Contract
Bedrooms4
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet3,132
MLS #1049066
Bathrooms (Half)1
AppliancesGas Range/Oven, Down Draft, Self Cleaning Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURESSink, Washer/Dryer Hookups
FIREPLACE FEATURESGas
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2022
BasementFull, Partially Finished
FINISHED BASEMENT SIZE1566.0
ARCHITECTURAL STYLERanch
RoofComposition
EXTERIOR FEATURESLighting
Parking FeaturesGarage Door Opener
FenceFenced, Wood
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Garage spaces3
CITYBerthoud
SUBDIVISIONFarmstead
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Park
HOA1
TAX AMOUNT3264.0
HOA FEE195.0
HOA 2 FEE45.0
HOA FREQUENCYQuarterly
HOA 2 FREQUENCYQuarterly
LATEST UPDATE2026-01-18T00:17:23.869Z
DAYS ON MARKET11
PRICE CHANGE(S)
$645,000 Jan 7, 2026
CUMULATIVE DAYS ON MARKET11
Market Trends
New Properties On Market
33
154%
Increase In New Listings
Average Asking Price
$750,713
$63,440 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$239
$36 Decrease In List Price/Sq. Ft.
Average Days On Market
31
9 Day
Decrease In Days On Market
Data as of Jan 27, 2026.
Remaining statistics above are calculated on activity within the period from Nov 01, 2025 to Dec 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.