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.
This property is $7.2M more than the Median Sold Price in Great Neck, NY.
Based on homes sold in the last 12 months
MLS Details
MLS Information:
MLS Name: ONEKEY
MLS Number: #3566075
Listing Office:
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.
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 2024, 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: 10/24/2024, 11:56:47 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Property Sales & Tax
Tax History
YEAR
PROP. TAX
ASSESSMENT
2021
$85,710
$3,783
2020
$94,420
$3,904
2019
$88,468
$9,826
2018
$84,690
$9,826
2017
$80,524
$9,826
History based on county public records data.
Payment Calculator
Calculate your estimated monthly expenses for this listing. Play with the values below to better understand your monthly payment and utilities.
$41.2K
Per Month
Principal & Interest
$41.1K
Home PriceThe dollar amount you pay for the home.
$
Interest RateMortgage interest rates fluctuate, but they're typically in the 5% to 9% range. Your rate will be calculated based on personal details including your credit score.
%
Down PaymentThe initial money paid at closing that is usually a percentage of the purchase price. Most loans require at least 3% down, but a 0% down payment may be possible if you're eligible for a VA or USDA loan.
$%
Loan TermThis is how long you'll pay on the loan. A longer term gives you smaller payments, while a shorter term saves you money on interest.
Property Taxes
$0
Property Taxes -Annual CostEvery homeowner pays taxes to their local government based on their home's value and the property tax rates for the county or city. Most areas charge property taxes semiannually.
$/ Year
Mortgage Insurance
$0
Mortgage Insurance -Monthly PremiumMortgage insurance helps secure a mortgage with a lower down payment. It typically costs 0.1% - 2% of your loan amount per year.
$/ Month
Homeowners Insurance
$67
Homeowners Insurance -Monthly PremiumMost homeowners pay about $1,000 a year for homeowners insurance, but the cost varies based on your location, home and coverage.
$/ Month
Homeowners Association (HOA)
$0
Homeowners Association -Monthly FeesHomeowners Association (HOA) fees can range from $30 per month to $500+ per month. Be sure to ask your agent about HOA fees on a home as it can impact your affordability or check the online home listing.
$/ Month
Utilities
$0
Utilities - Monthly CostYou'll need to budget for utilities as a homeowner, which typically includes water and sewer, gas and electric, internet and cable. Cost will depend on your location and the size of your home. On a monthly basis, Americans pay $239 - $442 per month.
$/ Month
Recommended Financing
30-Year Fixed
Rate/APR
7.5% / 6.68%
Total Monthly Payment
$24.8K
Schools
Schools Nearby
The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.
We're sorry, we currently don't have assigned school data for this listing.
Nearby Schools
8
/10
John F Kennedy School
1A Grassfield Rd
Distance between this listing and this school1.47 miles
Public District Grades KG-5
9
/10
Saddle Rock School
10 Hawthorne Ln
Distance between this listing and this school1.81 miles
Public District Grades KG-5
9
/10
E M Baker School
69 Baker Hill Rd
Distance between this listing and this school1.96 miles
Public District Grades KG-5
Nearby Schools
8
/10
Great Neck North Middle School
77 Polo Rd
Distance between this listing and this school1.25 miles
Public District Grades 6-8
5
/10
PS 175 City Island
200 City Island Ave
Distance between this listing and this school2.30 miles
Public District Grades KG-8
9
/10
Bell Academy
1825 212th St
Distance between this listing and this school2.56 miles
Public District Grades 6-8
Nearby Schools
7
/10
Great Neck North High School
35 Polo Rd
Distance between this listing and this school1.53 miles
Public District Grades 9-12
7
/10
Bayside High School
3224 Corporal Kennedy St
Distance between this listing and this school3.32 miles
Public District Grades 9-12
10
/10
Manhasset Secondary School
200 Memorial Pl
Distance between this listing and this school3.32 miles
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. Residents of this area typically have post secondary degree education.
All data provided by Home Junction and Claritas
Frequently Asked Questions About 40 Sunset Rd
What is the listing price of this property?
The listing price of 40 Sunset Rd property is $8,250,000.
What type of property is this?
The property 40 Sunset Rd is a house located in Great Neck, New York, 11024.
Is this property for sale now?
Active Listing: 40 Sunset Rd is For Sale (Active/New) which means the seller is accepting offers.
What is the annual property tax for this property?
According to the records, the last property tax for 2021 is $85,710 (source: MLS/based on county public records data).
How many bedrooms and bathrooms does this property have?
The property at 40 Sunset Rd has 9 bedrooms and 6 full and 1 half bathrooms.
Which year was this property built?
The year of construction for 40 Sunset Rd is 1925.
By checking this box and submitting your personal information, you agree to our Terms of Use and Privacy Policy. You also expressly consent to having Rocket Homes Real Estate LLC, its Family of Companies, Rocket Homes Network Partners, and potentially our mortgage partners contact you about your inquiry by text message or phone (including automatic telephone dialing system, AI voice, or an artificial or prerecorded voice) to the residential or cellular telephone number you have provided, even if that telephone number is on a corporate, state, or national Do Not Call Registry. You do not have to agree to receive such calls or messages as a condition of getting any services from Rocket Homes Real Estate, LLC or its partners. By communicating with us by phone, you consent to calls being recorded and monitored. You also agree that we can share your personal data and contact information with third parties such as mortgage partners, partner companies, and affiliates, and that these parties may use your personal data and contact information for marketing and analytic purposes, and to improve your experience.
This home is located at 40 Sunset Rd in Great Neck, NY and zip code 11024 in the Town of North Hempstead neighborhood. This home, which was built in 1925, sits on a 1.08 acre lot. Features: 9 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since July 16, 2024 and is currently priced at $8,250,000.
Over 8 listings were sold over their listed price in September 2024 in Great Neck, NY. In the same period over 22 listings were sold below the listed price and 2 listings were sold for the listed price. Between August 2024 and September 2024, Great Neck, NY real estate market has seen decrease in the number of listings by 1.1%. In September 2024, listings were on the market for 62 days. During the same period, the median list price in this real estate market was $1,015,400.
From Rocket Homes Real Estate and based on county public records data.
Listings courtesy of OneKey MLS as distributed by MLS GRID.
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. 
PGA/LPGA
PGA/LPGA
Skiing/snowboarding
Men's Tennis
Chico's
Nordstrom
Bloomingdales
Bonefish Grill
California Pizza Kitchen
Qdoba
Cadillac
BMW
Lexus
Classical
Talk/Personality
News