Beautiful Custom Home located in the gated Rookery section of Heron Lakes/TPC Colorado. The Rookery is a gated part of the community with a golf membership to the TPC Course deeded to the house! This home has the primary bedroom and 2 other bedroom on the main floor, The spacious living room is showcased by large custom beams, a floor to ceiling modern gas fireplace and custom built-ins. The show stopping kitchen features a large island with built in storage, huge sink, gas stove/range, and custom hidden walk-in pantry. There is additional flex space in the loft area, which could be used as a study or an additional bedroom. The loft has a cedar planked ceiling, custom built-ins with murphy bed and private patio. This home has so many fabulous designer finishes; custom closet systems throughout, custom blinds, heated bathroom floors in the primary, solid core interior doors, hand troweled textured walls, triple slider doors at great room, 2 zone heating and a tankless water heater. The 1154 sq ft garage offers a dog wash, hot and cold water and is roughed in for a future heater. Outside you will love the fully professionally landscaped yard, huge covered rear patio with cedar planking on the ceiling. Enjoy the ease of having gas pre-stubbed for grilling and future firepit. This resort style neighborhood includes TPC Colorado golf course, trails, pool, hot tub, workout facilities, restaurants and more.
Sold for $1,800,000 on 06/24/25
$1,800,000
2648 Bluewater Rd, Berthoud, CO 80513
3beds
4,801sqft
Residential-Detached, Residential
Built in 2023
10,454 Square Feet Lot
$1,792,200 Zestimate®
$375/sqft
$4,185 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: June 25, 2025 at 08:17am
Listed by:
David Johnson 303-893-3200,
LIV Sotheby's Intl Realty D
Bought with:
Christine Motschall
RE/MAX Alliance-Loveland
Source: IRES,MLS#: 1025119

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bedrooms: 3
Primary bedroom
- Area: 196
- Dimensions: 14 x 14
Bedroom 2
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Area: 165
- Dimensions: 15 x 11
Dining room
- Area: 154
- Dimensions: 14 x 11
Kitchen
- Area: 196
- Dimensions: 14 x 14
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
- Laundry: Washer/Dryer Hookups
Features
- Study Area, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Pantry, Stain/Natural Trim, Kitchen Island, High Ceilings, 9ft+ Ceilings
- Flooring: Wood, Wood Floors, Tile, Carpet
- Windows: Window Coverings
- Basement: Full,Unfinished
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,801
- Total interior livable area: 4,801 sqft
- Finished area above ground: 2,659
- Finished area below ground: 2,142
Property
Parking
- Total spaces: 3
- Parking features: Oversized
- Attached garage spaces: 3
- Details: Garage Type: Attached
Features
- Levels: One and One Half
- Stories: 1
- Patio & porch: Deck
- Exterior features: Lighting, Balcony
- Spa features: Community
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 10,454 sqft
- Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level, Abuts Public Open Space
Details
- Parcel number: R1661772
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary/Modern
- Property subtype: Residential-Detached, Residential
Materials
- Wood/Frame
- Roof: Tile
Condition
- Not New, Previously Owned
- New construction: No
- Year built: 2023
Details
- Builder name: Custom On Site
Utilities & green energy
- Electric: Electric, REA
- Gas: Natural Gas, XCEL
- Sewer: City Sewer
- Water: City Water, Town of Berthoud
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Trash: Step Up Disposals
Community & neighborhood
Community
- Community features: Clubhouse, Hot Tub, Pool, Fitness Center, Hiking/Biking Trails, Recreation Room, Gated
Location
- Region: Berthoud
- Subdivision: Heron Lakes
Other
Other facts
- Listing terms: Cash,Conventional
- Road surface type: Paved, Asphalt
Services availability
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,792,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,792,200