Skip main navigation
For sale
  • $3,216,800

    28 Red Brook Road, Great Neck, NY 11024

    5beds
    3,000sqft
    Loading
    Single Family Residence, Residential
    Built in 1951
    0.49 Acres Lot
    $-- Zestimate®
    $1,072/sqft
    $-- HOA

    What's special

    Premium finishes throughoutSoaring ceilingsConvenient laundry roomStylish wet bar areaDramatic double height foyerThoughtfully designed living spacesGenerous storage
    A rare opportunity to own a stunning newly constructed 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.
    12 hours
    |
    515
    |
    24
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Douglas Elliman Real Estate 516-627-2800,

    Ramona Sedaghat 516-776-8902

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1021145MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Heating
      • Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Dryer, Exhaust Fan, Gas Cooktop, Gas Oven, Microwave, Refrigerator, Washer, Gas Water Heater, Wine Refrigerator
      • Laundry: Washer/Dryer Hookup, Gas Dryer Hookup, Laundry Room, Washer Hookup
      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), Wet Bar
      • Flooring: Hardwood
      • Windows: Double Pane Windows, ENERGY STAR Qualified Windows, Screens, Wall of Windows
      • Basement: Finished,Partial
      • Attic: Full
      • Number of fireplaces: 1
      • Fireplace features: Electric
      Interior area
      • Total structure area: 3,000
      • Total interior livable area: 3,000 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 1
      • Parking features: Attached, Driveway, Garage Door Opener
      • Garage spaces: 1
      • Has uncovered spaces: Yes
      Features
      • Levels: Bi-Level
      • Patio & porch: Patio
      • Exterior features: Lighting, Mailbox, Rain Gutters
      • Fencing: None
      Lot
      • Size: 0.49 Acres
      • Dimensions: .04937
      • Features: Back Yard, Cleared, Corner Lot, Front Yard, Landscaped, Near Public Transit, Near School, Near Shops, Private, Sprinklers In Front, Sprinklers In Rear
      Details
      • Parcel number: 2217011420000010
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence, Residential
      Materials
      • HardiPlank Type
      Condition
      • Year built: 1951
      • Major remodel year: 2026

      Utilities & green energy

      • Sewer: Cesspool
      • Water: Public
      • Utilities for property: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Trash Collection Public, Water Connected

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Great Neck

      Financial & listing details

      • Price per square foot: $1,072/sqft
      • Tax assessed value: $1,352
      • Date on market: 7/14/2026
      • Cumulative days on market: 1 day
      • Listing agreement: Exclusive Right To Sell
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/14/2026Listed for sale$3,216,800+156.9%$1,072/sqft
        Source: OneKey® MLS as distributed by MLS GRID #1021145 Report a problem
        10/27/2023Sold$1,252,000+4.3%$417/sqft
        Source: OneKey® MLS as distributed by MLS GRID #L3481312 Report a problem
        6/27/2023Pending sale$1,200,000$400/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3481312 Report a problem
        5/30/2023Listed for sale$1,200,000$400/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3481312 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024-- $1,080 -20.1%
        2023-- $1,352
        2022-- $1,352
        2021$20,398 +6%--
        2020$19,249 +11.9%$2,085
        2019$17,200 $2,085
        2018$17,200 +5.3%$2,085
        2017$16,332 +4.8%$2,085
        2016$15,578 +334.9%$2,085
        2015$3,582 +4.8%$2,085
        2013$3,419 +7.5%$2,085
        2012$3,180 -66.8%$2,085 -12.5%
        2011$9,567 -21.6%$2,383 -28%
        2010$12,206 $3,308 +0.8%
        2009-- $3,282 +6%
        2008-- $3,097 +6%
        2006-- $2,922 -22%
        2005-- $3,747 -50%
        2004-- $7,494 -12.9%
        2003-- $8,600 -40.7%
        2002-- $14,500
        2001-- $14,500
        2000-- $14,500
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Kings Point

        Getting around

        45 / 100
        Car-Dependent
        34 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: John F Kennedy School
        • Middle: Great Neck North Middle School
        • High: Great Neck North High School

        Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes