Welcome to an extraordinary estate nestled in The Rookery-the most coveted enclave within the TPC at Heron Lakes Subdivision. This remarkable home offers not only elegance and privacy but also a grandfathered-in TPC Golf Membership. This incredible luxury estate is spanning over 7,000 square feet of meticulously crafted living space, this architectural masterpiece showcases panoramic, unobstructed views of the Rocky Mountains and sits just steps from the famous Heron Lakes. As you step through the grand entrance, you're greeted by soaring vaulted ceilings, a striking fireplace centerpiece, and an ambiance of timeless sophistication. Designed with both beauty and function in mind, the home features five spacious en-suite bedrooms, including a luxurious main-floor primary suite. The gourmet kitchen is a chef's dream-equipped with JennAir appliances, a built-in Miele espresso machine, granite counter tops, large chefs island and so much more. Whole home is bathed in natural light. Every inch of this home exudes luxury, with high-end finishes and thoughtful details throughout. Hydraulic elevator provides seamless access to all levels, where you'll find a resort-style spa complete with a custom wet and dry sauna, relaxing water feature, and a fully equipped private gym-offering a true wellness retreat without ever leaving home. Residents of Heron Lakes enjoy access to unmatched neighborhood amenities, including a clubhouse, fine dining restaurants, resort-style pool, private fitness center, and miles of scenic walking and biking trails.This is more than a home-it's a lifestyle of elevated living and a true golfers dream.
For sale
$3,175,000
2732 Bluewater Rd, Berthoud, CO 80513
5beds
7,070sqft
Est.:
Residential-Detached, Residential
Built in 2022
0.29 Acres Lot
$-- Zestimate®
$449/sqft
$-- HOA
What's special
- 24 days
- on Zillow |
- 718 |
- 22 |
Zillow last checked: 7 hours ago
Listing updated: August 01, 2025 at 02:33pm
Listed by:
Celina Rodriguez 970-214-1106,
The Station Real Estate
Source: IRES,MLS#: 1038828

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 1
- 3/4 bathrooms: 3
- 1/2 bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Area: 299
- Dimensions: 23 x 13
Bedroom 2
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Area: 192
- Dimensions: 16 x 12
Bedroom 4
- Area: 144
- Dimensions: 12 x 12
Bedroom 5
- Area: 156
- Dimensions: 13 x 12
Dining room
- Area: 240
- Dimensions: 20 x 12
Family room
- Area: 378
- Dimensions: 27 x 14
Kitchen
- Area: 204
- Dimensions: 17 x 12
Living room
- Area: 266
- Dimensions: 19 x 14
Heating
- Forced Air
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Purifier Owned, Disposal
- Laundry: Sink, Washer/Dryer Hookups, Upper Level
Features
- Study Area, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Sauna, Wet Bar, Kitchen Island, Two Primary Suites, Steam Shower, Open Floor Plan, Walk-in Closet
- Flooring: Tile, Carpet
- Windows: Window Coverings, Double Pane Windows
- Basement: Full,Partially Finished,Rough-in for Radon
- Has fireplace: Yes
- Fireplace features: Gas, Double Sided, Living Room
Interior area
- Total structure area: 7,070
- Total interior livable area: 7,070 sqft
- Finished area above ground: 4,685
- Finished area below ground: 2,385
Property
Parking
- Total spaces: 4
- Parking features: Garage Door Opener, Oversized
- Attached garage spaces: 4
- Details: Garage Type: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry, Accessible Elevator Installed
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Lighting, Balcony, Hot Tub Included
- Spa features: Heated
- Fencing: Fenced,Wood
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 0.29 Acres
- Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Near Golf Course
Details
- Parcel number: R1661779
- Zoning: Res
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential-Detached, Residential
Materials
- Wood/Frame, Stone
- Roof: Tile
Condition
- Not New, Previously Owned
- New construction: No
- Year built: 2022
Utilities & green energy
- Electric: Electric, PVREA
- Gas: Natural Gas, Xcel
- Sewer: City Sewer
- Water: City Water, Town of Berthoud
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Trash: Republic Serv or United Waste
Green energy
- Energy efficient items: HVAC
Community & HOA
Community
- Features: Clubhouse, Pool, Fitness Center, Hiking/Biking Trails, Recreation Room, Gated
- Subdivision: Heron Lakes 3rd Filing
HOA
- Has HOA: No
- Services included: Common Amenities, Management
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $449/sqft
- Annual tax amount: $15,757
- Date on market: 7/10/2025
- Listing terms: Cash,Conventional
- Exclusions: Seller's Personal Property
- Electric utility on property: Yes
- Road surface type: Paved
- Loading
- Loading