Seller's Agent in 2025
Stuart Bayer
Compass Greater NY LLC
(212) 464-7449
1 in this area
79 Total Sales
45 Longfellow Rd Great Neck, NY 11023
Saddle Rock/Harbor Hills NeighborhoodEstimated Value: $3,433,972 - $4,271,000
7
Beds
6.5
Baths
5,200
Sq Ft
$741/Sq Ft
Est. Value
Highlights
- Colonial Architecture
- Deck
- Cathedral Ceiling
- Saddle Rock School Rated A+
- Property is near public transit and schools
- 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
Compass Greater NY LLC Brokerage Phone: 516-375-1005 License #40BA0904601 Listed on: 08/14/2024
Co-Listed By
Compass Greater NY LLC 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
- 12,998 Sq Ft 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 and 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
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
Aug 14, 2024
Closed on
Sep 30, 2025
Sold by
Bought by
Seller's Agent
Stuart Bayer
Compass Greater NY LLC
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
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
$500,486
Avg. Annual Appreciation
21.00%
Purchase Details
Closed on
Sep 5, 2014
Sold by
Bought by
Purchase Details
Closed on
Feb 23, 2011
Sold by
Bought by
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
Bought by
Purchase Details
Closed on
Jan 3, 1996
Sold by
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 |
|---|---|---|---|
| $3,352,000 | Wfg Natl Title Ins Company | ||
| $3,352,000 | Wfg Natl Title Ins Company | ||
| -- | None Available | ||
| -- | None Available | ||
| -- | None Available | ||
| -- | None Available | ||
| $2,610,000 | -- | ||
| -- | -- | ||
| -- | -- | ||
| $2,610,000 | -- | ||
| -- | -- | ||
| $2,610,000 | -- | ||
| -- | -- | ||
| $1,380,000 | -- | ||
| $1,380,000 | -- | ||
| -- | -- | ||
| -- | -- |
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 |
|---|---|---|---|
| Previous Owner | $1,800,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 |
|---|---|---|---|---|
| 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
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 | $50,689 | $2,815 | $723 | $2,092 |
| 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
Compass Greater NY LLC
(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
17 in this area
71 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.
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
- 35 Longfellow Rd
- 25 Longfellow Rd
- 20 Dickenson Place
- 40 Longfellow Rd
- 70 Longfellow Rd
- 60 Longfellow Rd
- 50 Longfellow Rd
- 55 Longfellow Rd
- 30 Longfellow Rd
- 30 Dickenson Place
- 80 Longfellow Rd
- 35 Stevenson Dr
- 25 Stevenson Dr
- 5 Dickenson Place
- 215 Gristmill Ln
- 45 Stevenson Dr
- 225 Gristmill Ln
- 65 Longfellow Rd
- 20 Longfellow Rd
- 40 Dickenson Place
Your Personal Tour Guide
Ask me questions while you tour the home.