18501 Collins Ave Unit 1401/02

Sunny Isles Beach, FL 33160 · condos · For Sale · 382 days on market
Asking price$15,500,000
6 beds 7 baths 6,049 sqft
Suggested offer$1,806,352$13,693,648 above the est. market value of $1,806,352.
View on Realtor.com →
Listed by Lourdes Alatriste · Douglas Elliman
Typecondos
Built2020
Price / sqft$2562
Est. value (own analysis)$1,806,352
Rent estimate (Zillow ZIP avg)$3,079/mo
HOA$11,528/mo
Street view
View full map & nearby schools →

Neighborhood

Show every detail
Statusfor_sale
Listed date2025-08-16
Removed date
MLSMiamiMLS #A11858279
Coordinates25.94775, -80.12029
Address18501 Collins Ave Unit 1401/02
CitySunny Isles Beach
StateFL
Zip33160
Listing ID9266004328
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$15,500,000
Down payment (20.0%)$3,100,000
Loan amount$12,400,000
Closing costs (5.0%)$775,000
Total cash to close$3,875,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)$24,542$294,500
Insurance (placeholder 0.8% of price)$10,333$124,000
HOA dues$11,528$138,336
Management (0.0% of EGI)$0$0
Maintenance (5.0% of GSR)$154$1,847
Total operating expenses$46,557$558,683
Net operating income (NOI)

Net Operating Income (NOI)

Effective Gross Income − Total Operating Expenses

Effective gross income derived$33,988
Total operating expenses derived$558,683

$33,988 − $558,683 = -$524,695

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$12,400,000
Interest rate (avg 30yr rate) comp6.7%
Term (assumption) assumption30 years

$12,400,000 amortized at 6.7% over 30 years = $79,686/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-$524,695
Annual debt service derived$956,229
Annual CapEx reserve assumption$1,847
Annual PMI assumption$0

(-$524,695 − $956,229 − $1,847 − $0) ÷ 12 = -$123,564

Cap rate

Cap Rate

NOI ÷ Purchase Price

NOI derived-$524,695
Purchase price data$15,500,000

-$524,695 ÷ $15,500,000 = -3.4%

Cash-on-cash

Cash-on-Cash Return

Annual Cash Flow ÷ Total Cash Invested

Annual cash flow derived-$1,482,771
Total cash to close derived$3,875,000

-$1,482,771 ÷ $3,875,000 = -38.3%

DSCR

Debt Service Coverage Ratio (DSCR)

NOI ÷ Annual Debt Service

NOI derived-$524,695
Annual debt service derived$956,229

-$524,695 ÷ $956,229 = -0.55

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$15,500,000

($36,944 ÷ 12) ÷ $15,500,000 = 0.0%

Gross rent multiplier

Gross Rent Multiplier (GRM)

Purchase Price ÷ Gross Scheduled Rent

Purchase price data$15,500,000
Gross scheduled rent (annual) comp$36,944

$15,500,000 ÷ $36,944 = 419.6

Operating expense ratio

Operating Expense Ratio

Total Operating Expenses ÷ Effective Gross Income

Total operating expenses derived$558,683
Effective gross income derived$33,988

$558,683 ÷ $33,988 = 1643.8%

Break-even occupancy

Break-Even Occupancy

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

Total operating expenses derived$558,683
Annual debt service derived$956,229
Annual PMI assumption$0
Gross scheduled rent (annual) comp$36,944

($558,683 + $956,229 + $0) ÷ $36,944 = 4100.6%

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
17121 Collins Ave Apt 4806condos688,332$8,332,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

10-year hold projection

IRR-15.3%
Equity multiple-1.66x
Total return (10yr)-$8,275,870
YearProperty valueNOICash flowLoan balanceEquity
1$15,965,000-$524,695-$1,482,771$12,265,556$3,699,444
2$16,443,950-$537,642-$1,495,765$12,121,881$4,322,069
3$16,937,269-$550,908-$1,509,078$11,968,338$4,968,930
4$17,445,387-$564,501-$1,522,719$11,804,252$5,641,135
5$17,968,748-$578,428-$1,536,695$11,628,898$6,339,850
6$18,507,811-$592,697-$1,551,016$11,441,502$7,066,309
7$19,063,045-$607,317-$1,565,688$11,241,237$7,821,808
8$19,634,936-$622,297-$1,580,722$11,027,220$8,607,716
9$20,223,984-$637,646-$1,596,125$10,798,506$9,425,478
10$20,830,704-$653,372-$1,611,908$10,554,087$10,276,617
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.