Skip to content

Great Neck, NY 11024 40 Sunset Road

40 Sunset Road Great Neck, NY - Image 140 Sunset Road Great Neck, NY - Image 240 Sunset Road Great Neck, NY - Image 3
11 more
40 Sunset Road Great Neck, NY - Image 440 Sunset Road Great Neck, NY - Image 540 Sunset Road Great Neck, NY - Image 640 Sunset Road Great Neck, NY - Image 740 Sunset Road Great Neck, NY - Image 840 Sunset Road Great Neck, NY - Image 940 Sunset Road Great Neck, NY - Image 1040 Sunset Road Great Neck, NY - Image 1140 Sunset Road Great Neck, NY - Image 1240 Sunset Road Great Neck, NY - Image 1340 Sunset Road Great Neck, NY - Image 1440 Sunset Road Great Neck, NY - Image 15
  • MLS# 866599
  • Get pre-approved
  • Make an Appointment
  • Request Info
  • Beds • 9
  • Full/Half Baths • 7 / 1
  • SQFT • 5,809
  • Garage • 3

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
Price $5,750,000
MLS#866599
Property Type Single Family
Get pre-approved
Request Tour
Request Info
Visit My Website

Similar Properties to 40 Sunset Road