by RH Advisors

See Home Value
$2,750,000
● House - Off Market

217 Cedar Avenue

Hempstead, NY 11557
bedrooms
7 Beds
bathrooms
6 Baths, 2 Half Baths
square feet
8,290 Ft²
$19,198
Est. Monthly
4.55%
Cap Rate

About This Property

Experience 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
Unit Size
8,290 Ft²
Days on Market
-
Land Size
1.00 acres
Price per sqft
$356
Property Type
House
Property Taxes
$4,713
HOA Dues
-
Year Built
1923

Payment Calculator

Cap Rate Calculator

Last updated: 5 months ago (OneKey MLS #KEYL3549596)

Price History

Date / Event Date Event Price
Mar 14, 2025 Sold
Sold
May 6, 2024 Listed by Douglas Elliman Real Estate $2,950,000
Listed by Douglas Elliman Real Estate
Nov 17, 2023 No longer available -
No longer available
Oct 16, 2023 In contract -
In contract
Apr 18, 2023 Listed by Douglas Elliman Real Estate $3,650,000
Listed by Douglas Elliman Real Estate
Show More

Property Highlights

Garage
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1923
  • Effective Year Built: 1923
  • Total Rooms: 9
  • Bedroom Count: 0
  • Bathroom Count: 7
  • Full Bathrooms: 5
  • Partial Bathrooms: 7
  • Bathroom Plumbing Fixtures: 6
  • Building Condition: 1
  • Building Quality: 3
  • Construction Type: 6
  • Building Style: 21
  • Exterior Walls Type: 17
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 20
  • Floor Count: 175
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 3
  • Basement Area: 993
  • Garage Type: 7
  • Garage Square Area: 540
  • Parking Space Count: 2
  • Patio Type: 0
  • Porch Type: 7
  • Pool Type: 8

    Dimensions

  • Lot Size Square Feet: 43,560
  • Lot Size Depth Feet: 1,780
  • Lot Size Frontage Feet: 1,690
  • Total Building Area: 8,290
  • Building Area: 8,290
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 8,290
  • Heating Fuel Type: 6

    Utilities

  • Sewer System: 1
  • Water Service: 2

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000001000
  • Standard Land Use Code: 1001
  • County Land Use Code: 2100
  • Legal Description 1: TOWN #1 SCH DIST 014

Neighborhood

  • School District Name: Hewlett-Woodmere Union Free School District
  • School Tax School District: 014
  • School Tax District Code 2: HBP
  • Census Tract: 411500

Geography

  • District: 282015
  • Section: 41
  • Parcel: 41-006-00-0003
  • Block: 6
  • Lot: 3
  • Municipality: HEWLETT BAY PARK
  • Latitude: 40.6295
  • Longitude: -73.6943

    Address

  • Full Address: 217 Cedar Ave
  • Address - House Number: 217
  • Address - Street Name: Cedar
  • Address - Suffix Type: Ave
  • State: NY
  • City Name: Hewlett
  • Carrier Code: C003
  • 4-Digit Zip Code: 2519
  • Zip Code: 11557

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $5,236,676
  • Tax Rate Code Area: 174

    Appraisal Valuation

  • Standard Deviation: 0.0928
  • Valuation Date: Oct 18, 2023
  • Confidence Score: 91
  • Final Value: 3,373,299
  • High Value: 3,686,403
  • Low Value: 3,060,195

    Market Valuation

  • Market Total Value: $1,890,000

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $1,890
  • Assessed Land Value: $699
  • Assessed Improvements Value: $1,191

    Sales

  • Current Sale Contract Date: Aug 23, 2001
  • Current Sale Recording Date: Sep 04, 2001
  • Current Sale Price:
  • Current Sale Document Type: 27
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Five Towns


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Unit for rent at 1304 Harbor Road, Hewlett Harbor, NY, 11557

$16,950 /mo

  • 6 Beds
  • 3 Baths
  • 4,700 ft²
1304 Harbor Road, Hewlett Harbor, NY, 11557 Listing by Malka Asch


Frequently Asked Questions

When was property at 217 Cedar Avenue built and last sold?
The property at 217 Cedar Avenue was built in 1923 and last sold on Aug 23, 2001 for $1,575,000.
How much is this home worth?
The estimated value of the home located at 217 Cedar Avenue is $2,979,500.
What are some comparable homes to 217 Cedar Avenue?
There are currently no comparable homes to 217 Cedar Avenue.