Skip main navigation
For sale
  • Price cut: $1.8M (5/31)
    $5,750,000

    40 Sunset Road, Great Neck, NY 11024

    9beds
    5,809sqft
    Single Family Residence, Residential
    Built in 1925
    1.08 Acres Lot
    $-- Zestimate®
    $990/sqft
    $-- HOA

    What's special

    Waterfront compoundGrand in-ground poolPrivate cul-de-sacColonial-style residenceExpansive lawnsGated driveway
    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.
    68 days
    on Zillow
    |
    1,859
    |
    51
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 05, 2025 at 12:28am

    Listing by:

    Coldwell Banker American Homes 516-334-4333,

    Lisa M. Testagrose 516-334-4333

    Source: OneKey® MLS,MLS#: 866599MLS Logo
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 40 Sunset Road.

    Next available tour time:Today at 11am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 9
    • Bathrooms: 8
    • Full bathrooms: 7
    • 1/2 bathrooms: 1
    Other
    • Description: Entry Foyer, Formal DR w/FP, Huge EIK, LR, Den, 1 1/2 Baths
    • Level: First
    Other
    • Description: Primary Bedroom with Full Bath, 2 additional Bedrooms Hall Full Bath, Sitting Area
    • Level: Second
    Other
    • Description: Additional Primary Bedroom with Full Bath, 2 additional Bedrooms, Hall Full Bath and sitting area
    • Level: Third
    Other
    • Description: Guest Cottage, 3 Bedrooms, 2 Baths, LR, DR, Kitchen and Den
    • Level: Other
    Basement
    • Description: Unfinished/Storage
    • Level: Basement
    Heating
    • Hot Water
    Cooling
    • Wall/Window Unit(s)
    Appliances
    • Included: Gas Oven, Refrigerator, Stainless Steel Appliance(s)
    Features
    • First Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining, Primary Bathroom
    • Basement: Full
    • Attic: None
    • Number of fireplaces: 3
    Interior area
    • Total structure area: 5,809
    • Total interior livable area: 5,809 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Detached, Garage, Private
    • Garage spaces: 3
    Features
    • Levels: Three Or More
    • Has private pool: Yes
    • Pool features: In Ground
    • Has view: Yes
    • View description: Bridge(s), City, Panoramic, Skyline, Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Beach Access, Beach Front, Sound, Water Access, Waterfront
    Lot
    • Size: 1.08 Acres
    Details
    • Additional structures: Guest House
    • Parcel number: 2217012000000180
    • Special conditions: None

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial,Cottage
    • Property subtype: Single Family Residence, Residential
    Condition
    • Year built: 1925

    Utilities & green energy

    • Sewer: Cesspool
    • Water: Public
    • Utilities for property: Electricity Connected, Natural Gas Connected, Water Connected

    Community & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Great Neck

    Financial & listing details

    • Price per square foot: $990/sqft
    • Annual tax amount: $71,832
    • Date on market: 5/31/2025
    • Listing agreement: Exclusive Right To Sell
    • Electric utility on property: Yes
    • Loading
    • Loading