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?
$1,200,000
Listing Price5beds
3baths
2,406sqft
6,500sqft lot
547 Hewlett St, Franklin Square, NY 11010
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
This exquisite, top-tier custom-built home is prepared to welcome its new occupants. Located in the Dogwood Section of Franklin Square on a 65 x 100 lot, no expenses were spared by the builder. The kitchen features a bespoke design with Black Stainless Steel appliances and two-tone quartz countertops. It includes a custom island with a spacious accessory sink, a wine fridge, and a coffered ceiling that enhances the charming pendant lights. The open layout floor plan showcases custom finishes, three fireplaces, five bedrooms, 2.5 impeccably designed bathrooms, and a fully finished basement with an egress window. Every element was carefully handpicked and meticulously crafted to achieve an impeccable design and finish. Custom millwork is present throughout, with intricate detailing in the stairwells from the basement to the second floor. This exceptional property is a rare gem in the heart of Franklin Square and is a must-see.
Interior Details
2406
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
6500
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
Aluminum/vinyl
N/A
N/A
Other (not Classified)
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2019
$12,853
$301
$200
--%
$501
2019
$12,853
$557
$331
--%
$888
2018
$12,267
$557
$331
--%
$888
2016
$10,869
$557
$331
--%
$888
2016
$10,869
$557
$331
--%
$888
2015
$10,513
$557
$283
--%
$840
2014
$11,079
$557
$283
--%
$840
2012
$3,087
$557
$283
--%
$840
Average Home Price in 11010
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$1,181,700
$1,181,700
-- Beds
2 Baths
2,733 Sqft
9,000 Lot (sqft)
Sold 10/16/2026
$995,194
-- Beds
2 Baths
2,621 Sqft
6,100 Lot (sqft)
Sold 09/23/2026
$1,200,000
$1,200,000
5 Beds
3 Baths
2,406 Sqft
6,500 Lot (sqft)
Sold 10/26/2026
$989,000
5 Beds
4 Baths
2,445 Sqft
6,600 Lot (sqft)
Sold 10/27/2026
$899,000
3 Beds
3 Baths
2,400 Sqft
4,120 Lot (sqft)
Sold 10/26/2026
$1,449,000
$1,449,000
-- Beds
4 Baths
2,526 Sqft
6,272 Lot (sqft)
Sold 10/26/2026
$969,000
6 Beds
3 Baths
2,338 Sqft
6,000 Lot (sqft)
Sold 09/29/2026
$899,000
4 Beds
3 Baths
2,160 Sqft
6,720 Lot (sqft)
Sold 10/13/2026
$1,238,000
$1,238,000
4 Beds
2 Baths
2,428 Sqft
6,000 Lot (sqft)
Sold 07/28/2026





