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

    174 Avenue S Brooklyn, NY 11223

    For Sale
    $1,600,000

    MULTI_FAMILY - Brooklyn, NY

    Property size:
    3,907 SF
    Lot size:
    0.05 Acres
    Days on Market:
    27
    Last Refresh:
    Dec 6 at 7:06 am

    Property Features for 174 Avenue S

    General Information

    Property type
    Residential Multi Family
    Property subtype
    Other
    Standard status
    Active
    Zoning
    C2-3
    Rooms
    Bathroom 7, Bathroom 3, Bathroom 5, Basement, Bathroom 1, Bathroom 4, Bedroom 2, Bedroom 1, Bedroom 3, Bathroom 2, Bathroom 6
    Bedrooms
    3
    Bathrooms
    5
    APN
    07082-0003
    Parking features
    Off Street
    Size
    3,907 SF
    Lot size
    0.05 Acres

    Utilities

    Heating system
    Hot Water(Heating), Natural Gas

    Building Details

    Year built
    1931
    Floors in Building
    2
    Number of units
    2
    Building materials
    Stucco

    Homes R Us Realty Of NY (718) 668-2550 [email protected]

    Listing agent Huan Kuei Lo (347) 335-7946

    Listing date Nov 10, 2025

    MLS# 2506542 Listing URL

    Copyright © 2025 Staten Island Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

    Overview

    Brooklyn Mixed-Use Investment Opportunity

    This mixed-use building in Brooklyn presents an investment opportunity. The property is a legally configured mixed-use building. The first floor features a 20' x 75' commercial space suitable for an office, retail store, or other business ventures. The second floor contains two updated residential units, including one 2-bedroom apartment and one 1-bedroom apartment. The basement, measuring 20' x 60', provides storage or workspace. The property was gut-renovated approximately 8 years ago and features modern finishes. The building is situated in a location near transit and amenities. The lot size is 0.05 acres, and the property size is 3907 square feet. The zoning is C2-3.
    Property Profile Insight Report Location Intelligence

    Current Use by Public Records

    Retail space

    Suggested Use

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

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

    Location Insight

    • Map
    • Local Demand
    City
    Brooklyn
    County
    Kings
    State
    New York
    Longitude
    -73.979139
    Latitude
    40.60086

    Nearby Similar for Sale

    • New
      $2,950,000
      12,000 SF

      Brooklyn Multifamily Portfolio: 16 Units

      Two contiguous buildings with 16 units in Columbia Waterfront District.
      96 Baltic St, Brooklyn, NY 11201
      View Details
    • $2,099,000
      Pending

      Victorian Home in Ditmas Park

      Charming Victorian home, legal 3-family, close to transportation and shopping.
      793 Westminster Rd, Brooklyn, NY 11230
      View Details
    • $4,999,000
      3,060 SF

      Renovated Brownstone in Park Slope

      Impeccably renovated three-family brownstone in prime Park Slope location.
      645 Carroll St, Brooklyn, NY 11215
      View Details
    • New
      $7,250,000
      11,250 SF

      Renovated Commercial Building in Brooklyn

      Versatile commercial space in Bedford-Stuyvesant, ideal for owner-users.
      405 Gates Ave, Brooklyn, NY 11216
      View Details
    • $1,899,000
      2,032 SF

      Brooklyn Multi-Unit Home with Garages

      Large corner property with income potential in Bath Beach.
      8686 Bay 16Th St, Brooklyn, NY 11214
      View Details
    • $1,650,000
      2,048 SF

      Renovated Two-Family Home, Brooklyn

      Newly renovated 2-family in Dyker Heights with rental potential.
      200 Bay 7Th St, Brooklyn, NY 11228
      View Details

    FAQs

    What type of property is this?
    Mixed-use property - Versatile mixed-use building in Brooklyn with commercial and residential units.
    Where is this mixed-use property located?
    The property is located at 174 Avenue S Brooklyn, NY.
    What is the asking price?
    The asking price for this property is $1,600,000.
    What are key features of this property?
    This property features: - Legally configured mixed-use building with commercial and residential units.; - Strong income potential for owner-operators or investors.; - Prime Brooklyn location near transit and amenities.
    (347) 335-7946
    Request Owner's contact information
    174 Avenue S Brooklyn, NY 11223
    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.
    174 Avenue S
    Brooklyn, NY 11223
    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
    174 Avenue S Brooklyn, NY 11223
    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.