Your AI Navigator in Commercial Real Estate
Sign Up Successful!
You now have access to more from Realmo!
    For Sale
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    AI Search
    Back to Search

    138-27 247Th St Rosedale, NY 11422

    Sponsored
    For Sale
    Pending
    $3,100,000

    Business - Rosedale, NY

    Type:Business
    Property size:
    5,840 SF
    Days on Market:
    106
    Last Refresh:
    Jan 5 at 3:06 pm

    Property Features for 138-27 247Th St

    General Information

    Property type
    Commercial Sale
    Property subtype
    Business
    Standard status
    Pending
    Zoning
    R3-2, C1 Overlay
    Rooms
    Basement
    Parking features
    Open, Parking Lot
    Exterior features
    Fencing
    Fencing
    Fenced
    Basement Y/N
    1
    Size
    5,840 SF

    Utilities

    Heating system
    Forced Air, Natural Gas
    Cooling system
    Central Air

    Building Details

    Year built
    1987
    Building materials
    Brick, Frame
    Architectural style
    Other

    Signature Premier Properties (631) 673-3700 [email protected]

    Listing agent Kristin Schuster (631) 422-3100 License #10301209353

    Listing date Sep 22, 2025

    MLS# 815962 Listing URL

    Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

    Overview

    Rosedale Commercial Property with Warehouse

    Located on South Conduit Avenue in Rosedale, this commercial property includes a 5,840 sq. ft. free-standing building constructed in 1987. The building is situated on two 50’ x 100’ lots, totaling 10,000 sq. ft. The property features 3,500 sq. ft. of warehouse space with access to 3rd-floor storage and four 13’ high overhead doors. The warehouse also offers 22’ ceilings for loading and storage. Office space totals 2,600 sq. ft. and includes a stock room, a large showroom, office space, a kitchenette, and two half baths. There is also access to a 1,300 sq. ft. full basement with 11’ ceilings and an additional half bath. The property provides secure parking. A new heating and cooling system was installed in 2024. Zoned R3-2 with a C1 commercial overlay, the property is suitable for retail, warehouse operations, and light commercial use. It is located on a high-traffic corridor, offering visibility and accessibility.
    Property Profile Insight Report Location Intelligence

    Current Use by Public Records

    Schiano Fence Fence Supply Store

    Suggested Use

    Law Firm Restaurant Realty agency Spa & Massage Hair Salon Dental Office Clothing Store Nail Salon Food Market Gym & Fitness

    Zoning and permitted uses should be independently verified with local authorities.

    Similar Places Nearby

    Safeguard Self Storage, WolfePack Logistics, CubeSmart Self Storage, ATS

    Location Insight

    • Map
    • Local Demand
    City
    Rosedale
    County
    Queens
    State
    New York
    Longitude
    -73.722823
    Latitude
    40.74119

    Nearby Similar for Sale

    • New
      $1,449,000
      0.09 Acres

      New Construction Two-Family Home

      New construction two-family home in Rosedale, Queens.
      258-10 147Th Rd, Rosedale, NY 11422
      View Details
    • $1,199,000
      Pending

      Rosedale Two-Family Corner Property

      Well-maintained two-family property in desirable Queens neighborhood.
      225-15 147Th Ave, Rosedale, NY 11413
      View Details
    • New
      $1,399,999
      0.09 Acres

      Renovated Two-Family Home in Rosedale

      Meticulously renovated two-family home with income potential in Rosedale.
      24149 148Th Dr, Rosedale, NY 11422
      View Details
    • $1,495,000
      Pending

      Rosedale Two-Family Custom Home

      Newly constructed two-family home in Rosedale, Queens.
      24917 147Th Rd, Rosedale, NY 11422
      View Details
    • New
      $1,200,000
      0.07 Acres

      Rosedale Two-Family House For Sale

      Two-family house available for purchase in Rosedale, New York.
      138-60 234Th St, Rosedale, NY 11422
      View Details
    • New
      $1,449,000

      New Construction Two-Family Home

      New construction two-family home in Rosedale, NY.
      258-14 147Th Rd, Rosedale, NY 11422
      View Details
    • $1,079,000
      Pending

      Rosedale Multi-Family Brick Home

      Well-maintained multi-family home with investment potential in Rosedale, NY.
      146-06 228Th St, Rosedale, NY 11413
      View Details
    • $1,398,000
      0.09 Acres

      Modern Rosedale Two-Family Home

      Two modern units, built in 2019, with full basement.
      139-16 Caney Ln, Rosedale, NY 11422
      View Details
    • New
      $1,500,000
      0.07 Acres

      Rosedale Two-Story Residence

      Two-story residence in Rosedale near amenities, buses, schools, parks.
      143-06 243Rd St, Rosedale, NY 11422
      View Details
    • New
      $1,349,000
      0.14 Acres

      Renovated Two-Family in Rosedale

      Turn-key, renovated two-family home in Rosedale, move-in ready.
      14101 255Th St, Rosedale, NY 11422
      View Details
    • $869,990
      Pending

      Spacious Rosedale Multi-Family Home

      Five bedrooms, four baths, finished basement, garage, and driveway.
      256-20 Craft Ave, Rosedale, NY 11422
      View Details
    • New
      $807,500
      Pending

      Rosedale Multifamily Auction Property

      Multifamily property in Rosedale, NY, selling at auction.
      13834 247Th St, Rosedale, NY 11422
      View Details

    FAQs

    What type of property is this?
    Warehouse - Commercial property in Rosedale with warehouse, showroom, and office space.
    Where is this warehouse located?
    The property is located at 138-27 247Th St Rosedale, NY.
    What is the asking price?
    The asking price for this property is $3,100,000.
    What are key features of this property?
    This property features: - Prime commercial property featuring a 5,840 sq. ft. free-standing building.; - 3,500 sq. ft. warehouse space with 4 - 13’ high overhead doors and 22’ ceilings.; - 2,600 sq. ft. of office space includes showroom, kitchenette, and baths.
    (631) 417-6285
    Request Owner's contact information
    138-27 247Th St Rosedale, NY 11422
    Message sent successfully
    Error
    If you are the owner or broker of this property and would like to edit or remove this listing please send a message to web site administrator.
    138-27 247Th St
    Rosedale, NY 11422
    Message sent successfully
    Error
    Email to Your Friends
    Link copied to clipboard
    Separate multiple addresses with a comma
    Message sent successfully
    Error

    Realmo Value Estimation

    Realmo estimates a property’s market value using a proprietary methodology that incorporates public data and user-submitted information. This cumulative value is generated by integrating a variety of conventional and innovative methods. 

    Disclaimer

    These figures are not official appraisals and should not be used as a substitute for a valuation performed by a licensed appraiser.

    Actual market value may differ due to factors not captured in the data. Estimates are offered for informational purposes only, and users should conduct independent research before making financial or investment decisions.

    By using this feature, you acknowledge that Realmo is not responsible for actions taken based on these estimates.

    AI approach

    Realmo AI Method estimates property value using machine learning models trained on millions of comparable listings, transactions, and market signals. It analyzes property features, location intelligence data, and current market dynamics to predict the most probable market value in real time.

    Cap approach

    Capitalization Method calculates value based on estimated net operating income (NOI) and applying a market-based capitalization rate (cap rate), we estimate what a typical investor might be willing to pay for it.

    Comparable approach

    Comparable estimate is based on recent sales of similar nearby properties, adjusted for factors like size, condition, and location.

    Relative

    Relative property class coefficient uses factors that account for typical price differences between various asset types (e.g., retail vs. industrial) to provide a more accurate market-aligned estimate.

    Geo

    Comparable Sales Method, enhanced by Geo coefficients — location-based adjustment factors that reflect differences in price levels across neighborhoods, cities, or regions ensuring a more accurate, market-sensitive valuation.

    Alternative use

    Estimate considers the property’s potential value if used for a different purpose-based on zoning, demand, and market feasibility.

    More about this property
    138-27 247Th St Rosedale, NY 11422
    Thanks! Your message was sent.
    Error! Your message wasn't sent.
    Please enter your name
    Please enter email
    Please enter the email in the correct format
    Please enter phone
    Please enter the number in the correct format
    Please enter message
    Google sign-in failed. Please try again or use another login method.
    Create New Password
    • At least 8 characters
    • Contains both letters and numbers
    • Contains uppercase and lowercase letters
    • At most 32 characters
    • Password required
    • Password reset link has expired. Please request a new one.