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.
For sale
Price cut: $1.8M (5/31)
$5,750,000
40 Sunset Road, Great Neck, NY 11024
9beds
5,809sqft
Single Family Residence, Residential
Built in 1925
1.08 Acres Lot
$-- Zestimate®
$990/sqft
$-- HOA
What's special
Waterfront compoundGrand in-ground poolPrivate cul-de-sacColonial-style residenceExpansive lawnsGated driveway
- 68 days
- on Zillow |
- 1,859 |
- 51 |
Zillow last checked: 7 hours ago
Listing updated: June 05, 2025 at 12:28am
Listing by:
Coldwell Banker American Homes 516-334-4333,
Lisa M. Testagrose 516-334-4333
Source: OneKey® MLS,MLS#: 866599

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 9
- Bathrooms: 8
- Full bathrooms: 7
- 1/2 bathrooms: 1
Other
- Description: Entry Foyer, Formal DR w/FP, Huge EIK, LR, Den, 1 1/2 Baths
- Level: First
Other
- Description: Primary Bedroom with Full Bath, 2 additional Bedrooms Hall Full Bath, Sitting Area
- Level: Second
Other
- Description: Additional Primary Bedroom with Full Bath, 2 additional Bedrooms, Hall Full Bath and sitting area
- Level: Third
Other
- Description: Guest Cottage, 3 Bedrooms, 2 Baths, LR, DR, Kitchen and Den
- Level: Other
Basement
- Description: Unfinished/Storage
- Level: Basement
Heating
- Hot Water
Cooling
- Wall/Window Unit(s)
Appliances
- Included: Gas Oven, Refrigerator, Stainless Steel Appliance(s)
Features
- First Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining, Primary Bathroom
- Basement: Full
- Attic: None
- Number of fireplaces: 3
Interior area
- Total structure area: 5,809
- Total interior livable area: 5,809 sqft
Property
Parking
- Total spaces: 3
- Parking features: Detached, Garage, Private
- Garage spaces: 3
Features
- Levels: Three Or More
- Has private pool: Yes
- Pool features: In Ground
- Has view: Yes
- View description: Bridge(s), City, Panoramic, Skyline, Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Beach Access, Beach Front, Sound, Water Access, Waterfront
Lot
- Size: 1.08 Acres
Details
- Additional structures: Guest House
- Parcel number: 2217012000000180
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Cottage
- Property subtype: Single Family Residence, Residential
Condition
- Year built: 1925
Utilities & green energy
- Sewer: Cesspool
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected, Water Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Great Neck
Financial & listing details
- Price per square foot: $990/sqft
- Annual tax amount: $71,832
- Date on market: 5/31/2025
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
- Loading
- Loading