Water Front Luxury Realty

Save
Ask
Tour
Hide
Share
$5,750,000
10 Days On Site

40 Sunset Road
Great Neck, NY 11024

For Sale|Single Family Residence|Active
9
Beds
8
Total Baths
7
Full Baths
1
Partial Bath
5,809
SqFt
$990
/SqFt
1925
Built
County:
Nassau
Listing courtesy of Coldwell Banker American Homes ltestagrose@cbamhomes.com

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

Call Now: 987-456-3210
Is this the listing for you? We can help make it yours.
987-456-3210
40 Sunset Road40 Sunset Road40 Sunset Road40 Sunset Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$26,234
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$5,750,000
Days On Site 
10 Days
Bedrooms 
9
Inside Area (SqFt) 
5,809 sqft
Total Baths 
8
Full Baths 
7
Partial Baths 
1
Lot Size 
1.02 Acres
Year Built 
1925
MLS® Number 
866599
Status 
Active
Property Tax 
$71,832.25
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 weeks agoListing first seen on site
2 weeks agoListing updated with changes from the MLS®
General Features
Acres 
1.02
Cross Street 
Kings Point Road
Garage 
Yes
Garage Spaces 
3
Parking 
DetachedGaragePrivate
Property Sub Type 
Single Family Residence
Sewer 
Cesspool
SqFt Total 
5809
Stories 
Three Or More
Style 
ColonialCottage
Utilities 
Natural Gas AvailableElectricity ConnectedNatural Gas ConnectedWater Connected
Water Source 
Public
Interior Features
Appliances 
Gas OvenRefrigeratorStainless Steel Appliance(s)
Basement 
Level - BasementDescription - Unfinished/Storage
Cooling 
Wall/Window Unit(s)
Fireplace 
Yes
Fireplaces 
3
Heating 
Hot WaterNatural Gas
Interior 
Eat-in KitchenEntrance FoyerHigh Ceilings
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Frame
Exterior 
Dock
Lot Features 
Waterfront
Other Structures 
Guest House
Pool Features 
In GroundPrivate
Private Pool 
Yes
View 
Bridge(s)CityPanoramicSkylineWater
Waterfront Features 
Beach AccessBeach FrontWaterfrontWaterfront Access
Waterview 
Bridge(s)CityPanoramicSkylineWater
Community Features
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 ltestagrose@cbamhomes.com


Based on information submitted to the MLS GRID as of 2025-06-11 10:13 AM 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

REACH MICHELLE MADTES!


    error: Content is protected !!