17475 Collins Ave Ph 3201
Sunny Isles Beach, FL 33160 · condos · For Sale · 139 days on market
Asking price$23,990,000
4 beds 8 baths 9,051 sqft
Suggested offer$12,764,483$11,225,517 above the est. market value of $12,764,483.
View on Realtor.com →Listed by Chad Carroll · COMPASS
Typecondos
Built2016
Price / sqft$2651
Est. value (own analysis)$12,764,483
Rent estimate (own analysis)$26,500/mo
HOA$17,545/mo
Wind10/10Extreme$Heat10/10ExtremeFlood8/10severe$Air2/10MinorWildfire1/10Minimal
1 / 68
Show every detail
Statusfor_sale
Listed date2026-04-16
Removed date—
MLSMiamiMLS #A12001113
Coordinates25.93797, -80.12066
Address17475 Collins Ave Ph 3201
CitySunny Isles Beach
StateFL
Zip33160
Listing ID6999364194
Sourceus-real-estate-listings, cached 2026-08-31
ZIP market snapshot (33160)
Typical home value (ZHVI)$518,452
Typical rent (ZORI)$3,079/mo
Zillow Research's ZHVI (home value index) and ZORI (rent index) for this ZIP, as of 2026-07 — free published data, refreshed monthly, no RentCast quota spent. "Typical value/rent" is a smoothed index, not a literal median of active listings.
Underwriting (buy-and-hold, default assumptions)
| Acquisition (one-time, not monthly/yearly) | |
| Purchase price | $23,990,000 |
| Down payment (20.0%) | $4,798,000 |
| Loan amount | $19,192,000 |
| Closing costs (5.0%) | $1,199,500 |
| Total cash to close | $5,997,500 |
| Income | |
| Rent (comp-derived) | $26,500$318,000 |
| Vacancy loss (8.0%) | |
| Effective gross income | $24,380$292,560 |
| Operating expenses | |
| Property tax (placeholder 1.9% of price) | $37,984$455,810 |
| Insurance (est. scaled by flood & wind risk) | $31,187$374,244 |
| HOA dues | $17,545$210,540 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $1,325$15,900 |
| Total operating expenses | $88,041$1,056,494 |
| Net operating income (NOI) | |
| Debt service & reserves | |
| Debt service (6.66%, avg 30yr rate as of 2026-08-27, 30yr amortizing) | |
| CapEx reserve (5.0% of GSR) | $1,325$15,900 |
| Mortgage insurance (PMI) (0.0% of loan, not required — down payment ≥ 20%) | $0$0 |
| Cash flow |
Cap rate
Cash-on-cash
DSCR
Rent-to-price (1% rule)
Gross rent multiplier
Operating expense ratio
Break-even occupancy
Comparables
Same ZIP. Real active rental listings, used to derive the rent estimate above.
| Address | Type | Beds | Baths | Sqft | Asking rent | Listed | Days on market |
|---|---|---|---|---|---|---|---|
| condos | 4 | 6 | 3,252 | $45,000 | 2026-08-27 | — | |
| condos | 4 | 6 | 2,871 | $22,500 | 2026-08-21 | — | |
| condos | 4 | 4 | 2,870 | $12,000 | 2026-07-10 | — | |
| condos | 4 | 5 | 2,914 | $9,100 | 2026-08-12 | — | |
| condos | 4 | 5 | 2,485 | $19,000 | 2026-08-24 | — | |
| condos | 4 | 4 | 4,078 | $20,000 | 2026-08-25 | — | |
| condos | 4 | 6 | 3,945 | $16,900 | 2026-07-09 | — | |
| condos | 4 | 3 | 1,729 | $6,800 | 2026-08-19 | — | |
| condos | 4 | 6 | 3,171 | $27,100 | 2026-05-11 | — | |
| condos | 4 | 7 | 4,609 | $45,000 | 2026-08-12 | — | |
| condos | 4 | 5 | 3,287 | $41,000 | 2026-06-25 | — | |
| condos | 4 | 5 | 2,914 | $12,000 | 2026-08-24 | — | |
| condos | 4 | 5 | 2,394 | $15,000 | 2026-08-24 | — | |
| condos | 4 | 6 | 3,204 | $34,000 | 2026-04-20 | — | |
| condos | 4 | 7 | 4,609 | $39,900 | 2026-04-14 | — | |
| condos | 4 | 5 | 3,945 | $17,900 | 2026-05-19 | — | |
| condos | 4 | 6 | 3,500 | $29,500 | 2026-04-27 | — | |
| condos | 4 | 6 | 2,682 | $30,000 | 2026-05-24 | — | |
| apartment | 4 | 3 | 1,746 | $8,500 | 2026-06-20 | — | |
| condos | 4 | 5 | 3,171 | $28,500 | 2026-08-25 | — | |
| condos | 4 | 5 | 2,980 | $36,500 | 2026-08-11 | — | |
| condos | 4 | 5 | 2,394 | $18,500 | 2025-11-28 | — | |
| condos | 4 | 7 | 4,141 | $29,000 | 2024-07-21 | — | |
| condos | 4 | 5 | 4,046 | $11,995 | 2026-04-09 | — | |
| condos | 4 | 6 | 3,625 | $38,500 | 2026-09-02 | — | |
| condos | 4 | 5 | 2,987 | $45,000 | 2026-08-01 | — | |
| condos | 4 | 7 | 4,609 | $42,000 | 2026-03-04 | — | |
| condos | 4 | 6 | 3,613 | $22,000 | 2026-05-08 | — | |
| condos | 4 | 5 | 3,073 | $11,500 | 2026-08-21 | — | |
| condos | 4 | 6 | 4,385 | $60,000 | 2025-12-06 | — | |
| condos | 4 | 6 | 3,252 | $39,000 | 2026-08-07 | — | |
| condos | 4 | 5 | 3,750 | $26,000 | 2026-07-28 | — | |
| condos | 4 | 5 | 3,555 | $29,000 | 2026-06-01 | — | |
| condos | 4 | 4 | 2,736 | $27,000 | 2026-08-12 | — | |
| condos | 4 | 6 | 3,625 | $39,000 | 2026-05-22 | — | |
| apartment | 4 | 3 | 2,991 | $26,000 | 2025-03-07 | — | |
| condos | 4 | 5 | 4,339 | $17,000 | 2025-10-07 | — | |
| condos | 4 | 5 | 2,394 | $23,500 | 2025-01-13 | — | |
| condos | 4 | 6 | 4,050 | $39,500 | 2025-08-27 | — | |
| condos | 4 | 5 | 3,555 | $28,500 | 2026-06-12 | — | |
| condos | 4 | 4 | 2,390 | $10,000 | 2026-01-23 | — | |
| condos | 4 | 6 | 4,500 | $25,000 | 2026-06-20 | — | |
| condos | 4 | 6 | 3,854 | $50,000 | 2025-11-13 | — | |
| condos | 4 | 5 | 3,084 | $20,000 | 2026-01-24 | — | |
| condos | 4 | 6 | 2,682 | $28,000 | 2026-02-19 | — | |
| condos | 4 | 7 | 3,735 | $24,000 | 2026-05-01 | — | |
| condos | 4 | 5 | 2,682 | $33,000 | 2024-05-08 | — | |
| condos | 4 | 5 | 2,394 | $16,500 | 2026-01-23 | — | |
| apartment | 4 | 5 | 3,150 | $26,000 | — | — | |
| condos | 4 | 6 | 2,682 | $30,000 | 2026-09-01 | — | |
| condos | 4 | 6 | 2,871 | $22,500 | — | — | |
| condos | 4 | 5 | 2,987 | $42,000 | 2026-09-01 | — |
Same ZIP & bedroom count. Closed sales from Realtor.com over the last 12 months, matched to this property's type — real transaction prices, not asking prices. Falls back to Miami-Dade County public records (property appraiser tax roll) when Realtor.com has no sales on file for the area.
| Address | Type | Beds | Baths | Living sqft | Sale price | Sale date |
|---|---|---|---|---|---|---|
| 17749 Collins Ave Apt 3501 | condos | 4 | 7 | 4,609 | $6,500,000 | 2026-08-31 |
| 17901 Collins Ave Unit 3003 | condos | 4 | 5 | 2,987 | $6,700,000 | 2026-08-25 |
| 400 Sunny Isles Blvd Apt 2019 | condos | 4 | 5 | 3,088 | $1,865,000 | 2026-07-21 |
| 18555 Collins Ave Apt 3005 | condos | 4 | 5 | 3,415 | $3,797,359 | 2026-06-26 |
| 17975 Collins Ave Unit N2401 | condos | 4 | 6 | 4,780 | $10,250,000 | 2026-06-25 |
| 17875 Collins Ave Unit 1201 | condos | 4 | 4 | 2,736 | $3,900,000 | 2026-06-17 |
| 16047 Collins Ave Apt 404 | condos | 4 | 7 | 3,735 | $3,940,000 | 2026-06-03 |
| 17001 Collins Ave Apt 4608 | condos | 4 | 6 | 2,871 | $3,965,000 | 2026-06-01 |
| 18501 Collins Ave Apt 1001 | condos | 4 | 6 | 3,625 | $6,535,000 | 2026-05-29 |
Same ZIP. Other properties currently for sale nearby — asking prices, not closed sale prices. Not a price comp; see Sold comps for actual transaction history.
| Address | Type | Beds | Baths | Sqft | Asking price | Days on market |
|---|---|---|---|---|---|---|
| 333 Atlantic Ave | single_family | 4 | 4 | 2,426 | $11,999,000 | — |
| 3949 194th Ln | single_family | 4 | 4 | 2,353 | $2,259,000 | — |
| 3341 NE 170th St | single_family | 4 | 3 | 3,556 | $3,500,000 | — |
| 18555 Collins Ave Apt 3301 | condos | 4 | 5 | 4,154 | $6,500,000 | — |
| 329 Poinciana Dr Unit 909 | condos | 4 | 3 | 2,425 | $1,190,000 | — |
| 17875 Collins Ave Ph 4506 | condos | 4 | 7 | 6,419 | $13,495,000 | — |
| 2349 NE 173rd St | single_family | 4 | 3 | 1,432 | $839,000 | — |
| 330 Sunny Isles Blvd Unit 5-2403 | condos | 4 | 5 | 3,296 | $3,300,000 | — |
10-year hold projection
IRR-14.8%
Equity multiple-1.58x
Total return (10yr)-$12,352,971
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $24,709,700 | -$763,934 | -$2,259,830 | $18,983,916 | $5,725,784 |
| 2 | $25,450,991 | -$781,570 | -$2,277,863 | $18,761,543 | $6,689,448 |
| 3 | $26,214,521 | -$799,602 | -$2,296,303 | $18,523,899 | $7,690,622 |
| 4 | $27,000,956 | -$818,040 | -$2,315,158 | $18,269,936 | $8,731,021 |
| 5 | $27,810,985 | -$836,893 | -$2,334,439 | $17,998,533 | $9,812,452 |
| 6 | $28,645,315 | -$856,169 | -$2,354,154 | $17,708,492 | $10,936,822 |
| 7 | $29,504,674 | -$875,877 | -$2,374,312 | $17,398,534 | $12,106,140 |
| 8 | $30,389,814 | -$896,027 | -$2,394,923 | $17,067,291 | $13,322,523 |
| 9 | $31,301,509 | -$916,629 | -$2,415,997 | $16,713,301 | $14,588,207 |
| 10 | $32,240,554 | -$937,692 | -$2,437,544 | $16,335,003 | $15,905,551 |
Assumes 3.0% annual rent growth, 2.5% expense growth, 3.0% appreciation, and a 6.0% selling cost at exit — all placeholder assumptions, not market-derived.