5111 Alhambra Cir
Coral Gables, FL 33146 · single_family · For Sale · 77 days on market
Asking price$5,750,000
5 beds 6 baths 4,214 sqft
Suggested offer$4,305,036$1,444,964 above the est. market value of $4,305,036.
View on Realtor.com →Listed by Brittany Borges · TIM Realty, LLC.
Typesingle_family
Built2026
Price / sqft$1364
Est. value (own analysis)$4,305,036
Rent estimate (own analysis)$20,000/mo
HOANone
Wind10/10Extreme$Heat10/10ExtremeFlood3/10moderate$Air2/10MinorWildfire1/10Minimal
1 / 61
Show every detail
Statusfor_sale
Listed date2026-06-17
Removed date—
MLSMiamiMLS #A12039072
Coordinates25.72227, -80.28374
Address5111 Alhambra Cir
CityCoral Gables
StateFL
Zip33146
Listing ID5641684532
Sourceus-real-estate-listings, cached 2026-08-31
ZIP market snapshot (33146)
Typical home value (ZHVI)$1,955,688
Typical rent (ZORI)$3,608/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 | $5,750,000 |
| Down payment (20.0%) | $1,150,000 |
| Loan amount | $4,600,000 |
| Closing costs (5.0%) | $287,500 |
| Total cash to close | $1,437,500 |
| Income | |
| Rent (comp-derived) | $20,000$240,000 |
| Vacancy loss (8.0%) | |
| Effective gross income | $18,400$220,800 |
| Operating expenses | |
| Property tax (placeholder 1.9% of price) | $9,104$109,250 |
| Insurance (est. scaled by flood & wind risk) | $6,133$73,600 |
| HOA dues | $0$0 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $1,000$12,000 |
| Total operating expenses | $16,238$194,850 |
| 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,000$12,000 |
| 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 |
|---|---|---|---|---|---|---|---|
| single_family | 5 | 5 | 5,688 | $20,000 | 2026-04-01 | — | |
| single_family | 5 | 4 | 3,734 | $16,000 | 2026-05-29 | — | |
| single_family | 5 | 5 | 4,313 | $29,500 | 2026-05-08 | — |
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 |
|---|---|---|---|---|---|---|
| 6825 Riviera Dr | single_family | 5 | 4 | 3,401 | $2,675,000 | 2026-07-14 |
| 1426 Robbia Ave | single_family | 5 | 3 | 2,912 | $3,200,000 | 2026-06-17 |
| 1515 Urbino Ave | single_family | 5 | 7 | 4,111 | $5,100,000 | 2026-05-29 |
| 4819 University Dr | single_family | 5 | 4 | 3,451 | $3,850,000 | 2026-04-16 |
| 6636 Riviera Dr | single_family | 5 | 6 | 6,299 | $8,000,000 | 2026-04-03 |
| 4144 Pinta Ct | single_family | 5 | 4 | 4,329 | $5,200,000 | 2026-03-09 |
| 1033 Hardee Rd | single_family | 5 | 5 | 3,432 | $3,500,000 | 2026-01-20 |
| 1522 Zuleta Ave | single_family | 5 | 3 | 2,599 | $1,675,000 | 2025-11-12 |
| 1511 Alegriano Ave | single_family | 5 | 6 | 3,842 | $3,925,000 | 2025-10-29 |
| 1510 Sarria Ave | single_family | 5 | 5 | 3,360 | $3,025,000 | 2025-09-26 |
| 5008 Alhambra Cir | single_family | 5 | 5 | 2,630 | $1,337,500 | 2025-09-19 |
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 |
|---|---|---|---|---|---|---|
| 4041 S Le Jeune Rd | single_family | 5 | 6 | 4,208 | $7,550,000 | — |
| 1220 S Alhambra Cir | single_family | 5 | 6 | 4,074 | $5,950,000 | — |
| 1015 Bayamo Ave | single_family | 5 | 4 | 3,317 | $4,495,000 | — |
| 4128 Pinta Ct | single_family | 5 | 5 | 3,672 | $4,300,000 | — |
| 4001 Santa Maria St | single_family | 5 | 4 | 3,166 | $3,800,000 | — |
| 6900 Barquera St | single_family | 5 | 6 | 4,993 | $5,290,000 | — |
| 4716 University Dr | single_family | 5 | 4 | 4,024 | $4,100,000 | — |
| 475 Amalfi Ave | single_family | 5 | 5 | 5,084 | $7,350,000 | — |
10-year hold projection
IRR-5.9%
Equity multiple0.01x
Total return (10yr)-$671,202
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $5,922,500 | $25,950 | -$340,780 | $4,550,126 | $1,372,374 |
| 2 | $6,100,175 | $27,703 | -$339,327 | $4,496,827 | $1,603,348 |
| 3 | $6,283,180 | $29,532 | -$337,805 | $4,439,867 | $1,843,313 |
| 4 | $6,471,676 | $31,442 | -$336,211 | $4,378,997 | $2,092,679 |
| 5 | $6,665,826 | $33,434 | -$334,541 | $4,313,946 | $2,351,880 |
| 6 | $6,865,801 | $35,513 | -$332,794 | $4,244,428 | $2,621,373 |
| 7 | $7,071,775 | $37,680 | -$330,966 | $4,170,136 | $2,901,638 |
| 8 | $7,283,928 | $39,941 | -$329,054 | $4,090,743 | $3,193,185 |
| 9 | $7,502,446 | $42,297 | -$327,054 | $4,005,897 | $3,496,548 |
| 10 | $7,727,519 | $44,753 | -$324,963 | $3,915,226 | $3,812,294 |
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.