NEW 2 HRS AGO

For sale

$1,224,000

Est. $7,593/mo —

•

4,314

sq ft

2862 Newfound Lake Rd, Berthoud, CO 80513

About this home

Live where the pros play. With sweeping views of the lake and championship golf course, this fully upgraded Toll Brothers ranch sits in Heron Lakes, home of TPC Colorado, a PGA TOUR TPC network course and host of the Korn Ferry Tour’s The Ascendant. Inside, 10-foot ceilings and an expanded great room open to gorgeous views of the lake and course anchored by a welcoming gas fireplace with stacked stone facade. The top tier kitchen pairs a JennAir suite; a six-burner gas range, double wall ovens, quartz counters, stacked cabinetry, pantry and a Kohler cast-iron apron-front sink. The spacious primary retreat offers a tray ceiling, custom walk-in closets, ultra spa shower w/herringbone accent tile and bench. A main-level study (could be 3rd bedroom), and guest suite w/premium tiled walk in shower offer plenty of living space all on one level. The walkout lower level is waiting for your finishing touches w/upgraded ceiling height, "stubbs" for two additoinal baths, covered patio with views overlooking the lake and course. It's turnkey and low-maintenance, with an expanded, insulated garage that fits a golf cart and gear. TPC Residents enjoy the spectacular Rocky Mountains as their backdrop with a premier clubhouse, resort-style pool, fitness center, golf, private lake access, 8+ miles of trails. Golf Membership available. Enjoy lock and go living for a second home or primary home base. Rocky Mountain National Park, fly-fishing on the Big Thompson, Boulder, Fort Collins and world-class skiing are all within reach. DIA Airport less than an hour away. **Some lighting fixtures may not convey. Plenty of upgrades here! Concrete tile roof, tankless H20 Heater, Smart Systems, Top tier kitchen, Custom closets and more.

Single-familyProperty Type

2024Year Built

5,500 sq ftLot Size

$284Price/Sq.Ft.

$125/moHOA Dues

2 car garageParking

Listed by Osmirelly Kidwell • Coldwell Banker Realty 24

Listed by Kristen Danzig • JPAR Modern Real Estate

Contact: osmirely@hotmail.com,303-862-0809

Listing updated: Oct 24, 2026 at 03:36pm

Redfin checked: a minute ago

•Source:REColorado as Distributed by MLS Grid #4070988

Listing provided courtesy of Metrolist,Inc. (REColorado)

Payment calculator

$7,593 per month

Principal and interest$6,763

Property taxes

HOA dues

Home insurance

Utilities

5 minutes to get started. No credit impact.

Affordability tools

See this home in person

This home is unavailable to tour on this day.

Next available date: Sunday, October 25

Open houses

No upcoming open houses.

Nearby open houses (10)

OPEN SUN, 11AM TO 12:30PM
$465,000
3 beds2.5 baths2,472 sq ft
235 E 4th St, Berthoud, CO 80513
OPEN SUN, 11AM TO 1PM
$676,000
3 beds3 baths3,637 sq ft
2894 Donatello St, Loveland, CO 80538
OPEN SUN, 11AM TO 1PM
$589,320
3 beds3 baths2,963 sq ft
4752 Degas Dr, Loveland, CO 80538
OPEN SUN, 11AM TO 1PM3D WALKTHROUGH
$471,900
3 beds3.5 baths2,089 sq ft
1756 W 50th St, Loveland, CO 80538
OPEN SUN, 11AM TO 2PMVIDEO TOUR
$575,000
5 beds3.5 baths2,800 sq ft
2432 Eugene Dr, Loveland, CO 80537
OPEN SUN, 11AM TO 1PM
$599,000
4 beds2.5 baths3,058 sq ft
2908 Donatello St, Loveland, CO 80538
OPEN SUN, 11AM TO 1PM
$1,250,000
5 beds4 baths4,968 sq ft
17645 Silver Fox Ct, Mead, CO 80542
Rachel Deines • JPAR Modern Real Estate
OPEN SUN, 11:30AM TO 1:30PM
$580,000
4 beds3.5 baths2,715 sq ft
932 Alexandria Dr, Loveland, CO 80538
OPEN SUN, 12PM TO 2PM3D WALKTHROUGH
$500,000
3 beds2.5 baths2,119 sq ft
103 Lemonade Dr, Berthoud, CO 80513
OPEN SUN, 12PM TO 2PM
$459,000
3 beds2 baths2,806 sq ft
16228 Cinnamon Cir, Mead, CO 80542

Around this home

Schools

K - 12
Preschool & daycare

Carrie Martin Elementary School

Public PreK-5 • Assigned • 0.9mi

8/10

Bill Reed Middle School

Public 6-8 • Assigned • 4.0mi

3/10

Thompson Valley High School

Public 9-12 • Assigned • 3.4mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Market insights

2862 Newfound Lake Rd · $1,224,000

DAYS ON MARKET

The average home goes pending in 66 days.

SALE-TO-LIST

