247 Columbus Ave

Buffalo, NY 14220

$194,900B

5 bd · 2.0 ba · 2,085 sqft · Built 1910 · MultiFamily · Active · 47 DOM

Cashflow @ list (25.0% down · 7.5%)

• Estimated rent: $2,724/mo
• Mortgage (P&I): −$1,022
• Tax + insurance: −$140
• HOA: −$0
• Vac / Maint / Mgmt: −$572
• Net cashflow: $990/mo
• Annual: $11,884/yr
• Cap rate: 12.39%
• Cash-on-cash: 21.78%
• DSCR: 1.97
• 1% rule: 1.40%
• Cash to close: $54,572

Investor read

• This is a 2 × 2-bed/1.0-bath units multifamily listed at $195k. Condition is rated fair.
• At list price, monthly cash flow is $990 ($12k/yr) — positive. Per door: $495/mo.
• The deal already cash-flows at list — no discount required.
• Meets the 1% rule at list price ($3k rent vs $195k).
• It's been on market 47 days — a 3% lower offer ($189k) is reasonable based on typical stale-listing flexibility.
• Recommended offer: $189k (3.0% below list) — sets the bar for market timing.
• Local home prices are declining (-3.0%/yr); year-one equity from $1k of loan paydown is wiped out by about $6k of value loss. Plan a longer hold.
• Location reads 77/100 on livability (#195 in NY, #3,011 nationally) — a middle-class / working-renter tenant base. Strengths: commute A+, housing A+, health & safety A+; Watch: crime F, employment D-.
• Buffalo City School District (urban): math 41% / reading 40% proficiency, ranked #535 of 590 in NY (top 91%) — families likely to look elsewhere, expect single-tenant / working-renter base with shorter leases; 75% free/reduced lunch — lower-income household profile, screen leases tightly.
• Zoned schools: International School (math 8% / reading 17%, grade F, #2,048 of 2,108 statewide, top 97%, 981 students, 92% FRL); Hutchinson Central Technical High School (math 96% / reading 32%, grade B-, #807 of 1,100 statewide, top 73%, 1,175 students, 78% FRL).
• Watch-outs: built in 1910 — expect roof / HVAC / electrical / plumbing capex.
• Market conditions: Rents rising fast (+7.6%/yr); 241 active listings in the ZIP; 1,244 units permitted in Erie County in 2024 (563 in 5+ unit buildings).
• 3 sale attempts since 12y ago; this cycle's ask is 30% above the opening price — seller raised mid-cycle; expect resistance to lowballs.
• Current owner paid $54k; list at $195k implies a 261% gain — meaningful room to come down on a strong offer.
• At projected returns (-3.0% appreciation + 7.6% rent growth), your $55k cash investment doubles in ~5 years — after that, you're playing with house money.
• Cap rate 12.4% vs local median 6.9% in Buffalo — top-decile yield for the area; either an underpriced asset or a hidden risk that comps aren't pricing in. Stress-test before assuming the spread holds.

Questions for listing agent

• It's been on market 47 days. Have you received any prior offers? Is the seller open to a 3% concession, seller financing, or rate buy-down credit?
• Can we see the unit-by-unit rent roll, current vacancy, and any below-market leases? What's the average tenancy length?
• What capital expenditures (roof, boiler, parking lot, exteriors) have been made in the last 5 years, and what's planned in the next 2?
• Have any recent inspections been done? Can we get a copy of the seller's disclosures and any deferred-maintenance estimates?
• Built in 1910 — when were the roof, HVAC, electrical panel, plumbing, and water heater last replaced?
• Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
• Crime grade is F in this area — have there been break-ins, vandalism, or insurance claims at this property in the last 3 years? What carrier currently insures it and at what premium?
• What's the average days-on-market for RENTAL listings here right now (not sales)? A rising rental-DOM trend means longer vacancies and softer asking-rent achievability than the comps imply.

Repairs flagged (vision-AI assessment)

• Major: roof — Significant damage and potential leakage
• Major: exterior siding — Severe wear and peeling paint
• Major: flooring — Old and worn, needs replacement
• Major: interior walls/paint — Peeling paint and signs of wear
• Major: HVAC unit — Old and possibly inefficient