x
Showing 1 of 0
X
Save

40 Sunset Road
Great Neck NY 11024 US

$7,552,500

Active Listing ID L3566075
bed icon
9 bed
bath icon
7.00 Bath (6 Full , 1 Half)
home icon
Single Family Residence

$7,552,500

Active Listing ID L3566075
Save

40 Sunset Road 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

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 6
  • 1/2 Bathrooms: 1
  • Cooling System: Window Unit(s) A/C
  • Exterior Finish: Dock, Pool
  • Floor Covering: Hardwood
  • Heating Fuels: Hot Water
  • Additional Features
  • Pool
  • Waterfront

School Information

  • School
  • E M Baker School(Elementary)
  • Great Neck North Middle School(MiddleSchool)
  • Great Neck North High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 7552500
  • unparsedaddress: 40 Sunset Road
  • postalcity: Great Neck
  • stateorprovince: NY
  • country: US
  • postalcode: 11024
  • bathroomsfull: 6
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 40.816515
  • longitude: -73.759658
  • listagentfullname: Diane L. Polland
  • listagentemail: dpolland@cbamhomes.com
  • listagentkey: 3yd-MLSLINY-125069
  • listagentmlsid: 125069
  • listagentpreferredphone: 8666640347
  • listagentofficephone: 8666640347
  • listofficekey: 3yd-MLSLINY-BRMN18
  • listagentstatelicense: 40PO1038881
  • listofficemlsid: BRMN18
  • disclaimer: Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1925
  • listingcontractdate: 2024-07-16
  • listagenturl: http://www.cbamhomes.com
  • countyorparish: Nassau County
  • parcelnumber: 2217-01-200-00-0018-0
  • elementaryschool: E M Baker School
  • highschool: Great Neck North High School
  • elementaryschooldistrict: Great Neck
  • middleorjuniorschooldistrict: Great Neck
  • highschooldistrict: Great Neck
  • cooling: Window Unit(s) A/C
  • constructionmaterials: Frame
  • flooring: Hardwood
  • heating: Hot Water
  • numberofunitstotal: 1
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • view: City, Panorama
  • waterfrontyn: True
  • franchiseaffiliation: Coldwell Banker Real Estate
  • interiorfeatures: Primary Bathroom, Eat-in Kitchen, Entrance Foyer, Formal Dining
  • exteriorfeatures: Dock, Pool
  • waterfrontfeatures: Beach Access, Beach Front, Waterfront, Waterfront
  • architecturalstyle: Colonial
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5
  • structuretype: Dock
  • dock: True
  • poolprivateyn: True
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.75966, 40.816517
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Coldwell Banker American Homes", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"leads0822@leadparser.deltagroup.com", "ListBrokerageCity":"East Meadow", "ListBrokerageCountry":"US", "ListBrokerageEmail":"leads0822@leadparser.deltagroup.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/c5ababc31c90dea1011c91901ba23ee5/20210818200407414.png", "ListBrokerageName":"Coldwell Banker American Homes", "ListBrokeragePhone":"8666640347", "ListBrokeragePostalCode":"11554", "ListBrokerageStateOrProvince":"NY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"1856 Hempstead Turnpike", "ListBrokerageWebsiteUrl":"http://www.cbamhomes.com", "ListOfficeAddress1":"600 Plandome Rd", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"42452", "ListOfficeCity":"Manhasset", "ListOfficeCountry":"US", "ListOfficeEmail":"manhasset@cbamhomes.com", "ListOfficePostalCode":"11030", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence, Colonial - Great Neck, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/40-Sunset-Rd_Great-Neck_NY_11024_M40980-21650?f=listhub&s=MLSLINY&m=L3566075&c=rexren", "MLSModificationTimestamp":"2025-02-03T14:31:36Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":12, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":75570.19, "TaxDescription":null, "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 2/3/2025 9:33:07 PM GMT
Source Updated Date: 3/11/2025 6:48:48 AM GMT

Courtesy of: Diane L. Polland, Coldwell Banker American Homes, dpolland@cbamhomes.com

Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.