Winner of the 2025 Northern Colorado Parade of Homes, Best Primary Suite, Best Craftsmanship, Overall Winner Best Home. Spectacular Custom home in the gated Rookery section of Heron Lakes. This is one of the best floorplans I have seen in 25 years of real estate. From the exquisite Cape Cod exterior, the welcoming front porch, and grand entrance this home makes a statement from the moment you pull up. Vaulted 20-foot beamed ceiling greet you as you enter the front door to the great room and chef's kitchen and huge patio with covered deck. High end AGA stove, Wolf and Sub Zero appliances, and butler's pantry makes this dream kitchen a reality. Primary bedroom is spacious with lake views, beautiful tub, steam shower, and finished closet with washer and dryer. Main floor study and staircase with wainscoting, and second bedroom with on suite. Attached dwelling unit over the garage has over 800 sq ft of living space, kitchen area and full bath. Spacious basement rec room, bar area, golf simulator setup, workout room, 2 more bedrooms with full baths and a storage area with stairs to the garage. 5 car garage with 1442 sq ft, is heated, and has the ability to store a boat. Beautifully landscaped with fire pit and views of the lake and front range mountains. A full deeded membership is included with this home. Golf, restaurants, workout facility, resort style pool, trails and boating on Lonetree are all part of living in Heron Lakes at TPC Colorado.
Single-familyProperty Type
2025Year Built
0.4 acresLot Size
$463Price/Sq.Ft.
5 car garageParking
Listed by David Johnson• LIV Sotheby's Intl Realty D
Contact: 3038933200
Bought with David Johnson• LIV Sotheby's Intl Realty D
Lot Features: Golf Course Neighborhood, Abuts Pond/Lake, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet, Water Rights Excluded, Mineral Rights Excluded
Road Surface Type: Asphalt
Road Frontage Type: City Street
Financial
Tax Information
Tax Annual Amount: $19,408
Tax Year: 2024
Utilities
Utility Information
Water Source: City
Has Water Rights: No
Is Water Meter Installed: Yes
Sewer: Public Sewer
Utilities: Natural Gas Available, Electricity Available, Cable Available
Gas: XCEL
Trash: Step Up Disposals
Location
HOA Information
Association Fee YN: No
Association Transfer Fee: No
Association Reserve: No
Association Fee2 YN: No
Association Transfer Fee2: No
Association Fee Includes: Common Amenities, Management, Utilities
School Information
Elementary School: Carrie Martin
Middle Or Junior High School: Bill Reed
High School: Thompson Valley
High School District: Thompson R2-J
Community Information
Community Features: Clubhouse, Pool, Fitness Center, Trail(s), Recreation Room, Gated
Public facts
Beds: 7
Baths: 6.0
Sq. Ft.: 7,078
Stories: 1.5
Lot Size: 0.4 acres
Style: Single Family Residential
Year Built: 2024
Year Renovated: 2024
County: Larimer County
APN: R1661713
Home facts updated by county records on Jul 30, 2026
Other
Home Information
Builder Name: Stonebrook Homes
Builder Model: Custom
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.5mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.7mi
4/10
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
2% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 19 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
89
61
86
59
82
53
69
42
55
30
53
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 1% for direct sun exposure in the zip code. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.2 hrs
6.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$3.12M – $3.78M
Reach more buyers when you sell with Redfin. Plus, you'll save $32,822 in fees.