17121 Collins Ave Apt 4806

Sunny Isles Beach, FL 33160 · condos · For Sale · 282 days on market
Asking price$8,332,000
6 beds 8 baths 8,332 sqft
Suggested offer$2,488,102$5,843,898 above the est. market value of $2,488,102.
View on Realtor.com →
Listed by Daniel Tzinker · The Agency Florida LLC
Typecondos
Built2009
Price / sqft$1000
Est. value (own analysis)$2,488,102
Rent estimate (Zillow ZIP avg)$3,079/mo
HOA$12,788/mo
Street view
View full map & nearby schools →

Neighborhood

Show every detail
Statusfor_sale
Listed date2025-11-24
Removed date
MLSMiamiMLS #A11918249
Coordinates25.93436, -80.12103
Address17121 Collins Ave Apt 4806
CitySunny Isles Beach
StateFL
Zip33160
Listing ID6714545061
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)

Purchase price$8,332,000
Down payment (20.0%)$1,666,400
Loan amount$6,665,600
Closing costs (5.0%)$416,600
Total cash to close$2,083,000
Rent (ZIP avg, ZORI — not bedroom-specific)$3,079$36,944
Vacancy loss (8.0%)

Vacancy Loss

Gross Scheduled Rent × Vacancy Rate

Gross scheduled rent (annual) comp$36,944
Vacancy rate (assumption) assumption8.0%

$36,944 × 8.0% = $2,956

Effective gross income$2,832$33,988
Property tax (placeholder 1.9% of price)$13,192$158,308
Insurance (placeholder 0.8% of price)$5,555$66,656
HOA dues$12,788$153,456
Management (0.0% of EGI)$0$0
Maintenance (5.0% of GSR)$154$1,847
Total operating expenses$31,689$380,267
Net operating income (NOI)

Net Operating Income (NOI)

Effective Gross Income − Total Operating Expenses

Effective gross income derived$33,988
Total operating expenses derived$380,267

$33,988 − $380,267 = -$346,279

Debt service (6.66%, avg 30yr rate as of 2026-08-27, 30yr amortizing)

Monthly Principal & Interest

Standard amortization on the loan amount, at the effective rate and term

Loan amount derived$6,665,600
Interest rate (avg 30yr rate) comp6.7%
Term (assumption) assumption30 years

$6,665,600 amortized at 6.7% over 30 years = $42,835/mo

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

Monthly Cash Flow

(NOI − Annual Debt Service − Annual CapEx Reserve − Annual PMI) ÷ 12

NOI derived-$346,279
Annual debt service derived$514,019
Annual CapEx reserve assumption$1,847
Annual PMI assumption$0

(-$346,279 − $514,019 − $1,847 − $0) ÷ 12 = -$71,845

Cap rate

Cap Rate

NOI ÷ Purchase Price

NOI derived-$346,279
Purchase price data$8,332,000

-$346,279 ÷ $8,332,000 = -4.2%

Cash-on-cash

Cash-on-Cash Return

Annual Cash Flow ÷ Total Cash Invested

Annual cash flow derived-$862,145
Total cash to close derived$2,083,000

-$862,145 ÷ $2,083,000 = -41.4%

DSCR

Debt Service Coverage Ratio (DSCR)

NOI ÷ Annual Debt Service

NOI derived-$346,279
Annual debt service derived$514,019

-$346,279 ÷ $514,019 = -0.67

Rent-to-price (1% rule)

Rent-to-Price (the "1% rule")

(Gross Scheduled Rent ÷ 12) ÷ Purchase Price

Gross scheduled rent (annual) comp$36,944
Purchase price data$8,332,000

($36,944 ÷ 12) ÷ $8,332,000 = 0.0%

Gross rent multiplier

Gross Rent Multiplier (GRM)

Purchase Price ÷ Gross Scheduled Rent

Purchase price data$8,332,000
Gross scheduled rent (annual) comp$36,944

$8,332,000 ÷ $36,944 = 225.5

Operating expense ratio

Operating Expense Ratio

Total Operating Expenses ÷ Effective Gross Income

Total operating expenses derived$380,267
Effective gross income derived$33,988

$380,267 ÷ $33,988 = 1118.8%

Break-even occupancy

Break-Even Occupancy

(Total OpEx + Annual Debt Service + Annual PMI) ÷ Gross Scheduled Rent

Total operating expenses derived$380,267
Annual debt service derived$514,019
Annual PMI assumption$0
Gross scheduled rent (annual) comp$36,944

($380,267 + $514,019 + $0) ÷ $36,944 = 2420.7%

Comparables

Same ZIP. Real active rental listings, used to derive the rent estimate above.

AddressTypeBedsBathsSqftAsking rentListedDays on market
condos655,727$55,0002026-03-10
condos697,652$150,000

18201 E Collins Ave Unit TS1

Sunny Isles Beach, 33160 · rent comp

Bedrooms / bathrooms6 bd / 5 ba
Square footage5,727
Listed2026-03-10
Days on market

Asking rent: $55,000

View on Zillow →

17901 Collins Ave Unit TS4205

Sunny Isles Beach, 33160 · rent comp

Bedrooms / bathrooms6 bd / 9 ba
Square footage7,652
Listed
Days on market

Asking rent: $150,000

View on Zillow →

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.

