Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker American Homes
Property view
Listing view 2
Listing view 3

40 Sunset Road, 
Great Neck, NY 11024

$5,750,000


9

Beds


8

Baths


5,809

Sq Ft


Single Family

Active

Last updated:

June 5, 2025, 11:44 AM

MLS#

866599

Source:

One Key MLS

Company Logo

About This Home

40 Sunset Road

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.

Home Facts

Single Family

8 Baths

9 Bedrooms

Built in 1925

Price Summary

5,750,000

$989 per Sq. Ft.

MLS #:

866599

Last Updated:

June 5, 2025, 11:44 AM

Added:

8 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

9

Bathrooms

Total Bathrooms:

8

Full Bathrooms:

7

Interior

Living Area:

5,809 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial, Cottage

Building Area:

5,809 Sq. Ft.

Year Built:

1925


Lot

Lot Size (Sq. Ft):

47,084


Finances & Disclosures

Finances

Price:

$5,750,000

Price per Sq. Ft:

$989 per Sq. Ft.

Source:One Key MLS
Copyright 2025 OneKey MLS. All rights reserved. OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.