Presented by Lifestyle Custom Homes by Ed Rust, The Sophia is a stunning residence located in the exclusive gated section of Heron Lakes, known as "The Rookery". This lovely home comes with a Full TPC Golf Membership, allowing you to fully indulge in the ultimate golfing experience.The owner's retreat is designed to be your sanctuary, offering a peaceful and tranquil space to unwind. The gourmet kitchen is fully equipped with high end stainless steel appliances and features stunning granite or quartz countertops, providing a luxurious culinary experience. The oversized sliding doors open up to a spacious back patio, perfect for hosting guests and entertaining.The main floor of the home also includes a generously sized ensuite for guests, as well as a custom sliding door office. The lower level, funished basement is fully loaded with 2 gracious sized bedrooms, a walk up wet bar and oversized rec room. Not a detail is missed on this lovely home. With low-volt technology, this smart home is designed to enhance your daily living experience.This estate-sized lot with water and mountain views, providing a stunning outdoor living space for you to enjoy upon moving in.
Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
LAUNDRY FEATURES
Washer/Dryer Hookups
FIREPLACE FEATURES
Living Room
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town Of Berthoud
Year Built
2024
Builder Name
Lifestyle Custom -Ed Rust
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
2348.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Ranch
Roof
Tile
EXTERIOR FEATURES
Lighting
Fence
Partial
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level
Garage spaces
3
View
Foothills View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Pool, Fitness Center, Park, Hiking/Biking Trails, Gated
TAX AMOUNT
6460.0
LATEST UPDATE
2025-02-17T16:03:01.999Z
DAYS ON MARKET
342
PRICE CHANGE(S)
$2,150,000 Mar 13, 2024
CUMULATIVE DAYS ON MARKET
720
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)4
Property Sub TypeResidential-Detached
Square Feet4,696
MLS #1004931
Bathrooms (Half)1
AppliancesGas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
LAUNDRY FEATURESWasher/Dryer Hookups
FIREPLACE FEATURESLiving Room
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town Of Berthoud
Year Built2024
Builder NameLifestyle Custom -Ed Rust
BasementFull, Partially Finished
FINISHED BASEMENT SIZE2348.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLERanch
RoofTile
EXTERIOR FEATURESLighting
FencePartial
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level
Garage spaces3
ViewFoothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Park, Hiking/Biking Trails, Gated
TAX AMOUNT6460.0
LATEST UPDATE2025-02-17T16:03:01.999Z
DAYS ON MARKET342
PRICE CHANGE(S)
$2,150,000 Mar 13, 2024
CUMULATIVE DAYS ON MARKET720
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.