$1,225,000
PENDING $25K PRICE DROP

2940 Newfound Lake Rd Berthoud, CO 80513

Berthoud Area

Estimated payment $8,171/month

Total Views 17,238
4 Beds
3 Baths
4,238 Sq Ft
$289 Price per Sq Ft

Highlights

  • Water Views
  • Golf Course Community
  • Gated Community
  • Berthoud Elementary School Rated A-
  • Fitness Center
  • 2-minute walk to Gateway Park

About This Home

Experience resort-style living w/ sweeping golf course, lake, & mountain views from this ranch home on the 3rd hole of TPC Heron Lakes. Perfectly positioned away from tees & greens, it offers rare privacy & unobstructed scenery through oversized windows & a 3-panel sliding door that blends indoor/outdoor living. Open-concept main level features an expanded chef's kitchen w/ quartz island, abundant cabinetry, & seamless flow into the great room. Floor-to-ceiling gas fireplace & rich hardwood floors create a warm, elevated feel. Step onto the covered deck & enjoy panoramic fairway, water, & mountain views-ideal for morning coffee or sunset evenings. The primary suite is a true retreat w/ dual walk-in closets & a spa-inspired bath w/ oversized shower, double vanity, & private water closet. A flexible main-level office (or 5th bedroom) + bedroom, full bath, & laundry add convenience/versatility for everyday living. Garden-level basement expands living space w/ two large bedrooms featuring daylight windows & walk-in closets, + a spacious entertainment area w/ fireplace & a generous bonus room ideal for a wet bar, kitchenette, gym, or craft space. Excellent storage throughout supports long-term livability. Outdoor living continues w/ a fenced yard, xeriscaping, & a peaceful mountain-view seating area designed for relaxation & entertaining. HOA-covered lawn care and snow removal provide true lock-and-leave ease-perfect for full-time living or a low-maintenance second home. Located in the highly desirable Heron Lakes community, residents enjoy resort-style amenities including clubhouse dining, a resort pool w/ swim-up bar, year-round fitness center, & miles of scenic trails. Optional membership to Lone Tree Reservoir adds boating, paddleboarding, & summer recreation just minutes away. Rare opportunity to own a move-in-ready ranch in one of Northern Colorado's premier golf communities-where every day feels like a getaway surrounded by water, mountains, & championship golf!

Listing Agent

Lydia Creasey

RE/MAX Alliance-Olde Town Brokerage Phone: 3038008439 License #100000427 Listed on: 06/11/2026

Co-Listing Agent

James Dixon

RE/MAX Alliance-Olde Town Brokerage Phone: 3038008439 License #100088223

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,023

Year Built

  • Built in 2022

Lot Details

  • 5,663 Sq Ft Lot
  • West Facing Home
  • Southern Exposure
  • Aluminum or Metal Fence
  • Xeriscape Landscape
  • Paved or Partially Paved Lot
  • Level Lot
  • Sprinkler System

HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway Level

Property Views

  • Water
  • Mountain
  • Hills

Home Design

  • Contemporary Architecture
  • Composition Roof
  • Concrete Siding

Interior Spaces

  • 4,238 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • High Ceiling
  • Multiple Fireplaces
  • Gas Fireplace
  • Window Treatments
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Dining Room
  • Wood Flooring

Kitchen

  • Eat-In Kitchen
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Primary bathroom on main floor
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Natural lighting in basement

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Additional Features

  • Energy-Efficient Windows
  • Deck
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number R1671694

Community Details

Overview

  • Association fees include common amenities, snow removal, ground maintenance
  • Northern Lights HOA Kellison Association, Phone Number (970) 494-0609
  • Heron Lakes Metro Association
  • Built by Toll Brothers
  • Heron Lakes 12Th Fil Subdivision, Boyd Modern Ranch Floorplan

Amenities

  • Clubhouse
  • Recreation Room

Recreation

  • Golf Course Community
  • Fitness Center
  • Community Pool
  • Community Spa
  • Park
  • Trails

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,023

Year Built

Built in 2022

Lot Details

5,663 Sq Ft Lot

HOA Fees

$275 per month

Parking

2

Listing Details

  • Year Built: 2022
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.13
  • Road Frontage Type: City Street
  • Road Surface Type: Concrete
  • Co List Office Mls Id: IRERMOT1
  • Subdivision Name: Heron Lakes 12th Fil
  • Architectural Style: Contemporary
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Sun Space, Southern Exposure, Windows
  • Property Attached Yn: No
  • Attribution Contact: 3038008439
  • RoomType: Bedroom 4
  • RoomType: Dining Room
  • RoomType: Family Room
  • RoomType: Kitchen
  • RoomType: Laundry
  • RoomType: Living Room
  • RoomFeatures: 3/4 Primary Bath
  • IRE_AssociationFeeYN: Yes
  • IRE_AssociationYN2: 1
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 4238
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • RoomType: Primary Bedroom
  • RoomType: Study
  • IRE_AssociationFee2YN: Yes
  • IRE_HasFamilyRoom: 1
  • Special Features: VirtualTour

Interior Features

  • Possible Use: Single Family
  • Appliances: Gas Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
  • Accessibility Features: Level Lot, Level Drive, Main Floor Bath, Stall Shower, Main Level Laundry
  • Has Basement: Full, Partially Finished, Daylight
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Two or More, Gas, Living Room, Family Room
  • Flooring: Wood
  • Interior Amenities: Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Builder Name: Toll Brothers
  • Fencing: Fenced, Metal
  • Lot Features: Level, Abuts Golf Course, Golf Course Neighborhood, House Faces West, Xeriscape, Paved, Curbs, Gutters, Sidewalks, Street Light
  • View: Mountain(s), Hills, Water
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Concrete
  • Exterior Features: Sprinkler System
  • Patio And Porch Features: Deck

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Garage Door Opener, Attached
  • IRE_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: PVREA ELEC
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Sewer: Public Sewer
  • Water Source: City

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Snow Removal, Maintenance Grounds
  • Community Features: Clubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s), Recreation Room, Gated
  • Association #2 Fee: 1800
  • Association #2 Fee Frequency: Annually
  • Association Fee: 1500
  • Association Fee Frequency: Annually
  • Association: Heron Lakes Metro
  • Association Name: Northern Lights HOA - Kellison
  • Association Phone #2: 970-669-3611
  • Phone: 970-494-0609
  • Association: Yes

Schools

  • Elementary School: Carrie Martin
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Bill Reed

Lot Info

  • Zoning: RES
  • Parcel #: R1671694
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 14023

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $14,023 $77,744 $30,463 $47,281
2024 $2,824 $20,200 $17,909 $2,291
2022 $552 $3,306 $3,306 $0
2021 $540 $3,306 $3,306 $0
2020 $271 $1,610 $1,610 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/17/2026 08/17/26 Pending -- -- --
07/17/2026 07/17/26 Price Changed $1,225,000 -2.0% $289 / Sq Ft
06/11/2026 06/11/26 For Sale $1,250,000 -- $295 / Sq Ft
Source: IRES MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Special Warranty Deed $965,000 None Listed On Document
Source: Public Records

Source: IRES MLS

MLS Number: IRE1061527

IRES MLS

APN: 94032-36-013

Your Personal Tour Guide

Ask me questions while you tour the home.