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

    138-27 247Th St Rosedale, NY 11422

    • Investment properties
    • 5,840 SF
    • 0.11 lot acres
    For Sale
    View listing
    $3,100,000
    Value Estimation
    Location Intelligence
    Property ID
    US63-3801127
    The Realmo ID is a unique identifier assigned to every property, incorporating country codes and precise geo-coordinates for 300x300-foot land blocks. It enables standardized data collection and seamless integration of disparate sources such as ownership, tax, title data and physical specifications. By aggregating current and historical records, the Realmo ID powers advanced analytics and delivers deep, verifiable insights for real estate professionals.

    Current Use by Public Records

    • Investment properties

    Property Details for 138-27 247Th St

    Year built
    1987
    Lot size
    0.11 lot acres
    Property size
    5,840 SF
    Zone code
    R3-2
    Property type
    Investment properties
    Property subtype
    Retail residential properties
    APN
    13621-0011
    APU
    136210011

    Description

    This exceptional commercial property, located at 13827 247th St, Rosedale, NY, presents a unique investment opportunity. The property encompasses a substantial 0.23-acre lot and features a three-story, free-standing building totaling 5,840 square feet, constructed in 1987. The building offers a versatile layout, ideal for a variety of commercial uses. A significant portion of the space is dedicated to warehouse operations, encompassing 3,500 square feet. This area boasts 4, 13-foot high overhead doors, and 22-foot ceilings, facilitating efficient loading and storage. Access to a 3rd floor storage area further enhances the warehouse functionality. The office space comprises 2,600 square feet, including a stock room, a large showroom, dedicated office areas, a kitchenette, and two half bathrooms. A full 1300 sq ft basement with 11-foot ceilings and an additional half bath provides ample additional storage or potential for expansion. Secure parking is available on-site. Recent upgrades include a new heating and cooling system installed in 2024. The property is zoned R3-2 with a C1 commercial overlay, allowing for retail, warehouse, light commercial uses, or future development. Its location on a high-traffic corridor ensures excellent visibility and accessibility, making it an attractive investment for businesses seeking a prominent presence in Rosedale.

    Value Estimation

    Powered by Realmo proprietary methodology Last update: July 3, 2025

    • CAP approach

    • Comparable approach

    • Alternative Use

    Location Insight

    • Map
    • Local Demand
    City
    Jamaica
    County
    Queens
    State
    New York
    Longitude
    -73.7312
    Latitude
    40.665
    CBSA code
    35620
    CBSA name
    NEW YORK-NORTHERN NEW JERSEY-LONG ISLAND, NY-NJ-PA METROPOLITAN STATISTICAL AREA

    Property Tax & Assessments

    Tax date
    Tax Amount
    Assessed Land Value
    Assessed Improvement Value
    Total Assessed Value
    Applied Tax Rate
    Land Market Value
    Improvement Market Value
    Total Market Value
    2024
    $34,603
    $123,750
    $272,700
    $396,450
    -
    $275,000
    $606,000
    $881,000

    Comparable in this City

    • Value Estimation
      $340,000
      1,900 SF

      13895 Francis Lewis Blvd

      STORE/OFFICE (MIXED USE) • 1,900 SF
      13895 Francis Lewis Blvd, Jamaica, NY 11422-1727
      View Details
    • Value Estimation
      $330,000
      2,240 SF

      23404 Merrick Blvd

      STORE/OFFICE (MIXED USE) • 2,240 SF
      23404 Merrick Blvd, Jamaica, NY 11422-1320
      View Details
    • Value Estimation
      $455,000
      3,850 SF

      23432 Merrick Blvd

      STORE/OFFICE (MIXED USE) • 3,850 SF
      23432 Merrick Blvd, Jamaica, NY 11422-1320
      View Details
    • Value Estimation by Request
      2,000 SF

      23428 Merrick Blvd

      STORE/OFFICE (MIXED USE) • 2,000 SF
      23428 Merrick Blvd, Jamaica, NY 11422-1320
      View Details
    • Value Estimation by Request
      1,916 SF

      14516 243rd St

      STORE/OFFICE (MIXED USE) • 1,916 SF
      14516 243rd St, Jamaica, NY 11422-2411
      View Details
    • Value Estimation
      $470,000
      3,794 SF

      24120 Conduit Ave

      STORE/OFFICE (MIXED USE) • 3,794 SF
      24120 Conduit Ave, Jamaica, NY 11422-2250
      View Details

    Similar Nearby for Sale

    • $900,000
      5,000 SF

      Rosedale Mixed-Use Investment Opportunity

      Spacious 5,000 SF Multifamily in Rosedale, NY
      13938 249Th St, Rosedale, NY 11422
      View Details
    • $1,350,000

      Queens Specialty Property For Sale

      Specialty property available for purchase in Queens, New York.
      245-39 147Th Dr, Jamaica, NY 11422
      View Details
    • $1,029,000

      Renovated Two-Family Home

      Spacious 6-bedroom, 2.5-bath duplex with private driveway.
      240-24 149Th Ave, Jamaica, NY 11422
      View Details
    • $289,000

      Well-Maintained Two-Bedroom Unit

      Two-bedroom unit near Long Island border, highways, and Green Acres Mall.
      13109 234Th St, Jamaica, NY 11422
      View Details
    • $1,199,999

      Rosedale Waterfront Multi-Unit Residence

      Fully renovated multi-unit residence with waterfront views and modern finishes.
      254-16 Craft Ave, Jamaica, NY 11422
      View Details
    • $819,000
      Pending

      Rosedale Duplex with Private Driveway

      Duplex in Rosedale, NY, with spacious rooms and natural light.
      130-28 233Rd St, Rosedale, NY 11422
      View Details

    Similar Nearby for Lease

    • $3,600 /Mo

      Rosedale Rental: 3 Bed, 2 Bath

      Spacious 3 bed, 2 bath rental in Rosedale.
      23518 147Th Rd, Jamaica, NY 11422
      View Details
    • $3,500 /Mo

      Spacious Apartment in Rosedale

      Spacious 3-bedroom, 2-bathroom apartment in a convenient location.
      241-01 Caney Rd, Jamaica, NY 11422
      View Details
    • New
      $8,200 /Mo
      7,841 SF

      Versatile Office and Workshop Space

      Multi-use property in Rosedale, ideal for small business operations.
      10 3Rd St, Rosedale, NY 11422
      View Details
    • $2,300 /Mo
      800 SF

      Updated One Bedroom Apartment

      Clean, updated one-bedroom apartment with finished attic in Rosedale.
      243-12 144Th Ave, Rosedale, NY 11422
      View Details
    • $6,000 /Mo
      1,999 SF

      Retail Space in High-Traffic Area

      1,300 sq ft retail space in a prime Queens location.
      138-25 Brookville Blvd, Rosedale, NY 11422
      View Details
    • Contact for pricing
      10,000 SF

      Retail Space in Rosedale, NY

      10000 SF retail space available for rent.
      24856 Rockaway Blvd, Rosedale, NY 11422
      View Details
    Request Owner's contact information
    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
    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.