| Date / Event | Date | Event |
Price
|
| Sep 29, 2026 | Listed |
$1,900,000
|
|
Listed
|
| Jul 2, 2026 | Sold | |
|
Sold
|
| May 24, 2026 | In contract |
-
|
|
In contract
|
| May 22, 2026 | Price Decreased |
$1,849,000
↓ $146K
(7.3%) |
|
Price Decreased
|
| May 15, 2026 | Price Decreased |
$1,995,000
↓ $5K
(0.3%) |
|
Price Decreased
|
| Mar 14, 2026 | Price Decreased |
$2,000,000
↓ $75K
(3.6%) |
|
Price Decreased
|
| Feb 21, 2026 | No longer available |
-
|
|
No longer available
|
| Feb 20, 2026 | Withdrawn |
-
|
|
Withdrawn
|
| Feb 18, 2026 | Listed |
$2,075,000
|
|
Listed
|
| |
|
The best value per square foot in Heron Lakes - $451,000 below the 2026 certified appraisal. 6,837 sq ft of custom construction, a deeded TPC Colorado membership, and the privacy of an interior lot that keeps the course as your backdrop without the cart traffic at your door. This custom-designed 6-bedroom, 5-bath estate in the gated Rookery at Heron Lakes embodies refined Colorado living, framed by sweeping mountain, water, and open-space views. Encompassing a ~.32 acre lot, the residence makes a striking first impression with manicured grounds, a timeless water feature, and architectural detail that carries throughout the home. Designed for effortless entertaining and elevated daily living, the open layout centers on a dramatic great room with soaring ceilings and a floor-to-ceiling stone fireplace. The chef's kitchen is both sophisticated and functional, featuring quartz surfaces, custom knotty alder cabinetry, premium built-in appliances, and a substantial island. A sunlit morning room and formal dining area with butler's bar and wine refrigeration extend seamlessly to dual covered terraces, creating exceptional indoor-outdoor flow. The main level offers a private guest suite, well-appointed laundry, and access to a heated oversized three-car garage. Upstairs, the primary suite serves as a serene retreat with coffee bar, see-through fireplace, spa-inspired bath with steam shower and soaking tub, custom walk-in closet, and covered balcony for enjoying Colorado sunsets. The walkout lower level enhances the lifestyle with an expansive recreation room, wet bar, additional bedrooms, covered patio, and gas fire feature. A recreation-ready garage with epoxy floors, dog wash, and dog run completes the offering. Residents enjoy resort-caliber amenities including a pool, clubhouse, fitness center, miles of trails and shoreline, over 130 acres of preserved open space - an exceptional opportunity within one of Northern Colorado's most distinguished gated communities.
|
| Jan 21, 2026 | Listed |
$2,200,000
|
|
Listed
|
| |
|
Custom-designed 6-bedroom, 5-bath estate in the gated Rookery at Heron Lakes at TPC Colorado, where breathtaking mountain, water, and open-space views set the backdrop for refined Colorado living. This striking 6,567 SF residence, sitting on a ~.32 acre lot, makes a statement upon arrival with manicured landscaping, a timeless water feature, and architectural presence that carries through the interior. Designed for effortless entertaining and elevated everyday living, the open floor plan flows into a dramatic great room with soaring ceilings and a floor-to-ceiling stone fireplace framed by custom built-ins. The chef's kitchen is both beautiful and functional, featuring quartz countertops, custom knotty alder cabinetry, built-in appliances, and a substantial island that anchors the space. A sun-filled morning room and formal dining room with a butler's bar and wine refrigerator extend seamlessly to two covered back decks, creating exceptional indoor-outdoor living. The main level offers a private guest suite, generous laundry room, thoughtfully designed storage and access to the heated oversized 3-car garage. Upstairs, the primary retreat is a true sanctuary with a coffee bar, see-through fireplace, spa-inspired bath with steam shower and soaking tub, custom walk-in closet, and a private covered balcony for taking in unforgettable sunsets. The walkout lower level expands the lifestyle with a spacious recreation room, wet bar, additional bedrooms, covered patio, and gas firepit. A heated, recreation-ready garage with epoxy floors, dog wash, and dog run completes the home. Rookery residents enjoy access to resort-style amenities including a pool, clubhouse, fitness center, nearly 9 miles of trails, over 130 acres of open space, 4.5 miles of shoreline, and deeded TPC Colorado membership with world-class golf privileges. An exceptional opportunity to secure luxury living, privacy, and lifestyle in one of Northern Colorado's most sought-after gated golf communities.
|
| Jun 21, 2024 | Listed by LIV Sotheby's International Realty |
$2,300,000
|
|
Listed by LIV Sotheby's International Realty
|
| |
|
Custom designed estate home in Heron Lakes at TPC Colorado. Located in the gated Rookery that comes with deeded membership to TPC Colorado. Recent appraisal in hand at $2.475M! The lowest price per finished SF in the neighborhood! 2-story home offering 6 bedrooms, 4 baths, over 6,500 SF of living space and an outdoor setup made to entertain. Beautiful, luxury design features and stained wood accents throughout. Custom barn door entrance to the study off the grand foyer. Open floorplan with cathedral ceilings in the expansive great room highlighted by the dramatic floor to ceiling stone fireplace, built-ins and abundance of natural lighting. Chef's kitchen with quartz countertops, custom Knotty Alder cabinetry with built-in appliances, a massive kitchen island with an apron sink, gas range and off-kitchen dining with back deck access. Formal dining room with a butler's bar and wine fridge that extends to one of the two covered back decks for al fresco dining. Main-level guest suite with a private bath. Upper-level primary retreat offering a coffee bar, unique see-thru fireplace, a private covered balcony, luxury bath with a steam shower, deep soaking tub and expansive walk-in closet with built-ins and a stacked washer/dryer setup. Forced walkout basement with a massive rec room, extended wet bar, two large bedrooms, additional covered patio and gas firepit area. Recreation ready heated garage with epoxy flooring, a storage wall, dog washing station and dog run access. Full property professional landscaping with a timeless water feature. Owners have access to luxury community amenities; a resort-style pool, fitness center, 65,000 SF clubhouse, 2 restaurants (3rd under construction), 8.7 miles of trails, 130 acres of open space, discounted lake club membership for reservoir access. Membership to TPC offers golf privileges, practice facility, golf simulator center, Men/Women locker rooms access, invitations to exclusive events and international golf.
|
| Jun 20, 2024 | Price Increased |
$2,450,000
↑ $150K
(6.5%) |
|
Price Increased
|
| Apr 4, 2024 | Listed by LIV Sotheby's Intl Realty |
$2,300,000
|
|
Listed by LIV Sotheby's Intl Realty
|
| |
|
Custom designed estate home in Heron Lakes at TPC Colorado. Located in the gated Rookery that comes with deeded membership to TPC Colorado. Recent appraisal in hand at $2.475M! The lowest price per finished SF in the neighborhood! 2-story home offering 6 bedrooms, 4 baths, over 6,500 SF of living space and an outdoor setup made to entertain. Beautiful, luxury design features and stained wood accents throughout. Custom barn door entrance to the study off the grand foyer. Open floorplan with cathedral ceilings in the expansive great room highlighted by the dramatic floor to ceiling stone fireplace, built-ins and abundance of natural lighting. Chef's kitchen with quartz countertops, custom Knotty Alder cabinetry with built-in appliances, a massive kitchen island with an apron sink, gas range and off-kitchen dining with back deck access. Formal dining room with a butler's bar and wine fridge that extends to one of the two covered back decks for al fresco dining. Main-level guest suite with a private bath. Upper-level primary retreat offering a coffee bar, unique see-thru fireplace, a private covered balcony, luxury bath with a steam shower, deep soaking tub and expansive walk-in closet with built-ins and a stacked washer/dryer setup. Forced walkout basement with a massive rec room, extended wet bar, two large bedrooms, additional covered patio and gas firepit area. Recreation ready heated garage with epoxy flooring, a storage wall, dog washing station and dog run access. Full property professional landscaping with a timeless water feature. Owners have access to luxury community amenities; a resort-style pool, fitness center, 65,000 SF clubhouse, 2 restaurants (3rd under construction), 8.7 miles of trails, 130 acres of open space, discounted lake club membership for reservoir access. Membership to TPC offers golf privileges, practice facility, golf simulator center, Men/Women locker rooms access, invitations to exclusive events and international golf.
|
| Feb 28, 2024 | Listed by RE/MAX Town and Country |
$2,300,000
|
|
Listed by RE/MAX Town and Country
|
| |
|
Priced to sell with instant equity & $40K TPC golf membership included (appraisal in hand at $2.475M)! Custom-built w/ ample indoor & outdoor living spaces in gated community of Heron Lakes at TPC Colorado w/ priceless mountain & water views. Charming curb appeal w/ extensive landscaping & water feature. Enter via grand 2-story foyer featuring enchanting light fixtures, custom barn door to the vaulted study w/ abundant natural light & open plan perfect for entertaining & enjoyment. Main level offers spacious chef's kitchen w/ quartz countertops, oversized center island w/ farm sink & knotty alder cabinets. Entertain w/ ease in oversized great room w/ 2-story stone fireplace, built-in cabinets & floating shelves. Guests will love dining room complete w/ butler's bar & wine fridge leading to one of the covered back decks. Flooded w/ sunshine, morning room offers large windows & access to both covered decks. Upon garage entry, you are greeted w/ custom storage lockers, huge laundry room, sink & full-size refrigerator & guest suite w/ beautifully appointed bath. Upstairs you will find a luxurious primary suite w/ coffee bar, see thru fireplace to bathroom, steam shower, freestanding soaking tub & walk-in closet w/ built-in dresser & stacked washer/dryer. Views get even better from balcony off sitting room of primary suite where you can relax, unwind, & take in the stunning Colorado sunsets. Two secondary bedrooms with jack & jill bath. Forced walkout bsmt w/ rec room, wet bar, full-size refrigerator, dishwasher & micro. With, two large secondary bedrooms, add'l covered patio area, & gas firepit - possibilities are endless. Heated garage w/ epoxy floors, storage wall unit, loft shelving, dog wash & access to dog run. Amenities include resort-style swimming pool, 65k sq ft Clubhouse w/ fitness center, restaurant, event facilities, 8.7 miles of trails, 4.5 miles of shoreline, & over 130 acres of permanent open space.
|
| Jun 14, 2023 | Listed |
$2,300,000
|
|
Listed
|
| |
|
Fully custom w/ ample indoor & outdoor living spaces. Located in gated community of Heron Lakes at TPC Colorado, recently featured on HGTV's Rock the Block series, w/ priceless mtn views of Longs Peak, Mt. Meeker, & Lonetree Reservoir. $40K golf membership included! Charming curb appeal w/ extensive landscaping & water feature. Enter via the grand 2-story foyer featuring enchanting light fixtures, custom barn door to vaulted study w/ abundant natural light, & open floor plan perfect for entertaining & enjoyment. Main level offers spacious chef's kitchen w/ premier appliances, quartz countertops, oversized center island, knotty alder cabinetry, custom hood, & walk-in pantry. Entertain w/ ease in oversized great room w/ 2-story stone fireplace & built-in cabinets. Guests will love the dining room complete w/ butler's bar & wine fridge leading to one of the covered back decks. Flooded w/ sunshine, the morning rm offers lg windows & access to both covered decks. Upon garage entry, you are greeted w/ storage lockers, huge laundry rm, sink, & full-size refrigerator, & guest suite. Upstairs you will find a luxurious primary suite w/ coffee bar, see thru fireplace to bathroom, relaxing steam shower, freestanding soaking tub, & walk-in closet w/ built-in dresser & stacked washer/dryer. Views get even better from balcony off sitting room where you can take in the stunning sunsets. Two secondary bedrooms w/ jack & jill bath. Daylight bsmt w/ forced walkout, rec room, wet bar, fridge, dishwasher & microwave. Two large secondary bedrooms, add'l covered patio area & gas firepit, possibilities are endless. Extensive heated 3-car garage w/ epoxy floors, storage wall unit/workbench, loft shelving, dog wash, & access to dog run. Amenities incl resort-style swimming pool, 65k sq ft Clubhouse w/ fitness center, restaurant, event facilities, & miles of trails & shoreline. Access to SUP/canoe/kayak/lakeshore fishing; motorized boating membership available.
|
| Jul 8, 2022 | Sold | |
|
Sold
|
| Mar 23, 2021 | Listed by RE/MAX Alliance-Loveland |
$1,671,003
|
|
Listed by RE/MAX Alliance-Loveland
|
| |
|
This amazing home was built to reflect the desires of the buyer. Some of the features include full landscaping and an oversized 3 car garage.The main floor includes large decks off the great room and morning room. Extended hardwood flooring in great room, dining room, study, halls, kitchen and morning room. In the kitchen you will love the oversized kitchen island and generous appliance allowance. The living room features a fireplace with stone to the ceiling and custom, built in entertainment cabinets. Upstairs in the primary bedroom, you will find an oversized shower, cabinetry for coffee bar and a large deck.The 1700 sq ft finished, walk-out basement features a family room, game area and two bedrooms plus bath. Also, a fireplace and wet bar have been added for additional enjoyment. To be built.
|
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017