13723 249th St
*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED *** Location truly doesn’t get better than this. This legal 2-family home offers unbeatable convenience and exceptional potential. Just steps from Sunrise Highway and literally next to Green Acres Mall, everything you need is right at your doorstep - groceries, restaurants, retail shopping, banks, pharmacies, and everyday essentials. Commuters will appreciate the easy access to major transportation routes and public transit, making travel throughout Queens, Brooklyn, and Long Island effortless. Despite being next to everything, the home sits on a quiet dead-end block, providing a peaceful residential setting with minimal traffic. The property also features a private driveway, adding valuable convenience and off-street parking. This property checks every box for investors and end-users alike. With a legal two-family layout, it presents an excellent opportunity for rental income, multi-generational living, or a strong long-term investment in a high-demand neighborhood. The home is being SOLD AS-IS, ALL CASH and is DRIVE-BY ONLY. Priced for a very quick sale.
Listing Information
Facts & Features
Location
Community Information
Architecture
Features & Amenities
Property Features
Square Footage
Tax & Financial Information
Schools
Ps/Middle School 138 Sunrise
Ps 156 Laurelton
Robert W Carbonaro School
Valley Stream South High School
Forest Road School
Clearstream Avenue School
Ogden Elementary School
Ps 38 Rosedale
School ratings are provided for informational purposes only and are subject to change. Attendance boundaries are for reference only — contact the school or district directly to verify enrollment eligibility.
Historical Data
Price History
| Date | Event | Price |
|---|---|---|
| 03/13/2026 | Price change | $595,000 |
| 03/08/2026 | Listed for sale | $670,000 |
Listed by Bisendra M. Melaram AHWD MRP PSA S · Keller Williams Realty Greater · 5168737100
Listing information provided exclusively for consumers' 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 deemed reliable but not guaranteed by the MLS. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, OneKey MLS. All rights reserved.
Last Updated: September 10, 2026 at 6:58 PM | Source: OneKey MLS | MLS#: 968520
Similar Homes For Sale In Rosedale
Start Your Real Estate Journey
Whether you have questions about this listing, want to schedule a showing, or just want to talk through your options, Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
How can I help?
Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
Thanks — Jeromy Dunn-Portella will be in touch shortly.
Make A Plan For Your Purchase
Know what you can afford before you start shopping — then run the numbers on any home you have in mind.
How much house can I afford?
- Principal & interest
- Property taxes
- Homeowner's insurance
- HOA dues
If your monthly savings are applied to the loan principal.
Enter your income, debts, and down payment to see how much home you may qualify for. Estimates only — not a lending decision.
Want to know more?
Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
✓ Thanks — Jeromy Dunn-Portella will be in touch shortly.