- 0
- 16
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$199,900
Monthly Est:$995
5 Beds
3 Baths3 full baths
4,121sqft
557 Hertel Ave, Buffalo, NY 14207
$199,900
$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...
- Houzeo last checked: 4 hours ago
- Listing updated: September 11, 2026 at 10:09 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
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
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
Active
Days on Market
9
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
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
Cooling
Central Air
Flooring
Other, See Remarks
Sewer
Connected
Appliances
Gas Water Heater
Heating
Gas, Forced Air, Radiators
Construction
Year Built
Year Built: 1920
Home type
Mixed Use
Foundation Details
Block
Roof
Asphalt
Property Condition
Resale
Construction Materials
Other, Stone, Vinyl Siding, Copper Plumbing, Pex Plumbing
Architectural Style
Duplex
Utilities & Energy
Parking Features
Concrete, Two Or More Spaces
Basement
Full
Water Source
Connected, Public
Electric
Circuit Breakers
Utilities
Electricity Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Other Features
Patio And Porch Features
Covered, Porch
Lot Features
Near Public Transit, Rectangular, Rectangular Lot
Price History
| Date | Event | Price |
|---|---|---|
09/11/2026 Source: | Listed for Sale | $199,900 -33.34% $49/sqft |
07/29/2026 Source: | Price Increased | $299,900 +22114.81% $73/sqft |
09/10/2025 Source: | Off Market | $1,350 +8.00% $0/sqft |
05/09/2024 Source: | Sold | $1,250 -98.95% $0/sqft |
12/29/2019 Source: | Price Increased | $119,000 +15766.67% $29/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Buffalo, NY
Nearby New Homes For Sale
Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Sep 21, 2026, 10:45AM.. 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: Mark Karten | Karten Real Estate Services
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 01:30 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
