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:
Active
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
- 200 Delaware Condo
- 200 Delaware Residential
- 2nd Amd Sub Map Fairmont
- 5 Points
- 770 West Ferry Condo
- 800 West Ferry Condo
- 900 Delaware Condo
- Admirals Walk Condo
- Allentown
- Apollos Stevens Surv
- Appollos Stevens Surv
- Appolos Stevens Surv
- Bailey Estate 01
- Bailey Estates
- Bailey-Lovejoy
- Bailey/Delavan
- Barker Square Condo
- Bird Farm
- Black Rock
- Bryant Parish Condo
- Buffalo
- Buffalo Crk Erservation
- Buffalo Crk Indian Reserv
- Buffalo Crk Resermation
- Buffalo Crk Reservation
- Central Park
- Churchyards Sub
- City Centre Condo
- City/Buffalo
- Cold Springs
- Colvin Estates
- Colvin Park 01
- Colvin Park Map #4
- Congress Street
- Delaware District
- Delaware Hill
- Delaware Tower Condo
- Delaware Tower Condos
- Downtown
- Drexel Add
- East Side
- Elmwood Strip
- Elmwood Village
- Estate/James H Metcalfe
- Executive Condo
- Executive Condo #704
- Executive Condo Un 704
- Ferry
- Ferry Lt
- Fillmore Leroy
- First Ward
- Fruit Belt
- George E Mann
- Gore
- Hamlin Park
- Highland Park
- Historic Warehouse Condo
- Historic Warehouse LLC
- Holland
- Holland Land
- Holland Land Co
- Holland Land Comapny’s Su
- Holland Land Companies Su
- Holland Land Company
- Holland Land Company Surv
- Holland Land Company’s
- Holland Land Company’s Su
- Holland Land Companys
- Holland Land Companys Sub
- Holland Land Companys Sur
- Holland Land Cos Curv
- HOLLAND LAND COS SURV
- Holland Lands Company’s S
- Homes Tr
- Hospital Hill
- Humboldt Park
- James Sperry’s Surv
- Jones
- Jones Tr
- Jones Tract
- Kaisertown
- Kensington
- Kensington Heights
- Kensington Park
- Land Field Sub Map 3
- Lands/Late North Vlg/Blac
- Lang Field 02
- Late South Vlg/Black Rock
- Late Vlg/Black Rock
- Lower West Side
- M Davey’s Surv
- Masten
- Masten Park
- Mile Reserve
- Mile Strip
- N3384/0001
- New York State Reservatio
- Niagara Hall Assoc
- Niagara River
- North Buffalo
- Ogden Gore Tr
- Parish
- Parish Tr
- Parish Tract
- Park Gardens Map 1
- Park Gardens Sub #2
- Park Gardens Sub 5
- Park Land Association Tr
- Park Land Associations
- Park Lane Condo
- Parkside
- Pasquale Condo
- Polonia
- River View Land Co
- Rivermist
- Rivermist Dev Ph 01
- Rivermist Dev Ph 1
- Riverside
- Schiller Park
- Section 89 70
- South Buffalo
- South Park Sub
- South Vlg/Black Rock
- St Marys Square Condo
- Steven’s Surv
- Stevens Surv
- Symphony Circle Condo
- Tarrytown Park
- University District
- University Heights
- University Park Sub
- Vernon Triangle
- Village/Black Rock
- Waterfront Village Pt I
- Waterfront Village Pt II
- West End Condo Bldg
- West Side
- Willert Park
- Woodside Land Co
Market Summary
Current real estate data for Single Family in Buffalo as of Sep 13, 2026
790
Single Family Listed
77
Avg DOM
132
Avg $ / SqFt
$229,592
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 $132. The average listing price for Single Family in Buffalo is $229,592. 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



