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
Price cut: $5K (5/20)
$1,060,000
3010 Newfound Lake Rd, Berthoud, CO 80513
3beds
4,262sqft
Single Family Residence
Built in 2024
5,500 Square Feet Lot
$-- Zestimate®
$249/sqft
$-- HOA
What's special
Serene pondUpgraded custom cabinetsQuartz countertopsOversized primary bedroomSoaking tubBeautiful tile showerOpen floor plan
- 120 days |
- 469 |
- 14 |
Zillow last checked:
Listing updated:
Listed by:
Jason Filler 303-443-6161,
LIV Sotheby's Intl Realty,
Koa Schumann 970-310-9045,
LIV Sotheby's Intl Realty
Source: IRES as distributed by MLS GRID,MLS#: 1042298
Loading...
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: $249/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
| Date | Event | Price |
|---|---|---|
| 5/20/2026 | Price change | $1,060,000-0.5%$249/sqft |
Source:  IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 4/21/2026 | Price change | $1,065,000-0.5%$250/sqft |
Source: IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 4/14/2026 | Price change | $1,070,000-0.5%$251/sqft |
Source: IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 10/14/2025 | Price change | $1,075,000-1.4%$252/sqft |
Source: IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 10/3/2025 | Price change | $1,090,000-0.5%$256/sqft |
Source: IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 8/27/2025 | Price change | $1,095,000-0.5%$257/sqft |
Source: IRES as distributed by MLS GRID #1042298 Report a problem | ||
| 8/7/2025 | Price change | $1,100,000-0.9%$258/sqft |
Source: IRES as distributed by MLS GRID #1032089 Report a problem | ||
| 5/29/2025 | Price change | $1,110,000-1.8%$260/sqft |
Source: IRES as distributed by MLS GRID #1032089 Report a problem | ||
| 4/28/2025 | Price change | $1,130,000-0.4%$265/sqft |
Source: IRES as distributed by MLS GRID #1032089 Report a problem | ||
| 4/24/2025 | Price change | $1,135,000-0.4%$266/sqft |
Source: IRES as distributed by MLS GRID #1032089 Report a problem | ||
| 12/30/2024 | Price change | $1,140,000-1.3%$267/sqft |
Source: IRES as distributed by MLS GRID #1020954 Report a problem | ||
| 11/14/2024 | Price change | $1,155,000-1.7%$271/sqft |
Source: IRES as distributed by MLS GRID #1020954 Report a problem | ||
| 11/7/2024 | Price change | $1,175,000-1.7%$276/sqft |
Source: IRES as distributed by MLS GRID #1020954 Report a problem | ||
| 10/19/2024 | Listed for sale | $1,195,000+18%$280/sqft |
Source: IRES as distributed by MLS GRID #1020954 Report a problem | ||
| 9/30/2024 | Sold | $1,012,347$238/sqft |
Source: Agent Provided Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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: 3.9 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 as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Colorado
- Larimer County
- Berthoud
- 80513
- 3010 Newfound Lake Rd
Nearby cities
Nearby zip codes
Other Berthoud Topics
