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, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURES
Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
Circulating
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
Parking Features
RV/Boat Parking, Tandem
Fence
Fenced, Wood
Lot Features
Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Garage spaces
4
View
Mountain
CITY
Berthoud
SUBDIVISION
Red Horizons
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
TAX AMOUNT
6362.0
LATEST UPDATE
2024-11-06T18:22:19.606Z
DAYS ON MARKET
49
PRICE CHANGE(S)
$2,250,000 Sep 19, 2024
CUMULATIVE DAYS ON MARKET
49
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet5,062
MLS #1018952
Bathrooms (Half)1
AppliancesGas Range/Oven, Double Oven, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURESCirculating
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
Parking FeaturesRV/Boat Parking, Tandem
FenceFenced, Wood
Lot FeaturesSidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Garage spaces4
ViewMountain
CITYBerthoud
SUBDIVISIONRed Horizons
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
TAX AMOUNT6362.0
LATEST UPDATE2024-11-06T18:22:19.606Z
DAYS ON MARKET49
PRICE CHANGE(S)
$2,250,000 Sep 19, 2024
CUMULATIVE DAYS ON MARKET49
Market Trends
New Properties On Market
46
24%
Increase In New Listings
Average Asking Price
$804,043
$407,638 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$234
$168 Decrease In List Price/Sq. Ft.
Average Days On Market
17
16 Day
Decrease In Days On Market
Data as of Nov 15, 2024.
Remaining statistics above are calculated on activity within the period from Sep 01, 2024 to Oct 31, 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.