Skip main navigation
For sale
  • $2,250,000

    24 Steamboat Road, Great Neck, NY 11024

    4beds
    3,000sqft
    Single Family Residence, Residential
    Built in 2006
    6,000 Square Feet Lot
    $-- Zestimate®
    $750/sqft
    $-- HOA

    What's special

    All-brick center hall colonialThree additional family bedroomsPowder roomLaundry roomWalk-in closetLuxurious primary suiteGrand two-story marble foyer
    Better Than New! This stunning all-brick Center Hall Colonial offers timeless elegance and modern comfort. A grand two-story marble foyer welcomes you into spacious living and entertaining areas, including a formal living room, formal dining room, den, and a large granite chefs eat-in kitchen. The main level also features a powder room and laundry room for convenience. Upstairs, the luxurious primary suite includes a walk-in closet and a spa-like bath with Jacuzzi and separate shower, along with three additional family bedrooms and a full bath. The finished basement provides ample space for a play area & storage. Enjoy the beautiful flat backyard, perfect for outdoor gatherings. Prime location—walk to parks, worship, and schools. A must see!
    167 days
    |
    1,638
    |
    26
    |

    Zillow last checked: 7 hours ago

    Listing updated: January 18, 2026 at 09:39am

    Listing by:

    Janet Etessami Realty Inc 516-482-4321,

    Janet Etessami 516-816-5080

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

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Convection Oven, Cooktop, Dishwasher, Dryer, Electric Range, Exhaust Fan, Freezer, Gas Cooktop, Microwave, Oven, Refrigerator, Stainless Steel Appliance(s), Washer
      • Laundry: Laundry Room
      Features
      • Cathedral Ceiling(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, Kitchen Island, Marble Counters, Natural Woodwork, Pantry, Primary Bathroom, Tray Ceiling(s)
      • Flooring: Hardwood
      • Basement: Finished,Full
      • Attic: Storage,Unfinished
      • Number of fireplaces: 1
      • Fireplace features: Gas
      Interior area
      • Total structure area: 3,000
      • Total interior livable area: 3,000 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Detached
      • Garage spaces: 1
      Lot
      • Size: 6,000 Square Feet
      Details
      • Parcel number: 2209011280002040
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick
      Condition
      • Year built: 2006

      Utilities & green energy

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

      Community & HOA

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

      Financial & listing details

      • Price per square foot: $750/sqft
      • Tax assessed value: $1,249
      • Annual tax amount: $23,700
      • Date on market: 10/23/2025
      • Cumulative days on market: 168 days
      • Listing agreement: Exclusive Agency
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $7,928/mo

        Price history

        Price history
        DateEventPrice
        10/23/2025Listed for sale$2,250,000+33.1%$750/sqft
        Source: OneKey® MLS as distributed by MLS GRID #927695 Report a problem
        3/15/2023Listing removed--
        Source: OneKey® MLS as distributed by MLS GRID #3439755 Report a problem
        1/18/2023Price change$1,690,000-5.6%$563/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3439755 Report a problem
        11/13/2022Price change$1,790,000-4.8%$597/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3439755 Report a problem
        10/27/2022Listed for sale$1,880,000+10.9%$627/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3439755 Report a problem
        10/4/2021Listing removed--
        Source: OneKey® MLS as distributed by MLS GRID #3322971 Report a problem
        6/18/2021Listed for sale$1,695,000$565/sqft
        Source: OneKey® MLS as distributed by MLS GRID #3322971 Report a problem

        Public tax history

        Public tax history
        YearProperty taxesTax assessment
        2023-- $1,122 -2.1%
        2022-- $1,146
        2021$14,877 +20.5%--
        2020$12,349 -2.6%$1,127 -6.6%
        2019$12,682 $1,207 -6.3%
        2018$12,682 -1.3%$1,288 -5.8%
        2017$12,844 -1.4%$1,368 -5.6%
        2016$13,031 +203.4%$1,449 -5.2%
        2015$4,295 +0.9%$1,529 -4.2%
        2013$4,257 +9.3%$1,596 -9.1%
        2012$3,893 -50.7%$1,756 -12%
        2011$7,898 +1.1%$1,995 -8.5%
        2010$7,815 $2,180 -23.6%
        2009-- $2,855 -4.2%
        2008-- $2,980 +35.8%
        2006-- $2,194 -11.2%
        2005-- $2,472 -46.1%
        2004-- $4,583
        2003-- $4,583 -22.6%
        2002-- $5,920
        2001-- $5,920 +8.6%
        2000-- $5,450

        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment
        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: Great Neck Village

        Getting around

        63 / 100
        Somewhat Walkable
        46 / 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.

        Local experts in 11024

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel