547 Hewlett Street
Franklin Square, NY 11010
- 5 beds
- 3 baths
- – sqft
- 6,500 sqft lot
- 1951 build
- – on site
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.
Listing courtesy of ONEKEY / LJ Realty Team Inc
Last checked:
Checking…
•
Last updated Jun 2, 2024
•
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
MLS# 3514757 —
The Building
-
Year Built:1951
-
New Construction:false
-
Construction Materials:Brick, Frame, Aluminum Siding
-
Architectural Style:Colonial
-
Basement:Finished, Full
-
Common Walls:No Common Walls
-
Building Area Units:Square Feet
Interior
-
Interior Features:Den/Family Room, Eat-in Kitchen, Formal Dining, Marble Counters, Master Bath
-
Rooms Total:10
-
Flooring:Hardwood
-
Fireplace:true
-
Fireplaces Total:3
Room Dimensions
-
Living Area Units:Square Feet
Location
-
Directions:Google Maps
-
Cross Street:Othello Ave
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:false
-
Lot Size Acres:0.15
-
Lot Size Area:0.15
-
Lot Size SqFt:6500
-
Lot Size Units:Acres
-
Lot Size Source:Other
-
Lot Size Dimensions:65x100
-
Parcel Number:2089-35-624-00-0013-0
-
Flood Zone Report:No
Listing Agent
- Contact info:
- Agent phone:
- (631) 836-5130
- Office phone:
- (516) 218-1261
Taxes
-
Tax Lot:13
-
Tax Block:624
-
Tax Map Number:2089-35-624-00-0013-0
-
Tax Annual Amount:13879.79
Beds
-
Bedrooms Total:5
Baths
-
Total Baths:3
-
Half Baths:1
-
Full Baths:2
The Listing
-
Buyer's Brokerage Compensation:1.5
Heating & Cooling
-
Heating:Oil, Forced Air
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Sewer:Sewer
-
Water Source:Public
Appliances
-
Appliances:Cooktop, Dishwasher, Refrigerator
Schools
-
Elementary School District:Franklin Square
-
Middle Or Junior School:H Frank Carey High School
-
Middle Or Junior School District:Franklin Square
-
High School:H Frank Carey High School
-
High School District:Franklin Square
The Community
-
Community Features:Park
-
Senior Community:false
Parking
-
Garage:true
-
Garage Spaces:1
-
Attached Garage:false
-
Parking Features:Private, Detached, 1 Car Detached, Garage
Monthly cost estimate
Asking price
$1,200,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$6,425
|
Taxes | $1,156 |
Insurance | $330 |
Utilities | N/A |
Total | $7,911/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
5/23/24
May 23, 2024
|
Price Changed | ONEKEY | $1,200,000 | -1.6% |
5/15/24
May 15, 2024
|
Price Changed | ONEKEY | $1,219,000 | -0.8% |
4/5/24
Apr 5, 2024
|
Price Changed | ONEKEY | $1,229,000 | -0.8% |