Active Under Contract
House for sale at 557 Hertel Ave, Buffalo, NY 14207 | MLS# B1713757 | Listing updated on 2026-10-15
Photo 1 of House for sale at 557 Hertel Ave, Buffalo, NY 14207 | MLS# B1713757 | Listing updated on 2026-10-15
Photo 2 of House for sale at 557 Hertel Ave, Buffalo, NY 14207 | MLS# B1713757 | Listing updated on 2026-10-15
Photo 3 of House for sale at 557 Hertel Ave, Buffalo, NY 14207 | MLS# B1713757 | Listing updated on 2026-10-15
Photo 4 of House for sale at 557 Hertel Ave, Buffalo, NY 14207 | MLS# B1713757 | Listing updated on 2026-10-15
44+
Beds Icon

Virtual Tour

Beds Icon

Street View

$199,900

Monthly Est:$995

  • Beds Icon5 Beds
  • Beds Icon
    3 Baths
  • Beds Icon4,121sqft

557 Hertel Ave, Buffalo, NY 14207

$995/moEst:

Get Pre-Approved

  • Mixed Use

  • Built in 1920

  • $-- HOA

  • 0.08 acre lot

  • $49/sq.ft

Description

Rare mixed-use investment opportunity in Buffalo's Black Rock/Riverside neighborhood! This 4,121 sq ft building offers a first-floor commercial space (office or retail, roughly half the building) paired with a fully renovated, turnkey 5-bedroom, 1-bath apartment above, ideal for an owner-operator who wants to run a business downstairs and live upstairs, or for an investor seeking dual income streams.

The commercial space has served as a hair salon, bar, religious gathering space, and general office/retail over the years, proving its flexibility for nearly any use. Upstairs, the spacious 5-bedroom apartment has been cosmetically renovated top to bottom and is move-in re
ady, with a private back porch for the tenant, a rare perk in this market.

Mechanically, the building is well maintained: separate electric and gas meters (one shared water meter), circuit breakers throughout, a 2017 complete roof tear-off, forced air with central A/C (4 years old) on the lower level, and a boiler serving the upper unit. Hot water tanks are 4 years and 1.5 years old, and the plumbing has seen recent supply-line upgrades, with a mix of copper, steel, and PEX. A steel main carrier beam supports the structure, and the exterior features stone and vinyl siding, plus a curb cut and driveway on the left side for easy off-street parking.

Location is a major draw: you're minutes from the Niagara River and the Empire State Trail, with downtown Buffalo, Grand Island, and the Town of Tonawanda all about 5 minutes away. The City of Tonawanda, North Tonawanda, Amherst, and Hamburg are also close by, putting nearly all of Erie County within easy reach.

Don't miss this chance to own a versatile, income-producing mixed-use property in one of Buffalo's most connected neighborhoods.

  • Houzeo last checked: 4 hours ago
  • Listing updated: October 15, 2026 at 3:21 pm
  • Listing Provided by: Nicholas Giambra (716) 239-6432 DRE #10311210668 | Giambra Realty Corp (716) 239-6432
  • Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1713757 New York State Alliance of MLSs, Buffalo-NY

Property Details

  • Status

    Active Under Contract

  • Type

    Single Family Residence

  • No. of Stories

    2

  • County

    Erie County

  • City

    Buffalo

  • Neighborhood

    West Hertel

  • Year Built

    1920

  • HOA Fees

    -

  • Finished Area

    4,121 sqft

  • Lot Size

    0.08 acre lot

  • Basement Area

    - sqft

  • MLS Name

    New York State Alliance of MLSs, Buffalo

  • MLS Number

    B1713757

  • MLS Status

    ActiveUnderContract

  • Days on Market

    54

  • Cumulative Days on Market

    34

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 5

    Bathrooms: 3

Interior

  • Flooring

    Other, See Remarks

  • Heating

    Gas, Forced Air, Radiators

  • Cooling

    Central Air

  • Appliances

    Gas Water Heater

  • Sewer

    Connected

Construction

  • Year Built

    Year Built: 1920

  • Home type

    Mixed Use

  • Construction Materials

    Other, Stone, Vinyl Siding, Copper Plumbing, Pex Plumbing

  • Architectural Style

    Duplex

  • Foundation Details

    Block

  • Property Condition

    Resale

  • Roof

    Asphalt

Utilities & Energy

  • Electric

    Circuit Breakers

  • Basement

    Full

  • Parking Features

    Concrete, Two Or More Spaces

  • Water Source

    Connected, Public

  • Utilities

    Electricity Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected

Other Features

  • Lot Features

    Near Public Transit, Rectangular, Rectangular Lot

  • Patio And Porch Features

    Covered, Porch

Price History

DateEventPrice

10/15/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1713749

Contingent (Active Under Contract)

$199,900

$138/sqft

10/15/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1713749

Off Market

$199,900

$138/sqft

09/11/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1713749

Listed for Sale

$199,900 -33.34%

$138/sqft

08/21/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1702827

Listing Removed

$299,900

$206/sqft

08/21/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #B1702827

Off Market

$299,900 +22114.81%

$206/sqft

Show more

Nearby Homes

Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Nov 05, 2026, 12:45PM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group

Skip to Main Content