Seller's Agent in 2026
Edna Mashaal
Edna Mashaal Realty LLC
(516) 840-8888
8 in this area
223 Total Sales
90 Greenleaf Hill Great Neck, NY 11023
Saddle Rock/Harbor Hills Neighborhood
5
Beds
6.5
Baths
4,567
Sq Ft
18,731
Sq Ft
Highlights
- Beach Front
- Eat-In Gourmet Kitchen
- Deck
- Saddle Rock School Rated A+
- Open Floorplan
- Contemporary Architecture
About This Home
As of February 2026SADDLE ROCK WATERFRONT DREAM HOME! Welcome To Your Waterfront Oasis Offering Breathtaking Views of the Serene Waterfront, with a Touch of New York City's Vibrant Energy. Grand Entry Foyer, Formal Living Room, Den with Fireplace, State of the Art EIK with Large Breakfast Area with Radiant Heat Floors All Overlooking the Spectacular Views. The Soaring Ceilings Create an Open and Inviting Ambiance, While the Sensitive Design Details Add an Extra Layer of Luxury and Comfort. Experience the Perfect Blend of Tranquility & Excitement in this Remarkable Property. Your Dream Waterfront Living Awaits! Residence Enjoy Access to Top Notch Amenities, including Waterfront Pool, Tennis Courts & Outdoor Gym Equipment. Saddle Rock Elementary; Great Neck North Middle & High Schools.,
Last Agent to Sell the Property
Edna Mashaal Realty LLC Brokerage Phone: 516-504-8884 License #49MA0955405 Listed on: 09/05/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $51,241
Year Built
- Built in 2001
Lot Details
- 0.43 Acre Lot
- Lot Dimensions are 100 x 215
- Beach Front
- South Facing Home
Parking
- 2 Car Garage
Home Design
- Contemporary Architecture
- Frame Construction
Interior Spaces
- 4,567 Sq Ft Home
- Open Floorplan
- High Ceiling
- 2 Fireplaces
- Entrance Foyer
- Formal Dining Room
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Area or Nook
- Breakfast Bar
- Gas Oven
- Gas Range
- Freezer
- Dishwasher
- Stainless Steel Appliances
- Kitchen Island
Flooring
- Wood
- Radiant Floor
Bedrooms and Bathrooms
- 5 Bedrooms
- Main Floor Bedroom
- Bathroom on Main Level
Laundry
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Basement Storage
Home Security
- Home Security System
- Fire and Smoke Detector
Outdoor Features
- Deck
- Patio
- Terrace
Schools
- Saddle Rock Elementary School
- Great Neck North Middle School
- Great Neck North High School
Utilities
- Forced Air Heating and Cooling System
- Vented Exhaust Fan
- Heating System Uses Natural Gas
- Radiant Heating System
- Natural Gas Connected
Community Details
- Building Fire Alarm
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 5, 2025
Closed on
Jan 29, 2026
Sold by
Aizer Dan and Aizer Gila
Bought by
18 Locust Drive Llc
Seller's Agent
Edna Mashaal
Edna Mashaal Realty LLC
Buyer's Agent
Carole Hakimi
S Sharf Realty Inc
List Price
$6,450,000
Sold Price
$6,100,000
Premium/Discount to List
-$350,000
-5.43%
Views
1982
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
92.79%
Purchase Details
Closed on
Jun 29, 2000
Sold by
Steinman Bertram
Bought by
Aizer Dan and Aizer Gila
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 |
|---|---|---|---|
| Deed | $1,625,000 | Martin Katzman | |
| Deed | $1,625,000 | Martin Katzman |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/02/2026 02/02/26 | Sold | $6,100,000 | -5.4% | $1,336 / Sq Ft |
| 11/07/2025 11/07/25 | Pending | -- | -- | -- |
| 09/05/2025 09/05/25 | For Sale | $6,450,000 | -- | $1,412 / Sq Ft |
Source: OneKey® MLS
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 | $49,626 | $2,884 | $1,059 | $1,825 |
| 2024 | $10,915 | $2,781 | $1,021 | $1,760 |
Source: Public Records
Agents Affiliated with this Home
-
Edna Mashaal
-
Carole Hakimi
Buyer's Agent in 2026
Carole Hakimi
S Sharf Realty Inc
(516) 773-6677
4 in this area
28 Total Sales
Map
Source: OneKey® MLS
MLS Number: 908717
APN: 2249-02-312-00-0011-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
Nearby Homes
Your Personal Tour Guide
Ask me questions while you tour the home.