Skip To Content

40 Sunset Road

Great Neck, NY 11024
  • $7,552,500
  • STATUS: Active
  • ON SITE: 188 Days
  • MLS #: L3566075
UPDATED: 31 min ago
$7,552,500
  • 9
    BEDS
  • 1.08
    ACRES
  • 6
    BATHS
  • 1
    1/2 BATHS
Neighborhood:
Type:
Single-Family Home
Built:
1925
County:

School Information

Elementary School:
School District:

Description

The Sunset Estate - This spectacular waterfront estate is located in Kings Point, New York, on over 47,000 square feet of gated private grounds with sprawling lawns offering panoramic views of the Long Island Sound. This exceptional compound featuring a six-bedroom, four + bath, Colonial grand main residence, as well as an additional two-bedroom, two bath private guest house, pool, and a detached three car garage. An extraordinary feature of this property, with its stellar panoramic views, is its waterfront promenade with a deepwater pier that extends +/- 185 feet into the Long Island Sound. Your private and protected safe harbor can accommodate any type of boat. Celebrate life and enjoy city skyline views and magnificent sunsets every day of the year! Located on a very quiet exclusive cul-de-sac, and surrounded by the security of the Kings Point Police Headquarters and the United States Merchant Marine Academy, there is no safer place for carefree living. A long private driveway winds its way through the property, accessing each home individually. The property is ultimately defined by the splendid setting and stunning waterfront views enjoyed year-round. The unique surroundings and unmatched private location truly exemplify waterfront living at its very best. Kings Point residents have access to the Great Neck Park District, which offers summer concerts, beautiful parks, camps, and endless activities year-round. Renovate or build new, 40 Sunset can be your fresh palette, worthy of building your dream home. The possibilities are endless.......... Dreams can become your reality at 40 Sunset., Additional information: Appearance:Good

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 Berkshire Hathaway HomeService Hudson Valley Properties. Data last updated: 2025-01-21T07:18:34.733.
www.greathudsonvalleyhomes.com/homes/152660149
Print Image

40 Sunset Road Great Neck, NY 11024

  • Price: $7,552,500
  • Status: Active
  • On Site: 188 Days
  • Updated: 31 min ago
  • MLS #: L3566075
9
Beds
6
Baths
1
½ Baths
1.08
Acres
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
The Sunset Estate - This spectacular waterfront estate is located in Kings Point, New York, on over 47,000 square feet of gated private grounds with sprawling lawns offering panoramic views of the Long Island Sound. This exceptional compound featuring a six-bedroom, four + bath, Colonial grand main residence, as well as an additional two-bedroom, two bath private guest house, pool, and a detached three car garage. An extraordinary feature of this property, with its stellar panoramic views, is its waterfront promenade with a deepwater pier that extends +/- 185 feet into the Long Island Sound. Your private and protected safe harbor can accommodate any type of boat. Celebrate life and enjoy city skyline views and magnificent sunsets every day of the year! Located on a very quiet exclusive cul-de-sac, and surrounded by the security of the Kings Point Police Headquarters and the United States Merchant Marine Academy, there is no safer place for carefree living. A long private driveway winds its way through the property, accessing each home individually. The property is ultimately defined by the splendid setting and stunning waterfront views enjoyed year-round. The unique surroundings and unmatched private location truly exemplify waterfront living at its very best. Kings Point residents have access to the Great Neck Park District, which offers summer concerts, beautiful parks, camps, and endless activities year-round. Renovate or build new, 40 Sunset can be your fresh palette, worthy of building your dream home. The possibilities are endless.......... Dreams can become your reality at 40 Sunset., Additional information: Appearance:Good
Exterior Features

Architectural Style Colonial Construction Materials Frame Cross Street Kings Point Road Exterior Features Dock Levels Multi/Split Lot Features Near Public Transit Parking Features PrivateDetached Pool Features In Ground Pool Private YN Yes Property Attached YN No View CityPanoramicOpen Waterfront Features SoundBeach AccessBeach FrontWaterfrontWater Access Waterfront YN Yes

Interior Features

Additional Rooms Library/Den Appliances Gas Water Heater Attic None Basement Details Unfinished Basement YN No Cooling Wall/Window Unit(s) Fireplaces Total 3 Flooring Hardwood Interior Features Primary BathroomEat-in KitchenEntrance FoyerFormal Dining Num Of1 Bed Rooms 0 Num Of2 Bed Rooms 0 Num Of3 Bed Rooms 0 Num Of4 Bed Rooms 0 Number Of Kitchens 2 Rooms Total 12

Property Features

Additional Fees 0.00 Additional Fees YN No Additional Parcel YN No Association Amenities Powered Boats AllowedPark Association YN No Down Payment Resource YN No Heating Natural GasHot Water Lease Considered YN No Lot Size Dimensions Irregular Other Structures Outbuilding Property Sub Type Single Family Residence Seasonal YN No Senior Community YN No Sewer Cesspool Spa YN No Tax Annual Amount 75570.19 Tax Section 1 Village Great Neck Water Source Public

Listing courtesy of Diane L. Polland of Coldwell Banker American Homes: 516-365-5780
© 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 Berkshire Hathaway HomeService Hudson Valley Properties. Data last updated: 2025-01-21T07:18:34.733.
 
https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_5_L3566075-1.jpg https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_5_L3566075-1.jpg https://bt-photos.global.ssl.fastly.net/wpmls/1280_boomver_5_L3566075-1.jpg
Logo
Berkshire Hathaway HomeService Hudson Valley Properties
16 Hurley Avenue
Kingston NY, 12401