Welcome into this exceptional Hewlett Bay Park residence where timeless design meets modern comfort, set on 3/4 of an acre of magnificent grounds. With a convenient circular driveway, it is situated on a desirable corner property. This home greets you with beautiful curb appeal and lush, manicured landscaping that sets the tone for what’s inside. At the heart of the home is a newly updated kitchen featuring granite countertops and brand-new appliances, perfectly complemented by a sun-filled breakfast room. Just off the kitchen, a cozy den/playroom provides the ideal spot for playtime or casual relaxation, while a nearby powder room adds everyday ease. The attached garage provides seamless access, while the main level also showcases a formal dining room for elegant entertaining, a refined living room with wood burning fireplace, and a spacious den that serves as the ultimate gathering space. The finished lower level, with its walkout egress, extends the home’s living space and is perfectly suited for recreation, a home theater, or a fitness studio. Upstairs, the primary suite creates a serene retreat complete with its own bathroom and additional wood burning fireplace. On the same floor are Four additional bedrooms and 2 full bathrooms to provide comfort and functionality for family or guests. Above, the third floor elevates the home further with two additional bedrooms and a full bath, offering flexibility for extended family, guest quarters, or private work-from-home space. Outdoors, a sparkling fenced-in heated pool featuring a beautiful waterfall, surrounded by magnificent landscaping creates a private oasis, while the expansive corner lot provides both beauty and privacy. Set at the gateway to Hewlett Bay Park, Hewlett Neck, and Old Woodmere, this home provides not only a premier address but also a welcoming retreat for everyday living and entertaining. Close to many houses of worship! A rare opportunity.
Pending
$2,599,000
252 Cedar Avenue, Hewlett Bay Park, NY 11557
7beds
4,000sqft
Single Family Residence, Residential
Built in 1929
0.65 Acres Lot
$-- Zestimate®
$650/sqft
$-- HOA
What's special
Modern comfortBeautiful waterfallSparkling fenced-in heated poolBeautiful curb appealDesirable corner propertyLush manicured landscapingTimeless design
- 98 days |
- 135 |
- 2 |
Zillow last checked:
Listing updated:
Listed by:
BERKSHIRE HATHAWAY 516-295-3000,
Etty A. Levy 516-852-1439,
Jordan Rosenberg 516-459-0278,
BERKSHIRE HATHAWAY
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 908817
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Other
- Description: Storage, Play Room, Egress Staircase, (Plumbing accessible for laundry)
- Level: Basement
Other
- Description: Formal Dining Room, Large Den, Breakfast Room, Foyer, Formal Living Room, Den/Play Room, Kitchen, 1/2 Bath
- Level: First
Other
- Description: 2 Bedrooms, 1 Bedroom Ensuite, 1 Bedroom Jack & Jill, 1 Primary Ensuite, Full Bath
- Level: Second
Other
- Description: 1 Bedroom, 1 Ensuite With Full Bath
- Level: Third
Heating
- Baseboard
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Freezer, Gas Cooktop, Gas Oven, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer, Gas Water Heater
- Laundry: Gas Dryer Hookup, In Kitchen
Features
- Breakfast Bar, Chandelier, Eat-in Kitchen, Granite Counters, High Ceilings, Kitchen Island, Wet Bar
- Flooring: Ceramic Tile, Hardwood, Tile
- Windows: Bay Window(s), Casement, Double Pane Windows, Floor to Ceiling Windows, Skylight(s)
- Basement: Finished,Full
- Attic: Full,Unfinished
- Number of fireplaces: 2
- Fireplace features: Bedroom, Living Room
Interior area
- Total structure area: 3,623
- Total interior livable area: 4,000 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, Driveway, Garage Door Opener, Oversized
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Three Or More
- Patio & porch: Patio
- Exterior features: Gas Grill, Mailbox
- Has private pool: Yes
- Pool features: Electric Heat, In Ground, Vinyl
- Fencing: Fenced,Full,Wood
Lot
- Size: 0.65 Acres
- Features: Corner Lot, Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
Details
- Additional structures: Cabana, Shed(s)
- Parcel number: 201541A0000120
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Frame
Condition
- Year built: 1929
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Sewer Connected
Community & HOA
Community
- Security: Fire Alarm, Security System, Smoke Detector(s)
HOA
- Has HOA: No
Location
- Region: Hewlett
Financial & listing details
- Price per square foot: $650/sqft
- Tax assessed value: $1,027,000
- Annual tax amount: $31,436
- Date on market: 9/10/2025
- Cumulative days on market: 256 days
- Listing agreement: Exclusive Right To Sell
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 4/14/2026 | Pending sale | $2,599,000$650/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #908817 Report a problem | ||
| 4/14/2026 | Listed for sale | $2,599,000$650/sqft |
Source: OneKey® MLS as distributed by MLS GRID #908817 Report a problem | ||
| 4/1/2026 | Listing removed | $2,599,000$650/sqft |
Source: OneKey® MLS as distributed by MLS GRID #908817 Report a problem | ||
| 9/11/2025 | Listed for sale | $2,599,000$650/sqft |
Source: OneKey® MLS as distributed by MLS GRID #908817 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $1,027 +3.9% |
| 2023 | -- | $988 -3.8% |
| 2022 | -- | $1,027 |
| 2021 | $29,249 +9.6% | -- |
| 2020 | $26,688 -1.3% | $1,325 -6.7% |
| 2019 | $27,035 | $1,420 -6.2% |
| 2018 | $27,035 -2% | $1,514 -5.9% |
| 2017 | $27,578 -2.3% | $1,609 -5.5% |
| 2016 | $28,241 +358.3% | $1,703 -5.3% |
| 2015 | $6,162 -10% | $1,798 -16.7% |
| 2013 | $6,850 -5.3% | $2,158 -10.9% |
| 2012 | $7,234 -72.1% | $2,422 -12% |
| 2011 | $25,918 +1.8% | $2,752 -7.4% |
| 2010 | $25,466 | $2,971 -7.9% |
| 2009 | -- | $3,225 -10.6% |
| 2008 | -- | $3,609 +4% |
| 2006 | -- | $3,471 -38.8% |
| 2005 | -- | $5,671 -49% |
| 2004 | -- | $11,111 -7% |
| 2003 | -- | $11,947 -39.9% |
| 2002 | -- | $19,890 |
| 2001 | -- | $19,890 -2.9% |
| 2000 | -- | $20,490 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: Hewlett Bay Park
Nearby schools
GreatSchools rating
- NAFranklin Early Childhood CenterGrades: PK-1Distance: 1 mi
- 8/10Woodmere Middle SchoolGrades: 6-8Distance: 1.3 mi
- 8/10George W Hewlett High SchoolGrades: 9-12Distance: 0.9 mi
Schools provided by the listing agent
- Elementary: Franklin Early Childhood Center
- Middle: Woodmere Middle School
- High: George W Hewlett 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.
- $3,111,200-- bd4 ba4.8k sqft240 Cedar Ave, Hewlett, NY 11557Off Market
- $3,597,0007 bd7 ba7.4k sqft251 Adams Ln, Hewlett, NY 11557Off Market
- $4,624,3007 bd6 ba9k sqft245 Cedar Ave, Hewlett, NY 11557Off Market
- $2,194,800-- bd5 ba4k sqft239 Woodside Dr, Hewlett, NY 11557Off Market
- $3,558,1005 bd5 ba5.3k sqft230 Hewlett Neck Rd, Woodmere, NY 11598Off Market
- $2,692,000-- bd5 ba4.5k sqft238 Cedar Ave, Hewlett, NY 11557Off Market
- $2,649,3006 bd5 ba4.6k sqft260 Hewlett Neck Rd, Woodmere, NY 11598Off Market
- $1,485,5004 bd4 ba2.3k sqft206 Ocean Ave, Woodmere, NY 11598Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $2,699,9995 bd6 ba5.1k sqft1319 Auerbach Avenue, Hewlett Harbor, NY 11557For Sale
MLS ID #1016664, Gil R. Shemtov, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID - $2,185,0006 bd4 ba4.6k sqft1304 Harbor Road, Hewlett Harbor, NY 11557For Sale
MLS ID #1006296, Malka Asch, Listing by: Howard Hanna Coach. OneKey® MLS as distributed by MLS GRID - $2,345,0005 bd4 ba4.7k sqft1442 Stevenson Circle, Hewlett, NY 11557For Sale
MLS ID #987853, Donna Borenstein, Listing by: Howard Hanna Coach. OneKey® MLS as distributed by MLS GRID - $2,250,0007 bd4 ba4.2k sqft844 Park Lane, North Woodmere, NY 11581For Sale
MLS ID #1027923, Sergey Borohov, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID - $2,900,0005 bd5 ba3.4k sqft230 Ocean Avenue, Lawrence, NY 11559For SaleMLS ID #973260, Abigail Shechter, Listing by: Five Towns Miller Realty Inc. OneKey® MLS as distributed by MLS GRID
- $2,798,0006 bd4 ba3.2k sqft760 Hillcrest Place, North Woodmere, NY 11581For SaleMLS ID #1022067, Boris Streshinskiy, Listing by: All In Realty Group Inc. OneKey® MLS as distributed by MLS GRID
- $1,849,0004 bd3 ba2.9k sqft1566 Pebble Lane, Hewlett, NY 11557For SaleMLS ID #1004939, Asya Bangiyeva, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID
- $2,299,9996 bd6 ba2.7k sqft29 Waverly Place, Lawrence, NY 11559For SaleMLS ID #1009382, Alexandra Y. Mikhaylova, Listing by: EXP Realty. OneKey® MLS as distributed by MLS GRID
- $2,499,0004 bd5 ba3.1k sqft134 Dutchess Boulevard, Atlantic Beach, NY 11509For SaleMLS ID #935252, Faye Klausner, Listing by: Annett C Ellis Realty Inc. OneKey® MLS as distributed by MLS GRID
- $2,150,0004 bd3 ba2.5k sqft98 Washington Avenue S, Lawrence, NY 11559For SaleMLS ID #1011770, Milka Forst, Listing by: Milky Forst Properties Inc. OneKey® MLS as distributed by MLS GRID
- $3,499,0004 bd4 ba3.4k sqft19 Margaret Avenue, Lawrence, NY 11559For SaleMLS ID #1021202, Milka Forst, Listing by: Milky Forst Properties Inc. OneKey® MLS as distributed by MLS GRID
- $3,490,0007 bd8 ba4.4k sqft122 Lawrence Avenue, Lawrence, NY 11559For SaleMLS ID #1014364, Abigail Shechter, Listing by: Five Towns Miller Realty Inc. OneKey® MLS as distributed by MLS GRID
- $2,658,0005 bd5 ba3.4k sqft9 Nassau Drive, Great Neck, NY 11021For SaleMLS ID #1010256, Xiaoli Xie, Listing by: Keller Williams Rty Gold Coast. OneKey® MLS as distributed by MLS GRID
- $2,599,9995 bd5 ba4.6k sqft2 Greenwood Lane, Woodbury, NY 11797For SaleMLS ID #1015209, Lyndsey M. Gallagher, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID
- $2,950,0004 bd5 ba3.3k sqft70 Lewis Avenue, Atlantic Beach, NY 11509For SaleMLS ID #942762, Leah E. Rosensweig Tozer CBR, Listing by: Daniel Gale Sothebys Intl Rlty. OneKey® MLS as distributed by MLS GRID
- $2,480,0006 bd6 ba3.3k sqft2 Rutland Road, Great Neck, NY 11020For SaleMLS ID #1002414, Lina Wang, Listing by: Compass Greater NY LLC. OneKey® MLS as distributed by MLS GRID
- $2,595,0004 bd4 ba5.2k sqft4 Roads End, Brookville, NY 11545For SaleMLS ID #998655, Paul J. Mateyunas, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID
- $2,799,9995 bd5 ba4k sqft3390 Hewlett Avenue, Merrick, NY 11566For SaleMLS ID #995307, Lisa Pellegrino, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID
- $2,499,9995 bd4 ba3.5k sqft19 Pheasant Hill Lane, Old Brookville, NY 11545For SaleMLS ID #1019434, Emil Koniecko, Listing by: Signature Premier Properties. OneKey® MLS as distributed by MLS GRID
- $2,498,8885 bd5 ba4.6k sqft8 Verity Lane, Roslyn, NY 11576For SaleMLS ID #1012402, Limor Karudo CBR, Listing by: BERKSHIRE HATHAWAY. OneKey® MLS as distributed by MLS GRID
