Multi-family
2518 Walker Rd · Scott, LA
Flood risk 6/10 · Moderate
- FEMA flood zone
- AE
- Chance of flooding over 30 yrs
- 0.92%
- Est. flood insurance / yr
- $1,737 – $8,500
Fire risk 2/10 · Minimal
- Est. fire insurance / yr
- $1,269 – $2,357
Heat risk 8/10 · Major
- Hot days now (above 108°F)
- 7 days/yr
- Hot days in 30 yrs
- 20 days/yr
Wind risk 9/10 · Severe
- Chance of severe wind over 30 yrs
- 99.0%
Air-quality risk 1/10 · Minimal
- Unhealthy air days now
- 0 days/yr
- Unhealthy air days in 30 yrs
- 0 days/yr
Risk factors via First Street. Map © Google.
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 +30.0/30.0
- ARV discount +15.0/15.0
- 1% rule +10.0/10.0
- DSCR +10.0/10.0
- Schools +3.6/10.0
- Livability +3.3/5.0
- Rent growth +2.5/5.0
- Condition / age +2.2/5.0
- Appreciation +0.0/10.0
$95,000
🖨 Deal sheet 📄 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 MLS
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
Key facts
- 0.41 acre lot
- 4 parking spots
- Listed 149 days
Neighborhood map
What this means for you Summary
Snapshot
- This is a 3-bed/2.0-bath multifamily listed at $95k. Condition is rated fair.
Deal economics
- At list price, monthly cash flow is $320 ($4k/yr) — positive.
- The deal already cash-flows at list — no discount required.
- Meets the 1% rule at list price ($2k rent vs $95k).
- Recommended offer: $84k (12.0% below list) — sets the bar for market timing.
- Cap rate 15.7% vs local median 4.7% in Scott — 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 66/100 on livability (#116 in LA) — a middle-class / working-renter tenant base. Strengths: cost of living A+, health & safety A+, schools B+; Watch: crime F, amenities F, commute F.
- Lafayette Parish (urban): math 38% / reading 46% proficiency, ranked #19 of 98 in LA (top 19%) — families likely to look elsewhere, expect single-tenant / working-renter base with shorter leases.
- Market conditions: 276 active listings in the ZIP; 2 comparable units currently listed for rent nearby; 1,585 units permitted in Lafayette Parish in 2024 (10 in 5+ unit buildings).
Forward outlook
- Local home prices are declining (-3.0%/yr); year-one equity from $657 of loan paydown is wiped out by about $3k of value loss. Plan a longer hold.
- Lafayette County population projected at +34% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
- At projected returns (-3.0% appreciation + 3.0% rent growth), your $27k cash investment doubles in ~8 years — after that, you're playing with house money.
Negotiation context
- It's been on market 149 days — a 12% lower offer ($84k) is reasonable based on typical stale-listing flexibility.
- 3 sale attempts; this cycle's ask has dropped $25k (21%) from the opening price — seller is motivated, your offer sets the floor, not the list.
Risks & watch-outs
- Watch-outs: flood insurance adds $427/mo.
- Climate carrying-cost: in FEMA flood zone AE (mandatory federal flood insurance); severe wind risk, 99% chance of damaging wind over 30y; extreme-heat days projected 7→20/yr by 2055 (HVAC capex compounding) — expect insurance premiums to compound above CPI over the hold.
Questions for the listing agent
- It's been on market 149 days. Have you received any prior offers? Is the seller open to a 12% concession, seller financing, or rate buy-down credit?
- Have any recent inspections been done? Can we get a copy of the seller's disclosures and any deferred-maintenance estimates?
- What's the actual annual flood-insurance premium (NFIP or private), and is the property in a SFHA with mandatory coverage?
- Why hasn't it sold? Are there any deal-killer items the seller is aware of (foundation, flood, title, zoning, code violations)?
- Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
- Schools are B-rated — typically a magnet for longer-tenancy family renters. What's the average tenant stay here, and is there a school-zone premium baked into asking?
- 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.
- 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.
- 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.87% ✓
- Cap rate
- 15.72%
- Cash-on-cash
- 33.68%
- DSCR
- 2.50
- GRM
- 4.5
CMA / ARV
- ARV (median comp)
- $154,089
- List price
- $95,000
- Delta
- -38.35%
- Verdict
- UNDERPRICED
- Comps
- 3 within 2.0 mi
Show comp detail 1 sale within ~0.75 mi
| Address | Dist | Beds/Ba | Sqft | Sold | Price | $/sf | Match |
|---|---|---|---|---|---|---|---|
| 2518 Walker Rd | 0.00mi | 3/2.0 | 1,800 (0%) | 0mo | $75,000 | $42 | 100 |
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
- IRR
- 5.1%
- Equity multiple
- 1.20×
- Total profit
- $5,274
- Equity at exit
- $14,165
- IRR
- 14.7%
- Equity multiple
- 2.20×
- Total profit
- $32,008
- Equity at exit
- $8,214
Cash invested: $26,600 (down + closing). Projections, not guarantees.
Landlord ↔ Tenant lean methodology
- Overall (STATE)
- 90 Strongly Landlord-Friendly
- State Louisiana
- 90 Strongly Landlord-Friendly · R+12
- County
- — inherits STATE
- City
- — inherits STATE
ZIP-level market 70583
- Active inventory
- 276
- Price-to-rent
- 4.5×
Monthly cashflow live
- Estimated rent
- $1,776 medium interval (Pro) →
- Mortgage (P&I)
- −$498
- Tax est. 1.5%
- −$119 /mo · $1,425/yr
- Insurance
- −$40
- Flood insurance flood zone
- −$427 /mo · $5,118/yr
- HOA
- −$0
- Vacancy / Maint / Mgmt
- −$373
- Net cashflow
- $320
Break-even live
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
- $23,750
- Closing costs
- $2,850
- 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 2 comps
| Address | Beds | Baths | Sqft | Rent | $/sqft | DOM | Units | Dist |
|---|---|---|---|---|---|---|---|---|
| 108 Notre Dame Dr Lafayette, LA | 3.0 | 3.0 | 1700 | $1,700 | $1.00 | 43d | 1 | 1.10mi |
| 506 Kees Cir Lafayette, LA | 4.0 | 2.0 | 2433 | $1,900 | $0.78 | 21d | 1 | 1.40mi |
Listing history 8 events
-
2026-05-13status Pending 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2026-04-16status Active 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2026-03-09status Pending 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2026-02-19price $95,000 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2026-01-20status Active 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2025-11-25status Pending 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2025-09-24price $110,000 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
-
2025-09-09$120,000 Active 318-char remark
Show marketing remark (318 chars)
INVESTOR SPECIAL! Two adjacent homes with tenants in place. Unit 1 is a two bed, one bath detached single family home with a roof less than 10 years old. Unit 2 is a one bed one bath detached single family home with a roof under 5 years. Jump now on this opportunity to own two adjacent rental properties in Lafayette.
ⓘ 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 6/10 Major FEMA zone AE · 92% chance over 30 yrs
- Wildfire 2/10 Low
- Heat 8/10 Severe 7 d/yr ≥108°F today · 20 d/yr by 30 yrs out
- Wind 9/10 Extreme 99% chance of damaging wind over 30 yrs
- 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
- $21,312
- − Mortgage interest
- −$5,321
- − Property taxes
- −$1,425
- − Insurance
- −$5,594
- − Repairs & maintenance
- −$1,705
- − Management
- −$1,705
- − Depreciation
- −$2,764
- Taxable income
- $2,798
- Est. tax owed @ 24.0%
- −$672
- After-tax cash flow
- $3,168/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 · 12 photos
This property presents as a moderate rehab opportunity with average condition. Exterior repairs and interior updates would significantly enhance its value.
Repairs flagged
- Minor Kitchen cabinets — Worn appearance
- Minor Bathtub — Old and possibly in need of cleaning
- Moderate Exterior siding — Worn and faded
- Minor Interior walls — Paint chipping
- Minor Landscaping — Overgrown and needs trimming
Value-add opportunities
- Both Paint exterior siding and trim — Fresh paint enhances curb appeal and value
- Both Replace worn kitchen cabinets — New cabinets improve functionality and aesthetics
- Both Clean and organize interior walls — Fresh paint and organized space improve aesthetics and functionality
- Both Trim and maintain landscaping — Well-maintained landscaping enhances curb appeal and property value
Renovation cost estimate screening
| Repair item | Severity | Est. cost |
|---|---|---|
| Kitchen cabinets · Worn appearance | Minor | $500–3,000 |
| Bathtub · Old and possibly in need of cleaning | Minor | $500–3,000 |
| Exterior siding · Worn and faded | Moderate | $3,000–15,000 |
| Interior walls · Paint chipping | Minor | $500–3,000 |
| Landscaping · Overgrown and needs trimming | Minor | $500–3,000 |
| Total estimated repair cost · 5 items | $5,000–27,000 |
Value-add ROI direction
- Both Paint exterior siding and trim — Fresh paint enhances curb appeal and value ↑
- Both Replace worn kitchen cabinets — New cabinets improve functionality and aesthetics ↑
- Both Clean and organize interior walls — Fresh paint and organized space improve aesthetics and functionality ↑
- Both Trim and maintain landscaping — Well-maintained landscaping enhances curb appeal and property 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
- Lafayette Parish
- NCES district ID
- 2200870
- Math proficiency
- 38% ▼ -32.00%
- Reading proficiency
- 46% ▼ -24.00%
- Median HH income
- $50,238
- Composite
- 36.15/100
- National rank
- #4741
- State rank
- #19 of 98 in LA
Livability — Scott
- Score
- 66/100
- State rank
- #116
- US rank
- #11265
Category grades
Schools grade is shown separately in the Schools card above.
Census & demographics
- Census place
- Scott, LA
- City population
- 8,670
- Population (ZIP)
- 8,670
Population outlook (Lafayette County) Hauer SSP2
- Today (2025)
- 280,930 people
- By 2030
- 301,092 · +7.2%
- By 2040
- 339,456 · +20.8%
- By 2050
- 375,156 · +33.5%
- By 2075
- 451,672 · +60.8%
- By 2100
- 497,203 · +77.0%
Race, ethnicity, and origin ACS 2023
- Neighborhood character
- Predominantly White (68%)
- Race & ethnicity
- White 68% Hispanic / Latino 16% Black 13% Two or more races 11%
- Hispanic origin (detail)
- Mexican 7% Cuban 2%
- Common ancestry
- Lithuanian 11% Slovak 3% Italian 1%
- Foreign-born
- 11% · Canada
- Languages at home
- 81% English-only · Spanish 12% French/Haitian/Cajun 7%
Political lean MEDSL · Lafayette
- 2024 margin
- Solid R (+31.4) · D 33.5% · R 64.8% · Other 1.7%
- 2008→2024 swing
- -0.1pp no change · 2008: -31.3pp · 2024: -31.4pp
- All cycles
- 2024: R+31.4 2020: R+28.7 2016: R+33.6 2012: R+33.7 2008: R+31.3
Not yet ingested
- Civics
- —
Market trends
- HPI YoY
- ▼ -84.03%
- Current HPI
- 132.4083
- Rent YoY
- —
- Metro
- —
- State GDP YoY
- ▲ 3.29%
- F500 in state
- 10
Industry mix (Fortune 500 HQ in LA)
| Industry | F500 HQs | Revenue |
|---|---|---|
| Telecommunications | 2 | $23B |
|
||
| Utilities | 1 | $12B |
|
||
| Wholesale / Distribution | 1 | $5B |
|
||
| Advertising | 1 | $2B |
|
||
Price history
-20.8% since first listed8 events — show timeline
- 2026-05-13 Pending — AcadianaMLS
- 2026-04-16 Relisted — AcadianaMLS
- 2026-03-09 Pending — AcadianaMLS
- 2026-02-19 Price Changed $95,000 AcadianaMLS
- 2026-01-20 Relisted — AcadianaMLS
- 2025-11-25 Pending — AcadianaMLS
- 2025-09-24 Price Changed $110,000 AcadianaMLS
- 2025-09-09 Listed $120,000 AcadianaMLS
Cash-flow waterfall
monthlySold comps — $/sqft
last 12 mo · ≤1 miLoading sold comps…