Last Sold Price
3 beds4,801 sqft$375/sqft
2648 Bluewater Rd, Berthoud, CO 80513

Description

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...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.
LISTING CLOSED: 06/24/2025 12:00 AM

  1. Listed by David Johnson • LIV Sotheby's Intl Realty D
    P: (970) 213-0648 djohnson@livsothebysrealty.com

Property Details for 2648 Bluewater Road

Status
MLS #
1025119
Days on Compass
153
Taxes
$10,000 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
2023
Lot Size
0.24 AC / 10,454 SF
Locale
Berthoud
Description 1
House

Location

Listing Courtesy of LIV Sotheby's Intl Realty D, David Johnson

Sold By RE/MAX Alliance-Loveland, Christine Motschall

Add your commute

Building Information for 2648 Bluewater Road

Stories-Year Built2023Building Size-Lot Size0.24 AC / 10,454 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$9,983 per month

30 year fixed, 6.55% Interest

Principal and Interest

$9,149

Property Taxes

$833

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 2648 Bluewater Road

Summary
Location and General Information
  • Road Access 2: City Street
  • Latitude: 40.34
  • Longitude: -105.12
Parking
  • Garage SqFt: 1154
  • Total Parking: 3.00
  • Parking Features: Oversized
Taxes and HOA Information
  • Fee Includes: Common Amenities, Management
  • Has HOA: No
  • HOA Fee: $.00
  • Legal Description: Lot 20, Block 10, Heron Lakes Third Filing, BER
  • Tax Information: Yes
  • HOA2 Fee Amount: $0
  • Tax Year: 2024
  • Metro Tax District Fee: $7,395
  • Metro Tax District Fee Freq Id: Annually
  • Metro Tax District Name: Berthoud Heritage
  • Metro Tax District Website: http://berthoudheritagemd.live
  • Tax Annual Amount: $10,000
  • Parcel Number: R1661772
Property
Lot Information
  • Lot Improvements: Level, Abuts Public Open Space, House Faces West, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet
  • Lot Size Area: 10,454.00
  • Has Irrigation Water Rights: No
  • Has Improvements: No
Property and Assessments
  • Total Finished Area Source: Plans
  • Living SqFt: 2659
  • Above Grade Finished Area Source: 2659
  • Sq Ft Apx: 2142
  • Total Finished Area: 2659
  • Property Attached YN: No
  • Are Ditches Active: No
  • New Construction YN: No
  • Levels: One and One Half
Utilities
  • Electric: REA
  • Sewer: Public Sewer
Interior and Exterior Features
Exterior Features
  • Construction Materials: Frame
  • Exterior Features: Sprinkler System, Balcony, Oversized Garage
  • Flooring: Wood
Interior Features
  • Interior Features: Eat-in Kitchen, Cathedral Ceiling(s), Pantry, Natural Woodwork, Washer/Dryer Hookup, Kitchen Island, High Ceilings, Full Primary Bath, Luxury Features Primary Bath
  • Laundry Features: Gas Range, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal, Fire Alarm
  • Window Features: Window Coverings
  • Fireplaces 1: Gas
  • All Bedrooms Conform: Yes
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Rough-in Bathrooms: 2
  • Three Quarters Bathrooms: 1
  • Baths Full Additional: 0
  • Baths Full Basement: 0
  • Baths Full Upper: 0
  • Baths Full Main: 1
  • Baths Full Lower: 0
  • Baths Half Additional: 0
  • Baths Half Basement: 0
  • Baths Half Upper: 0
  • Baths Half Main: 1
  • Baths Half Lower: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 0
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0
  • Baths Three Quarters Main: 1
Room Information
Room 1
  • RoomDescription: Luxury Vinyl
  • RoomLength: 12.0
  • RoomLevel: Main
  • RoomType: Bedroom 2
  • RoomWidth: 11.0
Room 2
  • RoomDescription: Luxury Vinyl
  • RoomLength: 15.0
  • RoomLevel: Main
  • RoomType: Bedroom 3
  • RoomWidth: 11.0
Room 3
  • RoomDescription: Luxury Vinyl
  • RoomLength: 14.0
  • RoomLevel: Main
  • RoomType: Dining Room
  • RoomWidth: 11.0
Room 4
  • RoomDescription: Luxury Vinyl
  • RoomLength: 21.0
  • RoomLevel: Main
  • RoomType: Great Room
  • RoomWidth: 17.0
Room 5
  • RoomDescription: Luxury Vinyl
  • RoomLength: 14.0
  • RoomLevel: Main
  • RoomType: Kitchen
  • RoomWidth: 14.0
Room 6
  • RoomDescription: Tile
  • RoomLength: 10.0
  • RoomType: Laundry
  • RoomWidth: 8.0
Room 7
  • RoomDescription: Luxury Vinyl
  • RoomLength: 14.0
  • RoomLevel: Main
  • RoomType: Primary Bedroom
  • RoomWidth: 14.0
  • Room Features: Full Primary Bath, Luxury Features Primary Bath
Room 8
  • RoomDescription: Carpet
  • RoomLength: 14.0
  • RoomLevel: Upper
  • RoomType: Study
  • RoomWidth: 13.0
Rental
Rental Information
  • Horse YN: No
  • Occupant Type: Owner

Property History for 2648 Bluewater Road

DateEvent & SourcePriceAppreciation
Jun 24, 2025

Sold (Public Record)

Public Record #1901673140

$1,800,000

+4.1% / yr

Mar 8, 2024

Sold (Public Record)

Public Record #1528208211

$1,709,500

+274.1% / yr

Jan 13, 2023

Sold (Public Record)

Public Record #1504024675

$375,000—
DateEvent & SourcePrice
06/24/2025

Sold (Public Record)

Public Record #1901673140

$1,800,000

+4.1% / yr

03/08/2024

Sold (Public Record)

Public Record #1528208211

$1,709,500

+274.1% / yr

01/13/2023

Sold (Public Record)

Public Record #1504024675

$375,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 2648 Bluewater Road

Taxable ValueLand$24,206Additions$62,288Total$86,494
Tax Record2025$15,089 ($1,257 / month)
Home Facts
Beds3Total Finished SqFt2,652 SqFtAbove Grade Finished SqFt2,652 SqFtStories2Lot Size10,271 SqFtStyleSingle Family ResidenceYear Built2023CountyLARIMERAPN94044-31-020Fireplace TypeHas Fireplace

Schools near 2648 Bluewater Road

This home is within Thompson R2-J School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Charter - K to 12
Rating
School
Distance
Carrie Martin Elementary School
PublicPK to 5

Bill Reed Middle School
Public6 to 8

Thompson Valley High School
Public9 to 12

Loveland Classical School
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of LIV Sotheby's Intl Realty D, David Johnson

Based on information submitted to the MLS GRID as of 10/20/2025 07:56 PM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX 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. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.