CashFlowRE
Sign in Sign up
502 -504 Shannon Ave Duplex
B- Composite 65.96
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 +24.8/30.0
  • ARV discount +15.0/15.0
  • DSCR +8.0/10.0
  • 1% rule +6.4/10.0
  • Livability +3.3/5.0
  • Schools +3.1/10.0
  • Rent growth +3.0/5.0
  • Condition / age +2.2/5.0
  • Appreciation +0.0/10.0

$210,000

502 -504 Shannon Ave · Seguin, TX 78155
4 bd · 2.0 ba · 1,344 sqft · MultiFamily · 101 Days on market
Fair condition 4,007 sqft lot $156/sqft · 49% below area Est $410k · 49% under

🖨 Deal sheet (PDF) 📄 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

Opportunity is knocking! This duplex could be for someone wanting a buy and hold property to invest in with current tenants in place or purchase for yourself, live in one side and rent out the other! Each unit is a 2 bedroom, 1 bath, kitchen, living area, and laundry room. Located about a half a mile from downtown Seguin where you can enjoy shopping, restaurants, and nightlife.

Key facts

  • Nightlife
  • Shopping
  • Duplex

Tags

DUPLEXDOWNTOWN SEGUINSHOPPINGRESTAURANTSNIGHTLIFE

Neighborhood map

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

What this means for you Summary

Snapshot

  • This is a 2 × 2-bed/1.0-bath units multifamily listed at $210k. Condition is rated fair.

