This home's estimate is 86.2% higher than the average sale price ($3.43M) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
28 Sunset Rd, Great Neck, NY 11024
About this home
Magnificant Waterfront With City To Connecticut Views. 52 Foot Elevation Above The Water Affords No Worry Waterfront Living. Watch The Sunset Every Day From Your Architecturally Perfect Hamptons Style Home. Relax And Enjoy The Water 365 Days Of The Year!!, Additional information: Appearance:Diamond,Separate Hotwater Heater:Yes
Redfin Estimate
Earn from this home
List your home with Redfin and save $63,923
Get cash now or lower your monthly rate
List your home for rent
Market trends in 11024, NY
Last updated August 2026
Buyer's Market
Seller's Market
Balanced market
- $6,950,0008 beds8.5 baths7,264 sq ft17 Split Rock Dr, Great Neck, NY 11024Listing by S Sharf Realty Inc
- $1,298,0003 beds2.5 baths1,738 sq ft3 Crestwood Pl, Great Neck, NY 11024Listing by Lin Pan Realty Group LLC
- $1,268,0003 beds1 bath732 sq ft98 Steamboat Rd, Great Neck, NY 11024Listing by Coldwell Banker American Homes
See all
Provided by Redfin
Sale history for 28 Sunset Rd
$804/sq ft
$920/sq ft
$920/sq ft
$998/sq ft
$978/sq ft
$998/sq ft
$998/sq ft
$170/sq ft
** Price available after signing in.
Tax history for 28 Sunset Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking Information
- Parking Features: Attached, Private
Interior
- Fireplace Information
- Fireplaces Total: 1
- Heating & Cooling
- Cooling: Central Air
- Heating: Hot Water, Natural Gas
- Interior Features
- Interior Features: Eat-in Kitchen,Formal Dining,Smart Thermostat
- Appliances: Dishwasher, Dryer, Refrigerator, Washer
- Flooring: Carpet, Hardwood
- Patio And Porch Features: Deck, Patio, Porch
- Room Information
- Basement YN: No
- Attic: See Remarks
- Rooms Total: 10
- Basement: Finished, Full
- Additional Rooms: Home Office,Library/Den
- Bathroom Information
- Bathrooms Full: 5
- Bathrooms Half: 1
Exterior
- Exterior Features
- Construction Materials: Frame
- Lot Information
- Additional Parcels YN: No
- Lot Features: Sprinklers In Front, Sprinklers In Rear
- Property Information
- Property Sub Type: Single Family Residence
Financial
- Tax Information
- Tax Section: 1
- Tax Annual Amount: $67,000
- Financial Information
- Buyer Financing: Conventional
Location
- School Information
- School District Number: 7
- High School District: Great Neck
- Location Information
- Village: Great Neck
- Directions: Lie Exit 33 Lakeville Rd To Middle Neck Rd, Left On Redbrook Rd, Left On Kings Point Rd, Right On Sunset.
- County Or Parish: Nassau County
Public facts
- Beds: —
- Baths: 5.5
- Sq. Ft.: 5,118
- Stories: 2.0
- Lot Size: 0.58 acres
- Style: Single Family Residential
- Year Built: 1997
- Year Renovated: —
- County: Nassau County
- APN: 01200 00090
Around this home
Schools
Public PreK-5 • Assigned • 1.6mi
Public 6-8 • Assigned • 1.3mi
Public 9-12 • Assigned • 1.6mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 97° expected this year, 14 days in 30 years
27% chance of strong winds in next 30 years
6 unhealthy days expected this year, 6 days in 30 years
Sun exposure
In this area, properties receive around 8.7 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 11024
Home values near 28 Sunset Rd
| Address | Redfin Estimate |
|---|---|
- Beds | 4.5 Baths | 3571 Sq. Ft. | $2,540,880 |
4 Beds | 3.5 Baths | - Sq. Ft. | $3,216,427 |
| Address | Redfin Estimate |
|---|---|
- Beds | 2 Baths | 3531 Sq. Ft. | $2,621,075 |
- Beds | 5.5 Baths | 6217 Sq. Ft. | $6,415,454 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | - Sq. Ft. | $3,412,262 |
- Beds | 3.5 Baths | 4872 Sq. Ft. | $4,716,651 |
More real estate resources
- Cities
- Minor Civil Divisions
- Neighborhoods
- Zip Codes
- Popular Searches
| Manhattan homes for sale | |||
| New York homes for sale | |||
| Jersey City homes for sale |
| River Vale Township homes for sale | |||
| Teaneck Township homes for sale | |||
| Weehawken Township homes for sale | |||
| Mahwah Township homes for sale | |||
| New Canaan homes for sale |
| North Hempstead homes for sale |
| 11050 homes for sale | |||
| 11021 homes for sale | |||
| 11022 homes for sale | |||
| 11023 homes for sale | |||
| 11024 homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.





















United States
Canada