17141 Collins Ave Unit LPH1
Sunny Isles Beach, FL 33160 · condos · Pending — under contract · 309 days on market
Asking price$11,900,000
6 beds 8 baths 6,106 sqft
Suggested offer$1,823,374$10,076,626 above the est. market value of $1,823,374.
View on Realtor.com →Listed by Dora Puig · Luxe Living Realty
Typecondos
Built2018
Price / sqft$1949
Est. value (own analysis)$1,823,374
Rent estimate (Zillow ZIP avg)$3,079/mo
HOA$13,582/mo
Wind10/10Extreme$Heat10/10ExtremeFlood8/10severe$Air2/10MinorWildfire1/10Minimal
1 / 43
Show every detail
Statusfor_sale
Listed date2025-10-28
Removed date—
MLSMiamiMLS #A11888105
Coordinates25.93491, -80.12098
Address17141 Collins Ave Unit LPH1
CitySunny Isles Beach
StateFL
Zip33160
Listing ID5230578208
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 | $11,900,000 |
| Down payment (20.0%) | $2,380,000 |
| Loan amount | $9,520,000 |
| Closing costs (5.0%) | $595,000 |
| Total cash to close | $2,975,000 |
| Income | |
| Rent (ZIP avg, ZORI — not bedroom-specific) | $3,079$36,944 |
| Vacancy loss (8.0%) | |
| Effective gross income | $2,832$33,988 |
| Operating expenses | |
| Property tax (placeholder 1.9% of price) | $18,842$226,100 |
| Insurance (est. scaled by flood & wind risk) | $15,470$185,640 |
| HOA dues | $13,582$162,984 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $154$1,847 |
| Total operating expenses | $48,048$576,571 |
| 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) | $154$1,847 |
| 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 | 6 | 5 | 5,727 | $55,000 | 2026-03-10 | — | |
| condos | 6 | 9 | 7,652 | $150,000 | — | — |
Widened to any bedroom count in ZIP. 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 |
|---|---|---|---|---|---|---|
| 100 Bayview Dr Apt 2124 | condos | 2 | 2 | 1,357 | $650 | 2026-09-02 |
| 18555 Collins Ave Apt 2805 | condos | 3 | 5 | 3,171 | $3,500,000 | 2026-09-01 |
| 2999 Point East Dr Apt C502 | condos | 1 | 1 | 816 | $180,000 | 2026-09-01 |
| 17749 Collins Ave Apt 3501 | condos | 4 | 7 | 4,609 | $6,500,000 | 2026-08-31 |
| 3551 NE 169th St Apt 301 | condos | 2 | 2 | 1,085 | $250,000 | 2026-08-31 |
| 3862 NE 171st St Unit C | condos | 2 | 3 | 1,200 | $382,000 | 2026-08-31 |
| 2000 Island Blvd Apt 1109 | condos | 3 | 3 | 2,630 | $825,000 | 2026-08-28 |
| 2841 NE 163rd St Apt 704 | condos | 1 | 2 | 790 | $197,000 | 2026-08-28 |
| 6750864223 | condos | 0 | 1 | 664 | $220,000 | 2026-08-28 |
| 18001 Collins Ave Unit 1010 | condos | 0 | 1 | 551 | $220,000 | 2026-08-28 |
| 18001 Collins Ave Unit 1403 | condos | 0 | 1 | 551 | $220,000 | 2026-08-28 |
| 300 Sunny Isles Blvd Unit 4-807 | condos | 3 | 4 | 1,892 | $1,240,000 | 2026-08-28 |
| 330 Sunny Isles Blvd Unit 5-1708 | condos | 3 | 4 | 1,892 | $1,500,000 | 2026-08-26 |
| 230 174th St Apt 902 | condos | 2 | 2 | 1,276 | $435,000 | 2026-08-26 |
| 16400 Collins Ave Apt 1242 | condos | 2 | 2 | 1,530 | $815,000 | 2026-08-25 |
| 17901 Collins Ave Unit 3003 | condos | 4 | 5 | 2,987 | $6,700,000 | 2026-08-25 |
| 250 174th St Apt 1510 | condos | 0 | 1 | 595 | $170,000 | 2026-08-25 |
| 300 Bayview Dr Apt 307 | condos | 2 | 2 | 1,350 | $410,000 | 2026-08-25 |
| 18011 Biscayne Blvd Unit 1704-1 | condos | 2 | 2 | 1,605 | $170,000 | 2026-08-25 |
| 17301 Biscayne Blvd Apt 1106 | condos | 3 | 4 | 2,158 | $985,000 | 2026-08-25 |
| 19370 Collins Ave Apt 319 | condos | 1 | 2 | 1,005 | $335,000 | 2026-08-24 |
| 2801 NE 183rd St Unit 405W | condos | 1 | 2 | 1,066 | $172,000 | 2026-08-24 |
| 18061 Biscayne Blvd Apt 1203 | condos | 1 | 2 | 1,005 | $180,000 | 2026-08-24 |
| 15811 Collins Ave Apt 2201 | condos | 3 | 4 | 2,928 | $2,525,000 | 2026-08-24 |
| 17301 Biscayne Blvd Apt 401 | condos | 2 | 3 | 1,999 | $800,000 | 2026-08-21 |
| 18001 Collins Ave Unit 2204 | condos | 0 | 1 | 457 | $200,000 | 2026-08-21 |
| 18001 Collins Ave Unit 2102 | condos | 0 | 1 | 664 | $205,000 | 2026-08-21 |
| 3944 NE 167th St Apt 106 | condos | 2 | 2 | 970 | $190,000 | 2026-08-21 |
| 2851 NE 183rd St Apt 1416E | condos | 2 | 2 | 1,693 | $320,000 | 2026-08-21 |
| 17001 Collins Ave Apt 2307 | condos | 2 | 3 | 1,479 | $1,750,000 | 2026-08-21 |
| 17890 W Dixie Hwy Apt 307 | condos | 3 | 2 | 1,652 | $290,000 | 2026-08-20 |
| 3750 NE 169th St Apt 102 | condos | 1 | 2 | 812 | $185,000 | 2026-08-20 |
| 5878676453 | condos | 1 | 1 | 1,005 | $295,000 | 2026-08-19 |
| 3600 NE 170th St Apt 102 | condos | 1 | 2 | 812 | $185,000 | 2026-08-19 |
| 2750 NE 183rd St Apt 2108 | condos | 2 | 2 | 1,268 | $260,000 | 2026-08-19 |
| 19380 Collins Ave Apt 712 | condos | 1 | 1 | 1,005 | $255,000 | 2026-08-18 |
| 2920 Point East Dr Apt N111 | condos | 1 | 1 | 768 | $160,000 | 2026-08-18 |
| 250 174th St Apt 2012 | condos | 1 | 2 | 1,087 | $240,000 | 2026-08-18 |
| 17051 NE 35th Ave Apt 202 | condos | 2 | 2 | 861 | $190,000 | 2026-08-17 |
| 3551 NE 169th St Apt 104 | condos | 1 | 1 | 812 | $150,000 | 2026-08-17 |
| 3550 NE 169th St Apt 407 | condos | 2 | 2 | 1,085 | $289,000 | 2026-08-17 |
| 300 Bayview Dr Apt 905 | condos | 2 | 2 | 1,350 | $340,000 | 2026-08-17 |
| 17700 N Bay Rd Apt 805 | condos | 2 | 2 | 1,300 | $640,000 | 2026-08-17 |
| 17375 Collins Ave Unit 1708 | condos | 3 | 3 | 1,860 | $780,000 | 2026-08-14 |
| 5752196881 | condos | 2 | 2 | 1,115 | $620,000 | 2026-08-14 |
| 3020 Marcos Dr Apt S109 | condos | 1 | 1 | 768 | $105,000 | 2026-08-13 |
| 16001 Collins Ave Apt 1504 | condos | 3 | 4 | 2,327 | $2,800,000 | 2026-08-13 |
| 400 Sunny Isles Blvd Apt 116 | condos | 2 | 3 | 1,403 | $820,000 | 2026-08-13 |
| 300 Bayview Dr Apt 1009 | condos | 1 | 2 | 762 | $215,000 | 2026-08-12 |
| 3750 NE 169th St Apt 408 | condos | 1 | 1 | 812 | $179,500 | 2026-08-10 |
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 |
|---|---|---|---|---|---|---|
| 275 189th Ter | single_family | 6 | 7 | 4,167 | $4,500,000 | — |
| 3916 Island Estates Dr | single_family | 6 | 7 | 6,932 | $19,990,000 | — |
| 1522 Island Blvd | single_family | 6 | 8 | 6,430 | $13,750,000 | — |
| 17121 Collins Ave Apt 4806 | condos | 6 | 8 | 8,332 | $8,332,000 | — |
| 128 Ocean Blvd | single_family | 6 | 9 | 7,657 | $12,950,000 | — |
| 142 S Island Dr | single_family | 6 | 9 | 8,783 | $16,999,000 | — |
| single_family | 6 | 8 | 7,500 | $8,900,000 | — | |
| 19575 Collins Ave Unit 3 | condos | 6 | 9 | 10,515 | $19,995,000 | — |
10-year hold projection
IRR-18.1%
Equity multiple-2.19x
Total return (10yr)-$7,922,184
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $12,257,000 | -$542,583 | -$1,278,567 | $9,416,782 | $2,840,218 |
| 2 | $12,624,710 | -$555,978 | -$1,292,008 | $9,306,476 | $3,318,234 |
| 3 | $13,003,451 | -$569,702 | -$1,305,780 | $9,188,595 | $3,814,856 |
| 4 | $13,393,555 | -$583,764 | -$1,319,890 | $9,062,619 | $4,330,935 |
| 5 | $13,795,361 | -$598,173 | -$1,334,348 | $8,927,993 | $4,867,369 |
| 6 | $14,209,222 | -$612,936 | -$1,349,163 | $8,784,121 | $5,425,101 |
| 7 | $14,635,499 | -$628,062 | -$1,364,341 | $8,630,370 | $6,005,129 |
| 8 | $15,074,564 | -$643,561 | -$1,379,893 | $8,466,060 | $6,608,504 |
| 9 | $15,526,801 | -$659,441 | -$1,395,828 | $8,290,467 | $7,236,334 |
| 10 | $15,992,605 | -$675,711 | -$1,412,155 | $8,102,816 | $7,889,789 |
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.