28 Red Brook Rd Great Neck, NY 11024
Estimated payment $18,776/month
Highlights
- Open Floorplan
- Colonial Architecture
- Private Lot
- John F Kennedy School Rated A+
- Property is near public transit, schools, and shops
- Cathedral Ceiling
About This Home
A rare opportunity to own a stunning fully gutted expanded renovated modernized Colonial in the Village of Kings Point. Designed with exceptional attention to detail and built with the highest level of craftsmanship, this residence offers the perfect balance of modern luxury and everyday comfort. A dramatic double height foyer sets the tone, leading to an elegant sun filled great room, a state of the art chef’s kitchen with a pantry offering direct access to the garage, abundant closet space, and a stylish wet bar area. Sliding doors open to a beautifully landscaped backyard, creating seamless indoor-outdoor living.
The main level features a luxurious primary suite with a full bath, an additional bedroom, a powder room, a convenient laundry room, and thoughtfully designed living spaces throughout.
Upstairs offers one large bedroom with a full bath, along with two additional bedrooms and another full bath. The fully finished lower level provides excellent space for entertainment, recreation or extended living, complete with generous storage. Set on a beautifully positioned property, this home features soaring ceilings, premium finishes throughout, and a layout designed for both grand entertaining and comfortable living. Ideally located near parks, shopping, transportation, and top rated amenities, this is a true luxury offering in one of Long Island’s most sought after communities.
Listing Agent
Douglas Elliman Real Estate Brokerage Phone: 516-627-2800 License #10401382792 Listed on: 07/14/2026
Home Details
Home Type
- Single Family
Year Built
- Built in 1951 | Remodeled in 2026
Lot Details
- 21,504 Sq Ft Lot
- Landscaped
- Private Lot
- Corner Lot
- Front and Back Yard Sprinklers
- Cleared Lot
- Back and Front Yard
Parking
- 1 Car Attached Garage
- Garage Door Opener
- Driveway
Home Design
- Colonial Architecture
- Bi-Level Home
- HardiePlank Type
Interior Spaces
- 3,000 Sq Ft Home
- Open Floorplan
- Wet Bar
- Cathedral Ceiling
- Recessed Lighting
- Electric Fireplace
- Double Pane Windows
- ENERGY STAR Qualified Windows
- Window Screens
- Storage
- Wood Flooring
- Finished Basement
- Partial Basement
- Smart Thermostat
Kitchen
- Eat-In Kitchen
- Gas Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Wine Refrigerator
- Kitchen Island
Bedrooms and Bathrooms
- 5 Bedrooms
- Primary Bedroom on Main
- En-Suite Primary Bedroom
- Walk-In Closet
- Bathroom on Main Level
- Double Vanity
Laundry
- Laundry Room
- Dryer
- Washer
Outdoor Features
- Patio
- Exterior Lighting
- Rain Gutters
- Private Mailbox
Location
- Property is near public transit, schools, and shops
Schools
- John F Kennedy Elementary School
- Great Neck North Middle School
- Great Neck North High School
Utilities
- Central Air
- Vented Exhaust Fan
- Heating System Uses Natural Gas
- Gas Water Heater
- Cesspool
- Phone Available
- Cable TV Available
Listing and Financial Details
- Legal Lot and Block 1 / 142
- Assessor Parcel Number 2217-01-142-00-0001-0
Map
Home Values in the Area
Average Home Value in this Area
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $16,806 | $1,144 | $896 | $248 |
| 2025 | $16,806 | $1,080 | $716 | $364 |
| 2024 | $3,643 | $1,352 | $896 | $456 |
| 2023 | $19,515 | $1,352 | $896 | $456 |
| 2022 | $19,515 | $1,352 | $896 | $456 |
| 2021 | $18,184 | $1,337 | $886 | $451 |
| 2020 | $20,398 | $2,085 | $2,084 | $1 |
| 2019 | $19,249 | $2,085 | $2,084 | $1 |
| 2018 | $17,986 | $2,085 | $0 | $0 |
| 2017 | $12,698 | $2,085 | $2,084 | $1 |
| 2016 | $16,332 | $2,085 | $2,084 | $1 |
| 2015 | $3,582 | $2,085 | $2,084 | $1 |
| 2014 | $3,582 | $2,085 | $2,084 | $1 |
| 2013 | $3,419 | $2,085 | $2,084 | $1 |
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/14/2026 07/14/26 | For Sale | $3,216,800 | +156.9% | $1,072 / Sq Ft | |
| 10/27/2023 10/27/23 | Sold | $1,252,000 | +4.3% | $503 / Sq Ft | View Prior Sale |
| 06/27/2023 06/27/23 | Pending | -- | -- | -- | |
| 05/30/2023 05/30/23 | For Sale | $1,200,000 | -- | $482 / Sq Ft |
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Executors Deed | $1,252,000 | First American Title Ins Co |
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,001,600 | New Conventional |
Source: OneKey® MLS
MLS Number: 1021145
APN: 2217-01-142-00-0001-0
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
Based on information submitted to the MLS GRID. 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. Some IDX listings have been excluded from this website. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Copyright 2026 OneKey® MLS. All rights reserved.
Based on information submitted to the MLS GRID
Listings courtesy of OneKey® MLS as distributed by MLS GRID
- 7 Appletree Ln
- 26 Spring Ln
- 632 Middle Neck Rd Unit 2nd Floor
- 14 Beach Rd Unit 3C
- 15 Maple Grove St
- 9 Fairview Ave
- 9 Forest Row
- 5 Burbury Ln
- 523-531 Middle Neck Rd
- 258 Steamboat Rd
- 27 Martin Ct
- 30 Pheasant Run
- 55 Warwick Rd
- 230 Gristmill Ln
- 369 E Shore Rd
- 115 Old Mill Rd
- 70 Longfellow Rd
- 218 Middle Neck Rd Unit 313
- 127 Wooleys Ln
- 120 Longfellow Rd
Ask me questions while you tour the home.