COMPLETED. UPGRADED. MOVE-IN READY. WHY WAIT TO BUILD? Experience the best of Heron Lakes in this beautifully designed patio home featuring a rare covered and screened porch overlooking meaningful open space, exceptional upgrades and immediate enjoyment~without the added time, uncertainty and expense of new construction. The bright, open main level offers nearly 2,000 square feet of thoughtfully designed living space with beautiful light engineered wood flooring, abundant natural light and an effortless flow for everyday living and entertaining. The spacious kitchen opens seamlessly to the dining area and great room, creating the perfect gathering space. The private primary suite is a relaxing retreat featuring a luxurious soaking tub, custom walk-in closet system and elegant ensuite bath. A spacious secondary bedroom welcomes family and guests, while the dedicated office/flex room is ideal for working from home, hobbies or additional sleeping space. One of the home's most exceptional features is the rare covered and screened porch overlooking meaningful open space~an inviting extension of the living area for enjoying Colorado's beautiful seasons in comfort and privacy. With 3,924 total square feet, including nearly 2,000 square feet of unfinished basement, you'll have endless possibilities for future expansion while enjoying abundant storage today. Located within the award-winning Heron Lakes at TPC Colorado, residents enjoy reduced golf membership opportunities, a state-of-the-art fitness center, resort-style pool, miles of scenic trails and some of Colorado's most breathtaking mountain and water views. This is luxury, low-maintenance living at its finest.
For sale
$875,000
3043 Newfound Lake Rd, Berthoud, CO 80513
2beds
3,924sqft
:
Get pre-qualified$5,677/mo
Single Family Residence
Built in 2024
5,526 Square Feet Lot
$-- Zestimate®
$223/sqft
$350/mo HOA
What's special
Resort-style poolAbundant storageElegant ensuite bathSpacious secondary bedroomBright open main levelPerfect gathering spaceAbundant natural light
- 133 days |
- 306 |
- 8 |
Zillow last checked:
Listing updated:
Listed by:
Jennifer Madrick 970-226-3990,
RE/MAX Alliance-FTC South
Source: IRES as distributed by MLS GRID,MLS#: 1054509
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
Primary bedroom
- Description: Engineered Hardwood
- Features: Luxury Features Primary Bath
- Level: Main
- Area: 252 Square Feet
- Dimensions: 21 x 12
Kitchen
- Description: Engineered Hardwood
- Level: Main
- Area: 275 Square Feet
- Dimensions: 25 x 11
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Electric Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
Features
- Eat-in Kitchen, Separate Dining Room, Open Floorplan, Kitchen Island
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full
Interior area
- Total structure area: 1,962
- Total interior livable area: 3,924 sqft
- Finished area above ground: 1,962
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Attached
- Attached garage spaces: 2
- Details: Attached
Accessibility
- Accessibility features: Level Lot
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System, Recreation Association Required
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 5,526 Square Feet
- Features: Level, Paved, Curbs, Sidewalks, Street Light, Fire Hydrant within 500 Feet
Details
- Parcel number: R1671708
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Patio Home
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Composition
Condition
- New construction: No
- Year built: 2024
Utilities & green energy
- Electric: Poudre Valley REA
- Gas: Xcel Energy
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available
Green energy
- Energy efficient items: Windows
Community & HOA
Community
- Features: Clubhouse, Pool, Sauna, Fitness Center, Trail(s)
- Security: Fire Alarm
- Subdivision: Heron Lakes 12th Fil
HOA
- Has HOA: Yes
- Services included: Common Amenities, Trash, Snow Removal, Maintenance Grounds, Management
- HOA fee: $1,800 annually
- HOA name: Heron Lakes
- Second HOA fee: $200 monthly
- Second HOA name: Northern Lights HOA
- Second HOA phone: 970-494-0609
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $223/sqft
- Tax assessed value: $1,015,000
- Annual tax amount: $11,443
- Date on market: 3/23/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 3/26/2026 | Listed for sale | $875,000-7.9%$223/sqft |
Source:  IRES as distributed by MLS GRID #1054509 Report a problem | ||
| 9/27/2024 | Sold | $950,000+0%$242/sqft |
Source: Public Record Report a problem | ||
| 7/27/2024 | Price change | $949,995-4.9%$242/sqft |
Source:  Toll Brothers Inc. Report a problem | ||
| 6/13/2024 | Listed for sale | $998,995$255/sqft |
Source: Toll Brothers Inc. Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $11,443 +216.6% | $63,437 +207.7% |
| 2024 | $3,614 +554.3% | $20,618 +2.9% |
| 2023 | $552 +2.2% | $20,032 +505.9% |
| 2022 | $540 +99.5% | $3,306 |
| 2021 | $271 | $3,306 +105.3% |
| 2020 | -- | $1,610 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 9/10Carrie Martin Elementary SchoolGrades: PK-5Distance: 0.8 mi
- 4/10Bill Reed Middle SchoolGrades: 6-8Distance: 3.9 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.2 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.
- $770,000-- bd-- ba-- sqft3039 Newfound Lake Rd, Berthoud, CO 80513Sold
- $883,1223 bd2 ba2.6k sqft3051 Newfound Lake Rd, Berthoud, CO 80513Sold
- $770,0002 bd2 ba4k sqft3039 Newfound Lake Rd, Berthoud, CO 80513Sold
- $875,000-- bd-- ba-- sqft3027 Newfound Lake Rd, Berthoud, CO 80513Sold
- $875,0003 bd3 ba4.2k sqft3027 Newfound Lake Rd, Berthoud, CO 80513Sold
- $500-- bd-- ba-- sqft3060 Piper Glen Dr, Berthoud, CO 80513Off Market
- $730,000-- bd-- ba-- sqft3015 Newfound Lake Rd, Berthoud, CO 80513Sold
- $4,8503 bd2 ba4.2k sqft3010 Newfound Lake Rd, Berthoud, CO 80513For Rent
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.
Similar homes
- $850,0004 bd4 ba3.4k sqft1543 Stoneseed St, Berthoud, CO 80513For Sale
MLS ID #1061688, Wynn Washle, Group Mulberry. IRES as distributed by MLS GRID - $695,0005 bd3 ba3.8k sqft1661 Vantage Pkwy, Berthoud, CO 80513For Sale
MLS ID #1063157, Jace Thorpe, Better Homes and Gardens Real Estate - Neuhaus. IRES as distributed by MLS GRID - $740,0004 bd4 ba4.7k sqft1149 Clara View Dr, Berthoud, CO 80513For Sale
MLS ID #1063355, Kelly Huelsing, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID - $679,9004 bd4 ba3k sqft2739 Prairie Flax St, Berthoud, CO 80513For Sale
MLS ID #1058254, Rob Kittle, Kittle Real Estate. IRES as distributed by MLS GRID - $749,9903 bd2 ba4.2k sqft376 Rustic Barn Ln, Berthoud, CO 80513New ConstructionIRES as distributed by MLS GRID
- $706,9903 bd2 ba4.1k sqft322 Rustic Barn Ln, Berthoud, CO 80513New ConstructionIRES as distributed by MLS GRID
- $575,0004 bd3 ba2.5k sqft1496 Biffle Ct, Berthoud, CO 80513For SaleMLS ID #1058718, Kristine Van Buskirk, Live West Realty. IRES as distributed by MLS GRID
- $1,099,0005 bd3 ba3.9k sqft1311 Eliza Ave, Berthoud, CO 80513For SaleMLS ID #1062244, Jeff Butler, Resident Realty. IRES as distributed by MLS GRID
- $650,0004 bd3 ba3.4k sqft1822 Westport Ave, Berthoud, CO 80513For SaleMLS ID #1062599, Kelly Huelsing, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID
- $865,0005 bd5 ba4.1k sqft6304 Icegrass Ave, Loveland, CO 80538For SaleMLS ID #1065298, Daniel Mark Valles, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID
- $525,0003 bd3 ba2.4k sqft1481 Harebell St, Berthoud, CO 80513For SaleMLS ID #1064000, Jason Filler, LIV Sotheby's Intl Realty. IRES as distributed by MLS GRID
- $575,0003 bd2 ba2.9k sqft214 Dorothy Dr, Berthoud, CO 80513For SaleMLS ID #1062718, Amy Ackerman, Coldwell Banker Realty-NOCO. IRES as distributed by MLS GRID
- $825,0004 bd3 ba3.5k sqft1799 Tinkers Dr, Windsor, CO 80550For SaleMLS ID #1065588, Kimberley Hattem, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $609,9903 bd3 ba3.3k sqft157 Buckwheat Ln, Berthoud, CO 80513New ConstructionIRES as distributed by MLS GRID
- $669,9904 bd2 ba2.1k sqft348 Rustic Barn Ln, Berthoud, CO 80513New ConstructionIRES as distributed by MLS GRID
- $884,0004 bd4 ba4.1k sqft6682 Crooked Stick Dr, Windsor, CO 80550For SaleMLS ID #1063735, Dennis Schick, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $885,0004 bd4 ba4.1k sqft2260 Spruce Creek Dr, Fort Collins, CO 80528For SaleMLS ID #1063522, Emily Jones, Group Harmony. IRES as distributed by MLS GRID
- $868,0005 bd4 ba4.1k sqft1881 Blossom Grove Drive, Windsor, CO 80550For Sale
MLS ID #4889345, David Kaercher, RE/MAX Real Estate Group Inc. REcolorado as distributed by MLS GRID - $895,0004 bd4 ba4.2k sqft5752 Northern Lights Dr, Fort Collins, CO 80528For SaleMLS ID #1058876, Martine Bonhoure, Coldwell Banker Realty- Fort Collins. IRES as distributed by MLS GRID
- $899,9005 bd4 ba4.7k sqft2119 Setting Sun Dr, Windsor, CO 80550For SaleMLS ID #1063592, Michal Jaques, Group Mulberry. IRES as distributed by MLS GRID
