Save
Ask
Tour
Hide
Share
$199,900
8 Days On Site

557 Hertel Avenue
Buffalo, NY 14207

For Sale|Mixed Use|Active
5
Beds
3
Total Baths
3
Full Baths
4,121
SqFt
$49
/SqFt
1920
Built
County:
Erie
Listing courtesy of Nicholas Giambra of Giambra Realty Corp (716) 239-6432
Call Now: 716-207-2994
Is this the listing for you? We can help make it yours.
716-207-2994
557 Hertel Avenue557 Hertel Avenue557 Hertel Avenue557 Hertel Avenue
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$199,900
Days On Site 
8 Days
Bedrooms 
5
Inside Area (SqFt) 
4,121 sqft
Total Baths 
3
Full Baths 
3
Partial Baths 
N/A
Lot Size 
0.0755 Acres
Year Built 
1920
MLS® Number 
B1713757
Status 
Active
Property Tax 
$5,865
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a week agoListing first seen on site
a week agoListing updated with changes from the MLS®
General Features
Acres 
0.0755
Cross Street 
Pavonia St
Foundation 
Block
Levels 
Two
Number Of Stories 
2
Parking 
Concrete
Property Sub Type 
Mixed Use
Special Circumstances 
Standard
SqFt Total 
4121
Style 
Duplex
Utilities 
Electricity AvailableElectricity ConnectedSewer ConnectedWater Connected
Water Source 
Public
Interior Features
Appliances 
Gas Water HeaterWater Heater
Basement 
Full
Cooling 
Central Air
Electric 
Circuit Breakers
Flooring 
OtherSee Remarks
Heating 
Natural GasRadiantForced Air
Interior 
High Speed Internet
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
OtherStoneVinyl Siding
Lot Features 
Near Public TransitRectangular Lot
Patio And Porch 
CoveredPorch
Roof 
Asphalt
Community Features
MLS Area 
Buffalo City-140200
School District 
Buffalo
Township 
Not Applicable
Financing Terms Available 
Cash
Schools
School District
Buffalo
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Nicholas Giambra of Giambra Realty Corp (716) 239-6432



The data relating to real estate on this website comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name.

All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither the listing broker(s) nor shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © Last checked: 2026-09-20 06:13 PM UTC CNYIS, UNYREIS, WNYREIS. All rights reserved.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share