557 Hertel Ave, Buffalo, NY 14207
What's special
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.
- 67 days
- 70
- 1
Travel times
Kitchen
Bedroom
Bathroom
Zillow last checked:
Listing updated:
Giambra Realty Corp 716-239-6432,
Nicholas Giambra 716-239-6432
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
Heating
- Gas, Forced Air, Radiator(s)
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Flooring: Other, See Remarks
- Basement: Full
- Has fireplace: No
Interior area
- Total structure area: 4,121
- Total interior livable area: 4,121 sqft
Video & virtual tour
Property
Parking
- Parking features: Concrete, Two or More Spaces
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Porch
Lot
- Size: 3,288 Square Feet
- Dimensions: 32 x 101
- Features: Near Public Transit, Rectangular, Rectangular Lot
Details
- Parcel number: 1402000777600001002000
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Duplex
- Property subtype: Mixed Use, Duplex, Multi Family
Materials
- Other, Stone, Vinyl Siding, Copper Plumbing, PEX Plumbing
- Foundation: Block
- Roof: Asphalt
Condition
- Resale
- Year built: 1920
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Electricity Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Community & HOA
Location
- Region: Buffalo
Financial & listing details
- Price per square foot: $49/sqft
- Tax assessed value: $330,500
- Annual tax amount: $5,865
- Date on market: 9/11/2026
- Cumulative days on market: 68 days
- Listing terms: Cash
Price history
| Date | Event | Price |
|---|---|---|
| 10/15/2026 | Contingent | $199,900$49/sqft |
Source: | ||
| 9/11/2026 | Listed for sale | $199,900+566.3%$49/sqft |
Source: | ||
| 10/15/2019 | Sold | $30,000+66.7%$7/sqft |
Source: Public Record Report a problem | ||
| 7/5/2012 | Sold | $18,000+200%$4/sqft |
Source: Public Record Report a problem | ||
| 11/6/2009 | Sold | $6,000$1/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $330,500 +288.8% |
| 2024 | -- | $85,000 |
| 2023 | -- | $85,000 |
| 2022 | -- | $85,000 |
| 2021 | -- | $85,000 |
| 2020 | -- | $85,000 +112.5% |
| 2019 | -- | $40,000 |
| 2018 | -- | $40,000 |
| 2017 | $1,384 +481.8% | $40,000 |
| 2016 | $238 | $40,000 |
| 2015 | -- | $40,000 |
| 2014 | -- | $40,000 |
Monthly payment
Estimated market value
Not available
Estimated sales range
Not available
Not available
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.