• 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
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • 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 MAY 24 2025 AT 6:19 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

138-27 247 St

queens, NY 11422

$3,100,000

    INTERESTED? LET'S CONNECT

    This prime commercial property on South Conduit Avenue in Rosedale spans 10,000 sq. ft. across two 50’ x 100’ lots and features a three-story, 5,840 sq. ft.free standing building constructed in 1987. The 3,500 sq ft. warehouse space provides access to 3rd floor storage, 4 - 13’ high overhead doors, 22’ ceilings for efficient loading and storage. The office space totals 2600 sq. ft. including a stock room, large showroom, office space, kitchenette, 2 half baths and access to your 1300 sq. Ft full basement with 11’ ceilings and additional half bath. The property also provides secure parking and was recently upgraded with a new heating & cooling system installed in 2024. Zoned R3-2 with a C1 commercial overlay, this versatile property is ideal for retail, warehouse operations, light commercial use, or future development. Situated on a high-traffic corridor, it offers excellent visibility and accessibility, making it a valuable investment or expansion opportunity.

    Details

    5,840 Sq Ft

    0.23 Private Acres Exterior Space

    Commercial

    $43,108 Annual Tax

    Built in 1987

    MLS/Listing ID 815962

    Amenities & Features

    Block

    Cooling - Central Air

    Construction - Frame

    Parking - Open

    Parking - Private

    Construction - Brick

    Fenced

    Heating - Natural Gas

    Parking - Parking Lot

    Concrete Perimeter

    Heating - Forced Air

    Listing Courtesy of SIGNATURE PREMIER PROPERTIES, KRISTIN SCHUSTER - 631-417-6285

    ONEKEY

    Source of Data: ONEKEY MLS

    Interested in 138-27 247 St?