788 NE 23rd St Unit 5501
Miami, FL 33137 · condos · For Sale · 203 days on market
Asking price$7,695,000
4 beds 6 baths 3,887 sqft
Suggested offer$3,984,486$3,710,514 above the est. market value of $3,984,486.
View on Realtor.com →Listed by Lourdes Alatriste · Douglas Elliman
Typecondos
Built2021
Price / sqft$1980
Est. value (own analysis)$3,984,486
Rent estimate (own analysis)$22,250/mo
HOA$6,571/mo
1 / 101
Show every detail
Statusfor_sale
Listed date2026-02-11
Removed date—
MLSMiamiMLS #A11963315
Coordinates25.79902, -80.18584
Address788 NE 23rd St Unit 5501
CityMiami
StateFL
Zip33137
Listing ID9516884443
Sourceus-real-estate-listings, cached 2026-08-30
ZIP market snapshot (33137)
Typical home value (ZHVI)$682,165
Typical rent (ZORI)$3,560/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 | $7,695,000 |
| Down payment (20.0%) | $1,539,000 |
| Loan amount | $6,156,000 |
| Closing costs (5.0%) | $384,750 |
| Total cash to close | $1,923,750 |
| Income | |
| Rent (comp-derived) | $22,250$267,000 |
| Vacancy loss (8.0%) | |
| Effective gross income | $20,470$245,640 |
| Operating expenses | |
| Property tax (placeholder 1.9% of price) | $12,184$146,205 |
| Insurance (placeholder 0.8% of price) | $5,130$61,560 |
| HOA dues | $6,571$78,852 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $1,113$13,350 |
| Total operating expenses | $24,997$299,967 |
| 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,113$13,350 |
| 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 | 5 | 3,812 | $40,000 | 2026-08-19 | — | |
| condos | 4 | 6 | 2,582 | $18,000 | 2026-08-14 | — | |
| condos | 4 | 5 | 2,743 | $22,500 | 2026-08-14 | — | |
| condos | 4 | 6 | 2,694 | $45,000 | 2026-08-10 | — | |
| condos | 4 | 6 | 2,686 | $22,000 | 2026-08-07 | — | |
| condos | 4 | 6 | 4,210 | $30,000 | 2026-07-20 | — | |
| condos | 4 | 6 | 3,189 | $26,800 | 2026-07-16 | — | |
| condos | 4 | 6 | 2,663 | $17,500 | 2026-07-09 | — | |
| condos | 4 | 5 | 2,586 | $23,500 | 2026-07-07 | — | |
| condos | 4 | 4 | 4,270 | $17,250 | 2026-05-14 | — | |
| condos | 4 | 5 | 2,845 | $19,500 | 2026-08-23 | — | |
| condos | 4 | 6 | 2,582 | $14,000 | 2026-08-25 | — | |
| condos | 4 | 6 | 2,663 | $19,500 | 2026-04-11 | — | |
| condos | 4 | 6 | 2,530 | $29,995 | 2026-01-16 | — | |
| condos | 4 | 6 | 3,788 | $29,000 | 2026-01-07 | — | |
| condos | 4 | 4 | 3,179 | $12,000 | 2026-03-17 | — | |
| apartment | 4 | 5 | 3,341 | $21,500 | — | — | |
| condos | 4 | 6 | 3,189 | $23,000 | — | — | |
| condos | 4 | 6 | 2,582 | $20,000 | 2026-02-28 | — | |
| condos | 4 | 5 | 2,648 | $25,000 | — | — |
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 |
|---|---|---|---|---|---|---|
| 700 NE 24th St Unit 3201 | condos | 4 | 6 | 2,686 | $2,800,000 | 2026-07-30 |
| 700 NE 24th St Unit 4801 | condos | 4 | 6 | 2,686 | $2,750,000 | 2026-07-14 |
| 700 NE 24th St Unit 4401 | condos | 4 | 6 | 2,663 | $2,550,000 | 2026-06-11 |
| 700 NE 24th St Unit 4802 | condos | 4 | 6 | 3,189 | $3,850,000 | 2026-05-29 |
| 700 NE 26th Ter Unit 4203 | condos | 4 | 6 | 3,788 | $4,000,000 | 2026-05-27 |
| 700 NE 24th St Unit 3801 | condos | 4 | 6 | 2,582 | $2,650,000 | 2026-05-15 |
| 788 NE 23rd St Unit 2001 | condos | 4 | 5 | — | $2,720,000 | 2026-05-08 |
| 700 NE 26th Ter Unit TH403 | condos | 4 | 7 | 4,401 | $4,100,000 | 2026-05-08 |
| 788 NE 23rd St Unit 5502 | condos | 4 | 5 | 3,492 | $4,000,000 | 2026-05-08 |
| 700 NE 24th St Unit 1101 | condos | 4 | 6 | 2,686 | $2,400,000 | 2026-04-14 |
| 788 NE 23rd St Unit 3301 | condos | 4 | 6 | 3,298 | $3,600,000 | 2026-03-26 |
| 700 NE 24th St Unit 2501 | condos | 4 | 6 | 2,686 | $2,575,000 | 2026-03-26 |
| 700 NE 24th St Unit 5207 | condos | 4 | 6 | 2,520 | $3,000,000 | 2026-03-20 |
| 700 NE 26th Ter Unit 3903 | condos | 4 | 6 | 3,796 | $3,900,000 | 2026-03-18 |
| 788 NE 23rd St Unit 1001 | condos | 4 | 5 | 2,743 | $2,800,000 | 2026-03-18 |
| 700 NE 24th St Unit 2301 | condos | 4 | 6 | 2,686 | $2,450,000 | 2026-03-04 |
| 700 NE 24th St Unit 5903 | condos | 4 | 6 | 2,895 | $3,980,000 | 2026-03-03 |
| 700 NE 24th St Unit 2101 | condos | 4 | 6 | 2,686 | $2,475,000 | 2026-02-06 |
| 700 NE 24th St Unit 1401 | condos | 4 | 6 | 2,978 | $2,400,000 | 2026-01-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 |
|---|---|---|---|---|---|---|
| 121 NE 34th St Ph 3217 | condos | 4 | 5 | 2,866 | $2,499,000 | — |
| 725 NE 24th St Unit 301 | condos | 4 | 6 | — | $2,498,900 | — |
| 480 NE 31st St Unit 5104 | condos | 4 | 5 | 2,792 | $3,295,000 | — |
| 456 NE 29th ST | condo | 4 | 4 | 3,063 | $3,554,000 | — |
| 480 NE 31st St Unit 5303 | condos | 4 | 5 | 2,418 | $2,999,990 | — |
| 621 NE 57th St | single_family | 4 | 4 | 2,633 | $2,000,000 | — |
| 700 NE 26th Ter Unit 4403 | condos | 4 | 6 | 3,788 | $4,988,888 | — |
| 725 NE 24th Street Miami, FL 33137 | condo | 4 | 5 | 2,880 | $2,836,900 | — |
10-year hold projection
IRR-8.8%
Equity multiple-0.50x
Total return (10yr)-$1,878,593
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $7,925,850 | -$54,327 | -$542,398 | $6,089,255 | $1,836,595 |
| 2 | $8,163,626 | -$54,457 | -$542,862 | $6,017,927 | $2,145,698 |
| 3 | $8,408,534 | -$54,553 | -$543,301 | $5,941,701 | $2,466,833 |
| 4 | $8,660,790 | -$54,614 | -$543,712 | $5,860,240 | $2,800,550 |
| 5 | $8,920,614 | -$54,637 | -$544,095 | $5,773,185 | $3,147,429 |
| 6 | $9,188,232 | -$54,621 | -$544,447 | $5,680,152 | $3,508,080 |
| 7 | $9,463,879 | -$54,563 | -$544,766 | $5,580,731 | $3,883,149 |
| 8 | $9,747,796 | -$54,460 | -$545,051 | $5,474,482 | $4,273,314 |
| 9 | $10,040,230 | -$54,311 | -$545,298 | $5,360,937 | $4,679,293 |
| 10 | $10,341,437 | -$54,113 | -$545,507 | $5,239,594 | $5,101,843 |
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.