CashFlowRE
Sign in Sign up
1015-1017 Walnut St Duplex
C+ Composite 61.91
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).

  • Cash flow +30.0/30.0
  • 1% rule +10.0/10.0
  • DSCR +10.0/10.0
  • Livability +3.8/5.0
  • Schools +3.4/10.0
  • Rent growth +2.5/5.0
  • Condition / age +2.2/5.0
  • ARV discount +0.0/15.0
  • Appreciation +0.0/10.0

$174,500

1015-1017 Walnut St · Sunbury, PA 17801
6 bd · 2.0 ba · 2,016 sqft · MultiFamily · 37 Days on market
Built 1971 Fair condition 3,484 sqft lot $87/sqft · 41% above area Est $124k · 41% over

🖨 Deal sheet 📄 Offer letter ✓ Due diligence

Multi-family units

County records classify this as Multi-Family (2-4 Unit). Listing-text estimate: 2 units. confirmed

Listing remarks MLS

Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

Key facts

  • 3,484 sq ft lot
  • 2 parking spots
  • Built 1971

Property features AI

Finance

  • Financial info: Annual tax amount available (not included per instructions)

Exterior

  • Parking: 2 parking spaces
  • Utilities: Public water; Public sewer
  • Home design: Residential income property; Multi-unit
  • Construction: Vinyl siding, frame, and stone exterior; No foundation details provided
  • Exterior features: Metal roof; Sidewalks

Interior

  • Kitchen: Range
  • Bathrooms: 1 full bathroom; 1 three-quarter bathroom
  • Heating & cooling: Heating present
  • Interior features: Range; Water heater; Unfinished block basement

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 × 3-bed/1.0-bath units multifamily listed at $174k. Condition is rated fair.

