House, Apartment, Offices & Other Property For Sale
In Long Island, New York

Find a wide range of properties for sale in Long Island, New York, from beautiful houses and modern apartments to prime office spaces and commercial properties. Whether you’re looking for a cozy home, a stylish apartment, or the perfect location for your business, our listings offer something for everyone. Each property includes detailed information, photos, and key features to help you make an informed choice. Our team is dedicated to helping you find the right fit in Long Island’s diverse communities. Start browsing now to discover great opportunities and make your next real estate move with confidence.
Save
Ask
Tour
Hide
Share
$7,552,500
24 Days On Site

40 Sunset Road
Great Neck, NY 11024

For Sale|Single Family Residence|Active
9
Beds
6
Full Baths
1
Partial Bath

SqFt

/SqFt
1925
Built
County:
Nassau County
Listing courtesy of Coldwell Banker American Homes dpolland@cbamhomes.com

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

40 Sunset Road40 Sunset Road40 Sunset Road40 Sunset Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$34,458
Calculator powered by Showcase IDX. Copyright ©2024 Information is deemed reliable but not guaranteed.

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

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$7,552,500
Days On Site 
24 Days
Bedrooms 
9
Inside Area (SqFt) 
N/A
Total Baths 
7
Full Baths 
6
Partial Baths 
1
Lot Size 
N/A
Year Built 
1925
MLS® Number 
L3566075
Status 
Active
Property Tax 
$75,570.19
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 weeks agoPrice changed to $7,552,500
2 weeks agoListing updated with changes from the MLS®
3 weeks agoListing first seen on site
General Features
Cross Street 
Kings Point Road
Parking 
PrivateDetached
Property Sub Type 
Single Family Residence
Sewer 
Cesspool
Stories 
Multi/Split
Style 
Colonial
Water Source 
Public
Interior Features
Appliances 
Gas Water Heater
Basement 
Unfinished
Cooling 
Wall/Window Unit(s)
Fireplace 
Yes
Fireplaces 
3
Flooring 
Hardwood
Heating 
Natural GasHot Water
Interior 
Eat-in KitchenEntrance Foyer
Auxiliary Room 
Level - BasementDescription - Unfinished/Storage
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Frame
Exterior 
Dock
Lot Features 
WaterfrontNear Public Transit
Other Structures 
Outbuilding
Pool Features 
In GroundPrivate
Private Pool 
Yes
View 
CityPanoramic
Waterfront Features 
Beach AccessBeach FrontWaterfront
Waterview 
CityPanoramic
Community Features
Association Amenities 
Powered Boats AllowedPark
School District 
Great Neck
Schools
School District
Great Neck
Elementary School
E M Baker School
Middle School
Great Neck North Middle School
High School
Great Neck North High School
Listing courtesy of Coldwell Banker American Homes dpolland@cbamhomes.com


Based on information submitted to the MLS GRID as of 2024-10-29 08:00 PM EDT. 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.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

Accessibility Toolbar