Skip To Content

40 Sunset Road

Great Neck, NY 11024
  • $5,750,000
  • STATUS: Active
  • ON SITE: 15 Days
  • MLS #: 866599
$5,750,000
  • 9
    BEDS
  • 1.02
    ACRES
  • 7
    BATHS
  • 1
    1/2 BATHS
  • 5,809
    SQFT
  • $990
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
1925
County:

School Information

Elementary School:
School District:

Description

A Rare opportunity to own a waterfront compound on Long Island's Gold Coast within the prestigious Village of Kings Point ,New York. This gated and fenced 1.02-acre estate sits within a private cul-de-sac and offers a 185-foot deep-water private pier and sea wall promenade with stunning views of the Manhattan skyline. The main Colonial-style residence features three full floors and basement with 6 bedrooms and 5 1/2 baths. The adjacent Cottage provides a 3 bedroom, 2 bath guest home with separate driveway. The Property also has a detached 3-car garage. Amenities include a grand in-ground pool, expansive lawns, and a long gated driveway. Enjoy unmatched privacy and security near the Kings Point Police HQ and the U.S. Merchant Marine Academy, with access to the renowned Great Neck Schools and Great Neck Park District and nearby Steppingstone Park and Parkwood Sports Complex featuring Pool Tennis and Ice Rink . Perfect for a luxurious retreat or future redevelopment. Just minutes from NYC, this is a rare opportunity to own a legacy estate in a prestigious location. The Sunset Estate embodies the pinnacle of waterfront livingwhere every day ends with a breathtaking sunset.

Monthly Payment Calculator



© 2025 OneKey MLS. All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Team Braconi | Christie's International Real Estate | Northern New Jersey. Data last updated: 2025-06-16T00:17:45.783.
www.teambraconihomesales.com/homes/164424244
Print Image

40 Sunset Road Great Neck, NY 11024

  • Price: $5,750,000
  • Status: Active
  • On Site: 15 Days
  • MLS #: 866599
9
Beds
7
Baths
1
½ Baths
1.02
Acres
5,809
SQFT
$990
$/SQFT
1925
Built
Neighborhood:
North Hempstead
County:
Nassau
Area:
North Hempstead
Elementary School:
E M Baker School
Middle School:
Great Neck North Middle School
High School:
Great Neck North High School
School District:
Great Neck
Property Description
A Rare opportunity to own a waterfront compound on Long Island's Gold Coast within the prestigious Village of Kings Point ,New York. This gated and fenced 1.02-acre estate sits within a private cul-de-sac and offers a 185-foot deep-water private pier and sea wall promenade with stunning views of the Manhattan skyline. The main Colonial-style residence features three full floors and basement with 6 bedrooms and 5 1/2 baths. The adjacent Cottage provides a 3 bedroom, 2 bath guest home with separate driveway. The Property also has a detached 3-car garage. Amenities include a grand in-ground pool, expansive lawns, and a long gated driveway. Enjoy unmatched privacy and security near the Kings Point Police HQ and the U.S. Merchant Marine Academy, with access to the renowned Great Neck Schools and Great Neck Park District and nearby Steppingstone Park and Parkwood Sports Complex featuring Pool Tennis and Ice Rink . Perfect for a luxurious retreat or future redevelopment. Just minutes from NYC, this is a rare opportunity to own a legacy estate in a prestigious location. The Sunset Estate embodies the pinnacle of waterfront livingwhere every day ends with a breathtaking sunset.
Exterior Features

Architectural Style ColonialCottage Carport YN No Construction Materials Frame Cross Street Kings Point Road Exterior Features Dock Garage YN Yes Levels Three Or More Lot Features Waterfront Parking Features DetachedGaragePrivate Pool Features In Ground Pool Private YN Yes Property Attached YN No View Bridge(s)CityPanoramicSkylineWater Waterfront Features Beach AccessBeach FrontSoundWater AccessWaterfront Waterfront YN Yes

Interior Features

Appliances Gas OvenRefrigeratorStainless Steel Appliance(s) Attic None Basement Details Full Basement YN Yes Cooling Wall/Window Unit(s) Fireplace YN Yes Fireplaces Total 3 Interior Features First Floor Full BathEat-in KitchenEntrance FoyerFormal DiningHigh CeilingsPrimary Bathroom Number Of Kitchens 2 Rooms Total 17

Property Features

Association YN No Building Area Total 5809 Down Payment Resource YN No Heating Hot WaterNatural Gas Lease Considered YN No Lot Size Dimensions Irregular Other Structures Guest House Property Sub Type Single Family Residence Senior Community YN No Sewer Cesspool Special Listing Conditions None Tax Annual Amount 71832.25 Tax Section 1 Tax Source Other Utilities Electricity ConnectedNatural Gas ConnectedWater Connected Village Kings Point Water Access YN Yes Water Source Public

Listing courtesy of Lisa M. Testagrose of Coldwell Banker American Homes: 516-334-4333
© 2025 OneKey MLS. All rights reserved.


© 2025 OneKey MLS. All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Team Braconi | Christie's International Real Estate | Northern New Jersey. Data last updated: 2025-06-16T00:17:45.783.
 
https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_2_866599-1.jpg https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_2_866599-1.jpg https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_2_866599-1.jpg
Logo
Team Braconi | Christie's International Real Estate | Northern New Jersey
837 Franklin Lake Rd
Franklin Lakes NJ, 07417