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!!
Pending
$2,599,000
254 Adams Road, Hewlett Harbor, NY 11557
5beds
5,900sqft
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
- 57 days |
- 362 |
- 5 |
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#: 975037
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: 40 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
| Date | Event | Price |
|---|---|---|
| 5/11/2026 | Pending sale | $2,599,000$441/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #975037 Report a problem | ||
| 4/9/2026 | Listed for sale | $2,599,000+62.5%$441/sqft |
Source: OneKey® MLS as distributed by MLS GRID #975037 Report a problem | ||
| 4/12/2018 | Sold | $1,599,000$271/sqft |
Source: Public Record Report a problem | ||
| 11/6/2017 | Sold | $1,599,000$271/sqft |
Source: OneKey® MLS as distributed by MLS GRID #L2940812 Report a problem | ||
| 9/29/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 9/29/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/6/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/6/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/6/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/5/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/5/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/4/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/4/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/3/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/3/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/3/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/1/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 7/1/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/30/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/30/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/29/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/29/2017 | Pending sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/28/2017 | Listed for sale | $1,599,000$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 6/28/2017 | Pending sale | $1,599,000+61.5%$271/sqft |
Source: Douglas Elliman #2940812 Report a problem | ||
| 8/6/2002 | Sold | $990,000$168/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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.
Climate risks
Neighborhood: Hewlett Harbor
Nearby schools
GreatSchools rating
- 7/10Waverly Park SchoolGrades: 1-5Distance: 0.2 mi
- 6/10Lynbrook South Middle SchoolGrades: 6-8Distance: 0.5 mi
- 9/10Lynbrook Senior High SchoolGrades: 9-12Distance: 1.1 mi
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.
- New York
- Nassau County
- Hewlett
- 11557
- Hewlett Harbor
- 254 Adams Road
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Hewlett Topics
