
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$939,000
Listing Price5beds
3baths
2,472sqft
8,000sqft lot
1504 Hewlett Ave, Hewlett, NY 11557
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
Stately Colonial with Old World Charm and Classic Style nestled in the highly sought after Hewlett-Woodmere school district, this home offers a fabulous location with a blend of classic charm and convenience. The beautiful brick front porch enhances curb appeal and provides a welcoming entrance. Enter the home to a large foyer which connects to the formal dining room and the oversized living room featuring a gas fireplace, serving as the charming centerpiece of the room, perfect for hosting gatherings and entertainment. The oversized den provides wonderful versatile space. The first floor is completed with an eat in kitchen, separate guest bedroom and full bath. The second story consists of a large primary bedroom suite which includes a full bath, walk-in closet, and study, providing a private retreat. Two generous guest rooms, one with a connecting nursery or office space, and a full bath completes the second floor. A full basement with an outside entrance, high ceilings, and abundant storage space, can be transformed into a perfect lounge room. The 2-car detached garage offers ample parking and storage. The property is fully fenced and landscaped, ensuring privacy. This home combines timeless elegance making it a perfect choice for homeowners seeking a blend of style and comfort. Don't miss the opportunity to own this gem in a highly sought-after neighborhood. Schedule a private viewing today!
Interior Details
2472
5
3
Has Heating:
Yes
Heating Type:
Central
Has Cooling:
Yes
Cooling Type:
Central
Has Fuel:
Yes
Fuel Type:
Oil
Has Basement:
No
Basement Type:
Full
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
8000
Yes
Yes
Type:
Garage, Detached
Location:
N/A
Status:
N/A
Number of Spaces:
1
No
No
No
No
Yes
No
No
Construction Details
Colonial
Wood
N/A
N/A
Other (not Classified)
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2019
$15,451
$244
$411
--%
$655
2019
$15,451
$544
$205
--%
$749
2018
$13,747
$544
$255
--%
$799
2016
$14,236
$544
$332
--%
$876
2016
$14,236
$544
$354
--%
$898
2014
$13,083
$544
$369
--%
$913
2014
$13,083
$619
$419
--%
$1,038
2012
$12,086
$806
$545
--%
$1,351
Average Home Price in 11557
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$899,000
$899,000
5 Beds
3 Baths
2,789 Sqft
6,000 Lot (sqft)
Sold 10/01/2026
$899,000
$899,000
-- Beds
1.5 Baths
2,250 Sqft
6,000 Lot (sqft)
Sold 07/10/2025
$939,000
$939,000
5 Beds
3 Baths
2,472 Sqft
8,000 Lot (sqft)
Sold 10/13/2026
$999,999
$999,999
-- Beds
3 Baths
2,730 Sqft
6,000 Lot (sqft)
Sold 07/10/2025
$1,070,179
$1,070,179
-- Beds
1.5 Baths
2,308 Sqft
6,000 Lot (sqft)
Sold 10/26/2026
$989,000
$989,000
5 Beds
2 Baths
2,203 Sqft
6,000 Lot (sqft)
Sold 09/28/2026
$1,050,000
$1,050,000
5 Beds
3 Baths
2,735 Sqft
8,960 Lot (sqft)
Sold 10/05/2026
$899,000
$899,000
5 Beds
3 Baths
2,218 Sqft
12,950 Lot (sqft)
Sold 10/13/2026
$1,299,000
$1,299,000
-- Beds
3.5 Baths
2,700 Sqft
11,252 Lot (sqft)
Sold 10/27/2026






