


Listed By: Bosch Real Estate Group, LLC 2669 Southwind Road Berthoud, CO 80513
Active
$2,895,000 (USD)
OPEN HOUSE TIMES
-
OPENSat, Aug 112 noon - 2:00 pm
-
OPENSun, Aug 212 noon - 2:00 pm
-
OPENSat, Aug 812 noon - 2:00 pm
-
OPENSun, Aug 912 noon - 2:00 pm
-
OPENSat, Aug 1512 noon - 2:00 pm
-
OPENSun, Aug 1612 noon - 2:00 pm
-
OPENSat, Aug 2212 noon - 2:00 pm
-
OPENSun, Aug 2312 noon - 2:00 pm
-
OPENSat, Aug 2912 noon - 2:00 pm
-
OPENSun, Aug 3012 noon - 2:00 pm
-
OPENSat, Sep 512 noon - 2:00 pm
-
OPENSun, Sep 612 noon - 2:00 pm
-
OPENSat, Sep 1212 noon - 2:00 pm
-
OPENSun, Sep 1312 noon - 2:00 pm
-
OPENSat, Sep 1912 noon - 2:00 pm
-
OPENSun, Sep 2012 noon - 2:00 pm
-
OPENSat, Sep 2612 noon - 2:00 pm
-
OPENSun, Sep 2712 noon - 2:00 pm
-
OPENSat, Oct 312 noon - 2:00 pm
-
OPENSun, Oct 412 noon - 2:00 pm
-
OPENSat, Oct 1012 noon - 2:00 pm
-
OPENSun, Oct 1112 noon - 2:00 pm
-
OPENSat, Oct 1712 noon - 2:00 pm
-
OPENSun, Oct 1812 noon - 2:00 pm
-
OPENSat, Oct 2412 noon - 2:00 pm
-
OPENSun, Oct 2512 noon - 2:00 pm
-
OPENSat, Oct 3112 noon - 2:00 pm
-
OPENSun, Nov 112 noon - 2:00 pm
-
OPENSat, Nov 712 noon - 2:00 pm
-
OPENSun, Nov 812 noon - 2:00 pm
-
OPENSat, Nov 1412 noon - 2:00 pm
-
OPENSun, Nov 1512 noon - 2:00 pm
-
OPENSat, Nov 2112 noon - 2:00 pm
-
OPENSun, Nov 2212 noon - 2:00 pm
-
OPENSat, Nov 2812 noon - 2:00 pm
-
OPENSun, Nov 2912 noon - 2:00 pm
-
OPENSat, Dec 512 noon - 2:00 pm
-
OPENSun, Dec 612 noon - 2:00 pm
-
OPENSat, Dec 1212 noon - 2:00 pm
-
OPENSun, Dec 1312 noon - 2:00 pm
-
OPENSat, Dec 1912 noon - 2:00 pm
-
OPENSun, Dec 2012 noon - 2:00 pm
-
OPENSat, Dec 2612 noon - 2:00 pm
-
OPENSun, Dec 2712 noon - 2:00 pm
-
OPENSat, Jan 212 noon - 2:00 pm
-
OPENSun, Jan 312 noon - 2:00 pm
-
OPENSat, Jan 912 noon - 2:00 pm
-
OPENSun, Jan 1012 noon - 2:00 pm
-
OPENSat, Jan 1612 noon - 2:00 pm
-
OPENSun, Jan 1712 noon - 2:00 pm
-
OPENSat, Jan 2312 noon - 2:00 pm
-
OPENSun, Jan 2412 noon - 2:00 pm
-
OPENSat, Jan 3012 noon - 2:00 pm
-
OPENSun, Jan 3112 noon - 2:00 pm
-
OPENSat, Feb 612 noon - 2:00 pm
-
OPENSun, Feb 712 noon - 2:00 pm
-
OPENSat, Feb 1312 noon - 2:00 pm
-
OPENSun, Feb 1412 noon - 2:00 pm
-
OPENSat, Feb 2012 noon - 2:00 pm
-
OPENSun, Feb 2112 noon - 2:00 pm
-
OPENSat, Feb 2712 noon - 2:00 pm
-
OPENSun, Feb 2812 noon - 2:00 pm
-
OPENSat, Mar 612 noon - 2:00 pm
-
OPENSun, Mar 712 noon - 2:00 pm
show more
show more
Description
MASTERWORK HOME COMPANY CUSTOM HOME, JUST COMPLETED & READY FOR IMMEDIATE MOVE-IN! Experience an extraordinary blend of modern architecture, luxury, and craftsmanship in this truly one-of-a-kind residence located in The Rookery, the exclusive gated enclave of Heron Lakes at TPC Colorado Golf Resort. Included with the purchase is a coveted TPC membership, offering access to world-class golf, resort-style amenities, and an unparalleled lifestyle. Spanning more than 8,000 square feet, this architectural masterpiece showcases impeccable design and exceptional attention to detail throughout. Dramatic floor-to-ceiling windows flood the home with natural light, creating an inviting atmosphere while seamlessly connecting indoor and outdoor living spaces. Every element has been thoughtfully curated, from the custom cabinetry and designer doors to the professional-grade appliances and luxurious, high-end finishes. Expansive living areas, sophisticated entertaining spaces, and stunning architectural lines combine to create a home that is both breathtaking and timeless.This is more than a home - it is a statement of style, elegance, and elevated living. Truly impossible to capture in words, this remarkable property must be experienced in person to be fully appreciated.
MLS #:
IR1058729
IR1058729
Taxes
$5,858(2025)
$5,858(2025)
Lot Size
0.3 acres
0.3 acres
Type
Single-Family Home
Single-Family Home
Year Built
2026
2026
School District
Thompson R2-J
Thompson R2-J
County
Larimer County
Larimer County
Community
Heron Lakes 3rd Filing
Heron Lakes 3rd Filing
Listed By
Brian Terry, Bosch Real Estate Group, LLC
Source
RECOLORADO
Last checked Jul 27 2026 at 2:41 PM GMT-0600
RECOLORADO
Last checked Jul 27 2026 at 2:41 PM GMT-0600
Bathroom Details
- Full Bathrooms: 4
- Half Bathrooms: 2
Interior Features
- Dishwasher
- Dryer
- Washer
- Kitchen Island
- Five Piece Bath
- Double Oven
- Pantry
- Open Floorplan
- Vaulted Ceiling(s)
- Walk-In Closet(s)
- Eat-In Kitchen
- Oven
- Refrigerator
- Microwave
- Window Features: Double Pane Windows
- Bar Fridge
Subdivision
- Heron Lakes 3Rd Filing
Lot Information
- Level
Property Features
- Fireplace: Gas
- Fireplace: Gas Log
Heating and Cooling
- Forced Air
- Central Air
Flooring
- Tile
Exterior Features
- Stucco
- Stone
- Frame
- Cedar
- Roof: Spanish Tile
Utility Information
- Utilities: Electricity Available, Natural Gas Available
School Information
- Elementary School: Carrie Martin
- Middle School: Other
- High School: Thompson Valley
Parking
- Oversized
Stories
- 1
Living Area
- 6,705 sqft
Listing Price History
Date
Event
Price
% Change
$ (+/-)
Jun 10, 2026
Price Changed
$2,895,000
-3%
-$100,000
May 10, 2026
Price Changed
$2,995,000
-8%
-$275,000
May 09, 2026
Listed
$3,270,000
-
-
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 7/27/2026 08:41. 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.