40 Sunset Rd, Great Neck, NY 11024

    $5,750,000

    Not found in source

    9 beds
    8 baths
    5,809 sq ft
    Built in
    Some financial estimates for this property, including market rent, property taxes, and insurance cost, are missing or deemed unreliable. As a result, the calculated metrics are incomplete. Simply enter your own assumptions to proceed with your analysis.

    Purchase price

    Down payment

    Estimated rent

    About 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...

    Days on market

    150

    Property type

    Single family home

    Price per square foot

    $990

    Lot size

    47,084 sq ft

    HOA fees

    -

    Neighborhood score

    5 / 5

    School score

    8.3 / 10

    Crime score

    1 / 10

    MLS Logo

    Listed By: Lisa Testagrose, 30TE1004539, Coldwell Banker American Homes

    Source: OneKey MLS, #866599, last updated on 9/11/2025

    Neighborhood

    9 / 10

    John F Kennedy School

    7 / 10

    Great Neck North Middle School

    9 / 10

    Great Neck North High School