Skip main navigation
Pending
    • $2,599,000

    254 Adams Road, Hewlett Harbor, NY 11557

    5beds
    5,900sqft
    Loading
    Single Family Residence, Residential
    Built in 1948
    0.59 Acres Lot
    $-- Zestimate®
    $441/sqft
    $-- HOA

    What's special

    New gas heating systemBrick patioOpen layoutFull finished basementSeparate laundry roomStainless steel appliancesFabulous den
    Welcome To This Hampton Style 5900 Sq Ft Expanded Ranch on Beautiful Street in Hewlett Harbor. Totally Gut Renovated 24 Years Ago, This 5 Bedroom, 3.5 Bath Home Features an Open Layout. Upon Entering the Entry Foyer, You are Drawn to the Living Room/Dining Room with Floor to Ceiling Windows Overlooking the Manicured Property. The Eat in Kitchen Has Quartz Countertops, a Large Center Island, Stainless Steel Appliances and a Separate Breakfast Room with Cathedral Ceiling. The Family Room Has a Gas Fireplace, a Perfect Place to Relax. The Radiant Heated Mud Room with a Separate Laundry Room is the Ideal Entry When Coming in from 2 Car Garage. The Private Primary Suite is on the Main Level with a Radiant Heated Ensuite Bath & WIC. Expansive Second Level Features 4 Spacious Bedrooms, 2 Baths and a Fabulous Den. Full Finished Basement. Parklike .6 Acre Property with Brick Patio. HW Floors, New Gas Heating System, CAC, Surround Sound, Well Water for IG Sprinklers & New Alarm. SD#20(Lynbrook). Convenient Location Near School, Transportation, Houses of Worship, Park & 20 minutes to Beach. A GEM!!
    104 days
    |
    144
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Douglas Elliman Real Estate 516-623-4500,

    Ronnie B. Gerber 516-238-4299

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Bedroom 1
      • Description: Bedroom, Bedroom, Bath, Family Room, Bedroom, Bedroom, Bath
      • Level: Second
      Family room
      • Description: Recreation Room, Bonus Rm, Storage, Utilities
      • Level: Basement
      Living room
      • Description: Entry Hall, Living Room, Dining Room, Family Room, Eat in Kitchen & Breakfast Rm, Mud Rm, Laundry Rm, Powder Rm, Primary Bedroom w/ Ensuite Bath & WICh
      • Level: First
      Heating
      • Forced Air, Natural Gas, Radiant, Radiant Floor
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Gas Cooktop, Gas Oven, Microwave, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater
      • Laundry: Washer/Dryer Hookup, Laundry Room
      Features
      • First Floor Bedroom, First Floor Full Bath, Breakfast Bar, Cathedral Ceiling(s), Ceiling Fan(s), Chefs Kitchen, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, His and Hers Closets, Kitchen Island, Open Floorplan, Primary Bathroom, Master Downstairs, Quartz/Quartzite Counters, Recessed Lighting, Speakers, Storage, Walk-In Closet(s), Wired for Sound
      • Flooring: Carpet, Ceramic Tile, Hardwood
      • Windows: Double Pane Windows, Floor to Ceiling Windows
      • Basement: Partially Finished,Storage Space
      • Attic: Pull Stairs,Unfinished
      • Number of fireplaces: 1
      • Fireplace features: Family Room, Gas
      Interior area
      • Total structure area: 5,900
      • Total interior livable area: 5,900 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Driveway, Garage
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Levels: Tri-Level
      • Patio & porch: Patio
      • Fencing: Back Yard,Fenced
      Lot
      • Size: 0.59 Acres
      • Dimensions: 155 x 153
      • Features: Back Yard, Landscaped, Near Public Transit, Near School, Private, Sprinklers In Front, Sprinklers In Rear
      Details
      • Parcel number: 2017421960000090
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Exp Ranch
      • Property subtype: Single Family Residence, Residential
      Materials
      • Frame, Shingle Siding
      Condition
      • Updated/Remodeled
      • Year built: 1948

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Well, Public
      • Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected

      Community & HOA

      Community
      • Security: Security System, Smoke Detector(s)
      HOA
      • Has HOA: No
      Location
      • Region: Hewlett

      Financial & listing details

      • Price per square foot: $441/sqft
      • Tax assessed value: $1,506
      • Annual tax amount: $37,071
      • Date on market: 4/9/2026
      • Cumulative days on market: 87 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Contract,Conventional
      • Exclusions: Dining Rm Chandelier, Mud Room Refrigerator
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        5/11/2026Pending sale$2,599,000$441/sqft
        Source: OneKey® MLS as distributed by MLS GRID #975037 Report a problem
        4/9/2026Listed for sale$2,599,000+62.5%$441/sqft
        Source: OneKey® MLS as distributed by MLS GRID #975037 Report a problem
        4/12/2018Sold$1,599,000$271/sqft
        Source: Public Record Report a problem
        11/6/2017Sold$1,599,000$271/sqft
        Source: OneKey® MLS as distributed by MLS GRID #L2940812 Report a problem
        9/29/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        9/29/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/6/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/6/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/6/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/5/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/5/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/4/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/4/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/3/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/3/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/3/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/1/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        7/1/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/30/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/30/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/29/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/29/2017Pending sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/28/2017Listed for sale$1,599,000$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        6/28/2017Pending sale$1,599,000+61.5%$271/sqft
        Source: Douglas Elliman #2940812 Report a problem
        8/6/2002Sold$990,000$168/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024-- $1,313 -3.5%
        2023-- $1,360 -8.4%
        2022-- $1,485
        2021$32,314 -10.9%--
        2020$36,282 +12.7%$2,041
        2019$32,185 $2,041 -6.2%
        2018$32,185 -0.6%$2,177 -5.9%
        2017$32,379 -22.4%$2,313 -25%
        2016$41,748 +328.1%$3,084
        2015$9,753 +8.6%$3,084
        2013$8,980 +6.5%$3,084
        2012$8,436 -64.9%$3,084 -2.8%
        2011$24,056 +10.5%$3,174 +0.7%
        2010$21,779 $3,153 -16.3%
        2009-- $3,765 +6%
        2008-- $3,552 +6%
        2006-- $3,351 -40.2%
        2005-- $5,606 -46.9%
        2004-- $10,560 -24.5%
        2003-- $13,979 -51.1%
        2002-- $28,560 -8%
        2001-- $31,030
        2000-- $31,030
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: Hewlett Harbor

        Getting around

        19 / 100
        Car-Dependent
        34 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Waverly Park School
        • Middle: Lynbrook South Middle School
        • High: Lynbrook Senior 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

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Hewlett Topics

              Search
              Updates
              Favorites
              Plan
              Inbox