CashFlowRE
Sign in Sign up
No image
🔨 Auction
B- Composite 69.49
Why this score? — see what drove the B- grade

The composite is a weighted blend of 9 inputs, each scored 0–100. Each bar is that input's sub-score; the figure is the points it added to the 100-point composite (weight × sub-score).

  • Cash flow +25.8/30.0
  • Appreciation +10.0/10.0
  • DSCR +8.6/10.0
  • ARV discount +7.5/15.0
  • 1% rule +6.8/10.0
  • Livability +4.0/5.0
  • Rent growth +2.5/5.0
  • Condition / age +2.5/5.0
  • Schools +1.7/10.0

$5,000

101 Stevens Ave · Columbus, OH 43222
6 bd · None ba · 2,392 sqft · MultiFamily · 1 Days on market
Built 1920 4,356 sqft lot

🖨 Deal sheet (PDF) 📄 Offer letter ✓ Due diligence

Multi-family units

County records classify this as Multi-Family (2-4 Unit). Listing-text estimate: 1 unit. estimate disagrees with records

Listing remarks

Estate Auction - Estate of Emma C. Williams, FCPC 519955, Phyllis J. Hunter Admin. , Held ON LOCATION on May 5 @ 6 PM. 3% or $1000 min coop - pre-registration required via faxed or emailed Agency Disclosure (signed by buyer), Seller not obligated to accept list price prior to auction. No Buyer Premium.

Key facts

  • 4,356 sq ft lot
  • Built 1920

Neighborhood map

Property Rental comp Retail Transit Schools Stadiums Fortune 500 · Circle radius: 3.0 mi
Loading POIs…
🔨 Auction listing. The $5,000 list price is a nominal opening bid, not a real ask — every metric below is computed on the estimated value $243,984 (ARV from comps), not the list price.

What this means for you Summary

Snapshot

  • This is a 6-bed/?-bath multifamily listed at $5k.

Deal economics

  • At list price, monthly cash flow is $591 ($7k/yr) — positive.
  • The deal already cash-flows at list — no discount required.
  • Meets the 1% rule at list price ($3k rent vs $5k).
  • Cap rate 9.2% vs local median 3.8% in Columbus — 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.

