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.
New construction
$2,300,000
2696 Bluewater Rd, Berthoud, CO 80513
4beds
4,910sqft
Single Family Residence
Built in 2027
10,400 Square Feet Lot
$-- Zestimate®
$468/sqft
$-- HOA
What's special
Striking fireplaceBreathtaking rocky mountain viewsCustom beamsSurrounded by three reservoirsPremium dacor appliancesSpacious walk-in pantryChef-inspired kitchen
- 60 days |
- 211 |
- 4 |
Zillow last checked:
Listing updated:
Listed by:
Brandi Aspinall 970-682-4972,
Berkshire Hathaway HomeServices Colorado Real Estate Erie,
Mark Aspinall 970-682-4972,
Berkshire Hathaway HomeServices Colorado Real Estate Erie
Source: IRES as distributed by MLS GRID,MLS#: 1057321
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 3
Primary bedroom
- Description: Carpet
- Features: Luxury Features Primary Bath, 5 Piece Primary Bath
- Level: Main
- Area: 256 Square Feet
- Dimensions: 16 x 16
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 176 Square Feet
- Dimensions: 11 x 16
Bedroom 3
- Description: Carpet
- Level: Basement
- Area: 225 Square Feet
- Dimensions: 15 x 15
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 225 Square Feet
- Dimensions: 15 x 15
Dining room
- Description: Tile
- Level: Main
Kitchen
- Description: Tile
- Level: Main
- Area: 1 Square Feet
- Dimensions: 1 x 1
Laundry
- Level: Main
Living room
- Description: Wood
- Level: Main
Recreation room
- Description: Carpet
- Level: Basement
Study
- Description: Wood
- Level: Main
- Area: 130 Square Feet
- Dimensions: 10 x 13
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, Two Primary Suites, High Ceilings
- Flooring: Wood
- Basement: Full,Partially Finished
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,910
- Total interior livable area: 4,910 sqft
- Finished area above ground: 2,455
- Finished area below ground: 2,455
Property
Parking
- Total spaces: 3
- Parking features: Attached, Oversized
- Attached garage spaces: 3
- Details: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Spa features: Community
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 10,400 Square Feet
- Features: Level, Near Golf Course, Abuts Private Open Space
Details
- Parcel number: R1661776
- Zoning: SFR
- Special conditions: Builder
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Composition
- Roof: Tile
Condition
- New construction: Yes
- Year built: 2027
Details
- Builder name: Quinn Custom Homes
Utilities & green energy
- Electric: PV REA
- Gas: Xcel
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Community & HOA
Community
- Features: Clubhouse, Pool, Fitness Center, Park, Trail(s)
- Subdivision: Heron Lakes 3rd Filing
HOA
- Has HOA: No
- Services included: Common Amenities, Management
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $468/sqft
- Annual tax amount: $12,263
- Date on market: 4/23/2026
- Listing terms: Cash,Conventional
- Exclusions: None
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 3/27/2026 | Listed for sale | $2,300,000+513.3%$468/sqft |
Source:  REcolorado as distributed by MLS GRID #8315073 Report a problem | ||
| 10/25/2022 | Sold | $375,000$76/sqft |
Source:  IRES as distributed by MLS GRID #971922 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 9/10Carrie Martin Elementary SchoolGrades: PK-5Distance: 1.4 mi
- 4/10Bill Reed Middle SchoolGrades: 6-8Distance: 4.4 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.6 mi
Schools provided by the listing agent
- Elementary: Carrie Martin
- Middle: Bill Reed
- High: Thompson Valley
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Colorado
- Larimer County
- Berthoud
- 80513
- 2696 Bluewater Rd
Nearby cities
Nearby zip codes
Other Berthoud Topics
