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.
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.
Property Details
Price:
$199,900
MLS #:
B1713757
Status:
ActiveUnderContract
Beds:
5
Baths:
3
Type:
Single Family
Subtype:
MixedUse
Subdivision:
Black Rock
Neighborhood:
buffalocity140200
Listed Date:
Sep 11, 2026
Finished Sq Ft:
4,121
Total Sq Ft:
4,121
Lot Size:
3,288 sqft / 0.08 acres (approx)
Year Built:
1920
See this Listing
Schools
School District:
Buffalo
Interior
Appliances
Gas Water Heater
Bathrooms
3 Full Bathrooms
Cooling
Central Air
Flooring
Other, See Remarks
Heating
Gas, Forced Air, Radiators
Levels
Two
Exterior
Architectural Style
Duplex
Construction Materials
Other, Stone, Vinyl Siding, Copper Plumbing, Pex Plumbing
Lot Features
Near Public Transit, Rectangular, Rectangular Lot
Parking Features
Concrete, Two Or More Spaces
Patio And Porch Features
Covered, Porch
Roof
Asphalt
Stories
2
Financial
Taxes
$5,865
Map
Community
- Address557 Hertel Avenue Buffalo NY
- CityBuffalo
- CountyErie
- Zip Code14207
Subdivisions in Buffalo
- 800 West Ferry Condo
- 900 Delaware Condo
- Admirals Walk Condo
- Allentown
- Appollos Stevens
- Bailey Estate
- Bailey Estate 01
- Bailey Estate Anx 01
- Bailey-Lovejoy
- Bird Farm
- Black Rock
- Black Rock Village
- Blackrock
- Breakwaters Ph Ll
- Breakwaters Ph Two
- Buffalo
- Buffalo Crk
- Buffalo Crk Indian Reserv
- Buffalo Crk Reseravtion
- Buffalo Crk Reservation
- Buffalo Crk Reservations
- Central Park
- Churchyards
- Churchyards Sub
- City Centre Condo
- City/Buffalo
- Cold Springs
- Colonial Circle
- Columbus Park
- Colvin Gardens
- Colvin Park
- Colvin Park Map #1
- Connecticut Square
- Covin Pk Map #3
- Crocker Park
- Daniel Strickler
- Delaware District
- Delaware Tower Condo
- Downtown
- East Side
- Elmwood Strip
- Executive Condo
- Ferry
- Ferry Lt
- Fillmore Leroy
- First Ward
- Forest
- Front Park
- Fruit Belt
- Further Distinguished
- Goembel Ave Land Companys
- Gore
- Gull Landing-Waterfront
- Gull Lndg Condo
- Hamlin Park
- Highland Park
- Historic Warehouse Condo
- Holland Land Co
- Holland Land Compan’s Sur
- Holland Land Company
- Holland Land Company Surv
- Holland Land Company’s Su
- Holland Land Companys
- Holland Land Companys Lan
- Holland Land Companys Sta
- Holland Land Companys Sur
- Holland Land Companys Suv
- Holland Land’s Company Su
- Hospital Hill
- Humboldt Park
- Jones
- Jones Mile Square
- Jones Sub #3
- Jones Tr
- Jones Tr Sec 77 65
- Kaisertown
- Kensington
- Kensington Bailey Add
- Kensington Bailey Add # T
- Kensington Bailey Add #1
- Kensington Heights
- Kensington Park
- Kensington-Bailey Add 03
- Lake Front Commons
- Lakefront Commons
- Lang-Field Sub
- Late South Vlg/Black Rock
- Lovejoy
- Lower West Side
- Mannis Plan
- Maple Park Sub
- Masten Park
- Mcarthur Farm
- Meadow View Park
- Melton Manor Condo
- Millicent Ave
- MLK Park
- New York State Reservatio
- North Buffalo
- North Park
- Oakhurst Land Co
- Ogden Core
- Ogden Gore
- Parish
- Parish Tr
- Park Garden 03
- Park Gardens Sub 1
- Park Meadow
- Park Meadows
- Park Rdg Ave
- Parkside
- Perkins Place
- Polonia
- Prospect Place Ph 01-B
- Riverside
- Schiller Park
- South Buffalo
- South Vlg/Black Rock
- St Marys Square Condo
- Stephen Whitney
- Stevens Surv
- Subdivision #13
- The Jones
- Tivoli Garden Condo
- Tobias Witmer
- Town/Cheektowaga
- University District
- University Heights
- Vernon Triangle
- Village/Black Rock
- Village/Lower Black Rock
- Waterfront Village Pt II
- West End Condo
- West End Condo Bldg #272
- West Side
- Willert Park
- Willert Park Village Ph 1
- Willert Park Vlg-Ph 1
Market Summary
Current real estate data for Single Family in Buffalo as of Oct 29, 2026
796
Single Family Listed
82
Avg DOM
131
Avg $ / SqFt
$228,706
Avg List Price
Property Summary
- 557 Hertel Avenue Buffalo NY is a Single Family for sale in Buffalo, NY, 14207. It is listed for $199,900 and features 5 beds, 3 baths, and has approximately 4,121 square feet of living space, and was originally constructed in 1920. The current price per square foot is $49. The average price per square foot for Single Family listings in Buffalo is $131. The average listing price for Single Family in Buffalo is $228,706. To schedule a showing of MLS#b1713757 at 557 Hertel Avenue in Buffalo, NY, contact your Concrete Jungle Realty agent at 3472420937.
Similar Listings Nearby
Courtesy of Giambra Realty Corp. Disclaimer: All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the New York State Alliance of MLSs. Detailed information about real estate listings held by brokerage firms other than Concrete Jungle Realty include the name of the listing broker. Neither the listing company nor Concrete Jungle Realty shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. Copyright 2026. New York State Alliance of MLSs. All rights reserved. 557 Hertel Avenue
Buffalo, NY



