Home » Real Estate » CO » Berthoud » 80513 »
$3,500,000
2732 Bluewater Rd, Berthoud, CO, 80513
5
Beds
6
Baths
7,070
Square Feet
Rare opportunity to live in the Rookery at Heron Lakes, an exclusive gated section that comes with TPC Golf Membership! Meticulously designed luxury custom home with the highest quality design & upgrades throughout. Chef's kitchen w/large island, built-in Miele coffee station, Jenn Air appliances, beautiful granite & farmhouse sink. Dual primary suite design. Elevator provides access to all 3 floors of the home. Custom spa w/dry sauna room, steam room/shower, massage space & gym. Stunning outdoor entertaining spaces. Enjoy the Heron Lakes lifestyle w/golf, elite club facilities, restaurants, lakes & trails!
Offered By
Dennis Schick 9702263990, RE/MAX Alliance-FTC South
Property Details
Property Type
Residential
Status
Active
Bedrooms
5
Bathrooms (Full)
1
Property Sub Type
Residential-Detached
Square Feet
7,070
MLS #
1008786
Bathrooms (Half)
2
Appliances
Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Purifier Owned, Disposal
LAUNDRY FEATURES
Sink, Washer/Dryer Hookups, Upper Level
FIREPLACE FEATURES
Gas, Living Room
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2022
Basement
Full, 90%+ Finished Basement, Rough-in for Radon
FINISHED BASEMENT SIZE
2385.0
Roof
Tile
EXTERIOR FEATURES
Lighting, Balcony, Hot Tub Included
Parking Features
Garage Door Opener, Oversized
Fence
Fenced, Wood
Lot Features
Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Near Golf Course
Garage spaces
4
View
Mountain(s), Foothills View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Pool, Fitness Center, Hiking/Biking Trails
TAX AMOUNT
15975.0
LATEST UPDATE
2024-05-09T23:08:33.647Z
DAYS ON MARKET
7
PRICE CHANGE(S)
$3,500,000 May 4, 2024
CUMULATIVE DAYS ON MARKET
7
Property Details
Property Type
Residential
Status
Active
Bedrooms
5
Bathrooms (Full)
1
Property Sub Type
Residential-Detached
Square Feet
7,070
MLS #
1008786
Bathrooms (Half)
2
New Properties On Market
64
2%
Decrease In New Listings
Average Asking Price
$863,008
$30,205 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$289
$5 Decrease In List Price/Sq. Ft.
Average Days On Market
21
15 Day
Decrease In Days On Market
Data as of May 18, 2024.
Remaining statistics above are calculated on activity within the period from Mar 01, 2024 to Apr 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.
Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance
Similar Listings
$3,999,500
2554 Southwind Rd
Berthoud, CO
5
Beds
| 6
Baths
| 7,002
Square Feet
Offered By Melissa Doherty Melissa Doherty
$3,997,000
4514 Hoot Owl Dr
Berthoud, CO
3
Beds
| 4
Baths
| 6,655
Square Feet
Offered By Maggi Kelly Costello LIV Sotheby's International Realty
$3,997,000
4514 Hoot Owl Dr
Berthoud, CO
3
Beds
| 4
Baths
| 6,655
Square Feet
Offered By Margaret Kelly Costello LIV Sotheby's Intl Realty
$3,995,000
6502 Kiva Ridge Dr
Berthoud, CO
3
Beds
| 4
Baths
| 7,772
Square Feet
Offered By Jim Cavoto Engel & Volkers Denver
Information deemed reliable but not guaranteed by the MLS.
Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2024 IRES.
Property data was last updated on 5/10/2024 at 2:17 am