Skip main navigation
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

    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.

    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#: 1025119MLS Logo

    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