10203 Collins Ave Unit LPH2701

Bal Harbour, FL 33154 · condos · For Sale · 1 days on market
Asking price$38,500,000
5 beds 7 baths 7,774 sqft
Suggested offer$5,416,224$33,083,776 above the est. market value of $5,416,224.
View on Realtor.com →
Listed by Dina Goldentayer · Douglas Elliman - 120 Ocean Drive
Typecondos
Built2017
Price / sqft$4952
Est. value (own analysis)$5,416,224
Rent estimate (Zillow ZIP avg)$4,738/mo
HOA$15,500/mo
Street view
View full map & nearby schools →

Neighborhood

Show every detail
Statusfor_sale
Listed date2026-09-01
Removed date
MLSMiamiMLS #A12081475
Coordinates25.89518, -80.12321
Address10203 Collins Ave Unit LPH2701
CityBal Harbour
StateFL
Zip33154
Listing ID5661187029
Sourceus-real-estate-listings, cached 2026-09-02

ZIP market snapshot (33154)

Typical home value (ZHVI)$1,230,561
Typical rent (ZORI)$4,738/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$38,500,000
Down payment (20.0%)$7,700,000
Loan amount$30,800,000
Closing costs (5.0%)$1,925,000
Total cash to close$9,625,000
Rent (ZIP avg, ZORI — not bedroom-specific)$4,738$56,861
Vacancy loss (8.0%)

Vacancy Loss

Gross Scheduled Rent × Vacancy Rate

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

$56,861 × 8.0% = $4,549

Effective gross income$4,359$52,312
Property tax (placeholder 1.9% of price)$60,958$731,500
Insurance (placeholder 0.8% of price)$25,667$308,000
HOA dues$15,500$186,000
Management (0.0% of EGI)$0$0
Maintenance (5.0% of GSR)$237$2,843
Total operating expenses$102,362$1,228,343
Net operating income (NOI)

Net Operating Income (NOI)

Effective Gross Income − Total Operating Expenses

Effective gross income derived$52,312
Total operating expenses derived$1,228,343

$52,312 − $1,228,343 = -$1,176,031

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

$30,800,000 amortized at 6.7% over 30 years = $197,929/mo

CapEx reserve (5.0% of GSR)$237$2,843
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-$1,176,031
Annual debt service derived$2,375,149
Annual CapEx reserve assumption$2,843
Annual PMI assumption$0

(-$1,176,031 − $2,375,149 − $2,843 − $0) ÷ 12 = -$296,169

Cap rate

Cap Rate

NOI ÷ Purchase Price

NOI derived-$1,176,031
Purchase price data$38,500,000

-$1,176,031 ÷ $38,500,000 = -3.1%

Cash-on-cash

Cash-on-Cash Return

Annual Cash Flow ÷ Total Cash Invested

Annual cash flow derived-$3,554,023
Total cash to close derived$9,625,000

-$3,554,023 ÷ $9,625,000 = -36.9%

DSCR

Debt Service Coverage Ratio (DSCR)

NOI ÷ Annual Debt Service

NOI derived-$1,176,031
Annual debt service derived$2,375,149

-$1,176,031 ÷ $2,375,149 = -0.50

Rent-to-price (1% rule)

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

(Gross Scheduled Rent ÷ 12) ÷ Purchase Price

Gross scheduled rent (annual) comp$56,861
Purchase price data$38,500,000

($56,861 ÷ 12) ÷ $38,500,000 = 0.0%

Gross rent multiplier

Gross Rent Multiplier (GRM)

Purchase Price ÷ Gross Scheduled Rent

Purchase price data$38,500,000
Gross scheduled rent (annual) comp$56,861

$38,500,000 ÷ $56,861 = 677.1

Operating expense ratio

Operating Expense Ratio

Total Operating Expenses ÷ Effective Gross Income

Total operating expenses derived$1,228,343
Effective gross income derived$52,312

$1,228,343 ÷ $52,312 = 2348.1%

Break-even occupancy

Break-Even Occupancy

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

Total operating expenses derived$1,228,343
Annual debt service derived$2,375,149
Annual PMI assumption$0
Gross scheduled rent (annual) comp$56,861

($1,228,343 + $2,375,149 + $0) ÷ $56,861 = 6337.4%

Comparables

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

AddressTypeBedsBathsSqftAsking rentListedDays on market
condos553,300$20,0002026-04-24

10155 Collins Ave Apt 1210

Bal Harbour, 33154 · rent comp

Bedrooms / bathrooms5 bd / 5 ba
Square footage3,300
Listed2026-04-24
Days on market