Most homes are selling 1% below list price.

LIST PRICE

Median sale price in this area is $573,813. (53% lower than this home)

PRICE DROP

27% of homes in this area have had a price drop in the past month.

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Updated and remodeled
Main-level office
Gas fireplace in the great room
Full, unfinished basement with daylight, interior entry, bath stub-out, and sump pump
Double-pane windows with window coverings
Energy-efficient appliances, construction, doors, HVAC, insulation, lighting, roof, thermostat, water heater, and windows

Bedrooms
2 bedrooms, both on the main level
Primary suite

Bathrooms
2 bathrooms on the main level: 1 full and 1 three-quarter

Kitchen
Dishwasher, disposal, microwave, oven, and refrigerator

Laundry & utility
Washer and dryer

Heating & cooling
Forced-air heating with natural gas
Central air conditioning

Sale and tax history for 2862 Newfound Lake Rd

Sale History
Tax History

Date

Event

Price

REColorado as Distributed by MLS Grid #4070988

Oct 24, 2026

Listed

$1,224,000

$284/sq ft

+35

Live where the pros play. With sweeping views of the lake and championship golf course, this fully upgraded Toll Brothers ranch sits in Heron Lakes, home of TPC Colorado, a PGA TOUR TPC network course and host of the Korn Ferry Tour's The Ascendant. Inside, 10-foot ceilings and an expanded great room open to gorgeous views of the lake and course anchored by a welcoming gas fireplace with stacked stone facade. The top tier kitchen pairs a JennAir suite; a six-burner gas range, double wall ovens, quartz counters, stacked cabinetry, pantry and a Kohler cast-iron apron-front sink. The spacious primary retreat offers a tray ceiling, custom walk-in closets, ultra spa shower w/herringbone accent tile and bench. A main-level study (could be 3rd bedroom), and guest suite w/premium tiled walk in shower offer plenty of living space all on one level. The walkout lower level is waiting for your finishing touches w/upgraded ceiling height, "stubbs" for two additoinal baths, covered patio with views overlooking the lake and course. It's turnkey and low-maintenance, with an expanded, insulated garage that fits a golf cart and gear. TPC Residents enjoy the spectacular Rocky Mountains as their backdrop with a premier clubhouse, resort-style pool, fitness center, golf, private lake access, 8+ miles of trails. Golf Membership available. Enjoy lock and go living for a second home or primary home base. Rocky Mountain National Park, fly-fishing on the Big Thompson, Boulder, Fort Collins and world-class skiing are all within reach. DIA Airport less than an hour away. **Some lighting fixtures may not convey. Plenty of upgrades here! Concrete tile roof, tankless H20 Heater, Smart Systems, Top tier kitchen, Custom closets and more.

Public Records

Nov 19, 2024

Sold

$1,963,835

$455/sq ft

Public Records

May 26, 2022

Sold

$14,525,000

$3,367/sq ft

Public record

Public record
Zoning

Beds

Baths

2.5

Stories

Lot width

—

Lot depth

—

Lot size

5,500 Sq. Ft.

Year renovated

2024

Finished Sq. Ft.

2,157

Unfinished Sq. Ft.

—

Total Sq. Ft.

2,157

Year built

2024

Style

Single Family Residential

County

Larimer County

APN

R1671701

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 21, 2026.

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, 18 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)

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 Berthoud. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

10.2 hrs

6.4 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 2862 Newfound Lake Rd

We cannot show automated home-value estimates for this home.

Nearby homes have recently sold between $729,000 and $1,575,000.

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $729K to $1.6M.

SOLD JUN 4, 2026
$850,000 Last sold price
2 beds2 baths4,002 sq ft
3077 Newfound Lake Rd, Berthoud, CO 80513
Listing provided by metrolistCO
$72/sq ft
2 years newer
SOLD JUL 8, 2026
$929,000 Last sold price
6 beds4 baths5,100 sq ft
3618 Manzanita Dr, Loveland, CO 80537
Listing provided by metrolistCO
$102/sq ft
larger lot
47 years older
SOLD AUG 12, 2026
$1,575,000 Last sold price
5 beds4.5 baths5,072 sq ft
2761 Heron Lakes Pkwy, Berthoud, CO 80513
$27/sq ft
larger lot
4 years older
SOLD APR 9, 2026
$770,000 Last sold price
2 beds2 baths4,002 sq ft
3039 Newfound Lake Rd, Berthoud, CO 80513
Listing provided by metrolistCO
$92/sq ft
SOLD JUL 28, 2026
$729,000 Last sold price
5 beds4 baths3,960 sq ft
1281 Coffman Dr, Berthoud, CO 80513
$100/sq ft
larger lot
5 years older
SOLD SEP 18, 2026
$1,180,000 Last sold price
4 beds3 baths4,238 sq ft
2940 Newfound Lake Rd, Berthoud, CO 80513
$6/sq ft
2 years older

Tour for free, no strings attached

Make a winning offer with the help of a local agent

Ask a question

(970) 535-2324