Seller's Agent in 2025
Gil Shemtov
Douglas Elliman Real Estate
(516) 835-3333
7 in this area
142 Total Sales
217 Cedar Ave Hewlett, NY 11557
7
Beds
8
Baths
8,290
Sq Ft
1
Acres
Highlights
- Greenhouse
- Fitness Center
- Estate
- George W Hewlett High School Rated A+
- In Ground Pool
- Cathedral Ceiling
About This Home
As of March 2025Experience the epitome of luxury living in this exceptional, one-of-a-kind mansion nestled within a private estate. Upon entering the gates, you'll be greeted by immaculately manicured grounds boasting an array of fruit trees, rose bushes, and grape vines that exude a timeless charm reminiscent of historic mansions. As you approach the front door, a magnificent patio with an elevated view of the outdoor pool and grounds will leave you in awe. Stepping into the foyer, you'll be welcomed by a formal dining room that exudes elegance and sophistication, and the highlight of this home - the living room. The living room, with its soaring high ceilings, is a masterpiece of architectural design, spanning all three stories of the home and offering breathtaking views of the indoor pool, hot tub and sauna on the lower level from the upstairs bedroom landing. The newly renovated oversized kitchen located just outside the living room is perfect for preparing delicious meals for your family and guests. With a total of seven bedrooms and over 8200 square feet of living space, this mansion is a true masterpiece of luxury living. Don't miss the opportunity to witness the indescribable beauty and elegance of this unique property in person, Additional information: Appearance:Diamond
Last Agent to Sell the Property
Douglas Elliman Real Estate Brokerage Phone: 516-432-3400 License #10401250882 Listed on: 05/06/2024
Last Buyer's Agent
Douglas Elliman Real Estate Brokerage Phone: 516-432-3400 License #10401250882 Listed on: 05/06/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $56,554
Year Built
- Built in 1983
Lot Details
- 1 Acre Lot
- Lot Dimensions are 169x178
- Back Yard Fenced
Home Design
- Estate
- Frame Construction
- Stucco
Interior Spaces
- 8,290 Sq Ft Home
- 3-Story Property
- Cathedral Ceiling
- 2 Fireplaces
- Window Screens
- Entrance Foyer
- Formal Dining Room
- Security Gate
- Finished Basement
Kitchen
- Eat-In Kitchen
- Oven
- Microwave
- Dishwasher
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 7 Bedrooms
- En-Suite Primary Bedroom
- Whirlpool Bathtub
Laundry
- Dryer
- Washer
Parking
- Attached Garage
- Garage Door Opener
- Driveway
Outdoor Features
- In Ground Pool
- Patio
- Greenhouse
Schools
- Woodmere Middle School
- George W Hewlett High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Heating System Uses Oil
- Radiant Heating System
- Baseboard Heating
Community Details
- Fitness Center
Listing and Financial Details
- Legal Lot and Block 3 / 6
- Assessor Parcel Number 2015-41-006-00-0003-0
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 6, 2024
Closed on
Mar 12, 2025
Sold by
Hadpawat Narendra K and Hadpawat Hansa
Bought by
Karmaker Ashok K and Maity Gargi
Seller's Agent
Gil Shemtov
Douglas Elliman Real Estate
Buyer's Agent
Gil Shemtov
Douglas Elliman Real Estate
List Price
$3,250,000
Sold Price
$2,750,000
Premium/Discount to List
-$500,000
-15.38%
Views
157
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
$255,372
Avg. Annual Appreciation
11.59%
Original Mortgage
$1,925,000
Outstanding Balance
$1,912,619
Interest Rate
6.5%
Mortgage Type
New Conventional
Estimated Equity
$1,092,753
Purchase Details
Closed on
Jun 2, 2021
Sold by
Hadpawat Narendr K and Hadpawat Hansa
Bought by
Hadpawat Narendra K and Hadpawat Hansa
Purchase Details
Closed on
Aug 16, 2013
Sold by
Haddpawat Narendra K and Hadpawat Hansa
Bought by
Hadpawat Narenda K and Hadpawat Hansa
Purchase Details
Closed on
Aug 23, 2001
Bought by
Hadpawat Narendra K Hansa
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Bargain Sale Deed | $2,750,000 | Judicial Title Ins Agcy Llc | |
| Bargain Sale Deed | $2,750,000 | Judicial Title Ins Agcy Llc | |
| Bargain Sale Deed | $2,750,000 | Judicial Title Ins Agcy Llc | |
| Bargain Sale Deed | $2,750,000 | Judicial Title Ins Agcy Llc | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Bargain Sale Deed | -- | -- | |
| Bargain Sale Deed | -- | -- | |
| Bargain Sale Deed | -- | -- | |
| Deed | $1,575,000 | Jack Steingard | |
| Deed | $1,575,000 | Jack Steingard |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,925,000 | New Conventional | |
| Closed | $1,925,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 03/14/2025 03/14/25 | Sold | $2,750,000 | -6.8% | $332 / Sq Ft |
| 11/05/2024 11/05/24 | Pending | -- | -- | -- |
| 09/06/2024 09/06/24 | Price Changed | $2,950,000 | -9.2% | $356 / Sq Ft |
| 05/06/2024 05/06/24 | For Sale | $3,250,000 | -- | $392 / 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 | $57,679 | $1,907 | $706 | $1,201 |
| 2024 | $10,792 | $1,860 | $688 | $1,172 |
| 2023 | $52,367 | $1,890 | $699 | $1,191 |
| 2022 | $52,367 | $2,027 | $750 | $1,277 |
| 2021 | $78,926 | $2,255 | $757 | $1,498 |
| 2020 | $65,592 | $2,940 | $1,456 | $1,484 |
| 2019 | $11,930 | $3,150 | $1,463 | $1,687 |
| 2018 | $50,568 | $3,360 | $0 | $0 |
| 2017 | $57,663 | $3,960 | $1,433 | $2,527 |
| 2016 | $71,125 | $3,960 | $1,433 | $2,527 |
| 2015 | $13,633 | $4,311 | $1,238 | $3,073 |
| 2014 | $13,633 | $4,311 | $1,238 | $3,073 |
| 2013 | $12,553 | $4,311 | $1,238 | $3,073 |
Source: Public Records
Agents Affiliated with this Home
-
Gil Shemtov
Map
Source: OneKey® MLS
MLS Number: L3549596
APN: 2015-41-006-00-0003-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
- 252 Cedar Ave
- 1070 Seawane Dr
- 936 Madison St
- 185 Dolphin Dr
- 122 Finucane Place
- 1028 E Broadway
- 998 E Broadway
- 1205 E Broadway Unit F-13
- 1185 E Broadway Unit 4A
- 1175 E Broadway Unit 2-J
- 1197 E Broadway Unit K24
- 1195 E Broadway Unit L23
- 58 Centre St
- 4 Willow Ln
- 1 Willow Ln
- 1209 E Broadway Unit D15
- 101 Harold Rd
- 76 Carman Ave
- 1211 E Broadway Unit C-24
- 980 Singleton Ave