Welcome to 23 Estates Terrace North, an extraordinary custom built residence in the prestigious Estates II gated community of Manhasset. Designed and crafted as a personal residence by a world renowned contractor, this one-of-a-kind home showcases exceptional craftsmanship, cutting edge technology, and uncompromising attention to detail throughout. This sophisticated 4 bedroom, 4 bathroom modern sanctuary offers elegant, open concept living spaces designed for both everyday comfort and grand scale entertaining. At the heart of the home is a stunning chef’s kitchen featuring sleek Leicht cabinetry and seamless flow into the dining and living areas. Luxurious finishes abound, including full marble slab bathrooms, a dramatic marble fireplace, custom 5 inch wide plank flooring, and designer doors and moldings. Smart home technology is integrated throughout, with Lutron lighting, Sonos sound, Schlage locks, Ring security, Nest climate controls, and a comprehensive camera and alarm system, all conveniently managed from your smartphone. Heated bathroom floors, dual humidification systems, and premium materials create an unparalleled living experience. The exceptional primary suite serves as a private retreat, highlighted by a boutique style dressing room and custom designed closet space. The finished lower level expands the home’s living and entertaining options with a spacious great room, guest bedroom and full bath, plus spa inspired amenities including an infrared sauna. Outdoor living is equally impressive, featuring a beautifully designed patio and deck ideal for relaxing or entertaining. Additional highlights include a mudroom off the two car garage, abundant storage, and thoughtfully designed functional spaces throughout. Located within a gated community with 24-hour security, residents enjoy an exclusive, country club lifestyle with resort style amenities including a swimming pool, Har-Tru tennis courts, pickleball courts, fitness center and clubhouse complete with a game room and catering kitchen. All of this is offered within the highly acclaimed Manhasset School District, making 23 Estates Terrace North a rare opportunity to own one of the finest homes ever offered in Estates II. Some photo are virtually staged.
45 days
|
617
|
16
|
Zillow last checked:
Listing updated:
Listed by:
Compass Greater NY LLC516-517-4751,
Mark Leventhal516-330-8001
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1008997
Loading...
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 4
Full bathrooms: 4
Heating
Electric, Forced Air, Radiant Floor
Cooling
Central Air
Appliances
Included: Dishwasher, Dryer, Electric Cooktop, Electric Oven, Electric Water Heater, ENERGY STAR Qualified Appliances, Freezer, Microwave, Refrigerator, Washer
Features
First Floor Bedroom, First Floor Full Bath, Bidet, Chefs Kitchen, Eat-in Kitchen, Entrance Foyer, Formal Dining, High Ceilings, Kitchen Island, Low Flow Plumbing Fixtures, Natural Woodwork, Open Floorplan, Open Kitchen, Pantry, Primary Bathroom, Quartz/Quartzite Counters, Recessed Lighting, Sauna, Smart Thermostat, Soaking Tub, Storage, Walk-In Closet(s)
Flooring: Hardwood
Basement: Finished,Full,Walk-Out Access
Attic: Unfinished
Number of fireplaces: 1
Common walls with other units/homes: Center
Interior area
Total structure area: 4,200
Total interior livable area: 4,200 sqft
Property
Parking
Total spaces: 2
Parking features: Attached
Garage spaces: 2
Features
Patio & porch: Deck, Patio
Pool features: Community
Lot
Size: 51.96 Acres
Details
Parcel number: 222903162000829UCA006600023
Special conditions: None
Construction
Type & style
Home type: Condo
Property subtype: Condominium, Residential
Attached to another structure: Yes
Materials
Brick, Vinyl Siding
Condition
Updated/Remodeled
Year built: 1982
Utilities & green energy
Sewer: Public Sewer
Water: Public
Utilities for property: Electricity Connected, Sewer Connected, Trash Collection Private, Underground Utilities, Water Connected
Community & HOA
Community
Features: Clubhouse, Fitness Center, Gated, Pool, Tennis Court(s)
Subdivision: Estates II
HOA
Has HOA: Yes
Services included: Common Area Maintenance, Maintenance Structure, Maintenance Grounds, Pool Service, Snow Removal, Trash
HOA fee: $1,050 monthly
Location
Region: Manhasset
Financial & listing details
Price per square foot: $761/sqft
Tax assessed value: $1,160
Annual tax amount: $18,221
Date on market: 6/4/2026
Cumulative days on market: 257 days
Listing agreement: Exclusive Right To Sell
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
3/29/2026
Price change
$3,198,000-3%$761/sqft
Source: OneKey® MLS as distributed by MLS GRID #880729Report a problem
1/29/2026
Price change
$3,298,000-5.7%$785/sqft
Source: OneKey® MLS as distributed by MLS GRID #880729Report a problem
11/20/2025
Price change
$3,498,000-7.9%$833/sqft
Source: OneKey® MLS as distributed by MLS GRID #880729Report a problem
11/5/2025
Listed for sale
$3,800,000+126.2%$905/sqft
Source: OneKey® MLS as distributed by MLS GRID #880729Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.