Seller's Agent in 2025
Gil Shemtov
Douglas Elliman Real Estate
(516) 835-3333
144 Total Sales
217 Cedar Ave Hewlett, NY 11557
Estimated Value: $2,884,629 - $4,101,000
7
Beds
8
Baths
8,290
Sq Ft
$397/Sq Ft
Est. Value
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
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
May 6, 2024
Closed on
Mar 12, 2025
Sold by
Bought by
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
$541,657
Avg. Annual Appreciation
15.21%
Original Mortgage
$1,925,000
Outstanding Balance
$1,899,760
Interest Rate
6.5%
Mortgage Type
New Conventional
Estimated Equity
$1,391,897
Purchase Details
Closed on
Jun 2, 2021
Sold by
Bought by
Purchase Details
Closed on
Aug 16, 2013
Sold by
Bought by
Purchase Details
Closed on
Aug 23, 2001
Bought by
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 |
|---|---|---|---|
| $2,750,000 | Judicial Title Ins Agcy Llc | ||
| $2,750,000 | Judicial Title Ins Agcy Llc | ||
| $2,750,000 | Judicial Title Ins Agcy Llc | ||
| $2,750,000 | Judicial Title Ins Agcy Llc | ||
| -- | None Available | ||
| -- | None Available | ||
| -- | None Available | ||
| -- | -- | ||
| -- | -- | ||
| -- | -- | ||
| $1,575,000 | Jack Steingard | ||
| $1,575,000 | Jack Steingard |
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 | $1,925,000 | ||
| Closed | $1,925,000 |
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 |
|---|---|---|---|---|
| 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
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 | $57,679 | $1,958 | $724 | $1,234 |
| 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.
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
- 10 Macy Dr
- 214 Cedar Ave
- 252 Cedar Ave
- 50 Heron Dr
- 315 Hewlett Neck Rd
- 199 Cherry St
- 1040 Links Rd
- 205 Hewlett Neck Rd
- 170 Ocean Ave
- 148 Willis Ct
- 270 Dolphin Dr
- 1245 Veeder Dr
- 1045 Stanton Ave
- 996 Wateredge Place
- 185 Dolphin Dr
- 122 Palmyra Ave
- 111 Palmyra Ave
- 1304 Seawane Dr
- 118 Ocean Ave
- 122 Finucane Place
Your Personal Tour Guide
Ask me questions while you tour the home.