This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$1,180,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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!
Full Property Details
Full Property Details for 2940 Newfound Lk Rd
General
- Sold For: $1,180,000
- HOA FEE: $125/month
- HOA FEE FREQ.: Annually
- Taxes: $14,023 (2025)
- Status: Closed
- Type: Single Family
- Source: IRES
- MLS ID: 1061527
- Added to Site: 116 day(s) ago
Interior
- Interior Features: Eat-In Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings
- Fireplace: Yes
- Fireplace(s): Two or More, Gas, Living Room, Family Room
- Appliances: Gas Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
- Flooring: Wood
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 1
- 3/4 Bathrooms: 2
- Main Floor Baths: 1
Bedrooms
- Total Bedrooms: 4
Exterior
- Exterior Features: Sprinkler System
- Porch/Patio/Deck: Deck
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Parking Features: Garage Door Opener, Attached
- Garage Description: Attached
Location
- Area: Berthoud
- County: Larimer
- Subdivision: Heron Lakes 12th Fil
School Information
- School District: Thompson R2-J
- Elementary School: Carrie Martin
- Middle School: Bill Reed
- High School: Thompson Valley
Community
- Association: Yes
- Assoc. Name: Northern Lights HOA - Kellison
- Assoc. Fees Include: Common Amenities, Snow Removal, Maintenance Grounds
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Forced Air
Utilities
- Gas: Yes
- Gas: Xcel
- Sewer: Public Sewer
- Water: City
- Utility Description: Natural Gas Available, Electricity Available
Structural Information
- Architectural Style: Contemporary
- Builder: Toll Brothers
- Model: Boyd Modern Ranch
- Construction: Concrete
- Exterior Const.: Concrete
- Basement: Yes
- Basement Desc.: Full, Partially Finished, Daylight
- Roof: Composition
- Windows: Window Coverings
- Square Feet: 4,238
- Sq. Ft. Source: Assessor
- Living Area: 3,640 Sq. Ft.
- Year Built: 2022
Lot Features
- Property View: Mountain(s), Hills, Water
- Mountain views: Yes
- Lot Size (Acres): 0.13
- Lot Size (Sq. Ft.): 5,828
- Frontage: City Street
- Street/Road Desc.: Concrete
- Fence: Yes
- Lot Features: Level, Abuts Golf Course, Golf Course Neighborhood, House Faces West, Xeriscape, Paved, Curbs, Gutters, Sidewalks, Street Light
- Potential Use: Single-Family
- Permitted Use: Single Family
- Zoning: RES
- Fencing (Description): Fenced, Metal
Water Features
- Water View: Yes
Green Features
- Energy Efficient: Sun Space, Southern Exposure, Windows
Financial Considerations
- Association Fee: Yes
- Association Fee: $1,500
- Assoc Fee Freq.: Annually
- Other Assoc Fees: $1,800
- Other Fee Freq.: Annually
- Tax Amount: $14,023
- Tax Year: 2025
- Terms: Cash, Conventional, FHA, VA
Disclosures and Reports
- Special Conditions: Private Owner
- Exclusions: Seller's personal property
- Property ID: R1671694
Listed by RE/MAX Alliance-Old Town (303) 800-8439
Sold by LIV Sotheby's Intl Realty (720) 635-8105
Get Pre-Approved Today
Schools
Schools serving 2940 Newfound Lk Rd
School District:Thompson School District R-2j
| Name | Grades | Distance |
|---|---|---|
Carrie Martin Elementary School 4129 Joni Lane, Loveland, CO 80537 | PK-5 | 0.9 mi |
Bill Reed Middle School 370 West 4th Street, Loveland, CO 80537 | 6-8 | 4.1 mi |
Thompson Valley High School 1669 Eagle Drive, Loveland, CO 80537 | 9-12 | 3.3 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2940 Newfound Lk Rd
Date
Details
Price
Change
Source
9/18/2026
Sold
$1,180,000
-3.67%
MLS
7/17/2026
Price Reduced
$1,225,000
-2%
MLS
6/11/2026
Listed
$1,250,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
2940 Newfound Lake Rd, Berthoud, CO 80513 (MLS# 1061527) is a Single Family property that was sold at $1,180,000 on September 18, 2026. Want to learn more about 2940 Newfound Lake Rd? Do you have questions about finding other Single Family real estate for sale in Berthoud? You can browse all Berthoud real estate or contact a Coldwell Banker agent to request more information.

