Great Neck, NY 11024 40 Sunset Road
$5,750,000



11 more












Home Details
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 living—where every day ends with a breathtaking sunset.
Interior Features for 40 Sunset Road
Bedrooms
Total Bedrooms9
Bathrooms
Half Baths1
Total Baths8
Kitchen
Eat-in KitchenY
Other Interior Features
Formal DiningY
LivingAreaSourceOther
General FeaturesFirst Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining, High Ceilings, Primary Bathroom
Entrance FoyerY
BasementFull
Basement (Y/N)Yes
Basement FeaturesFull
Fireplace Y/NYes
Interior AmenitiesFirst Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining, High Ceilings, Primary Bathroom
Total Fireplaces3
General for 40 Sunset Road
Additional Parcels Y/NNo
AppliancesGas Oven, Refrigerator, Stainless Steel Appliance(s)
Architectural StyleColonial, Cottage
AttributionContact516-334-4333
Building Area UnitsSquare Feet
Carport Y/NNo
CityNorth Hempstead
Construction MaterialsFrame
CoolingWall/Window Unit(s)
CountyNassau County
DirectionsKings Point Road to Sunset Road
Elementary SchoolE M Baker School
Elementary School DistrictGreat Neck
Full Baths7
Garage Spaces3
Garage Y/NYes
HOANo
HeatingHot Water, Natural Gas
High SchoolGreat Neck North High School
High School DistrictGreat Neck
Lease Considered Y/NNo
LevelsThree Or More
Listing AppliancesGas Oven, Refrigerator, Stainless Steel Appliance(s)
Lot Size Square Feet47084
Middle/Junior High SchoolGreat Neck North Middle School
Middle/Junior School DistrictGreat Neck
ModificationTimestamp2025-06-05T07:28:36.583Z
Other StructuresGuest House
Parcel Number2217-01-200-00-0018-0
Pool FeaturesIn Ground
PostalCityGreat Neck
Property Attached Y/NNo
Property SubtypeSingle Family Residence
Property TypeResidential
Senior Community Y/NNo
SewerCesspool
Showing InstructionsBy Appointment Only - DO NOT WALK PROPRTY WITHOUT LISTING AGENT! Pre-Approval and/or Proof of Funds to be emailed to Ltestagrose@cbamhomes.com
Standard StatusActive
StatusActive
Tax Annual Amount71832.25
Tax Lot18
Tax Year2025
Total Rooms17
UtilitiesElectricity Connected, Natural Gas Connected, Water Connected
ViewBridge(s), City, Panoramic, Skyline, Water
Waterfront FeaturesBeach Access, Beach Front, Sound, Water Access, Waterfront
Year Built1925
Exterior for 40 Sunset Road
Building Area Total5809
Exterior AmenitiesDock
General Features Ext.Dock
Lot DimensionsIrregular
Lot FeaturesWaterfront
Lot Size Acres1.02
Parking FeaturesDetached, Garage, Private
Parking FeaturesDetached, Garage, Private
Water SourcePublic
Waterfront Y/NYes
Additional Details
Price History
Schools
Middle School
Great Neck North Middle School
High School
Great Neck North High School
Elementary School
E M Baker School Elementary School
Berkshire Hathaway HomeServices
Management