28 Red Brook Rd
Great Neck, NY 11024
$2,890,000Active · confirmed October 15, 2026 · $963/sq ft
28 Red Brook Rd in Great Neck. 5 bed, 3.5 bath, 3,000 sq ft. Asking $2,890,000. Active listing facts, schools and neighborhood context on EuKreate.
Answers use this home's own facts and the sources below. Ask without an account; sign in only to save this home to your research.
The facts
- Asking
- $2,890,000
- Beds
- 5
- Baths
- 3.5
- Sq ft
- 3,000
- Lot
- 21,506 sq ft
- Built
- 1951
- Type
- Single-family home
- Listed
- July 14, 2026 (94 days ago)
- Days on market
- 94 days
- County
- Nassau
Listing record · Ramona Sedaghat, Manhasset · MLS 1021145 · as of October 15, 2026
How this compares in Great Neck
138 homes for sale, median asking $1,584,000, typically listed 61 days. See the Great Neck market
Measured · 7 days ago; newer figures are not available yet
Assigned schools
- John F Kennedy School · PK-05 · Great Neck Union Free School District · 0.3 mi
- Great Neck North Middle School · 06-08 · Great Neck Union Free School District · 0.7 mi
- Great Neck North High School · 09-12 · Great Neck Union Free School District · 0.9 mi
Public school attendance boundaries. Boundaries change; confirm enrolment with the district.
Getting around
EuKreate neighborhood estimates (0 to 100, ZIP level)
Natural hazard risk
- WildfireVery Low
- EarthquakeRelatively Low
- River floodingRelatively Moderate
- Coastal floodingRelatively High
- LandslideRelatively Low
- Extreme heatRelatively Low
- HurricaneRelatively Moderate
- TornadoRelatively Low
- Winter weatherRelatively Moderate
- DroughtVery Low
These ratings describe the Census tract, not this home. Confirm insurance requirements with the listing agent and an insurer.
What is nearby
- Bank7-Eleven · 0.3 mi
- ParkVillage Green Park · 0.6 mi
- RestaurantParkwood Cafe · 0.6 mi
- Post OfficeUnited States Post Office · 0.6 mi
- GymConfiDanze · 0.6 mi
- BarBaker Hill Tavern · 0.7 mi
- GroceryEverfresh · 0.8 mi
- PharmacyCVS Pharmacy · 0.9 mi
- LibraryGreat Neck Public Library – Main Branch · 1.1 mi
- TheatreAckerman Auditorium · 1.2 mi
Nearest of each kind, by straight-line distance.
Where these facts come from
Partial: some facts are not availableListing courtesy of Manhasset, OneKeyMLS · Status as of Oct 15, 02:48 UTC
Listing data from RentCast and RealEstateAPI · as of
- Asking price
- $2,890,000
- Bedrooms
- 5
- Bathrooms
- 3.5
- Living area
- 3,000 sq ft
- Property type
- Single-family home
- Listed on
- July 14, 2026
- Year built
- 1951
- Lot size
- 21,506 sq ft
Around the home
- Assigned and nearby schoolsEuKreate neighborhood data (public sources) · October 16, 2026
- Getting aroundEuKreate neighborhood data (public sources) · October 16, 2026
- Natural hazard riskEuKreate neighborhood data (public sources) · October 16, 2026
- Reported crimeNot available for this home
- What is nearbyEuKreate neighborhood data (public sources) · October 16, 2026
Sources
- Listing data from RentCast and RealEstateAPI: Price, size, rooms and listing dates · as of October 15, 2026
- EuKreate neighborhood data: Schools, getting around, hazards, crime and places · as of October 16, 2026
- EuKreate market snapshot: Median asking price and days on market in Great Neck · as of October 9, 2026
Not available: Property tax, HOA dues, Reported crime. EuKreate says so rather than guessing.
Facts come from the listing record and public sources; confirm anything you rely on with the listing agent or an inspection.
Asking prices, not sold prices, and not an appraisal.
Active asking price only, not a sold price and not an appraisal. Check official sources before acting. Listing facts as of October 15, 2026. Neighborhood context as of October 16, 2026.