40 Sunset Rd Great Neck, NY 11024
Property details
About 40 Sunset Rd
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.
Highlights
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 7
- Appliances: Gas Oven, Refrigerator, Stainless Steel Appliance(s)
- Basement: Yes
- Interior: First Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining, High Ceilings, Primary Bathroom
- Total Bedroom Count: 9
- Garage Space: 3 spaces
- Private Pool: Yes
- Parking: Detached, Garage, Private
- Waterfront: Beach, Sound, Water Access, Waterfront
- View: Bridge(s), City, Panoramic, Skyline, Water
- Exterior: Boat Dock
- Architectural Style: Colonial, Cottage
- Heating: Hot Water, Natural Gas
- Cooling: Wall/Window Unit(s)
- List Price: $5,750,000
- Price/SqFt: $989
- Annual Tax Amount: $10,486
- Tax Year: 2024
- Lot: Waterfront
- Directions: Kings Point Road to Sunset Road
- Year Built: 1925
- Living Area: 5,809 SqFt
- Lot Size: 1.02 Acres
- MLS Number: 866599
- MLS Name: ONEKEY2
- Office Name: Coldwell Banker American Homes
- Office Phone: (516) 334-4333
Listings courtesy of OneKey MLS as distributed by MLS GRID.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
DMCA Notice
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/23/2025, 11:56:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $3,601 | $10,486 |
| 2023 | $3,601 | $63,512 |
| 2022 | $3,601 | $71,025 |
| 2021 | $3,783 | $85,709 |
| 2020 | $3,904 | $94,420 |
| 2019 | $9,826 | $88,468 |
| 2018 | $9,826 | $84,690 |
| 2017 | $9,826 | $80,524 |
History based on county public records data.
Nearby schools
8
John F. Kennedy Elementary School
Public District PK-5
1.5 mi
•1A Grassfield Rd
8
Saddle Rock Elementary School
Public District KG-5
1.8 mi
•10 Hawthorne Ln
8
Elizabeth M. Baker Elementary School
Public District KG-5
2.0 mi
•69 Baker Hill Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $176,351. The majority of Great Neck, NY residents have income $200k+ annually. Typical family type is married, no kids. Most residents in this area have post secondary degree education.
How much money do the neighbors make?
What level of education do the neighbors have?
What types of families live nearby?
Are the neighbors home owners or renters?
How old are people in this area?
What do the neighbors do for fun?
PGA/LPGA
Skiing/snowboarding
Men's Tennis
Where do the neighbors shop?
Chico's
Nordstrom
Bloomingdales
Where do the neighbors go to eat?
Bonefish Grill
California Pizza Kitchen
Qdoba
What do the neighbors drive?
Cadillac
BMW
Lexus
What do the neighbors listen to?
Classical
Talk/Personality
News
Frequently asked questions
About 40 Sunset Rd
The listing price of 40 Sunset Rd property is $5,750,000.
The property 40 Sunset Rd is a house located in Great Neck, New York, 11024.
Active Listing: 40 Sunset Rd is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 40 Sunset Rd are: John F. Kennedy Elementary School (GreatSchools Rating 8/10), Saddle Rock Elementary School (GreatSchools Rating 8/10), Elizabeth M. Baker Elementary School (GreatSchools Rating 8/10), Richard S. Sherman Great Neck North Middle School (GreatSchools Rating 7/10), P.S. 175 City Island School (GreatSchools Rating 6/10), Bell Academy (GreatSchools Rating 8/10), John L. Miller Great Neck North High School (GreatSchools Rating 9/10), Bayside High School (GreatSchools Rating 8/10), Manhasset Secondary School (GreatSchools Rating 10/10).
According to the records, the last property tax for 2024 is $10,486 (source: MLS/based on county public records data).
The property at 40 Sunset Rd has 9 bedrooms and 7 full and 1 half bathrooms.
The property 40 Sunset Rd is 5,809 SqFt (source: MLS/tax record).
The year of construction for 40 Sunset Rd is 1925.
This home is located at 40 Sunset Rd in Great Neck, NY and zip code 11024 in the Town of North Hempstead neighborhood. This 5,809 square foot home, which was built in 1925, sits on a 1.02 acre lot. Features: 9 bedrooms, 8 bathrooms. It has been listed on Rocket Homes since May 31, 2025 and is currently priced at $5,750,000.
Great Neck, NY housing market in June 2025 saw over 6 listings sold above listed price, more than 2 sold at listed price and over 12 sold below. In June 2025 in Great Neck, NY there were 1.9% more homes for sale than in May. While the average time on the market in June 2025 was 47 days, the median list price was $1,118,000.