40 Sunset Road, Great Neck, NY 11024

Local realty services provided by:Better Homes and Gardens Real Estate Choice Realty
#1#2#3
40 Sunset Road,Great Neck, NY 11024
$5,750,000
  • 9 Beds
  • 8 Baths
  • 5,809 sq. ft.
  • Single family
  • Active
Listed by:lisa m. testagrose
Office:coldwell banker american homes
MLS#:866599
Source:One Key MLS

Price summary

  • Price:$5,750,000
  • Price per sq. ft.:$989.84

About this home

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

Contact an agent

contact an agent

Yes, I would like more information from BHGRE®. Please use and/or share my information with an BHGRE affiliated agent to contact me about my real estate needs. By clicking Send message, I agree an BHGRE affiliated agent may contact me by phone or text message including by automated means 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 theTerms of useandPrivacy notice

Home facts

  • Year built:1925
  • Listing Id #:866599
  • Added:74 day(s) ago
  • Updated:July 13, 2025 at 10:40 AM

Rooms and interior

  • Bedrooms:9
  • Total bathrooms:8
  • Full bathrooms:7
  • Half bathrooms:1
  • Living area:5,809 sq. ft.

Heating and cooling

  • Heating:Hot Water, Natural Gas

Structure and exterior

  • Year built:1925
  • Building area:5,809 sq. ft.
  • Lot area:1.08 Acres

Schools

  • High school:Great Neck North High School
  • Middle school:Great Neck North Middle School
  • Elementary school:E M Baker School

Utilities

  • Water:Public
  • Sewer:Cesspool

Finances and disclosures

  • Price:$5,750,000
  • Price per sq. ft.:$989.84
  • Tax amount:$71,832 (2025)
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.

New listings near 40 Sunset Road