Mel Farrell
REALTOR® Associate Real Estate Broker
REALTOR®
BEDS5
BATHS2 full 2 partial
SQUARE FEET3,588
MLS#1017728
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLGreat Neck
Property Description
Welcome to this expansive and unique single-family home located in the highly sought-after Great Neck South School District. Situated on a massive 10,000 sq. ft. lot, this masterfully combined residence features a beautifully preserved vintage front section seamlessly blended with a brand-new, modern rear extension, offering a total usable living space of 3,600 sq. ft.Features & LayoutBedrooms & Bathrooms: 5 spacious bedrooms and 4 elegant bathrooms.Living Spaces: A massive main living room, plus a dedicated bonus study/office and a cozy TV/media room.Kitchens: A culinary dream featuring two premium marble-top gourmet kitchens, fully equipped with top-tier stainless steel appliances.Location & ConvenienceUnbeatable prime location! Just steps away from Northern Boulevard, placing you a quick 5-minute drive to local supermarkets. Commuting is effortless with the LIRR (Long Island Rail Road), easy access to the I-495 (LIE), and convenient direct buses to Main Street, Flushing.Perfectly blending classic charm, spacious luxury, and unparalleled convenience, this rare gem is an absolute must-see.
Property Features
Property Type: Residential - Single Family
Basement: Storage Space
Cooling: Central Air
Fireplaces: 1
Garage: 1
Heating: Natural Gas
Home Style: A-Frame
Lot Size: 0.23 Acres
Taxes: $18,261
Year Built: 1925
Amenities
Open Kitchen
Feature Descriptions
Appliances: Dishwasher, Gas Oven, Microwave, Refrigerator, Stainless Steel Appliance(s)
Attic: Storage
Building Area Total: 3588
Exterior: Other
Fireplace Y/N: Yes
Flooring: Hardwood
GarageY/N: Yes
On Market Date: 2026-06-24
Parcel Number: 2253-02-257-00-0384-0
Parking Features: Driveway, Garage, Storage
Rental Term: Monthly
Rooms Total: 12
Sewer: Public Sewer
Utilities: Electricity Available, Natural Gas Available
Water: Public
Local Schools
High School: Great Neck South High School
Middle School: Great Neck South Middle School
Elementary School: Lakeville Elementary School
School District: Great Neck
Estimate Your Payment
Estimated Payment
$ 15,427.10 per month $13,147.01 Principal & Interest $1,521.75 Property Tax $758.33 Homeowner's InsuranceChange Payment Information
Listed By / Shown By
Listing By
Agency Name: B Square Realty
Agency Contact: 516-888-8889
Shown By
Agent Name: Mel Farrell
Agent Phone: Cell: (601) 212-5666
Agency Title: Coldwell Banker American Homes
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
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.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
87 Susquehanna Avenue | MLS# 1017728
This single family home located at 87 Susquehanna Avenue, Great Neck, NY 11021 is currently listed for sale with an asking price of $2,600,000. This property was built in 1925 and has 5 bedrooms and 2 full and 2 partial baths with 3588 sq. ft. Susquehanna Avenue is located within the Great Neck school district. Search Great Neck real estate on melfarrell.cbamhomes.com today.