28 Red Brook Road • Great Neck, NY 11024

$3,216,800 Beds: 5 • Baths: 3 full 1 partial • Sq. Feet: 3000 • MLS ID: 1021145 • Subdivision:School Dist: Great Neck
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. View this listing at: http://monagold.laffey.com/mls=1021145

Property Features

  • Garage: 1
  • Taxes: $0
  • Basement: Yes
  • Exterior: HardiPlank Type
  • Lot Size: 0.49 Acres
  • Lot Dimensions: .04937
  • Heating: Natural Gas
  • Cooling: Central Air
  • Year Built: 1951
  • Fireplaces: 1
  • Water: Public
  • Sewer: Cesspool
  • On Market Date: 2026-07-14
  • Appliances: Dishwasher,Dryer,Exhaust Fan,Gas Cooktop,Gas Oven,Microwave,Refrigerator,Washer,Gas Water Heater,Wine Refrigerator
  • Basement: Finished,Partial
  • Building Area Total: 0
  • Exterior Features: Lighting,Mailbox,Rain Gutters
  • Fencing: None
  • Fireplace Features: Electric
  • Fireplace Y/N: Yes
  • Flooring: Hardwood
  • GarageY/N: Yes
  • Interior Features: First Floor Bedroom,First Floor Full Bath,Cathedral Ceiling(s),Double Vanity,Eat-in Kitchen,High Ceilings,Kitchen Island,Open Floorplan,Open Kitchen,Pantry,Primary Bathroom,Master Downstairs,Quartz/Quartzite Counters,Recessed Lighting,Smart Thermostat,Storage,Walk-In Closet(s),Washer/Dryer Hookup,Wet Bar
  • Laundry: Gas Dryer Hookup,Laundry Room,Washer Hookup
  • Lot Features: Back Yard,Cleared,Corner Lot,Front Yard,Landscaped,Near Public Transit,Near School,Near Shops,Private,Sprinklers In Front,Sprinklers In Rear
  • Attic: Full
  • Number Of Kitchens: 1
  • Heating Zones: 2
  • Parcel Number: 2217-01-142-00-0001-0
  • Parking Features: Attached,Driveway,Garage Door Opener
  • Parking Total: 1
  • Patio And Porch: Patio
  • Rental Term: Monthly
  • Rooms Total: 8
  • Utilities: Cable Available,Electricity Available,Natural Gas Available,Phone Available,Trash Collection Public,Water Connected
  • Window Features: Double Pane Windows,ENERGY STAR Qualified Windows,Screens,Wall of Windows

School Information

  • High School: Great Neck North High School
  • Middle School: Great Neck North Middle School
  • Elementary School: John F Kennedy School
  • School District: Great Neck
Printed July 16, 2026


Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers 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 on this site was last updated 07/16/2026. The listing information on this page last changed on 07/16/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 07/16/2026 12:00:29 AM EST) or OneKey MLS (last updated Wed 07/15/2026 11:53:26 PM EST). Real estate listings held by brokerage firms other than Laffey Real Estate may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
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.



Privacy Policy / DMCA Notice / ADA Accessibility