Location & tenants

  • Location reads 81/100 on livability (#97 in OH, #1,491 nationally) — a professional / high-income tenant draw. Strengths: commute A+, cost of living A+, housing A+; Watch: employment C-, crime F.
  • Columbus City School District (urban): math 15% / reading 26% proficiency, ranked #626 of 656 in OH (top 95%) — low school quality limits family demand, transient renter base, plan for 1-2y turnover; 72% free/reduced lunch — lower-income household profile, screen leases tightly.
  • Market conditions: 50 active listings in the ZIP; 3 comparable units currently listed for rent nearby; rentals leasing fast (median 9d on market — plan ~1-2 weeks tenant-placement turnaround); lower-income renter base — watch delinquency; 8,139 units permitted in Franklin County in 2024 (5,940 in 5+ unit buildings).
  • At $2,883/mo this rent would consume 107% of the median local household income ($32k/yr) (locally 126% of renters already pay >50% of income on rent) — very limited rent-growth headroom before tenants either downsize or default.

Forward outlook

  • In year one you build about $26k of equity ($2k loan paydown + $24k appreciation (10.0% local appreciation)).
  • Franklin County population projected at +34% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
  • At projected returns (10.0% appreciation + 3.0% rent growth), your $68k cash investment doubles in ~2 years — after that, you're playing with house money.
  • By year 2, paydown + projected appreciation supports a ~$42k cash-out refi (75% LTV) — recoverable capital for the next deal without selling this one.

Negotiation context

  • Only 1 days on market — expect competitive offers; lowballing is unlikely to land.
  • 2 sale attempts since 19y ago with the ask held roughly flat each time — persistent listings suggest the price (not the market) is what's stuck; bring a comps-based counter.

Risks & watch-outs

  • Watch-outs: property tax is 73.2% of price; built in 1920 — expect roof / HVAC / electrical / plumbing capex.
Recommended offer $5,000

Questions for the listing agent

  1. Built in 1920 — when were the roof, HVAC, electrical panel, plumbing, and water heater last replaced?
  2. Property tax is high relative to price — has the assessment been appealed recently, and will the sale trigger a re-assessment?
  3. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
  4. 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?
  5. 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.
  6. What's the recent tenant-quality profile in this submarket — average credit score on applications, eviction rate, late-payment / NSF rate, and stable-employment percentage? A property-management company in the area should have these aggregated.
  7. How much new apartment / multifamily construction is in the pipeline within 1–3 miles? Heavy new supply (>2% of stock underway) typically softens rents 12–24 months out; light construction supports rent growth.

Investment metrics

1% rule
1.18%
Cap rate
9.20%
Cash-on-cash
10.39%
DSCR
1.46
GRM
7.1

CMA / ARV

ARV (on-the-fly)
$243,984
Comps found
12
Show comp detail 12 sales within ~0.75 mi
Address Dist Beds/Ba Sqft Sold Price $/sf Match
78-80 Stevens Ave 0.05mi 6/— 2,352 (-2%) 6mo $240,000 $102 90
154-156 N Central Ave 0.20mi 6/— 2,184 (-9%) 2mo $315,000 $144 75
47-49 N Guilford Ave 0.10mi 6/— 2,240 (-6%) 12mo $163,000 $73 74
111-113 S Princeton Ave 0.46mi 6/— 2,528 (+6%) 2mo $200,000 $79 67
113-115 W Park Ave 0.51mi 6/— 2,576 (+8%) 2mo $310,000 $120 62
266-268 Brehl Ave 0.59mi 6/— 2,352 (-2%) 14mo $310,000 $132 58
59-61 N Princeton Ave 0.31mi 6/— 2,718 (+14%) 8mo $60,000 $22 56
53-55 W Park Ave 0.47mi 6/— 2,610 (+9%) 9mo $330,000 $126 56
1992 Fairmont Ave 0.68mi 6/— 2,480 (+4%) 11mo $203,000 $82 53
1336 Sullivant Ave 0.70mi 6/— 2,240 (-6%) 9mo $165,000 $74 49
58-60 W Park Ave 0.51mi 6/— 2,580 (+8%) 17mo $270,000 $105 48
411-413 Ryan Ave 0.74mi 6/— 2,646 (+11%) 12mo $187,000 $71 37

Match score weights: distance 35% · size 25% · config 20% · recency 20%. Top-matched comps best support the ARV.

Projected returns pro-forma

10.0% appreciation · 3.0% rent growth · sell at horizon

5-year hold
IRR
31.9%
Equity multiple
3.50×
Total profit
$170,581
Equity at exit
$219,800
10-year hold
IRR
27.6%
Equity multiple
7.92×
Total profit
$472,806
Equity at exit
$474,007

Cash invested: $68,316 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

Overall (STATE)
73 Landlord-Friendly
State Ohio
73 Landlord-Friendly · R+6
County
— inherits STATE
City
— inherits STATE
3-day notice; Cleveland / Columbus have some habitability code enforcement; otherwise landlord-leaning.

ZIP-level market 43222

Active inventory
50
Price-to-rent
0.1×

Monthly cashflow live

Estimated rent
$2,883 medium interval (Pro) →
Mortgage (P&I)
$1,279
Tax est. 1.5%
$305 /mo · $3,660/yr
Insurance
$102
HOA
$0
Vacancy / Maint / Mgmt
$605
Net cashflow
$591

Break-even live

Break-even rent $2,134
Max offer price $243,984
Occupancy floor 74%

Sensitivity live

Price -10% $760 -5% $676 +0% $591 +5% $507 +10% $423
Rent -10% $364 -5% $477 +0% $591 +5% $705 +10% $819
Rate -1.0pp $714 -0.5pp $653 base $591 +0.5pp $528 +1.0pp $464

UW: 25.0% down · 7.5% · 30yr · 1.5% tax · 5.0% vac · 8.0% maint · 8.0% mgmt

Financing live

Cash to close

Down payment
$60,996
Closing costs
$7,320
Reserves months
Total cash needed

Loan-product check · same deal, 3 products live

Conventional

25% down · 7.5% · 30yr

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Personal DTI + credit; lowest rate.

DSCR

20% down · 8.5% · 30yr

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

No personal income docs; deal must DSCR.

Hard money

10% down · 12.0% · 12mo

Down + closing
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Short-term bridge; refi at stabilization.

Rent comps 3 comps

AddressBedsBaths SqftRent$/sqft DOM Units Dist
63 Stevens Ave Columbus, OH 5.0 2.0 2437 $2,000 $0.82 8d 1 0.03mi
228 Schultz Ave Unit 1407033P Columbus, OH 5.0 1.5 1991 $5,806 $2.92 8d 1 0.21mi
89 S Richardson Ave Columbus, OH 6.0 2.0 2112 $1,995 $0.94 3d 1 1.44mi

Listing history 5 events

  1. 2024-12-02
    status Pending
  2. 2009-05-07
    historical
  3. 2009-03-31
    listed $5,000
  4. 2008-03-16
    historical
  5. 2007-11-16
    listed $50,000

ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot backfill from property_details.listing_events for pre-trigger history.

Climate risk First Street

  • 🌊 Flood 1/10 Low FEMA zone X · 0% chance over 30 yrs
  • 🔥 Wildfire 1/10 Low
  • 🌡 Heat 4/10 Moderate 7 d/yr ≥100°F today · 18 d/yr by 30 yrs out
  • 💨 Wind 2/10 Low 100% chance of damaging wind over 30 yrs
  • 🫁 Air quality 3/10 Moderate 2 unhealthy d/yr today · 4 by 30 yrs out

Nearby sold comps map

Loading sold comps map…

Walkable amenities ~0.75 mi

Loading nearby amenities…

Taxation est. · year 1

Rental income
$34,593
− Mortgage interest
−$13,667
− Property taxes
−$3,660
− Insurance
−$1,220
− Repairs & maintenance
−$2,767
− Management
−$2,767
− Depreciation
−$7,098
Taxable income
$3,414
combined federal + state — saved on this device
Est. tax owed @ 24.0%
−$819
After-tax cash flow
$6,276/yr

For passive investors: Depreciation is non-cash, so a rental often shows a tax loss while cash-flowing — sheltering income. Rental losses are passive: they offset passive income freely, and up to $25,000/yr can offset ordinary (W-2) income if you actively participate and your MAGI is under $100k (phasing out to $0 by $150k); unused losses carry forward. On sale, claimed depreciation is recaptured at up to 25%, and gains may owe capital-gains tax (a 1031 exchange can defer both). Figures are a year-1 estimate at your 24.0% rate — not tax advice; consult a CPA.

Schools (NCES district)

District
Columbus City School District
NCES district ID
3904380
Math proficiency
15% ▼ -17.00%
Reading proficiency
26% ▼ -12.00%
Median HH income
$38,483
Composite
17.19/100
National rank
#9105
State rank
#626 of 656 in OH

Livability — Columbus

Score
81/100
State rank
#97
US rank
#1491

Category grades

Amenities A- Commute A+ Cost of living A+ Crime F Employment C- Housing A+ Health & safety A- User ratings D

Schools grade is shown separately in the Schools card above.

Census & demographics

Census place
Columbus, OH
County
Franklin County · 1,351,780 people
City population
612,189
Metro
Columbus, OH
Population (ZIP)
4,819
Household income
$32,321
Rent vs Own
66.4% rent · 33.6% own
Severe rent burden
126.0

Population outlook (Franklin County) Hauer SSP2

Today (2025)
1,456,139 people
By 2030
1,556,890 · +6.9%
By 2040
1,757,349 · +20.7%
By 2050
1,950,539 · +34.0%
By 2075
2,376,171 · +63.2%
By 2100
2,636,796 · +81.1%

Race, ethnicity, and origin ACS 2023

Neighborhood character
Highly diverse neighborhood (Simpson 0.71)
Race & ethnicity
White 43% Hispanic / Latino 28% Two or more races 21% Black 18% Asian 2%
Hispanic origin (detail)
Mexican 1% Puerto Rican 16% Dominican 5%
Common ancestry
Lithuanian 1% Slovak 1% Ukrainian 1%
Foreign-born
8% · Canada, South Korea
Languages at home
86% English-only · Spanish 11% Korean 1% Russian/Polish/Slavic 0%

Political lean MEDSL · Franklin

2024 margin
Strong D (+28.4) · D 63.7% · R 35.3% · Other 1.0%
2008→2024 swing
+7.7pp toward D · 2008: 20.7pp · 2024: 28.4pp
All cycles
2024: D+28.4 2020: D+31.4 2016: D+25.9 2012: D+21.7 2008: D+20.7

Not yet ingested

Civics

Market trends

HPI YoY
▲ 231.44%
Current HPI
654.0855
Rent YoY
Metro
Columbus, OH
State GDP YoY
▲ 1.98%
F500 in state
48

Industry mix (Fortune 500 HQ in OH)

Industry F500 HQs Revenue

Price history

-90.0% since first listed
5 events — show timeline
  • 2024-12-02 Pending CBRMLS
  • 2009-05-07 Listing Removed CBRMLS
  • 2009-03-31 Listed $5,000 CBRMLS
  • 2008-03-16 Listing Removed CBRMLS
  • 2007-11-16 Listed $50,000 CBRMLS

Cash-flow waterfall

monthly

Sold comps — $/sqft

last 12 mo · ≤1 mi

Loading sold comps…