Home » Real Estate » CO » Berthoud » 80513 »
$2,765,000
2672 Bluewater Rd, Berthoud, CO, 80513
4
Beds
4
Baths
7,118
Square Feet
Amazing custom home in the Rookery, the gated portion of the Heron Lake community at the TPC Colorado golf resort. This grand home features a five car garage, elevator, wine room, theater room, wet bar, custom cabinets, professional appliances, huge recreation room, a loft with mountain and lake views, and a three store atrium. Enjoy views of the entire front range and two lakes from the magical rooftop deck. This featured design can be modified in any way to make the home perfect, or Masterwork Home Company can develop a new design especially for you. A membership to the TPC Colorado golf resort in included with the purchase of the home.
Offered By
Brian Terry 3034421277, Bosch Real Estate Group, LLC
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
4
Property Sub Type
Residential-Detached
Square Feet
7,118
MLS #
983648
Bathrooms (Half)
1
Flooring
Wood Floors
Appliances
Electric Range/Oven, Dishwasher, Bar Fridge, Microwave
LAUNDRY FEATURES
Main Level
FIREPLACE FEATURES
Gas
Heating
Forced Air, 2 or more Heat Sources
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
Masterwork Home Company
Basement
75%+Finished Basement
FINISHED BASEMENT SIZE
2923.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Balcony
Lot Features
Curbs, Gutters, Steep Slope, Near Golf Course
Garage spaces
5
View
Mountain(s), Foothills View, Plains View, City, Water, Panoramic
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Tennis Court(s), Hot Tub, Indoor Pool, Pool, Sauna, Playground, Fitness Center, Park, Hiking/Biking Trails, Recreation Room
TAX AMOUNT
6460.0
LATEST UPDATE
2024-08-14T09:49:47.346Z
DAYS ON MARKET
518
PRICE CHANGE(S)
$2,415,000 Mar 17, 2023
$2,765,000 May 30, 2024
CUMULATIVE DAYS ON MARKET
518
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
4
Property Sub Type
Residential-Detached
Square Feet
7,118
MLS #
983648
Bathrooms (Half)
1
New Properties On Market
45
17%
Decrease In New Listings
Average Asking Price
$929,119
$153,353 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$281
$19 Increase In List Price/Sq. Ft.
Average Days On Market
13
32 Day
Decrease In Days On Market
Data as of Sep 20, 2024.
Remaining statistics above are calculated on activity within the period from Jul 01, 2024 to Aug 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.
Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance
Similar Listings
$3,150,000
2517 Southwind Rd
Berthoud, CO
4
Beds
| 7
Baths
| 5,819
Square Feet
Offered By David Johnson LIV Sotheby's Intl Realty
$2,900,000
560 Talons Reach Run
Berthoud, CO
3
Beds
| 4
Baths
| 3,091
Square Feet
Offered By Marie Raines Equity Colorado-Front Range
$2,700,000
2638 Southwind Rd
Berthoud, CO
4
Beds
| 5
Baths
| 6,000
Square Feet
Offered By Dominic East RE/MAX Alliance-FTC South
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 9/10/2024 at 12:35 pm