Seller's Agent in 2025
Stuart Bayer
Douglas Elliman Real Estate
(212) 464-7449
1 in this area
83 Total Sales
45 Longfellow Rd Great Neck, NY 11023
Saddle Rock/Harbor Hills Neighborhood
7
Beds
6.5
Baths
5,200
Sq Ft
0.3
Acres
Highlights
- Colonial Architecture
- Deck
- Cathedral Ceiling
- Saddle Rock School Rated A+
- Property is near public transit
- Wood Flooring
About This Home
As of September 2025Welcome to this picture-perfect 7-bedroom, 6.5-bathroom brick center hall colonial, offering 5,200 square feet of refined living space in the highly sought-after Village of Saddle Rock. As you enter the dramatic double-height foyer, you are greeted by a stunning wrought iron circular staircase and an open floor plan that exudes elegance. The home features soaring 10-foot ceilings and a modern eat-in kitchen, complete with a large center island and breakfast area, perfect for casual dining and entertaining. Host elegant gatherings in the grand dining room with radiant heat or relax in the expansive living room, designed for seamless entertaining. A cozy den with a fireplace adds a touch of warmth, while a first-floor laundry room and a versatile bedroom or office with an en suite full bath provides convenience and flexibility. Architectural moldings, hardwood floors, luxurious marble, onyx bathrooms and a generator highlight the home's attention to detail. The expansive finished walk-out lower level, with its soaring ceilings, offers a bedroom, full bath, playroom and ample storage, making it an ideal space for recreation and organization. Outside, enjoy the proximity to Saddle Rock Village Park, featuring a private marina, waterfront pool, tennis courts, and basketball courts. This residence is not just a home; it's a lifestyle, perfectly suited for easy living and exceptional entertaining., Additional information: Appearance:Excellent,Interior Features:Guest Quarters,Marble Bath,Separate Hotwater Heater:Y
Last Agent to Sell the Property
Douglas Elliman Real Estate Brokerage Phone: 516-375-1005 License #40BA0904601 Listed on: 08/14/2024
Co-Listed By
Douglas Elliman Real Estate Brokerage Phone: 516-375-1005 License #10401267171
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $60,294
Year Built
- Built in 2009 | Remodeled in 2013
Lot Details
- 0.3 Acre Lot
- Lot Dimensions are 100x130
- Private Entrance
- Front and Back Yard Sprinklers
Parking
- Attached Garage
Home Design
- Colonial Architecture
- Brick Exterior Construction
Interior Spaces
- 5,200 Sq Ft Home
- 3-Story Property
- Cathedral Ceiling
- 2 Fireplaces
- Entrance Foyer
- Formal Dining Room
- Wood Flooring
- Attic Fan
- Home Security System
Kitchen
- Eat-In Kitchen
- Cooktop
- Freezer
- Dishwasher
- Granite Countertops
Bedrooms and Bathrooms
- 7 Bedrooms
- Main Floor Bedroom
- En-Suite Primary Bedroom
- Walk-In Closet
Laundry
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Deck
- Private Mailbox
- Porch
Location
- Property is near public transit
- Property is near schools
Schools
- Great Neck North Middle School
- Great Neck North High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Oil
- Radiant Heating System
- Electric Water Heater
Community Details
- Park
Listing and Financial Details
- Legal Lot and Block 7 / 308
- Assessor Parcel Number 2249-02-308-00-0007-0
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 14, 2024
Closed on
Sep 30, 2025
Sold by
The Xiao Rong He Revocable Trust and The Li Yan Revocable Trust
Bought by
Setareh Family Revocable Trust and Setareh
Seller's Agent
Stuart Bayer
Douglas Elliman Real Estate
Buyer's Agent
Diana Bakhash
S Sharf Realty Inc
List Price
$3,980,000
Sold Price
$3,352,000
Premium/Discount to List
-$628,000
-15.78%
Views
216
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
108.74%
Purchase Details
Closed on
Sep 5, 2014
Sold by
Yan Li and He Xiaorong
Bought by
The Xiao Rong He Revocable Trust and Yan
Purchase Details
Closed on
Feb 23, 2011
Sold by
45 Longfellow Road Inc
Bought by
He Xiaorong
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,800,000
Interest Rate
4.16%
Mortgage Type
Unknown
Purchase Details
Closed on
Feb 9, 2009
Sold by
Allan Greeenberg
Bought by
45 Longfellow Road Inc
Purchase Details
Closed on
Jan 3, 1996
Sold by
Horwitz Rhoda and Horwitz Gerard
Bought by
Rhoda Horwitz Qualified Person Al Residence T and Gerard Horwitz Qualified Perso Nal Residence
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 | $3,352,000 | Wfg Natl Title Ins Company | |
| Quit Claim Deed | -- | None Available | |
| Quit Claim Deed | -- | None Available | |
| Quit Claim Deed | -- | None Available | |
| Quit Claim Deed | -- | None Available | |
| Deed | $2,610,000 | -- | |
| Deed | -- | -- | |
| Deed | -- | -- | |
| Deed | $2,610,000 | -- | |
| Deed | -- | -- | |
| Deed | $2,610,000 | -- | |
| Deed | -- | -- | |
| Deed | $1,380,000 | -- | |
| Deed | $1,380,000 | -- | |
| Deed | -- | -- | |
| Deed | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $1,800,000 | Unknown |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 09/30/2025 09/30/25 | Sold | $3,352,000 | -9.0% | $645 / Sq Ft |
| 05/30/2025 05/30/25 | Pending | -- | -- | -- |
| 04/24/2025 04/24/25 | Price Changed | $3,685,000 | -2.9% | $709 / Sq Ft |
| 01/08/2025 01/08/25 | Price Changed | $3,795,000 | -4.6% | $730 / Sq Ft |
| 08/14/2024 08/14/24 | For Sale | $3,980,000 | -- | $765 / 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 | $50,689 | $2,815 | $723 | $2,092 |
| 2024 | $12,430 | $2,815 | $723 | $2,092 |
| 2023 | $45,552 | $2,815 | $723 | $2,092 |
| 2022 | $45,552 | $2,673 | $723 | $1,950 |
| 2021 | $41,460 | $2,522 | $699 | $1,823 |
| 2020 | $37,933 | $3,444 | $2,171 | $1,273 |
| 2019 | $35,871 | $3,691 | $2,182 | $1,509 |
| 2018 | $36,154 | $3,937 | $0 | $0 |
| 2017 | $26,990 | $4,183 | $2,127 | $2,056 |
| 2016 | $37,257 | $4,576 | $2,327 | $2,249 |
| 2015 | -- | $4,576 | $2,327 | $2,249 |
| 2014 | -- | $4,576 | $2,327 | $2,249 |
| 2013 | $10,229 | $4,576 | $2,327 | $2,249 |
Source: Public Records
Agents Affiliated with this Home
-
Stuart Bayer
-
Nicole Eskanazy
Seller Co-Listing Agent in 2025
Nicole Eskanazy
Douglas Elliman Real Estate
(516) 621-3555
1 in this area
33 Total Sales
-
Diana Bakhash
D
Buyer's Agent in 2025
Diana Bakhash
S Sharf Realty Inc
(516) 643-9411
15 in this area
69 Total Sales
Map
Source: OneKey® MLS
MLS Number: L3572391
APN: 2249-02-308-00-0007-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
- 70 Candy Ln
- 75 Greenleaf Hill
- 90 Greenleaf Hill
- 145 Arrandale Ave
- 23 Parkside Dr
- 11 Brook Ln
- 34 Woodland Place
- 6 Hickory Dr
- 200 Myrtle Dr
- 65 Clover Dr
- 14 Shorecliff Place
- 14 Martin Ct
- 13 Potters Ct
- 2 Henry St
- 20 Martin Ct
- 6 Grady Ct
- 22 Martin Ct
- 218 Middle Neck Rd Unit 207
- 218 Middle Neck Rd Unit 105
- 218 Middle Neck Rd Unit 314