Property details
About 40 Sunset Rd
The Sunset Estate - This spectacular waterfront estate is located in Kings Point, New York, on over 47,000 square feet of gated private grounds with sprawling lawns offering panoramic views of the Long Island Sound. This exceptional compound featuring a six-bedroom, four + bath, Colonial grand main residence, as well as an additional two-bedroom, two bath private guest house, pool, and a detached three car garage. An extraordinary feature of this property, with its stellar panoramic views, is its waterfront promenade with a deepwater pier that extends +/- 185 feet into the Long Island Sound. Your private and protected safe harbor can accommodate any type of boat. Celebrate life and enjoy city skyline views and magnificent sunsets every day of the year! Located on a very quiet exclusive cul-de-sac, and surrounded by the security of the Kings Point Police Headquarters and the United States Merchant Marine Academy, there is no safer place for carefree living. A long private driveway winds its way through the property, accessing each home individually. The property is ultimately defined by the splendid setting and stunning waterfront views enjoyed year-round. The unique surroundings and unmatched private location truly exemplify waterfront living at its very best. Kings Point residents have access to the Great Neck Park District, which offers summer concerts, beautiful parks, camps, and endless activities year-round. Renovate or build new, 40 Sunset can be your fresh palette, worthy of building your dream home. The possibilities are endless.......... Dreams can become your reality at 40 Sunset., Additional information: Appearance:Good
Highlights
Summary
- MLS Number: L3566075
- MLS Name: ONEKEY2
- Office Name: Coldwell Banker American Homes
- Office Phone: (516) 365-5780
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.
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: 2/8/2025, 7:11:49 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$7,552,500
40 Sunset Rd
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
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. Residents of Great Neck, NY typically earn $200k+ each year. Residents typically live in married, no kids family. Residents of this area typically 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
This home is located at 40 Sunset Rd in Great Neck, NY and zip code 11024 in the Town of North Hempstead neighborhood. Features: 9 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since July 16, 2024 and is currently priced at $7,552,500.
In January 2025 more than 6 listings in Great Neck, NY were sold above the asking price. During the same period more than 4 listings were sold at asking price, while more than 27 were sold below. The number of homes for sale in Great Neck, NY decreased by 8.6% between December and January 2025. In January 2025 median list price was $1,000,199 and the average listing age was 71 days.