Listed By: Osmirelly Kidwell, Coldwell Banker Realty 2862 Newfound Lake Road Berthoud, CO 80513
Active
$1,224,000 (USD)
Description
MLS #:
4070988
4070988
Taxes
$6,010(2025)
$6,010(2025)
Lot Size
5,500 SQFT
5,500 SQFT
Type
Single-Family Home
Single-Family Home
Building Name
Tpc Colorado
Tpc Colorado
Year Built
2024
2024
Style
Mountain Contemporary, Contemporary, Cottage
Mountain Contemporary, Contemporary, Cottage
Views
Golf Course, Mountain(s), Lake, Meadow
Golf Course, Mountain(s), Lake, Meadow
School District
Thompson R2-J
Thompson R2-J
County
Larimer County
Larimer County
Community
Heron Lakes
Heron Lakes
Listed By
Osmirelly Kidwell, Coldwell Banker Realty
Source
RECOLORADO
Last checked Oct 26 2026 at 10:11 AM GMT+0000
RECOLORADO
Last checked Oct 26 2026 at 10:11 AM GMT+0000
Bathroom Details
- Full Bathroom: 1
- 3/4 Bathroom: 1
Interior Features
- Dishwasher
- Disposal
- Dryer
- Washer
- Kitchen Island
- Double Oven
- Sump Pump
- Convection Oven
- Pantry
- Range Hood
- Radon Mitigation System
- Self Cleaning Oven
- Open Floorplan
- Walk-In Closet(s)
- Wired for Data
- Entrance Foyer
- Eat-In Kitchen
- Built-In Features
- Quartz Counters
- Smart Thermostat
- High Ceilings
- High Speed Internet
- Primary Suite
- Oven
- Refrigerator
- Security Features: Smoke Detector(s)
- Window Features: Window Coverings
- Microwave
- Range
- Security Features: Carbon Monoxide Detector(s)
- Window Features: Double Pane Windows
- Tankless Water Heater
- Window Features: Window Treatments
- Gas Water Heater
- Security Features: Radon Detector
- Laundry: Sink
- In-Law Floorplan
- Smart Appliance(s)
- Smart Light(s)
Subdivision
- Heron Lakes
Lot Information
- On Golf Course
- Master Planned
- Meadow
- Level
- Sprinklers In Front
- Sprinklers In Rear
- Landscaped
Property Features
- Grassed
- Fireplace: Insert
- Fireplace: Gas
- Fireplace: Living Room
- Fireplace: Great Room
- Fireplace: Circulating
- Fireplace: 1
- Foundation: Slab
- Foundation: Concrete Perimeter
Heating and Cooling
- Forced Air
- Natural Gas
- Central Air
Basement Information
- Full
- Bath/Stubbed
- Sump Pump
- Unfinished
- Daylight
- Interior Entry
Homeowners Association Information
- Dues: $1500
Flooring
- Vinyl
Exterior Features
- Brick
- Frame
- Cement Siding
- Roof: Concrete
- Roof: Shake
Utility Information
- Utilities: Natural Gas Connected, Electricity Connected, Internet Access (Wired), Phone Available
School Information
- Elementary School: Carrie Martin
- Middle School: Bill Reed
- High School: Thompson Valley
Garage
- Floor Coating
- Concrete
- Insulated Garage
- Smart Garage Door
Parking
- Concrete
- Smart Garage Door
- Floor Coating
- Insulated Garage
Stories
- 1
Living Area
- 2,157 sqft
Location
Disclaimer: The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (“IDX”) program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Windermere Real Estate are marked with the IDX Logo. This information is being provided for the consumers’ personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2026 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 500
Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2026 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 500
Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Based on information submitted to the MLS GRID as of 10/26/2026 10:11. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Two Bedrooms + a study (could be 3rd bedroom) all on main level. 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. The split floor plan offers a guest suite w/premium tiled walk in shower and pleasant views including a peek at the mountains. The walkout lower level is waiting for your finishing touches w/upgraded ceiling height, stubbed for two additionall baths, covered patio with views overlooking the lake and course.
It's turnkey with an insulated, expanded garage to fit a golf cart and gear and low-maintenance as the HOA takes care of snow removal, lawncare and trash service. TPC Residents enjoy the spectacular Rocky Mountains as their backdrop with a premier clubhouse, resort-style pool, state of the art fitness center, private lake access, 8+ miles of trails. Golf Membership available.
Enjoy lock and go living as a second home or primary home base. Rocky Mountain National Park, fly-fishing, on the Big Thompson, The Lone Tree Lake Club, Loveland, Boulder, Fort Collins and world-class skiing are all within reach. DIA Airport less than an hour away. **Some lighting fixtures may not convey. Loaded w/upgrades. Concrete tile roof, tankless H20 Heater, Smart Systems, Top tier kitchen, expanded floor plan, raised ceiling height, custom closets and more.