A
Seller's Agent in 2024
Arshdeep Singh
LJ Realty Team Inc
(631) 836-5130
2 in this area
24 Total Sales
547 Hewlett St Franklin Square, NY 11010
Estimated Value: $1,159,347 - $1,342,000
5
Beds
2.5
Baths
1,191
Sq Ft
$1,050/Sq Ft
Est. Value
Highlights
- Colonial Architecture
- Marble Countertops
- Den
- Wood Flooring
- 3 Fireplaces
- Formal Dining Room
About This Home
As of November 2024This 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.
Last Agent to Sell the Property
LJ Realty Team Inc Brokerage Phone: 516-218-1261 License #10401360592 Listed on: 11/04/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $13,880
Year Built
- Built in 1951
Lot Details
- 6,500 Sq Ft Lot
- Lot Dimensions are 65x100
Parking
- 1 Car Detached Garage
Home Design
- Colonial Architecture
- Brick Exterior Construction
- Frame Construction
- Aluminum Siding
Interior Spaces
- 3 Fireplaces
- Formal Dining Room
- Den
- Wood Flooring
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Cooktop
- Dishwasher
- Marble Countertops
Bedrooms and Bathrooms
- 5 Bedrooms
Schools
- H Frank Carey High Middle School
- H Frank Carey High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Oil
Community Details
- Park
Listing and Financial Details
- Legal Lot and Block 13 / 624
- Assessor Parcel Number 2089-35-624-00-0013-0
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Nov 4, 2023
Closed on
Nov 18, 2024
Sold by
Bought by
Seller's Agent
Arshdeep Singh
LJ Realty Team Inc
Buyer's Agent
Joseph Romeo
John Savoretti Realty
List Price
$1,229,000
Sold Price
$1,160,000
Premium/Discount to List
-$69,000
-5.61%
Views
423
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$90,674
Avg. Annual Appreciation
5.01%
Original Mortgage
$610,000
Outstanding Balance
$599,681
Interest Rate
6.54%
Mortgage Type
New Conventional
Estimated Equity
$650,993
Purchase Details
Listed on
Nov 10, 2020
Closed on
May 17, 2022
Sold by
Bought by
Seller's Agent
Joseph Romeo
John Savoretti Realty
Buyer's Agent
Ravinder Singh
LJ Realty Team Inc
List Price
$1,150,000
Sold Price
$1,075,000
Premium/Discount to List
-$75,000
-6.52%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.08%
Original Mortgage
$752,500
Interest Rate
5.11%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 31, 2003
Sold by
Purchase Details
Closed on
Mar 13, 2001
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,160,000 | Chicago Title Insurance Co | ||
| $1,160,000 | Chicago Title Insurance Co | ||
| $1,160,000 | Chicago Title Insurance Co | ||
| $1,160,000 | Chicago Title Insurance Co | ||
| $1,075,000 | Highland Title Ins Agcy Llc | ||
| $1,075,000 | Highland Title Ins Agcy Llc | ||
| $1,075,000 | Highland Title Ins Agcy Llc | ||
| $1,075,000 | Highland Title Ins Agcy Llc | ||
| $1,075,000 | Highland Title Ins Agcy Llc | ||
| -- | -- | ||
| -- | -- | ||
| -- | -- | ||
| -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $610,000 | ||
| Closed | $610,000 | ||
| Previous Owner | $752,500 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 11/19/2024 11/19/24 | Sold | $1,160,000 | -3.3% | $974 / Sq Ft | |
| 06/25/2024 06/25/24 | Pending | -- | -- | -- | |
| 05/23/2024 05/23/24 | Price Changed | $1,200,000 | -1.6% | $1,008 / Sq Ft | |
| 05/15/2024 05/15/24 | Price Changed | $1,219,000 | -0.8% | $1,024 / Sq Ft | |
| 04/05/2024 04/05/24 | Price Changed | $1,229,000 | 0.0% | $1,032 / Sq Ft | |
| 04/05/2024 04/05/24 | For Sale | $1,229,000 | +5.9% | $1,032 / Sq Ft | |
| 04/04/2024 04/04/24 | Off Market | $1,160,000 | -- | -- | |
| 02/16/2024 02/16/24 | Price Changed | $1,239,000 | -2.4% | $1,040 / Sq Ft | |
| 11/04/2023 11/04/23 | For Sale | $1,269,000 | +18.0% | $1,065 / Sq Ft | |
| 05/17/2022 05/17/22 | Sold | $1,075,000 | -6.5% | $903 / Sq Ft | View Prior Sale |
| 02/23/2021 02/23/21 | Pending | -- | -- | -- | |
| 11/10/2020 11/10/20 | For Sale | $1,150,000 | +253.8% | $966 / Sq Ft | |
| 04/30/2013 04/30/13 | Sold | $325,000 | -4.1% | $273 / Sq Ft | View Prior Sale |
| 02/02/2013 02/02/13 | Pending | -- | -- | -- | |
| 11/09/2012 11/09/12 | For Sale | $339,000 | -- | $285 / Sq Ft |
Source: OneKey® MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $12,070 | $815 | $307 | $508 |
| 2025 | $12,070 | $815 | $307 | $508 |
| 2024 | $4,737 | $815 | $307 | $508 |
| 2023 | $10,927 | $511 | $307 | $204 |
| 2022 | $10,927 | $511 | $307 | $204 |
| 2021 | $12,547 | $501 | $301 | $200 |
| 2020 | $12,854 | $888 | $557 | $331 |
| 2019 | $5,133 | $888 | $557 | $331 |
| 2018 | $4,721 | $888 | $0 | $0 |
| 2017 | $6,352 | $888 | $557 | $331 |
| 2016 | $10,869 | $888 | $557 | $331 |
| 2015 | $3,992 | $840 | $557 | $283 |
| 2014 | $3,992 | $840 | $557 | $283 |
| 2013 | $4,294 | $840 | $557 | $283 |
Source: Public Records
Agents Affiliated with this Home
-
Arshdeep Singh
-
Joseph Romeo
Buyer's Agent in 2024
Joseph Romeo
John Savoretti Realty
(516) 870-6007
18 in this area
44 Total Sales
-
Ravinder Singh
R
Buyer's Agent in 2022
Ravinder Singh
LJ Realty Team Inc
1 in this area
9 Total Sales
-
Kathleen Evangelista
Seller's Agent in 2013
Kathleen Evangelista
Douglas Elliman Real Estate
(516) 456-9278
35 in this area
133 Total Sales
-
Bernard Miglio
B
Buyer's Agent in 2013
Bernard Miglio
Bernard Miglio Real Estate Inc
(516) 428-0886
2 Total Sales
Map
Source: OneKey® MLS
MLS Number: KEY3514757
APN: 2089-35-624-00-0013-0
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Copyright 2026 OneKey® MLS. All rights reserved.
Based on information submitted to the MLS GRID
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Nearby Homes
- 744 Plato St
- 769 Anderson Ave
- 660 Hewlett St
- 562 Bernice Rd
- 708 Anderson Ave
- 738 Sprague Ave
- 406 Jefferson St
- 916 Center Dr
- 991 Ferngate Dr
- 1053 Lorraine Dr
- 1053 Lydia Dr
- 1009 Park Ln N
- 372 Madison St
- 938 Van Buren Ave
- 1047 Windermere Rd
- 1006 Glen Dr
- 1027 Windermere Rd
- 739 Dogwood Ave
- 292 Madison St
- 1027 Van Buren Ave
- 768 Othello Ave
- 535 Hewlett St
- 546 Hewlett St
- 754 Othello Ave
- 540 Hewlett St
- 777 Othello Ave
- 529 Hewlett St
- 552 Hewlett St
- 534 Hewlett St
- 521 Cato Ct
- 767 Othello Ave
- 748 Othello Ave
- 558 Hewlett St
- 563 Hewlett St
- 523 Cato Ct
- 528 Hewlett St
- 761 Othello Ave
- 564 Hewlett St
- 742 Othello Ave
- 755 Othello Ave
Your Personal Tour Guide
Ask me questions while you tour the home.