Skip to main content
Back to Search Results
|

40 Sunset Road, Great Neck, NY 11024

Show All 16 Photos
For Sale

$5,750,000

9 beds • 7 baths • 1 half baths • 5,809 sqft

Estimated Payment

$      /mo. †

APR for 30 years

Change Loan Terms

  • Single Family Detached
    Property type

  • $989.84
    Price per square foot

  • Over 50 Years Old
    Age

  • Basement
    Rooms

Explore this Property

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.
MLS# 866599

Courtesy Of Coldwell Banker American Homes

(866) 664-0347

Property Features

  • Age
    Over 50 Years Old
  • Amenities
    Dock, Pool, Water Front
  • Appliances
    Oven - Gas, Refrigerator
  • Architecture Style
    Colonial
  • Lot Size
    1.02 Acres
  • Rooms
    Basement
  • View Type
    Bridge, City, Panorama, Water

Map and Directions

Directions to 40 Sunset Road, Great Neck, NY 11024

Home seller CENTURY 21 Unique Realty

Get to know the neighborhood. A local affiliated CENTURY 21 office will help you set up tours, give advice, and negotiate with sellers.

CENTURY 21 Unique Realty

(516) 625-9100
Learn More About Us

Mortgage Calculator

$
$ %
Loan Term
%
Invalid number

$ /year
$ /year
$ /month

Monthly Payment Breakdown

  • Principle and Interest
    $0
  • Property Taxes
    $0
  • Hazard Insurance
    $0
  • Private Mortgage Insurance
    $0
  • HOA Dues
    $0
  • Total Monthly Payment:
    $0

Calculators provided for estimating purposes only. Consult with your lender to determine precise payment requirements.

An Equal Opportunity Company

Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified. Information being provided is 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 being provided is 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.

Data powered by Attom Data Solutions. Copyright© 2025. Information deemed reliable but not guaranteed.

This information is provided for general informational purposes only and should not be relied on in making any home-buying decisions. School information does not guarantee enrollment. Contact a local real estate professional or the school district(s) for current information on schools. This information is not intended for use in determining a person's eligibility to attend a school or to use or benefit from other city, town or local services.

† Based on a 30-year fixed rate of 3.38% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Interest rates are also subject to credit and property approval based on secondary market guidelines. The rates shown are based on average rates for our best qualified customers. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Loading