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!!
Sold for $2,500,000
$2,500,000
254 Adams Road, Hewlett Harbor, NY 11557
5beds
5,900sqft
Single Family Residence, Residential
Built in 1948
0.59 Acres Lot
$2,498,400 Zestimate®
$424/sqft
$7,641 Estimated rent
Home value
$2,498,400
$2.37M - $2.62M
$7,641/mo
Zestimate® history
Owner options
List your home for rent
$7,641/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$7,641/mo
Rent Zestimate®
Refinance and save
$16,792/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$16,792/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
New gas heating systemBrick patioOpen layoutFull finished basementSeparate laundry roomStainless steel appliancesFabulous den
Zillow last checked:
Listing updated:
Listed by:
Ronnie B. Gerber 516-238-4299,
Douglas Elliman Real Estate 516-623-4500
Bought with:
Jacqueline Dworkin, 10401247902
Compass Greater NY LLC
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
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: $424/sqft
- Tax assessed value: $1,506
- Annual tax amount: $37,071
- Date on market: 4/9/2026
- Cumulative days on market: 32 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Contract,Conventional
- Exclusions: Dining Rm Chandelier, Mud Room Refrigerator
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 7/27/2026 | Sold | $2,500,000-3.8%$424/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #975037 Report a problem | ||
| 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+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
Neighborhood: Hewlett Harbor
Nearby homes
- $1,295,600-- bd2 ba3.1k sqft285 Channon Rd, Hewlett, NY 11557Off Market
- $1,386,600-- bd3 ba2.8k sqft266 Adams Rd, Hewlett, NY 11557Off Market
- $1,146,2005 bd3 ba2.2k sqft291 Channon Rd, Hewlett, NY 11557Off Market
- $1,808,3006 bd6 ba4.5k sqft250 Adams Rd, Hewlett, NY 11557Off Market
- $1,259,900-- bd2 ba2.5k sqft267 Adams Rd, Hewlett, NY 11557Off Market
- $1,437,500-- bd3 ba2.7k sqft268 Adams Rd, Hewlett, NY 11557Off Market
- $1,118,2004 bd2 ba2.8k sqft295 Channon Rd, Hewlett, NY 11557Off Market
- $1,315,300-- bd3 ba2.9k sqft271 Adams Rd, Hewlett, NY 11557Off Market
Nearby schools
GreatSchools rating
- 8/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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,498,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,498,400
- New York
- Nassau County
- Hewlett
- 11557
- Hewlett Harbor
- 254 Adams Road
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Hewlett Topics
