Much sought after Heron Lakes Villa with 200k in upgrades after the closing. This home backs to a lake and holes 2 and 3 at TPC Colorado. Amazing views right as you walk in greet you from the Kitchen, great room, ding and primary rooms. Large kitchen with gas cooktop, dual ovens, and large island. Plenty of room in the primary bedroom with 2 custom finished closets and large shower. Too many upgrades to list but a few include a new fireplace enlarging the great room area, custom closets inside the primary bedroom, electric window shades, casement trim around all windows and a custom barn door built in cabinets and wine fridge in the study. Perfect sized home for weekend getaways, summers, or full time with a blank canvas unfinished garden level basement. Ownership in Heron Lakes gets you multiple restaurants, workout room, resort style pool, access to Lonetree reservoir for boating, kayaking, paddleboards, and a discounted membership to TPC Colorado.
For sale
$1,075,000
2978 Newfound Lake Rd, Berthoud, CO 80513
3beds
4,002sqft
Est.: Get pre-qualified
Single Family Residence
Built in 2024
5,828 Square Feet Lot
$1,052,400 Zestimate®
$269/sqft
$300/mo HOA
What's special
Electric window shadesCustom barn doorLarge shower
- 4 days |
- 242 |
- 9 |
Zillow last checked:
Listing updated:
Listed by:
David Johnson 970-213-0648,
LIV Sotheby's Intl Realty D
Source: IRES as distributed by MLS GRID,MLS#: 1060485
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 3/4 bathrooms: 1
- Main level bathrooms: 2
Primary bedroom
- Description: Carpet
- Features: Full Primary Bath, Luxury Features Primary Bath
- Level: Main
- Area: 240 Square Feet
- Dimensions: 12 x 20
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12 x 12
Bedroom 3
- Description: Wood
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12 x 12
Dining room
- Description: Wood
- Level: Main
- Area: 132 Square Feet
- Dimensions: 11 x 12
Great room
- Description: Wood
- Level: Main
- Area: 350 Square Feet
- Dimensions: 14 x 25
Kitchen
- Description: Wood
- Level: Main
- Area: 165 Square Feet
- Dimensions: 11 x 15
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Open Floorplan, Kitchen Island
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full,Unfinished
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,002
- Total interior livable area: 4,002 sqft
- Finished area above ground: 2,001
- Finished area below ground: 2,001
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
- Details: Attached
Features
- Levels: One
- Stories: 1
- Exterior features: Sprinkler System, Balcony
- Spa features: Community
- Fencing: Partial
- Has view: Yes
- View description: Plains View, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 5,828 Square Feet
- Features: Rolling Slope, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet
Details
- Parcel number: R1671690
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Patio Home
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Tile
Condition
- New construction: No
- Year built: 2024
Details
- Builder name: Toll Brothers
Utilities & green energy
- Electric: REA
- Gas: XCEL
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available
Community & HOA
Community
- Features: Clubhouse, Pool, Fitness Center, Park, Trail(s), Gated
- Security: Fire Alarm
- Subdivision: Heron Lakes 12th Fil
HOA
- Has HOA: Yes
- Services included: Common Amenities, Snow Removal, Maintenance Grounds, Management, Utilities
- HOA fee: $300 monthly
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $269/sqft
- Annual tax amount: $12,653
- Date on market: 5/30/2026
- Listing terms: Cash,Conventional
- Exclusions: Seller's personal property
- Electric utility on property: Yes
- Road surface type: Asphalt
Estimated market value
$1,052,400
$1.00M - $1.11M
$3,020/mo
Price history
| Date | Event | Price |
|---|---|---|
| 5/30/2026 | Listed for sale | $1,075,000+19.4%$269/sqft |
Source:  IRES as distributed by MLS GRID #1060485 Report a problem | ||
| 5/7/2025 | Sold | $899,9950%$225/sqft |
Source: IRES as distributed by MLS GRID #1027489 Report a problem | ||
| 3/25/2025 | Pending sale | $900,000$225/sqft |
Source:  REcolorado as distributed by MLS GRID #9567014 Report a problem | ||
| 3/3/2025 | Price change | $900,000+0%$225/sqft |
Source: REcolorado as distributed by MLS GRID #IR1027489 Report a problem | ||
| 2/19/2025 | Price change | $899,9950%$225/sqft |
Source:  Toll Brothers Inc. Report a problem | ||
| 2/17/2025 | Listed for sale | $900,000$225/sqft |
Source: REcolorado as distributed by MLS GRID #9567014 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: 0.8 mi
- 4/10Bill Reed Middle SchoolGrades: 6-8Distance: 3.9 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.3 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
- 2978 Newfound Lake Rd
Nearby cities
Nearby zip codes
Other Berthoud Topics
