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
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
2024-12-19T15:30:10.204Z
DAYS ON MARKET
2
PRICE CHANGE(S)
$2,250,000 Dec 19, 2024
CUMULATIVE DAYS ON MARKET
92
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
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 UPDATE2024-12-19T15:30:10.204Z
DAYS ON MARKET2
PRICE CHANGE(S)
$2,250,000 Dec 19, 2024
CUMULATIVE DAYS ON MARKET92
Market Trends
New Properties On Market
36
16%
Increase In New Listings
Average Asking Price
$837,246
$91,387 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$272
$27 Increase In List Price/Sq. Ft.
Average Days On Market
16
26 Day
Decrease In Days On Market
Data as of Dec 23, 2024.
Remaining statistics above are calculated on activity within the period from Oct 01, 2024 to Nov 30, 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.