2940 Newfound Lake Rd, Berthoud, CO 80513
What's special
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!
- 96 days |
- 90 |
- 1 |
Travel times
Living Room
Kitchen
Primary Bedroom
Zillow last checked:
Listing updated:
Lydia Creasey 303-800-8439,
RE/MAX Alliance-Olde Town,
Jim Dixon 303-653-1953,
RE/MAX Alliance-Olde Town
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 2
- Main level bathrooms: 2
Primary bedroom
- Description: Carpet
- Features: 3/4 Primary Bath
- Level: Main
- Area: 264 Square Feet
- Dimensions: 22 x 12
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Bedroom 3
- Description: Wood
- Level: Basement
- Area: 208 Square Feet
- Dimensions: 16 x 13
Bedroom 4
- Description: Wood
- Level: Basement
- Area: 228 Square Feet
- Dimensions: 19 x 12
Dining room
- Description: Wood
- Level: Main
- Area: 168 Square Feet
- Dimensions: 14 x 12
Family room
- Description: Wood
- Level: Basement
- Area: 240 Square Feet
- Dimensions: 16 x 15
Kitchen
- Description: Wood
- Level: Main
- Area: 165 Square Feet
- Dimensions: 15 x 11
Laundry
- Level: Main
- Area: 56 Square Feet
- Dimensions: 7 x 8
Living room
- Description: Wood
- Level: Main
- Area: 420 Square Feet
- Dimensions: 28 x 15
Study
- Description: Wood
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
Features
- Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full,Partially Finished,Daylight
- Has fireplace: Yes
- Fireplace features: Two or More, Gas, Living Room, Family Room
Interior area
- Total structure area: 2,119
- Total interior livable area: 4,238 sqft
- Finished area above ground: 2,119
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, Level Drive, Main Floor Bath, Stall Shower, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck
- Exterior features: Sprinkler System
- Spa features: Community
- Fencing: Fenced,Metal
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 5,828 Square Feet
- Features: Level, On Golf Course, Near Golf Course, Xeriscape, Paved, Curbs, Gutters, Sidewalks, Street Light
Details
- Parcel number: R1671694
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Concrete
- Roof: Composition
Condition
- New construction: No
- Year built: 2022
Details
- Builder model: Boyd Modern Ranch
- Builder name: Toll Brothers
Utilities & green energy
- Electric: PVREA ELEC
- Gas: Xcel
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available
Green energy
- Energy efficient items: Sun Space, Southern Exposure, Windows
Community & HOA
Community
- Features: Clubhouse, Pool, Fitness Center, Park, Trail(s), Recreation Room, Gated
- Subdivision: Heron Lakes 12th Fil
HOA
- Has HOA: Yes
- Services included: Common Amenities, Snow Removal, Maintenance Grounds
- HOA fee: $1,500 annually
- HOA name: Northern Lights HOA - Kellison
- HOA phone: 970-494-0609
- Second HOA fee: $1,800 annually
- Second HOA name: Heron Lakes Metro
- Second HOA phone: 970-669-3611
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $289/sqft
- Tax assessed value: $1,243,900
- Annual tax amount: $14,023
- Date on market: 6/11/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Seller's personal property
- Electric utility on property: Yes
- Road surface type: Concrete
Price history
| Date | Event | Price |
|---|---|---|
| 8/19/2026 | Pending sale | $1,225,000$289/sqft |
Source: | ||
| 7/17/2026 | Price change | $1,225,000-2%$289/sqft |
Source: | ||
| 6/11/2026 | Listed for sale | $1,250,000-0.8%$295/sqft |
Source: | ||
| 5/12/2026 | Listing removed | $1,260,000$297/sqft |
Source: | ||
| 2/11/2026 | Listed for sale | $1,260,000$297/sqft |
Source: | ||
| 1/1/2026 | Listing removed | $1,260,000$297/sqft |
Source: | ||
| 9/3/2025 | Listed for sale | $1,260,000+30.6%$297/sqft |
Source: | ||
| 10/4/2023 | Sold | $965,000-0.5%$228/sqft |
Source: Public Record Report a problem | ||
| 8/8/2023 | Price change | $969,995-2%$229/sqft |
Source: | ||
| 6/27/2023 | Price change | $989,995-1%$234/sqft |
Source: | ||
| 4/23/2023 | Listed for sale | $999,995$236/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $12,999 +360.4% | $77,744 +26.7% |
| 2024 | $2,824 +411.3% | $61,338 +200.7% |
| 2023 | $552 +2.2% | $20,397 +517% |
| 2022 | $540 +99.5% | $3,306 |
| 2021 | $271 | $3,306 +105.3% |
| 2020 | -- | $1,610 |
Find assessor info on the county website
Monthly payment
Estimated market value
Not available
Estimated sales range
Not available
Not available
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.