515 Valencia Ave Unit 802

Coral Gables, FL 33134 · condos · For Sale · 76 days on market
Asking price$3,800,000
4 beds 5 baths 3,210 sqft
Suggested offer$1,759,369$2,040,631 above the est. market value of $1,759,369.
View on Realtor.com →
Listed by Alejandro Pis-dudot · Coldwell Banker Realty
Typecondos
Built2022
Price / sqft$1184
Est. value (own analysis)$1,759,369
Rent estimate (Zillow ZIP avg)$3,095/mo
HOA$5,304/mo
Wind10/10Extreme$Heat10/10ExtremeFlood3/10moderate$Air2/10MinorWildfire1/10Minimal
Street view
View full map & nearby schools →

Neighborhood

Show every detail
Statusfor_sale
Listed date2026-06-18
Removed date
MLSMiamiMLS #A12038453
Coordinates25.74757, -80.26533
Address515 Valencia Ave Unit 802
CityCoral Gables
StateFL
Zip33134
Listing ID9960200141
Sourceus-real-estate-listings, cached 2026-08-30

ZIP market snapshot (33134)

Typical home value (ZHVI)$887,965
Typical rent (ZORI)$3,095/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$3,800,000
Down payment (20.0%)$760,000
Loan amount$3,040,000
Closing costs (5.0%)$190,000
Total cash to close$950,000
Rent (ZIP avg, ZORI — not bedroom-specific)$3,095$37,137
Vacancy loss (8.0%)

Vacancy Loss

Gross Scheduled Rent × Vacancy Rate

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

$37,137 × 8.0% = $2,971

Effective gross income$2,847$34,166
Property tax (placeholder 1.9% of price)$6,017$72,200
Insurance (est. scaled by flood & wind risk)$4,053$48,640
HOA dues$5,304$63,648
Management (0.0% of EGI)$0$0
Maintenance (5.0% of GSR)$155$1,857
Total operating expenses$15,529$186,345
Net operating income (NOI)

Net Operating Income (NOI)

Effective Gross Income − Total Operating Expenses

Effective gross income derived$34,166
Total operating expenses derived$186,345

$34,166 − $186,345 = -$152,179

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

$3,040,000 amortized at 6.7% over 30 years = $19,536/mo

CapEx reserve (5.0% of GSR)$155$1,857
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-$152,179
Annual debt service derived$234,430
Annual CapEx reserve assumption$1,857
Annual PMI assumption$0

(-$152,179 − $234,430 − $1,857 − $0) ÷ 12 = -$32,372

Cap rate

Cap Rate

NOI ÷ Purchase Price

NOI derived-$152,179
Purchase price data$3,800,000

-$152,179 ÷ $3,800,000 = -4.0%

Cash-on-cash

Cash-on-Cash Return

Annual Cash Flow ÷ Total Cash Invested

Annual cash flow derived-$388,466
Total cash to close derived$950,000

-$388,466 ÷ $950,000 = -40.9%

DSCR

Debt Service Coverage Ratio (DSCR)

NOI ÷ Annual Debt Service

NOI derived-$152,179
Annual debt service derived$234,430

-$152,179 ÷ $234,430 = -0.65

Rent-to-price (1% rule)

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

(Gross Scheduled Rent ÷ 12) ÷ Purchase Price

Gross scheduled rent (annual) comp$37,137
Purchase price data$3,800,000

($37,137 ÷ 12) ÷ $3,800,000 = 0.1%

Gross rent multiplier

Gross Rent Multiplier (GRM)

Purchase Price ÷ Gross Scheduled Rent

Purchase price data$3,800,000
Gross scheduled rent (annual) comp$37,137

$3,800,000 ÷ $37,137 = 102.3

Operating expense ratio

Operating Expense Ratio

Total Operating Expenses ÷ Effective Gross Income

Total operating expenses derived$186,345
Effective gross income derived$34,166

$186,345 ÷ $34,166 = 545.4%

Break-even occupancy

Break-Even Occupancy

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

Total operating expenses derived$186,345
Annual debt service derived$234,430
Annual PMI assumption$0
Gross scheduled rent (annual) comp$37,137

($186,345 + $234,430 + $0) ÷ $37,137 = 1133.0%

Comparables

Widened to city-wide. Real active rental listings, used to derive the rent estimate above.

AddressTypeBedsBathsSqftAsking rentListedDays on market
apartment421,863$4,5002026-07-22
apartment421,745$4,2002026-05-05

4855 University Dr Unit 4855

Coral Gables, 33146 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage1,863
Listed2026-07-22
Days on market

Asking rent: $4,500

View on Zillow →

517 Menendez Ave

Coral Gables, 33146 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage1,745
Listed2026-05-05
Days on market

