1514 Consolata Ave
Coral Gables, FL 33146 · single_family · Pending — under contract · 196 days on market
Asking price$5,250,000
6 beds 6 baths 4,455 sqft
Suggested offer$5,235,204$14,796 above the est. market value of $5,235,204.
View on Realtor.com →Listed by Andres Goldstuecker · Metrocoma Realty
Typesingle_family
Built2026
Price / sqft$1178
Est. value (own analysis)$5,235,204
Rent estimate (own analysis)$30,000/mo
HOANone
1 / 49
Show every detail
Statusfor_sale
Listed date2026-02-18
Removed date—
MLSMiamiMLS #A11966626
Coordinates25.71730, -80.28458
Address1514 Consolata Ave
CityCoral Gables
StateFL
Zip33146
Listing ID5726949009
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,250,000 |
| Down payment (20.0%) | $1,050,000 |
| Loan amount | $4,200,000 |
| Closing costs (5.0%) | $262,500 |
| Total cash to close | $1,312,500 |
| Income | |
| Rent (comp-derived) | $30,000$360,000 |
| Vacancy loss (8.0%) | |
| Effective gross income | $27,600$331,200 |
| Operating expenses | |
| Property tax (placeholder 1.9% of price) | $8,313$99,750 |
| Insurance (placeholder 0.8% of price) | $3,500$42,000 |
| HOA dues | $0$0 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $1,500$18,000 |
| Total operating expenses | $13,313$159,750 |
| 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,500$18,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
Widened to city-wide. Real active rental listings, used to derive the rent estimate above.
| Address | Type | Beds | Baths | Sqft | Asking rent | Listed | Days on market |
|---|---|---|---|---|---|---|---|
| single_family | 6 | 8 | 9,099 | $85,000 | 2026-05-04 | — | |
| single_family | 6 | 5 | 5,396 | $30,000 | 2026-02-13 | — | |
| single_family | 6 | 7 | 5,922 | $27,000 | 2026-08-10 | — |
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 |
|---|---|---|---|---|---|---|
| 5523 Alhambra Cir | single_family | 6 | 5 | 7,212 | $5,300,000 | 2026-03-16 |
| 420 Barbarossa Ave | single_family | 6 | 7 | 5,530 | $6,200,000 | 2026-01-05 |
| 6312 Riviera Dr | single_family | 6 | 6 | 9,550 | $32,000,000 | 2025-12-16 |
| 6400 San Vicente St | single_family | 6 | 8 | 6,102 | $7,500,000 | 2025-11-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.
| Address | Type | Beds | Baths | Sqft | Asking price | Days on market |
|---|---|---|---|---|---|---|
| 3917 SW 42nd Ave | single_family | 6 | 6 | 4,898 | $4,550,000 | — |
| 6716 San Vicente St | single_family | 6 | 6 | 5,250 | $7,899,000 | — |
| 5343 Orduna Dr | single_family | 6 | 5 | 3,950 | $6,998,000 | — |
| 6520 San Vicente St | single_family | 6 | 7 | 5,020 | $7,500,000 | — |
10-year hold projection
IRR1.5%
Equity multiple1.24x
Total return (10yr)$997,386
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $5,407,500 | $171,450 | -$170,434 | $4,154,463 | $1,253,037 |
| 2 | $5,569,725 | $177,392 | -$164,942 | $4,105,798 | $1,463,927 |
| 3 | $5,736,817 | $183,533 | -$159,262 | $4,053,792 | $1,683,025 |
| 4 | $5,908,921 | $189,878 | -$153,390 | $3,998,214 | $1,910,707 |
| 5 | $6,086,189 | $196,434 | -$147,318 | $3,938,820 | $2,147,369 |
| 6 | $6,268,775 | $203,209 | -$141,040 | $3,875,347 | $2,393,427 |
| 7 | $6,456,838 | $210,209 | -$134,549 | $3,807,516 | $2,649,322 |
| 8 | $6,650,543 | $217,442 | -$127,839 | $3,735,026 | $2,915,517 |
| 9 | $6,850,059 | $224,914 | -$120,901 | $3,657,559 | $3,192,500 |
| 10 | $7,055,561 | $232,635 | -$113,728 | $3,574,771 | $3,480,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.