Deal economics

  • At list price, monthly cash flow is $445 ($5k/yr) — positive. Per door: $222/mo.
  • The deal already cash-flows at list — no discount required.
  • Meets the 1% rule at list price ($2k rent vs $210k).
  • Recommended offer: $191k (9.0% below list) — sets the bar for market timing.
  • Cap rate 8.8% vs local median 3.6% in Seguin — 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 (#592 in TX) — a middle-class / working-renter tenant base. Strengths: cost of living A+, housing A+; Watch: employment D, amenities F, commute F.
  • Seguin ISD (town): math 26% / reading 30% proficiency, ranked #663 of 826 in TX (top 80%) — low school quality limits family demand, transient renter base, plan for 1-2y turnover; 63% free/reduced lunch — lower-income household profile, screen leases tightly.
  • Zoned schools: Oralia R Rodriguez El (math 28% / reading 30%, grade F, #2,668 of 4,322 statewide, top 63%, 475 students, 83% FRL); Briesemeister Middle (math 17% / reading 22%, grade F, #1,445 of 1,662 statewide, top 88%, 725 students, 77% FRL); Seguin H S (math 24% / reading 43%, grade F, #1,011 of 1,632 statewide, top 63%, 2,101 students, 71% FRL).
  • Market conditions: Rents rising (+2.0%/yr); 1833 active listings in the ZIP; 18 comparable units currently listed for rent nearby; rentals lingering (median 43d on market — plan ~5-8 weeks vacancy on turnover, expect pricing pressure); 67% of comp listings sitting > 30 days — soft ceiling on asking rent; 2,064 units permitted in Guadalupe County in 2024 (133 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 $6k of value loss. Plan a longer hold.
  • Guadalupe County population projected at +61% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.

Negotiation context

  • It's been on market 101 days — a 9% lower offer ($191k) is reasonable based on typical stale-listing flexibility.

Risks & watch-outs

  • Climate carrying-cost: severe wind risk, 80% chance of damaging wind over 30y; extreme-heat days projected 7→23/yr by 2055 (HVAC capex compounding) — expect insurance premiums to compound above CPI over the hold.
Recommended offer $191,100 (9.0% below list)

Questions for the listing agent

  1. It's been on market 101 days. Have you received any prior offers? Is the seller open to a 9% 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. Why hasn't it sold? Are there any deal-killer items the seller is aware of (foundation, flood, title, zoning, code violations)?
  6. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
  7. Schools are F-rated, which usually means shorter tenancies and higher turnover. Who's the typical renter profile here, and what's been the actual vacancy rate?
  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.14%
Cap rate
8.83%
Cash-on-cash
9.08%
DSCR
1.40
GRM
7.3

CMA / ARV

ARV (median comp)
$410,291
List price
$210,000
Delta
-48.82%
Verdict
UNDERPRICED
Comps
2 within 2.0 mi
Show comp detail 12 sales within ~0.75 mi
Address Dist Beds/Ba Sqft Sold Price $/sf Match
416 Avenue C 0.48mi 4/1.0 1,200 (-11%) 1mo $80,000 $67 55
219 Lopez 0.85mi 3/2.0 (-1) 1,428 (+6%) 2mo $149,900 $105 48
808 E Krezdorn 0.92mi 3/1.5 (-1) 1,450 (+8%) 2mo $250,000 $172 44
227 E College St 0.51mi 3/2.0 (-1) 1,658 (+23%) 3mo $249,900 $151 43
904 Bismark St 1.03mi 3/2.0 (-1) 1,211 (-10%) 2mo $249,900 $206 42
721 Roosevelt Dr 1.47mi 3/2.0 (-1) 1,092 (-19%) 1mo $169,000 $155 34
96 W Hampton Dr 1.05mi 3/2.0 (-1) 1,595 (+19%) 2mo $284,000 $178 33
431 Gravel 0.87mi 3/2.0 (-1) 1,071 (-20%) 2mo $189,999 $177 33
605 E Donegan 0.77mi 3/2.5 (-1) 1,652 (+23%) 1mo $349,500 $212 32
621 E Gonzales St 0.77mi 3/1.0 (-1) 1,077 (-20%) 0mo $217,000 $201 31
432 Romberg St 0.79mi 3/1.0 (-1) 1,056 (-21%) 2mo $170,000 $161 30
1326 Aldama St 0.87mi 3/1.0 (-1) 1,016 (-24%) 2mo $49,900 $49 29

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 · 2.04% rent growth · sell at horizon

5-year hold
IRR
-3.6%
Equity multiple
0.86×
Total profit
$-7,964
Equity at exit
$31,312
10-year hold
IRR
4.9%
Equity multiple
1.35×
Total profit
$20,444
Equity at exit
$18,157

Cash invested: $58,800 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

Overall (STATE)
87 Strongly Landlord-Friendly
State Texas
87 Strongly Landlord-Friendly · R+5
County
— inherits STATE
City
— inherits STATE
3-day notice; statewide preemption; one of the fastest eviction climates; Travis County (Austin) slightly slower.

ZIP-level market 78155

Rents YoY
2.0%
Active inventory
1833
Price-to-rent
14.6×

Monthly cashflow live

Estimated rent
$2,400 high interval (Pro) →
Mortgage (P&I)
$1,101
Tax est. 1.5%
$262 /mo · $3,150/yr
Insurance
$88
HOA
$0
Vacancy / Maint / Mgmt
$504
Net cashflow
$445

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

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

Break-even live

Break-even rent $1,837
Max offer price $210,000
Occupancy floor 76%

Sensitivity live

Price -10% $590 -5% $517 +0% $445 +5% $372 +10% $300
Rent -10% $255 -5% $350 +0% $445 +5% $540 +10% $634
Rate -1.0pp $550 -0.5pp $498 base $445 +0.5pp $390 +1.0pp $335

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
$52,500
Closing costs
$6,300
Reserves months
Total cash needed

Loan-product check · same deal, 3 products live

Conventional

25% down · 7.5% · 30yr

Cash invested
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Personal DTI + credit; lowest rate.

DSCR

20% down · 8.5% · 30yr

Cash invested
Monthly P&I
Monthly cashflow
DSCR
Eligible?

No personal income docs; deal must DSCR.

Hard money

10% down · 12.0% · 12mo

Cash invested
Monthly P&I
Monthly cashflow
DSCR
Eligible?

Short-term bridge; refi at stabilization.

Rent comps 40 comps

AddressBedsBaths SqftRent$/sqft DOM Units Dist
502 N Guadalupe St Seguin, TX 3.0 2.0 1426 $1,200 $0.84 43d 1 0.07mi
404 W Walnut St Seguin, TX 2.0 1.0 996 $1,550 $1.56 139d 1 0.18mi
702 San Antonio Ave Unit 4 Seguin, TX 2.0 1.0 896 $850 $0.95 42d 1 0.30mi
508 Pitts St Seguin, TX 3.0 1.0 973 $1,050 $1.08 29d 1 0.33mi
518 Newton Ave Seguin, TX 2.0 1.0 720 $1,000 $1.39 62d 1 0.38mi
935 Campbell St Seguin, TX 3.0 1.0 836 $1,300 $1.56 0d 1 0.41mi
908 Liberty Ave Seguin, TX 3.0 2.0 910 $1,475 $1.62 43d 1 0.42mi
755 N Austin St Unit B Seguin, TX 2.0 1.0 1100 $1,750 $1.59 10d 1 0.44mi
906 San Antonio Ave Seguin, TX 2.0 1.0 1020 $1,100 $1.08 139d 1 0.44mi
917 8th St Seguin, TX 3.0 2.0 1298 $1,349 $1.04 94d 1 0.44mi
920 San Antonio Ave Seguin, TX 1.0–2.0 1.0–2.0 909 $1,256 $1.38 0d 185 0.52mi
104 W Nolte St Unit A Seguin, TX 2.0 1.5 1100 $1,700 $1.55 10d 1 0.53mi
309 E Walnut St Unit 2 Seguin, TX 2.0 1.0 3456 $775 $0.22 29d 1 0.53mi
428 N Vaughan Ave Apt 2 Seguin, TX 1.0 1.0 $895 43d 1 0.54mi
428 N Vaughan Ave Unit 1 Seguin, TX 2.0 1.0 $1,125 43d 1 0.54mi
300 N Milam St Seguin, TX 1.0 1.0 700 $950 $1.36 139d 1 0.55mi
435 N Milam St Seguin, TX 2.0 1.0 960 $1,150 $1.20 10d 1 0.55mi
772 Mitchell Ave Seguin, TX 3.0 2.0 1298 $1,390 $1.07 68d 1 0.55mi
403 E Mountain St Unit Na Seguin, TX 3.0 2.0 1800 $1,500 $0.83 29d 1 0.58mi
809 Leissner St Seguin, TX 2.0 1.0 1020 $1,175 $1.15 119d 1 0.62mi
201 E Kingsbury St Seguin, TX 2.0 1.0 856 $1,095 $1.28 119d 1 0.68mi
201 E Kingsbury St Seguin, TX 2.0 1.0 856 $1,095 $1.28 110d 1 0.68mi
128 Moore St Unit 4 Seguin, TX 2.0 1.0 $1,000 84d 1 0.75mi
128 Moore St Unit 6 Seguin, TX 1.0 1.0 $900 112d 1 0.75mi
1037 W Court St Unit A Seguin, TX 2.0 1.0 700 $1,100 $1.57 10d 1 0.75mi
1037 W Court St Unit Main Seguin, TX 3.0 2.0 1000 $1,325 $1.32 10d 1 0.75mi
1037 W Court St Unit B Seguin, TX 2.0 1.0 700 $1,200 $1.71 62d 1 0.75mi
1331 Hidalgo St Seguin, TX 3.0 2.0 1298 $1,364 $1.05 117d 1 0.77mi
714 S River St Unit B Seguin, TX 3.0 1.0 936 $1,285 $1.37 119d 1 0.78mi
969 Kunkel St Seguin, TX 3.0 1.0 1648 $1,575 $0.96 40d 1 0.82mi
702 Cedar Pkwy Seguin, TX 2.0 2.0 1222 $1,595 $1.31 10d 1 0.84mi
732 E College St Seguin, TX 2.0 2.0 1073 $1,300 $1.21 0d 1 0.86mi
227 Lopez St Seguin, TX 3.0 2.0 1298 $1,249 $0.96 108d 1 0.87mi
519 E Pine St Seguin, TX 2.0 1.0 672 $1,000 $1.49 29d 1 0.87mi
726 E Humphreys St Seguin, TX 3.0 2.0 1248 $1,500 $1.20 119d 1 0.87mi
431 Gravel St Seguin, TX 3.0 2.0 1071 $1,625 $1.52 10d 1 0.88mi
431 Gravel St Seguin, TX 3.0 2.0 1071 $1,625 $1.52 43d 1 0.88mi
222 Garcia St Seguin, TX 3.0 2.0 1298 $1,215 $0.94 97d 1 0.88mi
228 Garcia St Seguin, TX 3.0 2.0 1298 $1,149 $0.89 62d 1 0.88mi
215 Garcia St Seguin, TX 3.0 2.0 1298 $1,310 $1.01 7d 1 0.89mi

Property features AI

Finance

Financial info
Gross annual income: $19,200Net operating income: $15,077Annual operating expense: $4,123Operating expenses include taxes, insurance, and maintenance0% vacancy rateBoth units occupied
HOA & community
Subdivision legal name: WEST

Exterior

Parking
Unit 1: Street parkingUnit 2: Pad parking (1 space)
Utilities
City electricityCity waterCity sewerCity garbage service
Home design
Pre-owned multi-family buildingResidential zoningSubdivision: West
Construction
Cement fiber exteriorComposition roof2-unit building
Exterior features
GuttersCable TV availableLevel lot

Interior

Kitchen
Oven/StoveRefrigerator
Bedrooms
Unit 1: 2 bedrooms (occupied)Unit 2: 2 bedrooms (occupied)
Flooring
Vinyl flooring
Bathrooms
Unit 1: 1 full bathUnit 2: 1 full bath
Heating & cooling
Window unit heatingElectric heatWindow/Wall air conditioning
Interior features
Window coveringsSeparate electric and water meters
Laundry & utility
Washer connection (each unit)Dryer connection (each unit)

Listing history 50 events

  1. 2026-09-24
    days on market $210,000 Active 101 DOM
  2. 2026-09-23
    days on market $210,000 Active 100 DOM
  3. 2026-09-22
    days on market $210,000 Active 99 DOM
  4. 2026-09-21
    days on market $210,000 Active 98 DOM
  5. 2026-09-20
    days on market $210,000 Active 97 DOM
  6. 2026-09-19
    days on market $210,000 Active 96 DOM
  7. 2026-09-18
    days on market $210,000 Active 95 DOM
  8. 2026-09-17
    days on market $210,000 Active 94 DOM
  9. 2026-09-16
    days on market $210,000 Active 93 DOM
  10. 2026-09-15
    days on market $210,000 Active 92 DOM
  11. 2026-09-14
    days on market $210,000 Active 91 DOM
  12. 2026-09-13
    days on market $210,000 Active 90 DOM
  13. 2026-09-12
    days on market $210,000 Active 89 DOM
  14. 2026-09-11
    statusdays on market $210,000 Active 88 DOM
  15. 2026-09-05
    days on market $210,000 Price Change 82 DOM
  16. 2026-09-04
    days on market $210,000 Price Change 81 DOM
  17. 2026-09-03
    days on market $210,000 Price Change 80 DOM
  18. 2026-08-31
    days on market $210,000 Price Change 77 DOM
  19. 2026-08-30
    days on market $210,000 Price Change 76 DOM
  20. 2026-08-29
    pricestatus $210,000 Price Change 75 DOM
  21. 2026-08-29
    days on market $220,000 Active 75 DOM
  22. 2026-08-28
    days on market $220,000 Active 74 DOM
  23. 2026-08-27
    days on market $220,000 Active 73 DOM
  24. 2026-08-25
    days on market $220,000 Active 71 DOM
  25. 2026-08-24
    days on market $220,000 Active 70 DOM
  26. 2026-08-23
    days on market $220,000 Active 69 DOM
  27. 2026-08-22
    days on market $220,000 Active 68 DOM
  28. 2026-08-21
    days on market $220,000 Active 67 DOM
  29. 2026-08-20
    days on market $220,000 Active 66 DOM
  30. 2026-08-19
    days on market $220,000 Active 65 DOM
  31. 2026-08-18
    days on market $220,000 Active 64 DOM
  32. 2026-08-17
    days on market $220,000 Active 63 DOM
  33. 2026-08-16
    days on market $220,000 Active 62 DOM
  34. 2026-08-15
    days on market $220,000 Active 61 DOM
  35. 2026-08-14
    days on market $220,000 Active 60 DOM
  36. 2026-08-13
    days on market $220,000 Active 59 DOM
  37. 2026-08-12
    days on market $220,000 Active 58 DOM
  38. 2026-08-11
    days on market $220,000 Active 57 DOM
  39. 2026-08-10
    days on market $220,000 Active 56 DOM
  40. 2026-08-09
    days on market $220,000 Active 55 DOM
  41. 2026-08-08
    days on market $220,000 Active 54 DOM
  42. 2026-08-06
    days on market $220,000 Active 52 DOM
  43. 2026-08-05
    days on market $220,000 Active 51 DOM
  44. 2026-08-04
    days on market $220,000 Active 50 DOM
  45. 2026-08-03
    days on market $220,000 Active 49 DOM
  46. 2026-07-31
    days on market $220,000 Active 46 DOM
  47. 2026-07-30
    days on market $220,000 Active 45 DOM
  48. 2026-07-30
    days on market $220,000 Active 44 DOM
  49. 2026-07-28
    days on market $220,000 Active 43 DOM
  50. 2026-07-26
    days on market $220,000 Active 41 DOM

ⓘ 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 (unshaded) · 0% chance over 30 yrs
  • 🔥 Wildfire 3/10 Moderate
  • 🌡 Heat 8/10 Severe 7 d/yr ≥108°F today · 23 d/yr by 30 yrs out
  • 💨 Wind 8/10 Severe 80% 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
$28,800
− Mortgage interest
−$11,763
− Property taxes
−$3,150
− Insurance
−$1,050
− Repairs & maintenance
−$2,304
− Management
−$2,304
− Depreciation
−$6,109
Taxable income
$2,120
combined federal + state — saved on this device
Est. tax owed @ 24.0%
−$509
After-tax cash flow
$4,828/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 · 5 photos

Fair 45/100 Moderate rehab Est. rehab $33,600–$60,480 screening

This two-unit property requires moderate repairs and maintenance to improve its condition and value. Painting the exterior and replacing the flooring would significantly enhance its curb appeal and living space.

Repairs flagged

  • Moderate exterior siding — Weathered and discolored
  • Moderate flooring — Worn hardwood
  • Minor interior walls — Some scuff marks

Value-add opportunities

  • Both paint exterior — Enhances curb appeal and value
  • Both replace flooring — Improves living space and value
  • Both update bathrooms — Modernizes and increases value
  • Both update kitchen — Modernizes and increases value

ⓘ Rehab cost is a screening estimate — Moderate scope × the home's square footage at US $/sqft rules of thumb (the same model as the Flip Finder). Get contractor quotes + a written scope before underwriting.

F Composite school gradezoned avg 31/100

Zoned Schools

Elementary Oralia R Rodriguez El F TX #2,668/4,322 Nat'l #27,846/41,679 High Seguin H S F TX #1,011/1,632 Nat'l #10,191/17,239

Schools (NCES district)

District
Seguin ISD
NCES district ID
4839690
Math proficiency
26% ▼ -8.00%
Reading proficiency
30% ▼ -5.00%
Median HH income
$46,210
Composite
24.17/100
National rank
#7738
State rank
#663 of 826 in TX
C Composite livability gradescore 66/100

Livability — Seguin

Score
66/100
State rank
#592
US rank
#11298

Category grades

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

Schools grade is shown separately in the Schools card above.

Census & demographics

Census place
Seguin, TX
County
Guadalupe County · 196,854 people
City population
55,600
Metro
San Antonio-New Braunfels, TX
Population (ZIP)
55,600
Household income
$71,039
Rent vs Own
27.5% rent · 72.5% own
Severe rent burden
17% of renters

Population outlook (Guadalupe County) Hauer SSP2

Today (2025)
196,854 people
By 2030
220,210 · +11.9%
By 2040
268,004 · +36.1%
By 2050
316,333 · +60.7%
By 2075
434,747 · +120.8%
By 2100
520,447 · +164.4%

Race, ethnicity, and origin ACS 2023

Neighborhood character
Diverse neighborhood (Simpson 0.58)
Race & ethnicity
Hispanic / Latino 49% White 43% Two or more races 26% Black 5%
Hispanic origin (detail)
Mexican 41%
Common ancestry
Lithuanian 2% Slovak 1% Romanian 1%
Foreign-born
8% · Canada
Languages at home
74% English-only · Spanish 24% German/W. Germanic 1%

Political lean MEDSL · Guadalupe

2024 margin
Strong R (+29.5) · D 34.8% · R 64.3%
2008→2024 swing
+1.5pp toward D · 2008: -31.0pp · 2024: -29.5pp
All cycles
2024: R+29.5 2020: R+24.2 2016: R+31.8 2012: R+35.1 2008: R+31.0

Not yet ingested

Civics

Price history

1 event — show timeline
  • 2026-06-15 Listed $220,000 LERA

Cash-flow waterfall

monthly

Sold comps — $/sqft

last 12 mo · ≤1 mi

Loading sold comps…