An absolute must see! One of a kind home in Northern Colorado. Welcome to your dream home! This exquisite residence spans over 5,000 square feet and offers the perfect blend of luxury and comfort. Nestled near a serene lake and a prestigious golf course, you'll be captivated by the breathtaking views from both the front and back yards. Step inside to find an open floor plan bathed in natural light, featuring a stunning white stone fireplace and beautiful hickory flooring. The gourmet kitchen is a chef's delight, featuring black stainless appliances, custom cabinetry, impressive tile backsplash and elegant quartz countertops, making it perfect for entertaining family and friends. The elegant private master retreat is a true sanctuary, showcasing upgraded tile, luxurious quartz finishes, and a stunning chandelier that adds a touch of sophistication. With convenient access to the laundry and mud room, this space is designed for modern living. Enjoy the exquisite front porch, perfect for morning coffee, and the covered back patio that extends into a beautifully designed concrete area with a full home Sonos System -ideal for al fresco dining and gatherings. The home boasts a wet bar, custom tile work, and solid hickory floors throughout, complemented by upgraded carpet in cozy spaces. Every detail has been meticulously crafted, ensuring that this home is as functional as it is beautiful. Truly one of a kind home - No hoa or metro district. Don't miss the opportunity to own a piece of paradise.
Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURES
Main Level
FIREPLACE FEATURES
Circulating, 2+ Fireplaces
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
2531.0
ARCHITECTURAL STYLE
Contemporary/Modern, Ranch
Roof
Composition
EXTERIOR FEATURES
Gas Grill
Parking Features
Heated Garage, Tandem
Fence
Fenced, Wood
Lot Features
Lawn Sprinkler System
Garage spaces
4
View
Mountain(s), Plains View
CITY
Berthoud
SUBDIVISION
Red Horizons
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
TAX AMOUNT
6362.0
LATEST UPDATE
2025-01-29T23:17:37.482Z
DAYS ON MARKET
43
PRICE CHANGE(S)
$2,250,000 Dec 19, 2024
CUMULATIVE DAYS ON MARKET
133
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet5,062
MLS #1023574
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESMain Level
FIREPLACE FEATURESCirculating, 2+ Fireplaces
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 SIZE2531.0
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofComposition
EXTERIOR FEATURESGas Grill
Parking FeaturesHeated Garage, Tandem
FenceFenced, Wood
Lot FeaturesLawn Sprinkler System
Garage spaces4
ViewMountain(s), Plains View
CITYBerthoud
SUBDIVISIONRed Horizons
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
TAX AMOUNT6362.0
LATEST UPDATE2025-01-29T23:17:37.482Z
DAYS ON MARKET43
PRICE CHANGE(S)
$2,250,000 Dec 19, 2024
CUMULATIVE DAYS ON MARKET133
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 23, 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.