Listed By: Jpar Modern Real Estate / Coldwell Banker Realty 2878 Newfound Lake Road Berthoud, CO 80513
Active
$1,275,000 (USD)
Description
MLS #:
3746701
3746701
Taxes
$6,111(2025)
$6,111(2025)
Lot Size
5,680 SQFT
5,680 SQFT
Type
Single-Family Home
Single-Family Home
Building Name
Tpc Colorado
Tpc Colorado
Year Built
2024
2024
Style
Mountain Contemporary, Contemporary
Mountain Contemporary, Contemporary
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
Kristen Danzig, Jpar Modern Real Estate
Osmirelly Kidwell, Coldwell Banker Realty
Osmirelly Kidwell, Coldwell Banker Realty
Source
RECOLORADO
Last checked Oct 24 2026 at 9:35 PM GMT+0000
RECOLORADO
Last checked Oct 24 2026 at 9:35 PM GMT+0000
Bathroom Details
- Full Bathrooms: 2
- Half Bathroom: 1
Interior Features
- Dishwasher
- Disposal
- Dryer
- Washer
- Kitchen Island
- Five Piece Bath
- Convection Oven
- Pantry
- Range Hood
- Radon Mitigation System
- Open Floorplan
- Walk-In Closet(s)
- 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
- Gas Water Heater
- Security Features: Security System
- Laundry: Sink
Subdivision
- Heron Lakes
Lot Information
- On Golf Course
- Irrigated
- Master Planned
- Open Space
- Level
- Sprinklers In Front
- Sprinklers In Rear
- Landscaped
Property Features
- Grassed
- Fireplace: Gas
- Fireplace: Great Room
- Fireplace: 1
- Foundation: Slab
- Foundation: Concrete Perimeter
Heating and Cooling
- Forced Air
- Natural Gas
- Central Air
Basement Information
- Exterior Entry
- Full
- Walk-Out Access
- Bath/Stubbed
- Sump Pump
- Unfinished
- Daylight
- Interior Entry
Homeowners Association Information
- Dues: $1500
Flooring
- Vinyl
Exterior Features
- Frame
- Roof: Composition
- Roof: Shingle
Utility Information
- Utilities: Natural Gas Connected, Electricity Connected, Cable Available, Internet Access (Wired)
School Information
- Elementary School: Carrie Martin
- Middle School: Bill Reed
- High School: Thompson Valley
Garage
- Tandem
- Concrete
- Insulated Garage
Parking
- Tandem
- Concrete
- Insulated Garage
Stories
- 2
Living Area
- 2,687 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/24/2026 21:35. 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.
The great room centers on a gas fireplace with floor-to-ceiling Saluzzo stacked stone and a black-stained mantel, all framed by golf course and lake views. The dining area was expanded 10 feet and opens to a covered deck, a natural spot for morning coffee or sunset entertaining. The kitchen pairs stacked cabinetry, a contrasting island and Vallejo Gold quartz with a herringbone backsplash that runs to the ceiling, a white cast-iron farmhouse sink and KitchenAid appliances: a 36 five-burner gas cooktop, combination microwave/wall oven, canopy hood and counter-depth French door refrigerator.
The primary bath feels like a spa, with a freestanding soaking tub, a frameless glass shower and dual sinks. Matte black fixtures, 30 added recessed lights and custom closets complete the finishes. The full walkout basement has 1' higher ceilings, great views and direct access to a patio, plus a bath rough-in, so there’s plenty of room to grow.
It’s turnkey and can be sold furnished! Low-maintenance and with a fenced yard, 3-car garage, tankless water heater and impact Resistent roof. The HOA covers grounds care and snow removal, so you can arrive, unwind and leave without a to-do list. You’ll have a clubhouse, pool, fitness center, trails and dining close by. Golf Membership available but not mandatory. DIA Airport & the Rocky Mountains less than an hour away.