Welcome to this stunning walkout ranch home, backing onto the luxurious TPC Golf Course and a serene pond, with breathtaking Mountain View's. This patio style home is packed with custom upgrades. This home features an open floor plan with 3 bedrooms and 2 bathrooms, living area with a tile surround fireplace, kitchen boasts a large center island, upgraded custom cabinets, quartz countertops, and beautiful tile extending to the ceiling above the gas range. Built-in speakers are installed in the living area, primary bedroom, and deck. Dining area leads to an 8-foot-tall slider that opens 8+ feet wide to your private deck. The oversized primary bedroom includes 2 walk-in closets with custom built in's, a soaking tub, and a beautiful tile shower. The walkout basement is ready for your personal touch, with rough-ins for a wet bar and future bath. Large covered patio perfect for entertaining. The TPC at Heron Lakes is one of Colorado's premier neighborhoods, offering over 8 miles of trails, several lakes, and access to Lonetree Reservoir (additional fees required) for fishing, boating, paddleboarding, and more. The community also features a private health club, a pool with a swim-up bar, 2 restaurants, and much more. Golf membership is discounted to $40,000 for the first 30 days after closing. For more information about the community and its amenities, or to schedule a tour of the facilities, please contact the agents.
For sale
$1,075,000
3010 Newfound Lake Rd, Berthoud, CO 80513
3beds
4,262sqft
Est.:
Single Family Residence
Built in 2024
5,500 Square Feet Lot
$-- Zestimate®
$252/sqft
$-- HOA
What's special
Serene pondUpgraded custom cabinetsQuartz countertopsOversized primary bedroomSoaking tubBeautiful tile showerOpen floor plan
- 13 days |
- 816 |
- 17 |
Zillow last checked: 8 hours ago
Listing updated: March 03, 2026 at 03:16am
Listed by:
Jason Filler 3034436161,
LIV Sotheby's Intl Realty,
Koa Schumann 970-310-9045,
LIV Sotheby's Intl Realty
Source: IRES,MLS#: 1042298
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
Primary bedroom
- Description: Wood
- Features: Luxury Features Primary Bath
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12 x 12
Bedroom 2
- Description: Wood
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Bedroom 3
- Description: Wood
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Dining room
- Description: Wood
- Level: Main
- Area: 143 Square Feet
- Dimensions: 13 x 11
Family room
- Description: Wood
- Level: Main
- Area: 130 Square Feet
- Dimensions: 10 x 13
Kitchen
- Description: Wood
- Level: Main
- Area: 154 Square Feet
- Dimensions: 14 x 11
Laundry
- Description: Tile
- Level: Main
- Area: 56 Square Feet
- Dimensions: 7 x 8
Living room
- Description: Wood
- Level: Main
- Area: 294 Square Feet
- Dimensions: 21 x 14
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Microwave, Disposal
Features
- Kitchen Island, High Ceilings
- Basement: Partial,Unfinished,Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,262
- Total interior livable area: 4,262 sqft
- Finished area above ground: 2,131
- Finished area below ground: 2,131
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
- Details: Attached
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Spa features: Community
- Fencing: Partial
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 5,500 Square Feet
- Features: On Golf Course, Near Golf Course, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet
Details
- Parcel number: R1671686
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Patio Home
- Property subtype: Single Family Residence
Materials
- Frame, Stone
- Roof: Tile
Condition
- New construction: No
- Year built: 2024
Utilities & green energy
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available
Community & HOA
Community
- Features: Clubhouse, Pool, Fitness Center, Park, Trail(s), Gated
- Security: Fire Alarm
- Subdivision: Heron Lakes 12th Fil
HOA
- Has HOA: No
- Services included: Common Amenities, Snow Removal, Maintenance Grounds, Management
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $252/sqft
- Annual tax amount: $3,614
- Date on market: 2/18/2026
- Listing terms: Cash,Conventional
- Exclusions: None
- Electric utility on property: Yes
- Road surface type: Concrete
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/14/2025 | Price change | $1,075,000-1.4%$252/sqft |
Source:  IRES #1042298 Report a problem | ||
| 10/3/2025 | Price change | $1,090,000-0.5%$256/sqft |
Source: IRES #1042298 Report a problem | ||
| 8/27/2025 | Price change | $1,095,000-0.5%$257/sqft |
Source: IRES #1042298 Report a problem | ||
| 8/7/2025 | Price change | $1,100,000-0.9%$258/sqft |
Source: IRES #1032089 Report a problem | ||
| 5/29/2025 | Price change | $1,110,000-1.8%$260/sqft |
Source: IRES #1032089 Report a problem | ||
| 4/28/2025 | Price change | $1,130,000-0.4%$265/sqft |
Source: IRES #1032089 Report a problem | ||
| 4/24/2025 | Price change | $1,135,000-0.4%$266/sqft |
Source: IRES #1032089 Report a problem | ||
| 12/30/2024 | Price change | $1,140,000-1.3%$267/sqft |
Source: IRES #1020954 Report a problem | ||
| 11/14/2024 | Price change | $1,155,000-1.7%$271/sqft |
Source: IRES #1020954 Report a problem | ||
| 11/7/2024 | Price change | $1,175,000-1.7%$276/sqft |
Source: IRES #1020954 Report a problem | ||
| 10/19/2024 | Listed for sale | $1,195,000+18%$280/sqft |
Source: IRES #1020954 Report a problem | ||
| 9/30/2024 | Sold | $1,012,347$238/sqft |
Source: Agent Provided Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$5,642/mo
Principal & interest
$5176
Property taxes
$466
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: 4 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.2 mi
Schools provided by the listing agent
- Elementary: Carrie Martin
- Middle: Bill Reed
- High: Thompson Valley
Source: IRES. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 80513