AddressTypeBedsBathsLiving sqftSale priceSale date
100 Bayview Dr Apt 2124condos221,357$6502026-09-02
18555 Collins Ave Apt 2805condos353,171$3,500,0002026-09-01
2999 Point East Dr Apt C502condos11816$180,0002026-09-01
17749 Collins Ave Apt 3501condos474,609$6,500,0002026-08-31
3551 NE 169th St Apt 301condos221,085$250,0002026-08-31
3862 NE 171st St Unit Ccondos231,200$382,0002026-08-31
2000 Island Blvd Apt 1109condos332,630$825,0002026-08-28
2841 NE 163rd St Apt 704condos12790$197,0002026-08-28
6750864223condos01664$220,0002026-08-28
18001 Collins Ave Unit 1010condos01551$220,0002026-08-28
18001 Collins Ave Unit 1403condos01551$220,0002026-08-28
300 Sunny Isles Blvd Unit 4-807condos341,892$1,240,0002026-08-28
330 Sunny Isles Blvd Unit 5-1708condos341,892$1,500,0002026-08-26
230 174th St Apt 902condos221,276$435,0002026-08-26
16400 Collins Ave Apt 1242condos221,530$815,0002026-08-25
17901 Collins Ave Unit 3003condos452,987$6,700,0002026-08-25
250 174th St Apt 1510condos01595$170,0002026-08-25
300 Bayview Dr Apt 307condos221,350$410,0002026-08-25
18011 Biscayne Blvd Unit 1704-1condos221,605$170,0002026-08-25
17301 Biscayne Blvd Apt 1106condos342,158$985,0002026-08-25
19370 Collins Ave Apt 319condos121,005$335,0002026-08-24
2801 NE 183rd St Unit 405Wcondos121,066$172,0002026-08-24
18061 Biscayne Blvd Apt 1203condos121,005$180,0002026-08-24
15811 Collins Ave Apt 2201condos342,928$2,525,0002026-08-24
17301 Biscayne Blvd Apt 401condos231,999$800,0002026-08-21
18001 Collins Ave Unit 2204condos01457$200,0002026-08-21
18001 Collins Ave Unit 2102condos01664$205,0002026-08-21
3944 NE 167th St Apt 106condos22970$190,0002026-08-21
2851 NE 183rd St Apt 1416Econdos221,693$320,0002026-08-21
17001 Collins Ave Apt 2307condos231,479$1,750,0002026-08-21
17890 W Dixie Hwy Apt 307condos321,652$290,0002026-08-20
3750 NE 169th St Apt 102condos12812$185,0002026-08-20
5878676453condos111,005$295,0002026-08-19
3600 NE 170th St Apt 102condos12812$185,0002026-08-19
2750 NE 183rd St Apt 2108condos221,268$260,0002026-08-19
19380 Collins Ave Apt 712condos111,005$255,0002026-08-18
2920 Point East Dr Apt N111condos11768$160,0002026-08-18
250 174th St Apt 2012condos121,087$240,0002026-08-18
17051 NE 35th Ave Apt 202condos22861$190,0002026-08-17
3551 NE 169th St Apt 104condos11812$150,0002026-08-17
3550 NE 169th St Apt 407condos221,085$289,0002026-08-17
300 Bayview Dr Apt 905condos221,350$340,0002026-08-17
17700 N Bay Rd Apt 805condos221,300$640,0002026-08-17
17375 Collins Ave Unit 1708condos331,860$780,0002026-08-14
5752196881condos221,115$620,0002026-08-14
3020 Marcos Dr Apt S109condos11768$105,0002026-08-13
16001 Collins Ave Apt 1504condos342,327$2,800,0002026-08-13
400 Sunny Isles Blvd Apt 116condos231,403$820,0002026-08-13
300 Bayview Dr Apt 1009condos12762$215,0002026-08-12
3750 NE 169th St Apt 408condos11812$179,5002026-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.

AddressTypeBedsBathsSqftAsking priceDays on market
275 189th Tersingle_family674,167$4,500,000
3916 Island Estates Drsingle_family676,932$19,990,000
1522 Island Blvdsingle_family686,430$13,750,000
128 Ocean Blvdsingle_family697,657$12,950,000
142 S Island Drsingle_family698,783$16,999,000
single_family687,500$8,900,000
19575 Collins Ave Unit 3condos6910,515$19,995,000
342 S Parkwaysingle_family675,660$16,900,000

10-year hold projection

IRR-17.1%
Equity multiple-2.01x
Total return (10yr)-$5,173,749
YearProperty valueNOICash flowLoan balanceEquity
1$8,581,960-$346,279-$862,145$6,593,330$1,988,630
2$8,839,419-$354,766-$870,679$6,516,097$2,323,321
3$9,104,601-$363,460-$879,420$6,433,561$2,671,040
4$9,377,739-$372,366-$888,375$6,345,357$3,032,383
5$9,659,072-$381,490-$897,548$6,251,095$3,407,976
6$9,948,844-$390,836-$906,945$6,150,361$3,798,483
7$10,247,309-$400,410-$916,571$6,042,709$4,204,600
8$10,554,728-$410,217-$926,432$5,927,664$4,627,064
9$10,871,370-$420,263-$936,533$5,804,720$5,066,650
10$11,197,511-$430,555-$946,881$5,673,332$5,524,179
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.
All figures are estimates for evaluation purposes only, not investment, tax, legal, or insurance advice. Property tax is estimated from a real matched tax bill or millage rate when available, a placeholder % of price otherwise; insurance is scaled by flood and wind risk where those are known and a flat percentage otherwise — never a real quote. Verify all of them, along with association restrictions and permit status, before committing capital. Rent estimates come from real comps or Zillow’s ZIP index, not appraisals.