14983 254 St
Welcome to an exceptional and elegantly maintained two family residence in the heart of Rosedale, featuring 8 bedrooms , 5 bathrooms and a finished basement. presenting a rare opportunity for discerning homeowners. This impressive property offers two separate living units, creating remarkable flexibility for multi generational living, rental income, or owner occupied income. Complemented by private parking and a shared driveway, the property offers an inviting functional layout with enduring potential. ideally positioned near shopping, transportation, schools, parking and major roadways , this compelling Queens opportunity delivers an appealing blend of convenience, versatility and value . Schedule your private showing today.
Listing Information
Open Houses
-
Sunday, October 183:00 PM – 5:00 PM
Facts & Features
Location
Community Information
Architecture
Features & Amenities
Property Features
Square Footage
Tax & Financial Information
Schools
Ps 195 William Haberle
Assigned school for this home
Ps 181 Brookfield
Ps/Middle School 138 Sunrise
Valley Stream South High School
Robert W Carbonaro School
Ogden Elementary School
Ps 38 Rosedale
Woodmere Middle School
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 |
|---|---|---|
| 09/09/2026 | Price change | $1,120,000 |
| 07/07/2026 | Listed for sale | $1,150,000 |
Listed by Gayon Facey · Xquizit Realty Inc · 6466759617
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: October 14, 2026 at 8:59 PM | Source: OneKey MLS | MLS#: 1022603

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, James Haydon is here to help. Reach out and expect a response within one business day.
How can I help?
James Haydon is here to help. Reach out and expect a response within one business day.
Thanks — James Haydon 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?
James Haydon is here to help. Reach out and expect a response within one business day.
✓ Thanks — James Haydon will be in touch shortly.