Deal economics

  • At list price, monthly cash flow is $913 ($11k/yr) — positive. Per door: $457/mo.
  • The deal already cash-flows at list — no discount required.
  • Meets the 1% rule at list price ($3k rent vs $174k).
  • Recommended offer: $169k (3.0% below list) — sets the bar for market timing.
  • Cap rate 13.0% vs local median 7.1% in Sunbury — 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 76/100 on livability (#374 in PA, #3,298 nationally) — a middle-class / working-renter tenant base. Strengths: crime A+, cost of living A+, housing A+; Watch: schools C-, amenities F, commute F.
  • Shikellamy SD (town): math 33% / reading 47% proficiency, ranked #362 of 539 in PA (top 67%) — families likely to look elsewhere, expect single-tenant / working-renter base with shorter leases.
  • Market conditions: 43 active listings in the ZIP; 81 units permitted in Northumberland County in 2024 (0 in 5+ unit buildings).

Forward outlook

  • Local home prices are declining (-3.0%/yr); year-one equity from $1k of loan paydown is wiped out by about $5k of value loss. Plan a longer hold.
  • Northumberland County population projected at -11% by 2050 — secular population decline; favor cash flow + early exit over multi-decade hold.
  • At projected returns (-3.0% appreciation + 3.0% rent growth), your $49k cash investment doubles in ~6 years — after that, you're playing with house money.

Negotiation context

  • It's been on market 37 days — a 3% lower offer ($169k) is reasonable based on typical stale-listing flexibility.
  • 2 sale attempts since 3y 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.
  • Current owner paid $130k; 35% above their basis — modest negotiation headroom, anchor on the comps not their cost.

Risks & watch-outs

  • Watch-outs: flood insurance adds $56/mo.
  • Climate carrying-cost: severe flood risk; extreme-heat days projected 7→16/yr by 2055 (HVAC capex compounding) — expect insurance premiums to compound above CPI over the hold.
Recommended offer $169,265 (3.0% below list)

Questions for the listing agent

  1. It's been on market 37 days. Have you received any prior offers? Is the seller open to a 3% concession, seller financing, or rate buy-down credit?
  2. Can we see the unit-by-unit rent roll, current vacancy, and any below-market leases? What's the average tenancy length?
  3. What capital expenditures (roof, boiler, parking lot, exteriors) have been made in the last 5 years, and what's planned in the next 2?
  4. Have any recent inspections been done? Can we get a copy of the seller's disclosures and any deferred-maintenance estimates?
  5. Built in 1971 — when were the roof, HVAC, electrical panel, plumbing, and water heater last replaced?
  6. What's the actual annual flood-insurance premium (NFIP or private), and is the property in a SFHA with mandatory coverage?
  7. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
  8. 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.
  9. 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.
  10. 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.58%
Cap rate
12.96%
Cash-on-cash
23.80%
DSCR
2.06
GRM
5.3

CMA / ARV

ARV (median comp)
$123,698
List price
$174,500
Delta
41.07%
Verdict
OVERPRICED
Comps
20 within 1.0 mi
Show comp detail 6 sales within ~0.75 mi
Address Dist Beds/Ba Sqft Sold Price $/sf Match
521-523 Walnut St 0.20mi 6/2.0 2,016 (0%) 16mo $160,000 $79 77
1058-1060 Miller St 0.12mi 5/2.0 (-1) 2,112 (+5%) 17mo $58,000 $27 67
316-318 Linden St 0.42mi 6/3.0 2,100 (+4%) 6mo $165,000 $79 65
877-879 S 2nd St 0.73mi 6/— 2,184 (+8%) 10mo $68,500 $31 43
873-875 S Second St 0.73mi 6/2.0 2,184 (+8%) 21mo $120,000 $55 34
208-210 Speece Ave 0.66mi 6/2.0 2,250 (+12%) 24mo $145,000 $64 30

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

Projected returns pro-forma

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

5-year hold
IRR
15.3%
Equity multiple
1.61×
Total profit
$29,974
Equity at exit
$26,019
10-year hold
IRR
24.0%
Equity multiple
3.07×
Total profit
$101,318
Equity at exit
$15,088

Cash invested: $48,860 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

Overall (STATE)
62 Landlord-Friendly
State Pennsylvania
62 Landlord-Friendly · EVEN
County
— inherits STATE
City
— inherits STATE
10-day notice; Philadelphia has eviction-court diversion + some protections; otherwise moderate.

ZIP-level market 17801

Home prices YoY
-18.4%
Active inventory
43
Price-to-rent
10.6×

Monthly cashflow live

Estimated rent
$2,753 medium interval (Pro) →
Mortgage (P&I)
$915
Tax est. 1.5%
$218 /mo · $2,618/yr
Insurance
$73
Flood insurance flood zone
−$56 /mo · $666/yr
HOA
$0
Vacancy / Maint / Mgmt
$578
Net cashflow
$913

Break-even live

Break-even rent $1,597
Max offer price $174,500
Occupancy floor 62%

2-unit breakdown (identical units grouped — click to expand)

UnitsBedsBathsEst. rent
Total (2 units) $2,753

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
$43,625
Closing costs
$5,235
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 17 events

  1. 2026-06-13
    status $174,500 Pending 37 DOM
  2. 2026-06-12
    days on market $174,500 Active 37 DOM
  3. 2026-06-09
    days on market $174,500 Active 34 DOM
  4. 2026-06-08
    days on market $174,500 Active 33 DOM
  5. 2026-06-07
    days on market $174,500 Active 32 DOM
  6. 2026-06-05
    days on market $174,500 Active 29 DOM
  7. 2026-06-02
    days on market $174,500 Active 27 DOM
  8. 2026-06-01
    days on market $174,500 Active 26 DOM
  9. 2026-05-31
    days on market $174,500 Active 25 DOM
  10. 2026-05-30
    days on market $174,500 Active 24 DOM
  11. 2026-05-06
    listed $179,500 Active 236-char remark
  12. 2023-09-01
    historical 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

  13. 2023-08-31
    soldstatus $129,500 Closed 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

  14. 2023-08-27
    historical Active Under Contract 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

  15. 2023-08-13
    historical 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

  16. 2023-07-14
    historical Active Under Contract 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

  17. 2023-07-07
    listed $129,500 Active 496-char remark
    Show marketing remark (496 chars)

    Looking to expand your investment portfolio? Take a look at this fully rented double in Sunbury. Property has off street parking in the back, has been well maintained, and code inspection was just done. Allow 24-48 hours for all showings. Send pre-approval or proof of funds when scheduling. Photos are from when 1017 was being renovated. Call Kristine Horten 570-898-4977 or Heidi Dunigan 570-850-8651 to schedule your showing. Square footage taken from Northumberland County Assessment Office.

ⓘ 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 9/10 Extreme FEMA zone X (shaded) · 99% chance over 30 yrs
  • 🔥 Wildfire 1/10 Low
  • 🌡 Heat 5/10 Major 7 d/yr ≥97°F today · 16 d/yr by 30 yrs out
  • 💨 Wind 2/10 Low 3% chance of damaging wind over 30 yrs
  • 🫁 Air quality 2/10 Low 1 unhealthy d/yr today · 1 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
$33,036
− Mortgage interest
−$9,775
− Property taxes
−$2,618
− Insurance
−$1,539
− Repairs & maintenance
−$2,643
− Management
−$2,643
− Depreciation
−$5,076
Taxable income
$8,743
combined federal + state — saved on this device
Est. tax owed @ 24.0%
−$2,098
After-tax cash flow
$8,863/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.

Condition & rehab AI · 6 photos

Fair 45/100 Moderate rehab

This multi-family property requires significant exterior repairs and landscaping to improve its curb appeal and value. Immediate attention to the roof and siding is critical.

Repairs flagged

  • Major roof — Significant wear and tear visible on the roof
  • Major exterior siding — Weathered and peeling siding, indicating structural issues
  • Major landscaping — Overgrown and unkempt lawn and landscaping

Value-add opportunities

  • Both repair and paint the exterior — Improving the exterior appearance will attract more tenants and buyers
  • Both landscaping and yard maintenance — A well-maintained yard can increase the property's curb appeal and value

Renovation cost estimate screening

Repair itemSeverityEst. cost
roof · Significant wear and tear visible on the roof Major $15,000–50,000
exterior siding · Weathered and peeling siding, indicating structural issues Major $15,000–50,000
landscaping · Overgrown and unkempt lawn and landscaping Major $15,000–50,000
Total estimated repair cost · 3 items $45,000–150,000

Value-add ROI direction

  • Both repair and paint the exterior — Improving the exterior appearance will attract more tenants and buyers
  • Both landscaping and yard maintenance — A well-maintained yard can increase the property's curb appeal and value

ⓘ Cost ranges are severity-bucket heuristics (US national rule-of-thumb). Get contractor quotes + a written scope before underwriting a rehab budget.

Schools (NCES district)

District
Shikellamy SD
NCES district ID
4221540
Math proficiency
33% ▼ -8.00%
Reading proficiency
47% ▼ -12.00%
Median HH income
$41,227
Composite
33.6/100
National rank
#5415
State rank
#362 of 539 in PA

Livability — Sunbury

Score
76/100
State rank
#374
US rank
#3298

Category grades

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

Schools grade is shown separately in the Schools card above.

Census & demographics

Census place
Sunbury, PA
Population (ZIP)
16,229

Population outlook (Northumberland County) Hauer SSP2

Today (2025)
90,896 people
By 2030
89,084 · -2.0%
By 2040
84,822 · -6.7%
By 2050
80,521 · -11.4%
By 2075
72,152 · -20.6%
By 2100
62,257 · -31.5%

Race, ethnicity, and origin ACS 2023

Neighborhood character
Predominantly White (88%)
Race & ethnicity
White 88% Hispanic / Latino 6% Two or more races 5% Black 2%
Hispanic origin (detail)
Puerto Rican 5%
Common ancestry
Romanian 3% Polish 3% Iranian 3%
Foreign-born
0%
Languages at home
97% English-only · Spanish 2%

Political lean MEDSL · Northumberland

2024 margin
Solid R (+39.9) · D 29.6% · R 69.5%
2008→2024 swing
-26.1pp toward R · 2008: -13.8pp · 2024: -39.9pp
All cycles
2024: R+39.9 2020: R+38.5 2016: R+43.6 2012: R+19.4 2008: R+13.8

Not yet ingested

Civics

Market trends

HPI YoY
▼ -35.78%
Current HPI
158.7449
Rent YoY
Metro
State GDP YoY
▲ 1.68%
F500 in state
34

Industry mix (Fortune 500 HQ in PA)

Industry F500 HQs Revenue

Price history

+34.7% since first listed
9 events — show timeline
  • 2026-06-12 Pending CSVBR
  • 2026-05-25 Price Changed $174,500 CSVBR
  • 2026-05-06 Listed $179,500 CSVBR
  • 2023-09-01 Delisted CSVBR
  • 2023-08-31 Sold (MLS) $129,500 CSVBR
  • 2023-08-27 Contingent CSVBR
  • 2023-08-13 Delisted CSVBR
  • 2023-07-14 Contingent CSVBR
  • 2023-07-07 Listed $129,500 CSVBR

Cash-flow waterfall

monthly

Sold comps — $/sqft

last 12 mo · ≤1 mi

Loading sold comps…