• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON JUL 06 2025 AT 12:24 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

238-47 148th Dr

queens, NY 11422

$1,100,000

  • 6 BR
    4 BA, 1 HALF BA
    APPROX. 2,400 SF

INTERESTED? LET'S CONNECT

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.

Details

2,400 Sq Ft

4,000 Sq Ft Exterior Space

Single Family Townhouse

$7,896 Annual Tax

Built in 1945

MLS/Listing ID 879836

Amenities & Features

Cooling - Wall/window unit(s)

Construction - Frame

Style - A Frame

Refrigerator

Heating - Natural Gas

Listing Courtesy of COLDWELL BANKER RELIABLE R E, CHRISTIAN FLOREZ - 718-921-3100

ONEKEY

Source of Data: ONEKEY MLS

Interested in 238-47 148th Dr?