Jagmeet Bedi
Compass
(855) 934-0730
111 Total Sales
1 in Franklin Square
$1,350,000 Price
547 Hewlett St Franklin Square, NY 11010
Franklin Square AreaEstimated Value: $1,249,761
5
Beds
2.5
Baths
1,191
Sq Ft
$1,049/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
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 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
Kaur Davinder and Kaur Dalvinder
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
$89,761
Avg. Annual Appreciation
4.18%
Original Mortgage
$610,000
Outstanding Balance
$597,861
Interest Rate
6.54%
Mortgage Type
New Conventional
Estimated Equity
$651,900
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
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Franklin Square, NY
-
Jagmeet Bedi
-
Richard Krug
Richard Krug
Coldwell Banker American Homes
(516) 400-4970
172 Total Sales
1 in Franklin Square
$620,000 Price
-
Raj Jaggi
Raj Jaggi
VORO LLC
(516) 518-6053
572 Total Sales
3 in Franklin Square
$635K - $1.2M Price Range
-
Andréa Sorrentino
Andréa Sorrentino
Douglas Elliman Real Estate
(516) 518-7141
125 Total Sales
1 in Franklin Square
$625,000 Price
-
Janet Nation
Janet Nation
Keller Williams Realty Greater
(844) 871-1555
44 Total Sales
1 in Franklin Square
$581,000 Price
-
Inderjeet Khaneja
Inderjeet Khaneja
Posh Homes Realty Inc
(888) 621-4609
47 Total Sales
1 in Franklin Square
$708,000 Price
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 | ||
| Kaur Jaswant | $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 | ||
| Previous Owner | Kaur Jaswant | $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
AS
Seller's Agent in 2024
Arshdeep Singh
LJ Realty Team Inc
(631) 836-5130
31 Total Sales
-
Joseph Romeo
Buyer's Agent in 2024
Joseph Romeo
John Savoretti Realty
(516) 870-6007
48 Total Sales
-
Ravinder Singh
RS
Buyer's Agent in 2022
Ravinder Singh
LJ Realty Team Inc
9 Total Sales
-
Kathleen Evangelista
Seller's Agent in 2013
Kathleen Evangelista
Douglas Elliman Real Estate
(516) 456-9278
140 Total Sales
-
Bernard Miglio
BM
Buyer's Agent in 2013
Bernard Miglio
Bernard Miglio Real Estate Inc
(516) 428-0886
1 Total Sale
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
- 757 Anderson Ave
- 745 Anderson Ave
- 816 Gehrig Ave
- 696 Hewlett St
- 678 Carlyle Ave
- 933 Third Ave
- 586 Martin Rd
- 672 Anderson Ave
- 676 Dickens Ave
- 654 Carlyle Ave
- 406 Jefferson St
- 1005 Ferngate Dr
- 852 Jackson Ave
- 1053 Lorraine Dr
- 685 Seabury Ave
- 977 Third Ave
- 1053 Lydia Dr
- 409 Saint Agnes Place
- 695 Eileen Ct
- 795 Herman Ave
- 796 Horatio Ave
- 563 Hewlett St
- 784 Horatio Ave
- 777 Othello Ave
- 797 Horatio Ave
- 570 Hewlett St
- 767 Othello Ave
- 564 Hewlett St
- 774 Horatio Ave
- 576 Hewlett St
- 785 Horatio Ave
- 558 Hewlett St
- 587 Hewlett St
- 582 Hewlett St
- 761 Othello Ave
- 779 Horatio Ave
- 766 Horatio Ave
- 552 Hewlett St
- 588 Hewlett St
- 773 Horatio Ave
Your Personal Tour Guide
Ask me questions while you tour the home.