REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Aaron Welch

admin@welchteamhomes.com +1(720) 675-9997

$ 3,450,000

Est. payment | -/mo

5 Beds

6 Baths

7,158 SqFt

Save

$ 3,450,000

Est. payment | -/mo

Save

5 Beds

6 Baths

7,158 SqFt

Open House

Sat Apr 25, 11:00am - 1:00pm

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 7,158 sqft

Price per Sqft $481

Subdivision Heron Lakes Eighteenth Fil

MLS Listing ID IR1056389

Bedrooms 5

Full Baths 1

Half Baths 2

Three Quarter Bath 3

HOA Y/N No

Abv Grd Liv Area 4,082

Year Built 2026

Annual Tax Amount $15,970

Tax Year 2025

Lot Size 0.435 Acres

Acres 0.43

Property Sub-Type Single Family Residence

Source recolorado

Property Description

This one-of-a-kind custom home is in prestigious TPC at Heron Lakes, where luxury living meets breathtaking Colorado beauty. Perfectly positioned to capture sweeping mountain views at the base of the Rockies, this home was thoughtfully designed to bring the outdoors in from every angle. Step inside to an expansive open-concept layout with soaring beamed ceilings, rich architectural details, and a seamless blend of timeless elegance and modern design. The heart of the home is a true showstopper a chef's kitchen featuring high-end appliances, custom cabinetry, and two oversized islands designed for both entertaining and everyday living. Just beyond, a stunning hidden pantry adds both function and a touch of surprise. The great room and dining space are framed by panoramic views, creating a light-filled, inviting atmosphere that carries throughout the home. The main-level primary suite is a private retreat, perfectly positioned to take in those same incredible views. The spa-inspired five-piece bath is elevated with custom lighting details that create a warm, elevated experience. With 6 bedrooms total, this home offers exceptional flexibility for both everyday living and hosting. Upstairs, you'll find a private guest suite with en suite bath, two additional bedrooms connected by a Jack and Jill bathroom, a spacious loft, and a second laundry room. The walkout basement is designed for both relaxation and entertainment, filled with natural light and thoughtfully laid out with a dedicated workout room, secure vault, custom bar, wine storage, open theater space, and an additional bedroom with en-suite bath. Completing the home is an oversized 4-car garage featuring modern glass panel doors and a 10-foot bay, offering both style and functionality. Located within one of Northern Colorado's most sought-after communities, residents of TPC Colorado at Heron Lakes enjoy miles of scenic trails, a resort-style pool, state-of-the-art fitness center, and a clubhouse with dining

Location

State CO

County Larimer

Zoning RES

Rooms

Main Level Bedrooms 1

Interior

Interior Features Eat-in Kitchen, Jack & Jill Bathroom, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Sauna, Walk-In Closet(s), Wet Bar

Heating Forced Air

Cooling Central Air

Flooring Tile, Wood

Fireplaces Type Other

Fireplace N

Appliance Bar Fridge, Dishwasher, Disposal, Double Oven, Oven, Refrigerator

Laundry In Unit

Exterior

Garage Spaces 4.0

Utilities Available Natural Gas Available

View Mountain(s)

Roof Type Spanish Tile

Total Parking Spaces 4

Garage Yes

Building

Lot Description Cul-De-Sac, On Golf Course

Water Public

Level or Stories Two

Structure Type Frame

Schools

Elementary Schools Carrie Martin

Middle Schools Other

High Schools Thompson Valley

School District Thompson R2-J

Others

Ownership Builder

Acceptable Financing Cash, Conventional

Listing Terms Cash, Conventional

Listed by eXp Realty LLC

Nearby Locations

"My job is to find and attract mastery-based agents to the office, protect the culture, and make sure everyone is happy! "

+1(720) 675-9997

admin@welchteamhomes.com

3379 Danzante Bay CT Berthoud, CO 80513