CashFlowRE
Sign in Sign up
412 Esplanade St
C- Composite 52.56
Why this score? — see what drove the C- 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).

  • ARV discount +15.0/15.0
  • Cash flow +9.8/30.0
  • Appreciation +9.2/10.0
  • Schools +5.1/10.0
  • Livability +3.4/5.0
  • DSCR +2.8/10.0
  • Rent growth +2.5/5.0
  • Condition / age +2.5/5.0
  • 1% rule +2.4/10.0

$130,000

412 Esplanade St · Bellwood, NE 68624
2 bd · 1.0 ba · 1,028 sqft · SingleFamily public records · 163 Days on market
Built 1910 6,534 sqft lot $126/sqft · 13% above area Est $169k · 23% under

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

Listing remarks MLS

Discover the perfect blend of comfort and convenience in this cozy 2-bedroom, 1-bathroom home located just steps from downtown. Enjoy the charm of small-town living. This well-kept home features a bright and inviting living space, functional kitchen, and 2 bedrooms with plenty of natural light. The partial basement offers extra storage or potential for a small workshop or Bonus Room. Outside, you'll find a 1-stall detached garage and a manageable yard—perfect for easy maintenance and relaxation. Whether you're an affordable home or looking to downsize, or searching for an affordable investment property, this home is an excellent choice at a great price! Don’t miss this opportunity—schedule your showing today!

Key facts

  • Manageable yard
  • Partial basement
  • Detached garage

Tags

DETACHED GARAGEPARTIAL BASEMENTMANAGEABLE YARD

Neighborhood map

Property Rental comp Retail Transit Schools Stadiums Fortune 500 · Circle radius: 3.0 mi
Loading POIs…

What this means for you Summary

Snapshot

  • This is a 2-bed/1.0-bath single-family listed at $130k.

Deal economics

  • At list price, monthly cash flow is $-84 ($-1k/yr) — negative.
  • To cash-flow at today's rent, offer at most $115k (11.4% below list).
  • To meet the 1% rule (rent ≥ 1% of price), the offer needs to be $96k (26.3% below list).
  • Recommended offer: $96k (26.3% below list) — sets the bar for 1% rule.

