5239 172nd St

Urbandale, IA 50323

$574,900D

4 bd · 3.5 ba · 1,895 sqft · Built 2026 · Other · Active · 67 DOM

Cashflow @ list (25.0% down · 7.5%)

• Estimated rent: $2,275/mo
• Mortgage (P&I): −$3,015
• Tax + insurance: −$958
• HOA: −$15
• Vac / Maint / Mgmt: −$478
• Net cashflow: $-2,190/mo
• Annual: $-26,285/yr
• Cap rate: 1.72%
• Cash-on-cash: -16.33%
• DSCR: 0.27
• 1% rule: 0.40%
• Cash to close: $160,972

Investor read

• This is a 4-bed/3.5-bath other listed at $575k.
• At list price, monthly cash flow is $-2k ($-26k/yr) — negative.
• To cash-flow at today's rent, offer at most $258k (55.1% below list).
• To meet the 1% rule (rent ≥ 1% of price), the offer needs to be $228k (60.4% below list).
• It's been on market 67 days — a 6% lower offer ($540k) is reasonable based on typical stale-listing flexibility.
• Recommended offer: $228k (60.4% below list) — sets the bar for 1% rule.
• In year one you build about $32k of equity ($4k loan paydown + $28k appreciation (4.8% local appreciation)).
• Location reads 90/100 on livability (#4 in IA, #69 nationally) — a professional / high-income tenant draw. Strengths: crime A+, amenities A+, employment A+; Watch: commute F.
• Waukee Community School District (suburban): math 80% / reading 79% proficiency, ranked #14 of 289 in IA (top 5%) — strong family-tenant draw, lease renewals of 3-5y typical; only 11% free/reduced lunch — higher-income household profile.
• Zoned schools: Walnut Hills Elementary School (math 91% / reading 81%, grade A+, #26 of 616 statewide, top 4%, 625 students, 9% FRL); Waukee Middle School (math 83% / reading 81%, grade A+, #22 of 246 statewide, top 12%, 1,069 students, 12% FRL); Waukee High School (math 74% / reading 82%, grade A-, #53 of 336 statewide, top 16%, 1,268 students, 24% FRL) — zoned schools at 15% FRL track the district average.
• Market conditions: 381 active listings in the ZIP; 7 comparable units currently listed for rent nearby; rentals at typical pace (median 21d on market — plan ~3-4 weeks tenant-placement turnaround); 43% of comp listings sitting > 30 days — soft ceiling on asking rent; high-income renter base; 1,503 units permitted in Dallas County in 2024 (630 in 5+ unit buildings).
• Dallas County population projected at +74% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
• 2 sale attempts 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.
• By year 2, paydown + projected appreciation supports a ~$51k cash-out refi (75% LTV) — recoverable capital for the next deal without selling this one.
• Cap rate 1.7% vs local median 2.4% in Urbandale — below-typical yield; the buyer is paying a premium for something (appreciation thesis, condition, location) that the cap rate doesn't capture.
• This rent is only 16% of the median local income ($176k/yr) — well below the 30% rent-burden line; pricing power to push rent on renewal without tenant pushback.

Questions for listing agent

• 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?
• It's been on market 67 days. Have you received any prior offers? Is the seller open to a 60% concession, seller financing, or rate buy-down credit?
• What does the HOA fee cover, when was the last increase, and are there any pending special assessments or reserve-fund shortfalls?
• 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 A-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?
• The area grade is low — what's the realistic commute time and amenity access for the typical tenant pool here? Any planned neighborhood developments (good or bad) we should know about?
• 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.