Skip main navigation
Active under contract
$199,900
5beds
4,121sqft

557 Hertel Ave, Buffalo, NY 14207

5beds
4,121sqft
Mixed Use, Duplex, Multi Family
Built in 1920
$49/sqft

What's special

First-floor commercial spacePrivate back porch

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
Source: NYSAMLSs,MLS#: B1713757MLS LogoOriginating MLS: Buffalo
Travel times

Kitchen

Bedroom

Bathroom

Zillow last checked:

Listing updated:

Listed by:

Giambra Realty Corp 716-239-6432,

Nicholas Giambra 716-239-6432

Source: NYSAMLSs,MLS#: B1713757MLS LogoOriginating MLS: Buffalo

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

DateEventPrice
10/15/2026Contingent$199,900$49/sqft
Source: NYSAMLSs #B1713757 Report a problem
9/11/2026Listed for sale$199,900+566.3%$49/sqft
Source: NYSAMLSs #B1713757 Report a problem
10/15/2019Sold$30,000+66.7%$7/sqft
Source: Public Record Report a problem
7/5/2012Sold$18,000+200%$4/sqft
Source: Public Record Report a problem
11/6/2009Sold$6,000$1/sqft
Source: Public Record Report a problem

Public tax history

YearProperty taxesTax 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
Find assessor info on the county website

Monthly payment

Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
See how much you could borrow to make a competitive offer.
Loading

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®️.

Neighborhood: Military

Nearby schools

West Hertel Elementary School
Grades PK-8 • 0.2 miles
4/10
GreatSchools® Rating
Test Score Rating
2/10
Student Progress Rating
5/10
Buffalo Academy For The Visual And Perform Arts
Grades 5-12 • 2.6 miles
4/10
GreatSchools® Rating
Test Score Rating
4/10
College Readiness Rating
4/10
Student Progress Rating
3/10
Grabiarz Campus School 79
Grades PK-8 • 0.3 miles
4/10
GreatSchools® Rating
Test Score Rating
2/10
Student Progress Rating
5/10