$2,300,000

2696 Bluewater Rd Berthoud, CO 80513

Berthoud Area

Estimated payment $13,651/month

Total Views 12,618
4 Beds
5 Baths
4,910 Sq Ft
$468 Price per Sq Ft

Highlights

  • Home Theater
  • New Construction
  • Lake View
  • Carrie Martin Elementary School Rated 9+
  • Primary Bedroom Suite
  • Open Floorplan

About This Home

Imagine building a home designed entirely around the way you want to live.Located within the gated Rookery enclave of Heron Lakes at TPC Colorado, this rare homesite offers the opportunity to create a truly custom home with Quinn Custom Homes, a trusted local builder with more than 30 years of experience. Choose from the builder's plan, customize it to suit your lifestyle, or bring your own vision and floor plan to create a one-of-a-kind home from the ground up. Surrounded by three reservoirs, miles of trails, wildlife, and breathtaking Rocky Mountain views, this is more than a place to live-it's a lifestyle defined by space, serenity, and connection to Colorado's natural beauty. Included TPC Charter Resident Membership provides access to world-class golf, dining, fitness, and resort-style amenities just moments from your door. The featured home concept highlights the craftsmanship and quality Quinn Custom Homes is known for. Expansive windows fill the home with natural light, while soaring ceilings, warm wood accents, custom beams, and a striking fireplace create an atmosphere that feels both sophisticated and welcoming. The open-concept layout centers around a chef-inspired kitchen featuring a quartz waterfall island, premium Dacor appliances, and a spacious walk-in pantry. The primary suite serves as a private retreat with a spa bath. A finished walkout basement provides flexibility for entertaining, guests, fitness, or recreation. Built with comfort, efficiency, and modern living in mind, the home incorporates high-performance construction, smart home readiness, energy-efficient systems, and an oversized three-car garage with EV charging capability. Whether you select the builder's plan, personalize every detail, or bring a completely custom design to life, this is a rare opportunity to build your dream home in one of Northern Colorado's most sought-after luxury communities. Live more intentionally. Live more connected. Live immersed in the Colorado lifestyle.

Listing Agent

Brandi Aspinall

Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie Brokerage Email: brandi@livingCOelite.com,970-682-4972 License #100052550 Listed on: 03/27/2026

Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie

Co-Listing Agent

Mark Aspinall

Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie Brokerage Email: brandi@livingCOelite.com,970-682-4972 License #100071049

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,263

Year Built

  • New Construction

Lot Details

  • 10,454 Sq Ft Lot
  • West Facing Home
  • Level Lot
  • Front and Back Yard Sprinklers

Parking

  • 3 Car Attached Garage
  • Electric Vehicle Home Charger
  • Insulated Garage
  • Dry Walled Garage
  • Epoxy Flooring

Property Views

  • Lake
  • Mountain

Home Design

  • Frame Construction
  • Composition Roof
  • Cement Siding
  • Stone Siding

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wired For Data
  • Built-In Features
  • Bar Fridge
  • Vaulted Ceiling
  • Family Room
  • Living Room with Fireplace
  • Dining Room
  • Home Theater
  • Home Office
  • Smart Thermostat
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Oven
  • Range with Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms | 2 Main Level Bedrooms
  • Primary Bedroom Suite
  • En-Suite Bathroom
  • Walk-In Closet

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Stubbed For A Bathroom
  • 2 Bedrooms in Basement

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows
  • Energy-Efficient HVAC
  • Energy-Efficient Lighting
  • Energy-Efficient Insulation
  • Energy-Efficient Thermostat
  • Smart Irrigation

Outdoor Features

  • Covered Patio or Porch

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Utilities

  • Mini Split Air Conditioners
  • Humidifier
  • Forced Air Heating System
  • 220 Volts
  • 220 Volts in Garage
  • 110 Volts
  • Natural Gas Connected
  • High-Efficiency Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Heron Lakes 3Rd Filing Subdivision, Modern Prairie Ranch Floorplan
  • Greenbelt

Listing and Financial Details

  • Assessor Parcel Number R1661776

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,263

Year Built

New Construction

Lot Details

10,454 Sq Ft Lot

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: One
  • Year Built: 2027
  • Above Grade Finished Sq Ft: 2455
  • Exclusions: None
  • Living Area: 4910
  • Property Condition: New Construction
  • SubdivisionName: Heron Lakes 3rd Filing
  • Co List Office Mls Id: RECIRE06
  • Ownership: Builder
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 2
  • REC_ExpectedActiveDate: 2026-03-27
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • New Home Available Options: All appliances and interior features are completely customizable. Finishes chosen by buyer.
  • REC_AdditionalLivingStructureYN: 0
  • Special Features: NewHome

Interior Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Humidifier, Microwave, Oven, Range, Range Hood, Refrigerator
  • Fireplaces: 1
  • Interior Amenities: Built-in Features, Eat-in Kitchen, Five Piece Bath, High Ceilings, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s), Wired for Data
  • Fireplace Features: Living Room
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Basement: Bath/Stubbed, Finished, Full, Sump Pump, Walk-Out Access
  • Basement: Yes
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 2455
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 2

Exterior Features

  • Direction Faces: West
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame, Stone
  • View: Lake, Mountain(s)
  • Exterior Features: Gas Valve, Smart Irrigation
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public

Garage/Parking

  • Parking Features: 220 Volts, Dry Walled, Finished Garage, Floor Coating, Insulated Garage
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Air Conditioning-Room
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V, 220 Volts

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00

Schools

  • Middle Or Junior School: Bill Reed

Lot Info

  • Parcel Number: R1661776
  • Lot Size Acres: 0.24
  • Building Area Total: 4910
  • Lot Features: Greenbelt, Level, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 10454.4

Green Features

  • Green Energy Efficient: Appliances, HVAC, Insulation, Lighting, Thermostat, Water Heater, Windows

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 12263

MLS Schools

  • Elementary School: Carrie Martin
  • High School: Thompson Valley

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $12,263 $72,684 $72,684
2024 $3,299 $20,032 $20,032
2022 $6,460 $39,585 $39,585 $0
2021 $6,163 $37,961 $37,961 $0
2020 $6,016 $35,757 $35,757 $0
2019 $5,918 $35,757 $35,757 $0
2018 $862 $5,278 $5,278 $0
2017 $721 $5,278 $5,278 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/27/2026 03/27/26 For Sale $2,300,000 +513.3% $468 / Sq Ft
10/25/2022 10/25/22 Sold $375,000 0.0% -- View Prior Sale
07/26/2022 07/26/22 For Sale $375,000 -- --
Source: REcolorado®

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Corporate Deed $66,083,900 --
Special Warranty Deed $375,000 Ascendant Title
Quit Claim Deed -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $281,250 New Conventional
Source: Public Records

Source: REcolorado®

MLS Number: 8315073

REcolorado®

APN: 94044-31-024

Your Personal Tour Guide

Ask me questions while you tour the home.