Asking rent: $4,200

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
441 Valencia Ave Apt 1201condos341,713$1,275,0002026-08-26
1300 Ponce De Leon Blvd Apt 815condos221,111$775,0002026-08-26
3881 W Flagler St Apt 318condos21707$201,8512026-08-12
55 Merrick Way Apt 831condos321,553$915,0002026-08-10
1650 Galiano St Apt TH15condos231,792$1,000,0002026-08-07
650 Valencia Ave Unit 302condos332,365$1,510,0002026-08-06
55 Merrick Way Apt 812condos331,611$975,0002026-08-03
100 Andalusia Ave Apt 410condos12929$506,0002026-07-31
1110 Salzedo St Apt 2Ccondos22969$350,0002026-07-31
700 Biltmore Way Apt 314condos01450$215,0002026-07-30
626 Coral Way Apt 503condos321,531$1,175,0002026-07-17
235 Antilla Ave Apt 7condos231,015$405,0002026-07-15
124 Mendoza Ave Apt 6condos01351$200,0002026-07-10
1805 Ponce De Leon Blvd Apt 730condos11697$412,0002026-07-07
1300 Ponce De Leon Blvd Apt 603condos231,108$719,0002026-07-07
911 E Ponce De Leon Blvd Apt 1504condos22960$458,0002026-07-06
357 Almeria Ave Apt 1106condos22932$533,0002026-07-02
234 Antiquera Ave Apt 3condos221,080$150,0002026-07-01
126 Mendoza Ave Apt 5condos01351$165,0002026-07-01
700 Coral Way Apt 5condos333,200$1,950,0002026-06-30
700 Biltmore Way Apt 216condos01440$218,0002026-06-30
1805 Ponce De Leon Blvd Apt 823condos11779$420,0002026-06-30
888 S Douglas Rd Apt 1203condos221,126$485,0002026-06-25
357 Almeria Ave Apt 1006condos22932$510,8082026-06-24
411 Anastasia Ave Apt 303condos22986$450,0002026-06-24
600 Biltmore Way Apt 217condos221,129$530,0002026-06-22
55 Merrick Way Apt 507condos12784$460,0002026-06-18
1 Alhambra Cir Apt 403condos221,030$460,0002026-06-17
441 Valencia Ave Apt 302condos231,142$545,0002026-06-16
5271 SW 8th St Apt 212condos22970$330,0002026-06-12
721 Biltmore Way Apt 101condos12948$550,0002026-06-11
888 S Douglas Rd Apt 404condos321,351$606,0002026-06-11
11 SW 52nd Ave Apt 7Acondos11531$190,0002026-06-09
55 Merrick Way Apt 505condos11790$433,0002026-06-03
100 Andalusia Ave Apt 301condos231,246$750,0002026-06-01
100 Andalusia Ave Apt 408condos231,218$839,0002026-06-01
600 Biltmore Way Apt 718condos231,423$768,0002026-06-01
1607 Ponce De Leon Blvd Apt 12Econdos221,181$670,0002026-05-29
55 Merrick Way Apt 800condos231,167$710,0002026-05-26
718 Valencia Ave Unit 206condos231,972$1,250,0002026-05-20
700 Biltmore Way Apt 1008condos01450$220,0002026-05-19
625 Biltmore Way Apt 905condos221,094$500,0002026-05-14
625 Biltmore Way Apt 807condos221,369$600,0002026-05-13
642 Valencia Ave Unit 305condos231,932$1,215,0002026-05-08
626 Coral Way Apt 1104condos332,100$1,673,2502026-05-05
10 Aragon Ave Ste 1105condos321,654$839,5982026-04-30
1300 E Ponce De Leon Blvd Unit 514condos221,128$760,0002026-04-24
357 Almeria Ave Apt 1406condos22932$535,0002026-04-16
400 Valencia Ave Apt 3condos221,111$620,0002026-04-15
2030 S Douglas Rd Apt 511condos321,337$580,0002026-04-14

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
4701 SW 7th Stsingle_family431,830$750,000
4870 SW 6th Stsingle_family431,682$700,000
3788 SW 27th Lnmulti_family421,980$1,250,000
5330 SW 7th Stsingle_family432,424$2,500,000
2893-2895 SW 37th Ctmulti_family431,935$915,000
4450 W Flagler Stmulti_family442,103$1,000,000
4251 SW 11th Stsingle_family443,736$2,990,000
2841 SW 38th Ct Unit Btownhomes442,671$1,950,000

10-year hold projection

IRR-16.8%
Equity multiple-1.95x
Total return (10yr)-$2,301,691
YearProperty valueNOICash flowLoan balanceEquity
1$3,914,000-$152,179-$388,466$3,007,040$906,960
2$4,031,420-$155,812-$392,146$2,971,816$1,059,604
3$4,152,363-$159,531-$395,913$2,934,173$1,218,189
4$4,276,933-$163,339-$399,769$2,893,946$1,382,988
5$4,405,241-$167,235-$403,715$2,850,955$1,554,286
6$4,537,399-$171,224-$407,755$2,805,013$1,732,386
7$4,673,521-$175,306-$411,890$2,755,916$1,917,605
8$4,813,726-$179,485-$416,123$2,703,447$2,110,279
9$4,958,138-$183,762-$420,455$2,647,376$2,310,763
10$5,106,882-$188,140-$424,889$2,587,453$2,519,429
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.