Location & tenants

  • Location reads 67/100 on livability (#285 in NE) — a middle-class / working-renter tenant base. Strengths: cost of living A+, housing A+; Watch: health & safety C-, amenities F, commute F.
  • David City Public Schools (town): math 61% / reading 58% proficiency, ranked #21 of 111 in NE (top 19%) — acceptable for families but not a draw, mixed tenant base, ~2y average lease.
  • Zoned schools: David City Secondary School (math 57% / reading 57%, grade C, #70 of 261 statewide, top 30%, 308 students, 46% FRL).
  • Market conditions: 16 active listings in the ZIP; 3 units permitted in Butler County in 2024 (0 in 5+ unit buildings).

Forward outlook

  • In year one you build about $12k of equity ($899 loan paydown + $11k appreciation (8.5% local appreciation)).
  • Butler County population projected at -18% by 2050 — secular population decline; favor cash flow + early exit over multi-decade hold.
  • By year 4, paydown + projected appreciation supports a ~$42k cash-out refi (75% LTV) — recoverable capital for the next deal without selling this one.

Negotiation context

  • It's been on market 163 days — a 12% lower offer ($114k) is reasonable based on typical stale-listing flexibility.
  • 3 sale attempts since 3y ago; this cycle's ask has dropped $10k (7%) from the opening price — seller is motivated, your offer sets the floor, not the list.

Risks & watch-outs

  • Watch-outs: built in 1910 — expect roof / HVAC / electrical / plumbing capex.
Recommended offer $95,832 (26.3% below list)

Questions for the listing agent

  1. What do current leases actually rent for vs. the listed asking? Can we see a recent rent roll and the last 12 months of T-12 income?
  2. It's been on market 163 days. Have you received any prior offers? Is the seller open to a 26% concession, seller financing, or rate buy-down credit?
  3. Built in 1910 — when were the roof, HVAC, electrical panel, plumbing, and water heater last replaced?
  4. Why hasn't it sold? Are there any deal-killer items the seller is aware of (foundation, flood, title, zoning, code violations)?
  5. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
  6. 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.
  7. 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.
  8. How much new for-sale + rental construction is in the pipeline within 1–3 miles? Heavy new supply typically softens prices + rents 12–24 months out; constrained supply supports both.

Investment metrics

1% rule
0.74%
Cap rate
5.52%
Cash-on-cash
-2.76%
DSCR
0.88
GRM
11.3

CMA / ARV

ARV (median comp)
$168,626
List price
$130,000
Delta
-22.91%
Verdict
UNDERPRICED
Comps
13 within 1.0 mi
Show comp detail 1 sale within ~0.75 mi
Address Dist Beds/Ba Sqft Sold Price $/sf Match
711 Church St 0.26mi 3/1.0 (+1) 1,080 (+5%) 4mo $155,000 $144 71

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

Projected returns pro-forma

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

5-year hold
IRR
19.0%
Equity multiple
2.43×
Total profit
$52,138
Equity at exit
$102,952
10-year hold
IRR
17.7%
Equity multiple
5.27×
Total profit
$155,461
Equity at exit
$208,488

Cash invested: $36,400 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

Overall (STATE)
83 Strongly Landlord-Friendly
State Nebraska
83 Strongly Landlord-Friendly · R+13
County
— inherits STATE
City
— inherits STATE
3-day pay-or-quit; preempted; moderate court pace.

ZIP-level market 68624

Home prices YoY
3.3%
Active inventory
16
Price-to-rent
11.3×

Monthly cashflow live

Estimated rent
$958 medium interval (Pro) →
Mortgage (P&I)
$682
Tax from tax record
$105 /mo · $1,258/yr
Insurance
$54
HOA
$0
Vacancy / Maint / Mgmt
$201
Net cashflow
$-84

Break-even live

Break-even rent $1,064
Max offer price $115,216
Occupancy floor

Sensitivity live

Price -10% $-10 -5% $-47 +0% $-84 +5% $-120 +10% $-157
Rent -10% $-159 -5% $-122 +0% $-84 +5% $-46 +10% $-8
Rate -1.0pp $-18 -0.5pp $-51 base $-84 +0.5pp $-117 +1.0pp $-152

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
$32,500
Closing costs
$3,900
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.

Listing history 24 events

  1. 2026-06-22
    days on market $130,000 Active 163 DOM
  2. 2026-06-21
    days on market $130,000 Active 162 DOM
  3. 2026-06-21
    days on market $130,000 Active 161 DOM
  4. 2026-06-18
    days on market $130,000 Active 159 DOM
  5. 2026-06-17
    days on market $130,000 Active 158 DOM
  6. 2026-06-16
    days on market $130,000 Active 157 DOM
  7. 2026-06-15
    days on market $130,000 Active 156 DOM
  8. 2026-06-13
    days on market $130,000 Active 154 DOM
  9. 2026-06-12
    days on market $130,000 Active 153 DOM
  10. 2026-06-09
    days on market $130,000 Active 150 DOM
  11. 2026-06-08
    days on market $130,000 Active 149 DOM
  12. 2026-06-07
    days on market $130,000 Active 148 DOM
  13. 2026-06-07
    days on market $130,000 Active 147 DOM
  14. 2026-06-04
    days on market $130,000 Active 144 DOM
  15. 2026-06-02
    days on market $130,000 Active 143 DOM
  16. 2026-06-01
    days on market $130,000 Active 142 DOM
  17. 2026-05-31
    days on market $130,000 Active 141 DOM
  18. 2026-05-10
    status Active 736-char remark
    Show marketing remark (736 chars)

    Discover the perfect blend of comfort and convenience in this cozy 2-bedroom, 1-bathroom home located just steps from downtown. Enjoy the charm of small-town living. This well-kept home features a bright and inviting living space, functional kitchen, and 2 bedrooms with plenty of natural light. The partial basement offers extra storage or potential for a small workshop or Bonus Room. Outside, you'll find a 1-stall detached garage and a manageable yard—perfect for easy maintenance and relaxation. Whether you're an affordable home or looking to downsize, or searching for an affordable investment property, this home is an excellent choice at a great price! Don’t miss this opportunity—schedule your showing today!

  19. 2026-04-15
    price $130,000 736-char remark
    Show marketing remark (736 chars)

    Discover the perfect blend of comfort and convenience in this cozy 2-bedroom, 1-bathroom home located just steps from downtown. Enjoy the charm of small-town living. This well-kept home features a bright and inviting living space, functional kitchen, and 2 bedrooms with plenty of natural light. The partial basement offers extra storage or potential for a small workshop or Bonus Room. Outside, you'll find a 1-stall detached garage and a manageable yard—perfect for easy maintenance and relaxation. Whether you're an affordable home or looking to downsize, or searching for an affordable investment property, this home is an excellent choice at a great price! Don’t miss this opportunity—schedule your showing today!

  20. 2026-01-07
    listed $140,000 Active 736-char remark
    Show marketing remark (736 chars)

    Discover the perfect blend of comfort and convenience in this cozy 2-bedroom, 1-bathroom home located just steps from downtown. Enjoy the charm of small-town living. This well-kept home features a bright and inviting living space, functional kitchen, and 2 bedrooms with plenty of natural light. The partial basement offers extra storage or potential for a small workshop or Bonus Room. Outside, you'll find a 1-stall detached garage and a manageable yard—perfect for easy maintenance and relaxation. Whether you're an affordable home or looking to downsize, or searching for an affordable investment property, this home is an excellent choice at a great price! Don’t miss this opportunity—schedule your showing today!

  21. 2023-08-11
    soldstatus $130,000
  22. 2023-08-10
    soldstatus $130,000 287-char remark
    Show marketing remark (287 chars)

    THIS HOME IS PRICED TO SELL. IT HAS 2 BEDROOMS AND 1 BATHROOM ON ONE LEVEL. IT HAS AN EAT IN KITCHEN WITH LAUNDRY OFF OF THE KITCHEN. THE PARTIAL BASEMENT IS VERY CLEAN AND COULD BE USED FOR MANY THINGS. IT HAS A DETACHED GARAGE IN THE BACK WITH ALLEY ACCESS. CALL FOR A PRIVATE VIEWING.

  23. 2023-04-26
    listed $125,000 287-char remark
    Show marketing remark (287 chars)

    THIS HOME IS PRICED TO SELL. IT HAS 2 BEDROOMS AND 1 BATHROOM ON ONE LEVEL. IT HAS AN EAT IN KITCHEN WITH LAUNDRY OFF OF THE KITCHEN. THE PARTIAL BASEMENT IS VERY CLEAN AND COULD BE USED FOR MANY THINGS. IT HAS A DETACHED GARAGE IN THE BACK WITH ALLEY ACCESS. CALL FOR A PRIVATE VIEWING.

  24. 1997-11-20
    soldstatus $22,000

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

Tax reassessment forecast NE · Resets to sale price

Current annual tax
$1,258 · $105/mo
Projected year-2 tax
$2,249 · $187/mo
Expected delta
+$991/yr (+$83/mo · 78.7%)

ⓘ Screening estimate from a state-policy table — verify with the county assessor before closing.

Climate risk First Street

  • 🌊 Flood 1/10 Low FEMA zone X (unshaded) · 0% chance over 30 yrs
  • 🔥 Wildfire 1/10 Low
  • 🌡 Heat 3/10 Moderate 7 d/yr ≥104°F today · 15 d/yr by 30 yrs out
  • 💨 Wind 2/10 Low
  • 🫁 Air quality 1/10 Low 0 unhealthy d/yr today · 0 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
$11,500
− Mortgage interest
−$7,282
− Property taxes
−$1,258
− Insurance
−$650
− Repairs & maintenance
−$920
− Management
−$920
− Depreciation
−$3,782
Taxable loss
−$3,312
combined federal + state — saved on this device
Est. tax savings @ 24.0%
+$795
After-tax cash flow
$-209/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
David City Public Schools
NCES district ID
3100002
Math proficiency
61% ▼ -5.00%
Reading proficiency
58% ▬ 0.00%
Median HH income
$48,334
Composite
50.52/100
National rank
#1850
State rank
#21 of 111 in NE

Livability — Bellwood

Score
67/100
State rank
#285
US rank
#10522

Category grades

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

Schools grade is shown separately in the Schools card above.

Census & demographics

Census place
Bellwood, NE
Population (ZIP)
971

Population outlook (Butler County) Hauer SSP2

Today (2025)
7,618 people
By 2030
7,353 · -3.5%
By 2040
6,802 · -10.7%
By 2050
6,253 · -17.9%
By 2075
5,416 · -28.9%
By 2100
4,653 · -38.9%

Race, ethnicity, and origin ACS 2023

Neighborhood character
Predominantly White (94%)
Race & ethnicity
White 94% Two or more races 6%
Common ancestry
Romanian 4% Lithuanian 2% Serbian 1%
Foreign-born
0%

Political lean MEDSL · Butler

2024 margin
Solid R (+59.6) · D 19.8% · R 79.4%
2008→2024 swing
-24.0pp toward R · 2008: -35.6pp · 2024: -59.6pp
All cycles
2024: R+59.6 2020: R+59.1 2016: R+60.8 2012: R+44.5 2008: R+35.6

Not yet ingested

Civics

Market trends

HPI YoY
▲ 8.47%
Current HPI
265.0111
Rent YoY
Metro
State GDP YoY
▲ 0.68%
F500 in state
2

Industry mix (Fortune 500 HQ in NE)

Industry F500 HQs Revenue

Price history

+490.9% since first listed
7 events — show timeline
  • 2026-05-10 Relisted CBOR
  • 2026-04-15 Price Changed $130,000 CBOR
  • 2026-01-07 Listed $140,000 CBOR
  • 2023-08-11 Sold (Public Records) $130,000 Public Records
  • 2023-08-10 Sold (MLS) $130,000 CBOR
  • 2023-04-26 Listed $125,000 CBOR
  • 1997-11-20 Sold (Public Records) $22,000 Public Records

Property tax history

+4.5%/yr

Latest (2025): $1,258 · -12.0% YoY. Source: county tax records.

Cash-flow waterfall

monthly

Sold comps — $/sqft

last 12 mo · ≤1 mi

Loading sold comps…