A
Seller's Agent in 2024
Arshdeep Singh
LJ Realty Team Inc
(631) 836-5130
1 in this area
18 Total Sales
547 Hewlett St Franklin Square, NY 11010
Estimated Value: $1,148,000 - $1,186,427
5
Beds
2.5
Baths
1,191
Sq Ft
$980/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
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Nov 4, 2023
Closed on
Nov 18, 2024
Sold by
Kaur Davinder and Kaur Dalvinder
Bought by
Ivis Paolo and Ivis Tina
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
$46,270
Avg. Annual Appreciation
0.59%
Original Mortgage
$610,000
Outstanding Balance
$603,814
Interest Rate
6.54%
Mortgage Type
New Conventional
Estimated Equity
$563,400
Purchase Details
Listed on
Nov 10, 2020
Closed on
May 17, 2022
Sold by
Flores Jessica L
Bought by
Kaur Jaswant
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
Garber Ruth
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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Ivis Paolo | $1,160,000 | Chicago Title Insurance Co | |
| Ivis Paolo | $1,160,000 | Chicago Title Insurance Co | |
| Ivis Paolo | $1,160,000 | Chicago Title Insurance Co | |
| Ivis Paolo | $1,160,000 | Chicago Title Insurance Co | |
| Kaur Jaswant | $1,075,000 | Highland Title Ins Agcy Llc | |
| Kaur Jaswant | $1,075,000 | Highland Title Ins Agcy Llc | |
| Kaur Jaswant | $1,075,000 | Highland Title Ins Agcy Llc | |
| Kaur Jaswant | $1,075,000 | Highland Title Ins Agcy Llc | |
| Kaur Jaswant | $1,075,000 | Highland Title Ins Agcy Llc | |
| -- | -- | -- | |
| -- | -- | -- | |
| -- | -- | -- | |
| -- | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Ivis Paolo | $610,000 | |
| Closed | Ivis Paolo | $610,000 | |
| Previous Owner | Kaur Jaswant | $752,500 |
Source: Public Records
Property History
| 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 Compared to Growth
Tax History
| 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 |
|---|---|---|---|---|
| 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
16 in this area
43 Total Sales
-
R
Buyer's Agent in 2022
Ravinder Singh
LJ Realty Team Inc
-
Kathleen Evangelista
Seller's Agent in 2013
Kathleen Evangelista
Douglas Elliman Real Estate
(516) 456-9278
36 in this area
132 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.
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 2025 OneKey® MLS. All rights reserved.
Nearby Homes
- 850 First Ave
- 865 Third Ave
- 816 Anderson Ave
- 791 Caryl St
- 911 First Ave
- 708 Anderson Ave
- 993 Ferngate Dr
- 600 Dogwood Ave
- 422 Saint Agnes Place
- 1053 Lorraine Dr
- 757 Marion St
- 726 Meisser St
- 1007 Third Ave
- 997 Glen Dr
- 1048 Windermere Rd
- 1047 Windermere Rd
- 1027 Windermere Rd
- 956 Hancock Ave
- 1035 Glen Dr
- 301 Hoffman St
- 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