238 47 148 Dr
A rare opportunity to own a fully-detached, solid two-family home nestled on a quiet residential block in the heart of Rosedale, Queens. This well-maintained property offers space, flexibility, and convenience for both end users and investors alike. This versatile property features two spacious 3-bedroom, 2-bath apartments, each with a private en-suite bathroom in the primary bedroom, plus a semi-finished basement with its own separate entrance and 3/4 bath — ideal for extended living or bonus recreational space. The first-floor unit has been recently renovated, offering a fresh, modern interior with direct basement access and side access to the backyard. The upper unit offers the same generous layout, full of natural light, flexibility and a private balcony off of the living room. Each unit is equipped with its own separate gas boiler and hot water tank, providing comfort and independence for both households. A long, private driveway fits 3–4 vehicles comfortably, allowing for family and friend gatherings for those days you want to entertain. Whether you're looking to live in one unit and rent the other, or seeking a strong investment property, this is an incredible opportunity. Conveniently located near shops, parks, schools, JFK airport and major transit options. Move-in ready, income-producing, and fully detached — this home has it all.
Listing Information
Facts & Features
Location
Community Information
Architecture
Features & Amenities
Property Features
Square Footage
Tax & Financial Information
Schools
Ps 181 Brookfield
Assigned school for this home
Community Voices Middle School
Assigned school for this home
Ps/Middle School 138 Sunrise
Ps 156 Laurelton
Collaborative Arts Middle School
Ps 52
Ps 195 William Haberle
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 |
|---|---|---|
| 06/19/2025 | Listed for sale | $1,100,000 |
Listed by Christian Florez · MYNY Residential · 7189213100
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: July 30, 2026 at 12:31 AM | Source: OneKey MLS | MLS#: 879836

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, 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.





