- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$199,900
Monthly Est:$995
5 Beds
- 3 Baths
3 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 ready, 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

Property Details
Status
Active Under Contract
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
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!
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
| Date | Event | Price |
|---|---|---|
10/15/2026 Source: | Contingent (Active Under Contract) | $199,900 $138/sqft |
10/15/2026 Source: | Off Market | $199,900 $138/sqft |
09/11/2026 Source: | Listed for Sale | $199,900 -33.34% $138/sqft |
08/21/2026 Source: | Listing Removed | $299,900 $206/sqft |
08/21/2026 Source: | Off Market | $299,900 +22114.81% $206/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 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















