7150 W Lago Dr
Coral Gables, FL 33143 · single_family · For Sale · 182 days on market
Asking price$15,950,000
6 beds 7 baths 6,622 sqft
Suggested offer$7,595,765$8,354,235 above the est. market value of $7,595,765.
View on Realtor.com →Listed by Saddy Abaunza Delgado · One Sotheby's International Realty
Typesingle_family
Built1988
Price / sqft$2409
Est. value (own analysis)$7,595,765
Rent estimate (own analysis)$30,000/mo
HOA$600/mo
1 / 38
Show every detail
Statusfor_sale
Listed date2026-03-04
Removed date—
MLSMiamiMLS #A11975747
Coordinates25.70073, -80.25771
Address7150 W Lago Dr
CityCoral Gables
StateFL
Zip33143
Listing ID5848361450
Sourceus-real-estate-listings, cached 2026-08-31
ZIP market snapshot (33143)
Typical home value (ZHVI)$957,553
Typical rent (ZORI)$2,761/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 | $15,950,000 |
| Down payment (20.0%) | $3,190,000 |
| Loan amount | $12,760,000 |
| Closing costs (5.0%) | $797,500 |
| Total cash to close | $3,987,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) | $25,254$303,050 |
| Insurance (placeholder 0.8% of price) | $10,633$127,600 |
| HOA dues | $600$7,200 |
| Management (0.0% of EGI) | $0$0 |
| Maintenance (5.0% of GSR) | $1,500$18,000 |
| Total operating expenses | $37,988$455,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,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
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 | 6 | 6 | 5,322 | $28,000 | 2026-06-17 | — | |
| single_family | 6 | 8 | 9,099 | $85,000 | 2026-05-04 | — | |
| single_family | 6 | 5 | 5,396 | $30,000 | 2026-02-13 | — |
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 |
|---|---|---|---|---|---|---|
| 7426 SW 49th Pl | single_family | 6 | 7 | 5,848 | $9,250,000 | 2026-08-05 |
| 6641 SW 85th St | single_family | 6 | 8 | 5,266 | $5,900,000 | 2026-07-30 |
| 7900 SW 57th Ct | single_family | 6 | 7 | 4,866 | $5,795,000 | 2026-07-02 |
| 277 Veleros Ct | single_family | 6 | 7 | 6,700 | $10,500,000 | 2026-06-30 |
| 7900 SW 54th Ave | single_family | 6 | 7 | 5,068 | $4,950,000 | 2026-06-25 |
| 4790 SW 78th St | single_family | 6 | 7 | 7,787 | $11,700,000 | 2026-06-25 |
| 6250 SW 78th St | single_family | 6 | 8 | 5,494 | $4,275,000 | 2026-06-24 |
| 7030 SW 72nd Ct | single_family | 6 | 8 | 5,112 | $3,800,000 | 2026-06-16 |
| 620 Tibidabo Ave | single_family | 6 | 6 | 3,924 | $5,159,500 | 2026-06-12 |
| 4871 SW 74th Ter | single_family | 6 | 6 | 5,521 | $8,500,000 | 2026-06-01 |
| 350 Costa Brava Ct | single_family | 6 | 5 | 5,938 | $6,000,000 | 2026-05-28 |
| 6450 SW 82nd St | single_family | 6 | 8 | 5,131 | $5,150,000 | 2026-05-22 |
| 7605 SW 71st Ave | single_family | 6 | 8 | 5,710 | $5,075,000 | 2026-05-19 |
| 7610 SW 48th Ct | single_family | 6 | 8 | 6,265 | $10,148,000 | 2026-05-09 |
| 7965 SW 53rd Ave | single_family | 6 | 6 | 4,093 | $5,600,000 | 2026-04-24 |
| 501 Casuarina Concourse | single_family | 6 | 6 | 9,682 | $55,000,000 | 2026-04-22 |
| 535 Casuarina Concourse | single_family | 6 | 6 | 6,680 | $55,000,000 | 2026-04-22 |
| 5001 Pine Dr | single_family | 6 | 8 | 4,395 | $13,500,000 | 2026-04-08 |
| 5847 SW 81st St | single_family | 6 | 7 | 4,973 | $6,200,000 | 2026-04-07 |
| 7001 SW 71st Ave | single_family | 6 | 8 | 5,473 | $4,700,000 | 2026-04-06 |
| 12 Tahiti Beach Island Rd | single_family | 6 | 9 | 10,441 | $32,000,000 | 2026-03-31 |
| 6495 SW 85th St | single_family | 6 | 6 | 4,313 | $4,100,000 | 2026-03-20 |
| 6003 SW 80th St | single_family | 6 | 6 | 6,847 | $6,700,000 | 2026-03-16 |
| 7975 SW 52nd Ct | single_family | 6 | 7 | 5,888 | $4,500,000 | 2026-03-12 |
| 231 Costanera Rd | single_family | 6 | 6 | 5,442 | $10,250,000 | 2026-01-30 |
| 6021 SW 86th St | single_family | 6 | 8 | 5,112 | $6,000,000 | 2026-01-14 |
| 6900 SW 72nd Ct | single_family | 6 | 8 | 6,698 | $7,400,000 | 2025-12-22 |
| 8264 SW 84th Ter | single_family | 6 | 5 | 3,497 | $1,650,000 | 2025-12-19 |
| 506 Sunset Dr | single_family | 6 | 6 | 7,354 | $7,500,000 | 2025-12-08 |
| 6401 SW 84th St | single_family | 6 | 8 | 6,028 | $5,385,000 | 2025-12-05 |
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 |
|---|---|---|---|---|---|---|
| 7740 SW 52nd Ave | single_family | 6 | 8 | 6,936 | $8,750,000 | — |
| 5731 SW 62nd Ter | single_family | 6 | 6 | 1,938 | $1,250,000 | — |
| 7235 SW 54th Ave | single_family | 6 | 7 | — | $7,690,000 | — |
| 7895 SW 52nd Ct | single_family | 6 | 8 | 6,377 | $9,625,000 | — |
| 5002 SW 86th St | single_family | 6 | 8 | 5,908 | $8,250,000 | — |
| 7430 SW 66th St | single_family | 6 | 8 | 5,609 | $4,599,000 | — |
| 8755 SW 54th Ave | single_family | 6 | 7 | 12,152 | $19,950,000 | — |
| 7700 SW 50th Ct | single_family | 6 | 7 | 5,804 | $7,490,000 | — |
10-year hold projection
IRR-8.9%
Equity multiple-0.52x
Total return (10yr)-$3,966,818
| Year | Property value | NOI | Cash flow | Loan balance | Equity |
|---|---|---|---|---|---|
| 1 | $16,428,500 | -$124,650 | -$1,126,640 | $12,621,653 | $3,806,847 |
| 2 | $16,921,355 | -$126,110 | -$1,128,551 | $12,473,806 | $4,447,549 |
| 3 | $17,428,996 | -$127,557 | -$1,130,459 | $12,315,806 | $5,113,190 |
| 4 | $17,951,866 | -$128,989 | -$1,132,364 | $12,146,956 | $5,804,910 |
| 5 | $18,490,421 | -$130,405 | -$1,134,264 | $11,966,511 | $6,523,911 |
| 6 | $19,045,134 | -$131,801 | -$1,136,157 | $11,773,674 | $7,271,460 |
| 7 | $19,616,488 | -$133,176 | -$1,138,041 | $11,567,595 | $8,048,893 |
| 8 | $20,204,983 | -$134,528 | -$1,139,915 | $11,347,365 | $8,857,618 |
| 9 | $20,811,132 | -$135,855 | -$1,141,776 | $11,112,011 | $9,699,121 |
| 10 | $21,435,466 | -$137,153 | -$1,143,623 | $10,860,495 | $10,574,971 |
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.