Asking rent: $20,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
10185 Collins Ave Apt 308condos221,514$525,0002026-08-28
9501 E Bay Harbor Dr Apt 5Bcondos221,485$670,0002026-08-28
9800 W Bay Harbor Dr Apt 602condos12895$540,0002026-08-27
9940 W Bay Harbor Dr Unit 7B-Scondos231,335$845,0002026-08-26
9559 Collins Ave Unit 7Dcondos231,740$1,270,0002026-08-26
9801 Collins Ave Apt 5Rcondos331,968$2,075,0002026-08-26
1070 98th St Apt 14condos11530$215,0002026-08-25
8855 Collins Ave Apt 5Acondos332,050$1,500,0002026-08-24
10190 Collins Ave Apt 107condos01506$220,0002026-08-24
20 Park Dr Apt 6condos221,036$615,0002026-08-24
10350 W Bay Harbor Dr Apt 4Tcondos11950$400,0002026-08-24
1075 93rd St Apt 106condos22840$277,0002026-08-24
10350 W Bay Harbor Dr Ph Hcondos221,335$540,0002026-08-21
9751 E Bay Harbor Dr Unit 12Dcondos331,731$1,050,0002026-08-21
9559 Collins Ave Unit 8Fcondos221,260$912,0002026-08-21
10275 Collins Ave Apt 915condos12896$800,0002026-08-20
9001 Collins Ave Unit S1003condos464,235$30,250,0002026-08-17
9250 W Bay Harbor Dr Ph Ccondos221,675$905,0002026-08-14
9273 Collins Ave Apt 503condos221,024$575,0002026-08-14
9703 Collins Ave Unit 800condos222,721$6,150,0002026-08-14
9703 Collins Ave Unit 1900condos342,721$7,350,0002026-08-13
10140 W Bay Harbor Dr Unit 502Bcondos221,620$634,0002026-08-13
9350 W Bay Harbor Dr Apt 5Ccondos332,600$2,450,0002026-08-12
9601 Collins Ave Apt 1502condos232,160$2,585,0002026-08-06
9300 Bay Harbor Ter Apt 3Bcondos331,600$660,0002026-08-06
9700 E Bay Harbor Dr Apt 406condos12919$255,0002026-08-05
6868882314condos231,740$1,350,0002026-08-04
9595 Collins Ave Unit 3Dcondos231,740$1,000,0002026-08-04
10155 Collins Ave Apt 307condos232,525$1,450,0002026-07-31
9455 Collins Ave Apt 703condos221,170$1,110,0002026-07-30
9601 Collins Ave Apt 1504condos232,160$3,850,0002026-07-29
1075 93rd St Apt 206condos22840$275,0002026-07-27
9801 Collins Ave Apt 16Ucondos231,688$2,100,0002026-07-21
9500 W Bay Harbor Dr Apt 6Bcondos12975$495,0002026-07-17
10185 Collins Ave Ph 8condos221,514$828,0002026-07-15
9559 Collins Ave Unit 8Bcondos342,750$4,050,0002026-07-13
9225 Collins Ave Apt 1409condos12918$400,0002026-07-10
9221 E Bay Harbor Dr Unit 509condos341,830$2,450,0002026-07-10
9101 E Bay Harbor Dr Apt 705condos221,105$480,0002026-07-10
10201 Collins Ave Unit 611condos221,917$4,040,0002026-07-09
1150 101st St Apt 601condos221,128$828,0002026-07-07
9821 E Bay Harbor Dr Apt 503condos221,143$950,0002026-07-02
9341 Collins Ave Apt 604condos221,277$910,0002026-07-01
9801 Collins Ave Apt 18Ucondos221,688$1,550,0002026-06-30
1177 Kane Concourse Unit 703condos231,756$2,200,0002026-06-30
9901 W Bay Harbor Dr Apt 406condos231,366$1,375,0002026-06-26
1001 91st St Apt 408condos221,192$300,0002026-06-26
9821 E Bay Harbor Dr Apt 502condos221,142$850,0002026-06-25
10275 Collins Ave Apt 724condos12896$718,0002026-06-25
10275 Collins Ave Apt 429condos12896$610,0002026-06-23

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
9001 Collins Ave Unit S201condos575,729$21,900,000
8777 Collins Ave Apt 702condos568,724$40,150,000
9349 Collins Ave Apt 1101condos576,726$24,995,000
10155 Collins Ave Apt 1210condos553,300$4,650,000
9324 Abbott Avesingle_family532,900$2,500,000
145 Harbour Waysingle_family573,142$13,500,000
9110 W Bay Harbor Dr Apt 5condos576,122$11,250,000
1233 102nd Stsingle_family554,126$6,000,000

10-year hold projection

IRR-14.5%
Equity multiple-1.51x
Total return (10yr)-$19,119,453
YearProperty valueNOICash flowLoan balanceEquity
1$39,655,000-$1,176,031-$3,554,023$30,466,060$9,188,940
2$40,844,650-$1,205,171-$3,583,234$30,109,187$10,735,463
3$42,069,990-$1,235,030-$3,613,166$29,727,808$12,342,182
4$43,332,089-$1,265,629-$3,643,839$29,320,239$14,011,850
5$44,632,052-$1,296,984-$3,675,271$28,884,682$15,747,370
6$45,971,013-$1,329,114-$3,707,479$28,419,215$17,551,799
7$47,350,144-$1,362,038-$3,740,485$27,921,783$19,428,361
8$48,770,648-$1,395,777-$3,774,306$27,390,193$21,380,455
9$50,233,768-$1,430,350-$3,808,963$26,822,097$23,411,670
10$51,740,781-$1,465,777-$3,844,477$26,214,990$25,525,790
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.