Lake Homes Realty
Enter City, Zip or MLS

2696 bluewater rd

Berthoud, CO 80513

$2,300,000

4 BEDS 5 BATHS
4,910 SQFT0.23 AC LOT
Residential - Single Family
Image 1: Rendering placed on the lot
Image 2: Rendering placed on the lot
Image 3: Mountain and Lake Views
Image 4
Bedrooms 4
Total Baths 5
Full Baths 3
Square Feet 4910
Acreage 0.24
Status Active
MLS # 8315073
County Larimer
More Info
Category Residential - Single Family
Status Active
Square Feet 4910
Acreage 0.24
MLS # 8315073
County Larimer
Listed By: Listing Agent Brandi Aspinall
Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Erie - (970) 682-4972
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.
Location not available
Listing
Street
Satellite

Exterior Features

  • Construction Single Family Residence
  • Siding Frame, Stone, Composition
  • Exterior Sprinkler System
  • Roof Composition
  • Garage Yes
  • Garage Description Attached
  • Water City
  • Sewer Public Sewer
  • Lot Description Level, Abuts Private Open Space, House Faces West

Interior Features

  • Appliances Dishwasher, Refrigerator, Microwave, Disposal
  • Heating Forced Air, Humidity Control
  • Cooling Wall/Window Unit(s)
  • Basement Full, Partially Finished, Walk-Out Access, Sump Pump
  • Fireplaces Description Living Room, One
  • Living Area 4,910 SQFT
  • Year Built 2027
  • Stories One

Neighborhood & Schools

  • Subdivision Heron Lakes 3rd Filing
  • School Disrict Thompson R2-J
  • Elementary School Carrie Martin
  • Middle School Bill Reed
  • High School Thompson Valley

Financial Information

    Additional Services

    Internet Service Providers

    Listing Information

    Listing Provided Courtesy of Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Erie - (970) 682-4972
    Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

    Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

    Based on information submitted to the MLS GRID as of 07/03/2026 03:58:13 UTC. 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.

    The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

    The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

    © 2026 IRESDS MLS, Inc.
    Listing data is current as of 07/03/2026.

    Contact Our Agent

    By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.