Sold
Last Sold Price
3 beds4,801 sqft

2648 Bluewater Rd, Berthoud, CO 80513

Single FamilyProperty Type
0.24 acresLot Size
2023Year Built
$375/sq ftPrice per sq ft
3 carsParking Spaces

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.
  • Listed by: David Johnson 970.213.0648 djohnson@livsothebysrealty.com • LIV Sotheby's Intl Realty D
Listing closed: 06/24/2025 12:00 AM • Source: IRES as distributed by MLS GRID, MLS#: 1025119
See It First™ on Compass

Find homes before they're listed on other real estate sites.

Start your search

Recent comparable sales

Median sold price

$1,255,000

Avg days on market

124

Sale-to-list ratio

123.6%

Berthoud, CO

9 comparable properties found

$1,255,000 | 2932 Heron Lakes Parkway, Berthoud, CO 80513
1/51
1

$1,255,000

Sold 08/25/25

3
Bedrooms
4,788
Square Feet
0.23
Acres
$1,320,000 | 3344 Danzante Bay Court, Berthoud, CO 80513
1/38
2

$1,320,000

Sold 06/05/26

3
Bedrooms
4,244
Square Feet
0.13
Acres
$1,400,000 | 1336 Paramount Drive, Berthoud, CO 80513
1/49
3

$1,400,000

Sold 07/22/26

3
Bedrooms
4,234
Square Feet
2
Acres
$1,601,137 | 2757 Heron Lakes Parkway, Berthoud, CO 80513
1/23
4

$1,601,137

Sold 12/19/24

2
Bedrooms
4,869
Square Feet
0.2
Acres
a front view of a house with a yard
1/34
5

$960,000

Sold 04/02/25

3
Bedrooms
4,297
Square Feet
0.13
Acres
a front view of a house with a yard and garage
1/41
6

$1,700,000

Sold 05/30/25

3
Bedrooms
5,381
Square Feet
0.25
Acres
an aerial view of a house with a garden and lake view
1/40
7

$950,000

Sold 04/25/25

3
Bedrooms
4,460
Square Feet
0.14
Acres
a front view of a house with a yard
1/7
8

$972,000

Sold 03/31/25

3
Bedrooms
4,627
Square Feet
0.16
Acres
a front view of a house with a yard and garage
1/47
9

$810,000

Sold 01/29/26

3
Bedrooms
4,111
Square Feet
0.13
Acres

Location

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

Sold By RE/MAX Alliance-Loveland, Christine Motschall

Add your commute
Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$10,443 per month

30 year fixed, 7.03% Interest

Principal and Interest

$9,609

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

Property Details

  • Taxes: $10,000 / year
  • MLS Type: Residential / Single Family Residence
  • Locale: Berthoud
  • Description 1: House

Building Information

  • Year Built: 2023
  • Lot Size: 0.24 AC / 10,454 SF

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 Value

Land

$24,206

Additions

$62,288
Total$86,494

Tax Record

2025

$15,089 ($1,257 / month)

Home Facts

Beds

3

Baths

4.2

Total Finished SqFt

2,652 SqFt

Above Grade Finished SqFt

2,652 SqFt

Stories

1

Lot Size

10,271 SqFt

Style

Single Family Residence

Year Built

2023

Year Renovated

2023

County

LARIMER

APN

R1661772

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

New listings in 80513

$469,900 | 228 East 4th Street, Berthoud, CO 80513
1/36

RE/MAX Town and Country • MLS #1070055

New

$469,900

3
Bedrooms
1,963
Square Feet
0.14
Acres
$890,000 | 2238 Breckenridge Drive, Berthoud, CO 80513
1/28

Northern Colorado Real Estate • MLS #1070058

New

$890,000

3
Bedrooms
4,200
Square Feet
0.44
Acres
$485,000 | 820 13th Street, Berthoud, CO 80513
1/34

MB Boulder Suburban Homes • MLS #1070017

$485,000

2
Bedrooms
2,648
Square Feet
0.1
Acres
$1,075,000 | 3010 Newfound Lk Road, Berthoud, CO 80513
1/36

LoKation • MLS #3902415

$1,075,000

3
Bedrooms
4,262
Square Feet
0.13
Acres
$1,324,999 | 1424 Burt Avenue, Berthoud, CO 80513
1/47

RE/MAX Alliance-Longmont • MLS #1069747

$1,324,999

5
Bedrooms
4,462
Square Feet
0.22
Acres
$1,550,000 | 20509 County Road 3, Berthoud, CO 80513
1/49

C3 Real Estate Solutions, LLC • MLS #1069749

$1,550,000

5
Bedrooms
5,152
Square Feet
3.81
Acres
$625,000 | 2431 Nicholson Street, Berthoud, CO 80513
1/33

Berkshire Hathaway HomeServices Rocky Mtn Realtors • MLS #5764955

$625,000

4
Bedrooms
3,154
Square Feet
0.17
Acres
$549,000 | 307 East Michigan Avenue, Berthoud, CO 80513
1/38

WK Real Estate • MLS #1069783

$549,000

4
Bedrooms
2,076
Square Feet
0.18
Acres
$789,000 | 2736 Prairie Flax Street, Berthoud, CO 80513
1/44

Resident Realty • MLS #1069804

$789,000

4
Bedrooms
3,052
Square Feet
0.1
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 2648 Bluewater Road, Berthoud, CO 80513
$1,800,000
3
4,801
10,454
$425,000
–
–
–
12,632
$1,550,000
–
–
–
17,859
$375,000
–
–
–
10,454
$1,850,000
–
–
–
25,700
$1,550,000
–
–
–
17,859

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.