Located at the base of the beautiful foothills in the highly sought after Rainbow Lake Estates - just minutes from Carter Lake! This is a rare opportunity to own this like new custom built Modern farmhouse located on 2 acres in Berthoud with gorgeous mountain views! Stunning is truly the best way to describe this spectacular home! From the moment you enter, you will see all the custom touches this home has to offer! Shiplap ceilings, hand carved wood beams, custom iron handrails, and hand scraped wood floors. Spectacular kitchen with custom center island wrapped in black shiplap, high end appliances including an induction cooktop with retractable vent, walk in pantry and double patio doors off the kitchen lead to the covered patio to take in the views and sunsets! Main floor master suite features soaker tub, herringbone tile, heated floors and large walk in closet with built in organizers. Huge bonus room on upper level that can be used as an office, play room, tv room - the possibilities are endless. The bright and beautiful open floor plan also includes a full basement ready to finish as you like. Tankless hot water heater, two AC units. Full laundry and mudroom room. 3 car garage is fully insulated and has epoxy flooring, Tesla EV Charger, gas snub to add a heater, cabinets, workbench and tire racks are all included. Fiber optic internet and the whole house is wired on CAT5 ethernet. Professionally landscaped with wifi sprinkler system and drip system to every plant and tree on the lot. Nest Security cameras on every side of the home along with a nest thermostat and doorbell are also included. Come take a look at this stunning home, soak up the views and make it yours!
Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Gas, Family Room, One
Heating
Forced Air
Cooling
Ceiling Fan(s)
SEWER
Septic Tank
WATER SOURCE
City
Year Built
2019
Basement
Full, Unfinished
FINISHED BASEMENT SIZE
2166.0
Roof
Composition
EXTERIOR FEATURES
Sprinkler System
Lot Features
Paved
Garage spaces
3
View
Mountain(s)
CITY
Berthoud
SUBDIVISION
Rainbow Lake Estates
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Park
HOA
1
TAX AMOUNT
3664.0
HOA FEE
500.0
HOA FREQUENCY
Annually
LATEST UPDATE
2026-01-23T06:30:24.638Z
PRICE CHANGE(S)
$1,195,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms3
Bathrooms (Full)2
Property Sub TypeSingle Family Residence
Square Feet2,993
MLS #8104397
Bathrooms (¾)1
Bathrooms (Half)1
AppliancesDouble Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURESGas, Family Room, One
HeatingForced Air
CoolingCeiling Fan(s)
SEWERSeptic Tank
WATER SOURCECity
Year Built2019
BasementFull, Unfinished
FINISHED BASEMENT SIZE2166.0
RoofComposition
EXTERIOR FEATURESSprinkler System
Lot FeaturesPaved
Garage spaces3
ViewMountain(s)
CITYBerthoud
SUBDIVISIONRainbow Lake Estates
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESPark
HOA1
TAX AMOUNT3664.0
HOA FEE500.0
HOA FREQUENCYAnnually
LATEST UPDATE2026-01-23T06:30:24.638Z
PRICE CHANGE(S)
$1,195,000 Oct 21, 2025
Market Trends
New Properties On Market
77
31%
Increase In New Listings
Average Asking Price
$994,971
$162,667 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$324
$25 Increase In List Price/Sq. Ft.
Average Days On Market
7
18 Day
Decrease In Days On Market
Data as of Mar 31, 2026.
Remaining statistics above are calculated on activity within the period from Feb 01, 2026 to Mar 31, 2026.
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.