Experience the zenith of luxury living in this visionary masterpiece meticulously crafted by Lifestyle Custom Homes, Ed Rust. This two-story haven epitomizes modern luxury living, boasting an array of meticulously curated features. The main level offers an inviting space characterized by seamless transitions between rooms and an unmissable grandeur in every detail. The upper floor extends this allure, offering boundless possibilities for customizing your living spaces. A finished walk-out basement adds flexible living space, ideal for recreation or leisure, with the potential for future expansion to match your evolving lifestyle. Outdoor enjoyment is paramount with a spacious covered back patio on the walkout level, a matching covered concrete deck on the main floor, and private concrete balconies for each upper-floor bedroom suite.The Bailey Spec Home distinguishes itself with cutting-edge technology, including a low-voltage smart home system. It showcases custom features and meticulous design, evident in the European cabinetry, solid surface countertops, top-quality floor coverings, premium appliances, exquisite lighting, and plumbing fixtures, as well as carefully selected details like door hardware and bath accessories. This property is a testament to unmatched luxury in Heron Lakes, TPC Colorado. Contact us today to explore how this residence can become the unique embodiment of your vision.
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURES
Washer/Dryer Hookups, Upper Level
FIREPLACE FEATURES
Gas, Living Room, Family/Recreation Room Fireplace, Basement
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2024
Builder Name
Lifestyle Custom Homes
Basement
90%+ Finished Basement, Walk-Out Access
FINISHED BASEMENT SIZE
2503.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Tile
EXTERIOR FEATURES
Lighting, Balcony
Parking Features
Garage Door Opener, Oversized
Lot Features
Gutters, Sidewalks, Fire Hydrant within 500 Feet, Sloped, Near Golf Course, Within City Limits, Lake Front
Garage spaces
3
View
Mountain(s), Foothills View, Water, Panoramic
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Tennis Court(s), Hot Tub, Pool, Park, Hiking/Biking Trails
TAX AMOUNT
6460.0
LATEST UPDATE
2024-08-14T10:13:50.930Z
DAYS ON MARKET
167
PRICE CHANGE(S)
$3,999,500 Mar 1, 2024
CUMULATIVE DAYS ON MARKET
167
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)5
Property Sub TypeResidential-Detached
Square Feet7,002
MLS #1004259
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESWasher/Dryer Hookups, Upper Level
FIREPLACE FEATURESGas, Living Room, Family/Recreation Room Fireplace, Basement
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2024
Builder NameLifestyle Custom Homes
Basement90%+ Finished Basement, Walk-Out Access
FINISHED BASEMENT SIZE2503.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLEContemporary/Modern
RoofTile
EXTERIOR FEATURESLighting, Balcony
Parking FeaturesGarage Door Opener, Oversized
Lot FeaturesGutters, Sidewalks, Fire Hydrant within 500 Feet, Sloped, Near Golf Course, Within City Limits, Lake Front
Garage spaces3
ViewMountain(s), Foothills View, Water, Panoramic
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Tennis Court(s), Hot Tub, Pool, Park, Hiking/Biking Trails
TAX AMOUNT6460.0
LATEST UPDATE2024-08-14T10:13:50.930Z
DAYS ON MARKET167
PRICE CHANGE(S)
$3,999,500 Mar 1, 2024
CUMULATIVE DAYS ON MARKET167
Market Trends
New Properties On Market
47
27%
Increase In New Listings
Average Asking Price
$798,957
$412,724 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$235
$167 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.