Public Remarks: Former MODEL Home by Lifestyle Custom Homes. Enclosed front patio w/fire pit & west facing views. Custom ceiling beams throughout. Gourmet kitchen with top-of-the-line Miele appliance package. The owner's suite has custom ceiling detail and a private balcony & the owner's bathroom is pure luxury with heated flooring and an attached laundry room. Covered back patio w/fire pit & outdoor kitchen w/BBQ. Basement has a golf simulator room! Wine cellar & pub-style bar. 5 Bedroom home with large walk-in closets & en-suites for every Bedroom. Located in TPC COLORADO at Heron Lakes.. Located in The Rookery, the Gated section of Heron Lakes also includes Full TPC Membership.
Single-familyProperty Type
2019Year Built
10,400 sq ftLot Size
$331Est. Price/Sq.Ft.
3 car garageParking
Listed by Melissa Maersk-Moller• C3 Real Estate Solutions, LLC
Former MODEL Home by Lifestyle Custom Homes. Enclosed front patio w/fire pit & west facing views. Custom ceiling beams throughout. Gourmet kitchen with top-of-the-line Miele appliance package. The owner's suite has custom ceiling detail and a private balcony & the owner's bathroom is pure luxury with heated flooring and an attached laundry room. Covered back patio w/fire pit & outdoor kitchen w/BBQ. Basement has a golf simulator room! Wine cellar & pub-style bar. 5 Bedroom home with large walk-in closets & en-suites for every Bedroom. Located in TPC COLORADO at Heron Lakes.. Located in The Rookery, the Gated section of Heron Lakes also includes Full TPC Membership.
IRES as Distributed by MLS Grid #905993
Mar 6, 2020
Sold
$1,525,000
$285/sq ft
Jan 8, 2020
Listed
$1,525,000
$285/sq ft
+35
Public Remarks
Sold before published. Our Custom Avanti floorplan. Model home with so many custom features: Courtyard entry, 2 outdoor firepits, built in BBQ, covered back patio, heated garages. Interior featuring gourmet kitchen with Miele' applainces, master retreat, radiant floor heating, 12 foot ceilings in main living, Napoleon fireplace, light fixtures by Fusion. Basement has 10 ft ceilings, custom wine room and pub style bar, built in simulator, theater system and a safe room. Fully Landscaped as part of our standards. Not a detail has been missed.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
5
Baths
6
Stories
1
Lot width
—
Lot depth
—
Lot size
10,400 Sq. Ft.
Year renovated
2018
Sq. Ft.
4,439
Year built
2018
Style
Single Family Residential
County
Larimer County
APN
R1661777
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 21, 2026.
R1
Single Family District
The R1 District provides for the development of low to moderate density single family residential dwellings.
Permitted uses
Include but are not limited to:
Garden center
Infrastructure
Educational/school
Museum / gallery
Park & open space
Property details
Parking
Parking Features
Covered Spaces: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Interior
Bathroom Information
Bathrooms (Full): 5
Bathrooms (Half): 2
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 5
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Accessibility Features: Main Floor Bath, Main Level Bedroom, Main Level Laundry
Gas Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator
Fireplace: Yes
Fireplace Features: Gas, Gas Logs Included
Flooring: Wood Floors
Study Area, High Speed Internet, Eat-in Kitchen, Open Floorplan, Pantry, Kitchen Island
Laundry Features: Washer/Dryer Hookups, Main Level
Exterior
Exterior Features
Fencing: Partial
Patio and Porch Features: Patio, Deck
Roof: Tile
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level
Road Frontage Type: City Street
Zoning: RES
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Heron Lakes 3rd Filing
MLS Area Major: Loveland/Berthoud
Building Information
Above Grade Finished Area: 2675
Below Grade Finished Area: 2675
Builder Name: Lifestyle Custom- Ed Rust
Building Area Total: 2675
Construction Materials: Wood/Frame
Financial
Tax Information
Parcel Number: R1661777
Tax Annual Amount: 9003
Tax Year: 2020
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Cable Available
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: Yes
Association Fee: 5400
Association Fee Frequency: Annually
Association Fee Includes: Common Amenities
Community Features: Clubhouse, Pool, Park, Hiking/Biking Trails
School Information
High School District: Thompson R2-J
Elementary School: Carrie Martin
Middle or Junior School: Bill Reed
High School: Thompson Valley
Location Information
Directions: Berthoud Lakes Parkway AKA TaftNorth on Berthoud Lakes Pkwy Take round about into the TPC Colorado Golf Course,Right Right on Heron Lakes, Left on Southwind Pull up to the Rookery Gates Sensor will open gates, right at the gate left on Bluewater
Unparsed Address: 2702 Bluewater Rd Berthoud CO 80513
Street Number: 2702
Street Name: Bluewater
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.117921,40.337945
Latitude: 40.337945
Longitude: -105.117921
Public facts
Beds: 5
Baths: 6.0
Sq. Ft.: 4,439
Stories: 1.0
Lot Size: 10,400 square feet
Style: Single Family Residential
Year Built: 2018
Year Renovated: 2018
County: Larimer County
APN: R1661777
Home facts updated by county records on Oct 21, 2026
Other
Miscellaneous Information
Exclusions: Basement Washer and Dryer TVs Except outdoor Tv Fridge in Garage Ice Maker on the deck
Listing Information
Attribution Contact: 9702255152
Close Price: $1,900,000
Photos Count: 39
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, April 22, 2022
Cumulative Days on Market: 78
Days on Market: 78
Listing Contract Date: Friday, February 4, 2022
Modification Timestamp: Thursday, August 1, 2024 7:09 PM
Home Information
Window Features: Window Coverings
Year Built: 2019
Around this home
Schools
Carrie Martin Elementary School
Public PreK-5 • Assigned • 1.4mi
8/10
Bill Reed Middle School
Public 6-8 • Assigned • 4.4mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.6mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
1% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 18 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
6 unhealthy days expected this year, 7 days in 30 years
Provided by First Street
Historical weather
Berthoud, CO • 80513
Average low and high temperatures (°F)
42
17
52
23
65
36
65
38
72
46
85
56
91
62
86
59
79
52
69
42
55
30
53
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 5.9 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
5.9 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.68M – $2.04M
Reach more buyers when you sell with Redfin. Save up to $17,721 in fees.3 minutes to get started.