17150 N Bay Rd #2122 · Sunny Isles Beach, FL 33160

$327,000

1 bd · 1.0 ba · 673 sqft · Condo public records · 93 Days on market

Built 2003 $615/mo HOA · 17% of rent

---

Why this score? — see what drove the C- grade

The composite is a weighted blend of 9 inputs, each scored 0–100. Each bar is that input's sub-score; the figure is the points it added to the 100-point composite (weight × sub-score).

• Cash flow +14.0/30.0
• ARV discount +7.5/15.0
• 1% rule +6.1/10.0
• Appreciation +5.3/10.0
• DSCR +4.3/10.0
• Livability +4.3/5.0
• Schools +4.2/10.0
• Rent growth +2.7/5.0
• Condition / age +2.5/5.0

Listing remarks MLS

PRICED TO SELL, Porto Bellagio Sunny Isles. Steps from the beach, this unique 1/1 is situated on the bay. Quiet and bright courtyard exposure, this property boasts an oversized living room with outdoor patio, separate dining area, open renovated kitchen and King sized master bedroom with massive walk in closet. The apartment has washer dryer windowed bathroom w/ tub & shower. Amenities include bay front promenade, parking, pool, jacuzzi, fitness center, party room, on-site management.

Key facts

• Business center
• Billiards
• Washer and dryer

Tags

• GARDEN VIEWS
• WASHER AND DRYER
• POOL
• BILLIARDS
• GYM
• BUSINESS CENTER

Property features AI

Finance

• Financial info: Lease considered; Pets allowed with restrictions or possible restrictions
• HOA & community: Monthly association fee of $615 covering amenities; Association offers bike storage

Exterior

• Parking: Attached garage with 1 covered space
• Security: Doorman; Complex fenced
• Utilities: Cable available
• Home design: Attached property; 8-story building; First-floor entry
• Construction: Block construction
• Exterior features: Courtyard; Complex is fenced; Doorman

Interior

• Kitchen: Dishwasher; Electric range; Microwave; Refrigerator; Garbage disposal
• Bedrooms: Bedroom located on the main level
• Flooring: Laminate flooring
• Bathrooms: 1 full bathroom
• Heating & cooling: Central heating; Central air conditioning
• Interior features: Impact glass windows; Bedroom on main level; First floor entry
• Laundry & utility: Dryer; Electric water heater

What this means for you Summary

Snapshot

• This is a 1-bed/1.0-bath condo listed at $327k.

Deal economics

• At list price, monthly cash flow is $-383 ($-5k/yr) — negative.
• To cash-flow at today's rent, offer at most $259k (20.7% below list).
• Meets the 1% rule at list price ($4k rent vs $327k).
• Recommended offer: $259k (20.7% below list) — sets the bar for cash-flow.
• Cap rate 6.5% vs local median 0.8% in Sunny Isles Beach — top-decile yield for the area; either an underpriced asset or a hidden risk that comps aren't pricing in. Stress-test before assuming the spread holds.

Location & tenants

• Location reads 86/100 on livability (#20 in FL, #434 nationally) — a professional / high-income tenant draw. Strengths: amenities A+, health & safety A+, crime A; Watch: housing C-, cost of living F.
• Miami-Dade (suburban): math 45% / reading 54% proficiency, ranked #40 of 73 in FL (top 55%) — families likely to look elsewhere, expect single-tenant / working-renter base with shorter leases; 64% free/reduced lunch — lower-income household profile, screen leases tightly.
• Zoned schools: Norman S. Edelcup/Sunny Isles Beach K-8 (math 68% / reading 69%, grade B+, #409 of 2,144 statewide, top 20%, 2,231 students, 30% FRL); Highland Oaks Middle School (math 28% / reading 51%, grade F, #373 of 571 statewide, top 66%, 774 students, 50% FRL); Alonzo & Tracy Mourning Senior High School (math 38% / reading 50%, grade F, #244 of 667 statewide, top 37%, 1,597 students, 48% FRL) — zoned schools average 43% FRL vs 64% district-wide (21 pts lower); this property's tenant base skews higher-income than the district average.
• Market conditions: Rents flat; 1879 active listings in the ZIP; 10,051 units permitted in Miami-Dade County in 2024 (7,758 in 5+ unit buildings).

Forward outlook

• In year one you build about $4k of equity ($2k loan paydown + $2k appreciation (0.5% local appreciation)).
• Miami-Dade County population projected at +28% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.
• By year 8, paydown + projected appreciation supports a ~$34k cash-out refi (75% LTV) — recoverable capital for the next deal without selling this one.

Negotiation context

• It's been on market 93 days — a 9% lower offer ($298k) is reasonable based on typical stale-listing flexibility.
• 7 sale attempts since 12y ago with the ask held roughly flat each time — persistent listings suggest the price (not the market) is what's stuck; bring a comps-based counter.
• Current owner paid $258k; 27% above their basis — modest negotiation headroom, anchor on the comps not their cost.

Risks & watch-outs

• Watch-outs: flood insurance adds $427/mo.
• Climate carrying-cost: in FEMA flood zone AE (mandatory federal flood insurance); severe wind risk, 99% chance of damaging wind over 30y; extreme-heat days projected 7→28/yr by 2055 (HVAC capex compounding) — expect insurance premiums to compound above CPI over the hold.

Recommended offer $259,385 (20.7% below list)

Questions for the listing agent

1. What do current leases actually rent for vs. the listed asking? Can we see a recent rent roll and the last 12 months of T-12 income?
2. It's been on market 93 days. Have you received any prior offers? Is the seller open to a 21% concession, seller financing, or rate buy-down credit?
3. What's the actual annual flood-insurance premium (NFIP or private), and is the property in a SFHA with mandatory coverage?
4. What does the HOA fee cover, when was the last increase, and are there any pending special assessments or reserve-fund shortfalls?
5. Any open or pending special assessments — roof, HVAC, plumbing, elevator, façade? What's the per-unit balance and payoff schedule, and is the seller paying it off at close or rolling it to the buyer?
6. Why hasn't it sold? Are there any deal-killer items the seller is aware of (foundation, flood, title, zoning, code violations)?
7. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
8. Schools are A-rated — typically a magnet for longer-tenancy family renters. What's the average tenant stay here, and is there a school-zone premium baked into asking?
9. What's the average days-on-market for RENTAL listings here right now (not sales)? A rising rental-DOM trend means longer vacancies and softer asking-rent achievability than the comps imply.
10. What's the recent tenant-quality profile in this submarket — average credit score on applications, eviction rate, late-payment / NSF rate, and stable-employment percentage? A property-management company in the area should have these aggregated.
11. How much new apartment / multifamily construction is in the pipeline within 1–3 miles? Heavy new supply (>2% of stock underway) typically softens rents 12–24 months out; light construction supports rent growth.

Investment metrics

• 1% rule: 1.11% ✓
• Cap rate: 6.45%
• Cash-on-cash: 0.57%
• DSCR: 1.03
• GRM: 7.5

CMA / ARV

No comps found within radius.

Projected returns pro-forma

0.53% appreciation · 0.94% rent growth · sell at horizon

5-year hold

• IRR: -7.4%
• Equity multiple: 0.65×
• Total profit: $-32,460
• Equity at exit: $103,657

10-year hold

• IRR: -3.4%
• Equity multiple: 0.63×
• Total profit: $-33,594
• Equity at exit: $131,779

Cash invested: $91,560 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

• Overall (STATE): 87 Strongly Landlord-Friendly
• State Florida: 87 Strongly Landlord-Friendly · R+3
• County: — inherits STATE
• City: — inherits STATE

3-day pay-or-quit; preempts local rent control; landlord-friendly statutes. Court speed varies by county.

Methodology + full state rankings →

ZIP-level market 33160

• Home prices YoY: 0.2%
• Rents YoY: 0.9%
• Active inventory: 1879
• Price-to-rent: 7.5×

Monthly cashflow live

• Estimated rent: $3,624 medium
• Mortgage (P&I): −$1,715
• Tax from tax record: −$353 /mo · $4,237/yr
• Insurance: −$136
• Flood insurance flood zone: −$427 /mo · $5,118/yr
• HOA: −$615
• Vacancy / Maint / Mgmt: −$761
• Net cashflow: $-383

Break-even live

Break-even rent $4,108

Max offer price $259,385

Occupancy floor —

Sensitivity live

Price	-10% $-198	-5% $-290	+0% $-383	+5% $-475	+10% $-568
Rent	-10% $-669	-5% $-526	+0% $-383	+5% $-240	+10% $-96
Rate	-1.0pp $-218	-0.5pp $-300	base $-383	+0.5pp $-467	+1.0pp $-554

UW: 25.0% down · 7.5% · 30yr · 1.5% tax · 5.0% vac · 8.0% maint · 8.0% mgmt

Financing live

Cash to close

• Down payment: $81,750
• Closing costs: $9,810
• Reserves months: —
• Total cash needed: —

HOA detail condo

• Monthly dues: $615 · $7,380/yr
• Likely covers: poolgym
• Assessments: None detected in remarks — confirm with the listing agent.

Listing history 36 events

1. 2026-06-21
   days on market $327,000 Active 93 DOM
2. 2026-06-18
   days on market $327,000 Active 90 DOM
3. 2026-06-17
   days on market $327,000 Active 89 DOM
4. 2026-06-16
   days on market $327,000 Active 88 DOM
5. 2026-06-15
   days on market $327,000 Active 87 DOM
6. 2026-06-13
   days on market $327,000 Active 85 DOM
7. 2026-06-09
   days on market $327,000 Active 81 DOM
8. 2026-06-08
   days on market $327,000 Active 80 DOM
9. 2026-06-07
   days on market $327,000 Active 79 DOM
10. 2026-06-04
    days on market $327,000 Active 76 DOM
11. 2026-06-03
    days on market $327,000 Active 75 DOM
12. 2026-06-02
    days on market $327,000 Active 74 DOM
13. 2026-06-02
    price $327,000 Active 73 DOM
14. 2026-06-01
    days on market $328,000 Active 73 DOM
15. 2026-05-31
    days on market $328,000 Active 72 DOM
16. 2026-05-22
    price $2,125
17. 2026-05-21
    price $328,000
18. 2026-04-28
    price $2,225
19. 2026-04-13
    price $2,125
20. 2026-03-26
    price $2,150
21. 2026-03-20
    listed $335,000 Active
22. 2026-03-19
    listed $2,199
23. 2026-02-18
    historical $2,225
24. 2026-02-04
    listed $2,225
25. 2026-01-28
    historical $2,250
26. 2026-01-06
    price $2,250
27. 2025-12-27
    price $2,350
28. 2025-12-05
    listed $2,390
29. 2025-11-26
    historical $2,400
30. 2025-11-04
    listed $2,400
31. 2023-10-03
    historical $2,300
32. 2023-10-02
    listed $2,300
33. 2014-10-28
    soldstatus $258,000
34. 2014-10-22
    soldstatus $258,000 Sold 500-char remark

    Show marketing remark (500 chars)

    PRICED TO SELL, Porto Bellagio Sunny Isles. Steps from the beach, this unique 1/1 is situated on the bay. Quiet and bright courtyard exposure, this property boasts an oversized living room with outdoor patio, separate dining area, open renovated kitchen and King sized master bedroom with massive walk in closet. The apartment has washer dryer windowed bathroom w/ tub & shower. Amenities include bay front promenade, parking, pool, jacuzzi, fitness center, party room, on-site management.

35. 2014-07-03
    listed $268,000 Active 500-char remark

    Show marketing remark (500 chars)

    PRICED TO SELL, Porto Bellagio Sunny Isles. Steps from the beach, this unique 1/1 is situated on the bay. Quiet and bright courtyard exposure, this property boasts an oversized living room with outdoor patio, separate dining area, open renovated kitchen and King sized master bedroom with massive walk in closet. The apartment has washer dryer windowed bathroom w/ tub & shower. Amenities include bay front promenade, parking, pool, jacuzzi, fitness center, party room, on-site management.

36. 2004-05-14
    soldstatus $119,500,000

ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot backfill from property_details.listing_events for pre-trigger history.

Tax reassessment forecast FL · Resets to sale price

• Current annual tax: $4,237 · $353/mo
• Projected year-2 tax: $4,237 · $353/mo
• Expected delta: $0/yr ($0/mo · 0.0%)

ⓘ Screening estimate from a state-policy table — verify with the county assessor before closing.

Climate risk First Street

• 🌊 Flood 9/10 Extreme FEMA zone AE · 99% chance over 30 yrs
• 🔥 Wildfire 1/10 Low
• 🌡 Heat 10/10 Extreme 7 d/yr ≥103°F today · 28 d/yr by 30 yrs out
• 💨 Wind 10/10 Extreme 99% chance of damaging wind over 30 yrs
• 🫁 Air quality 2/10 Low 1 unhealthy d/yr today · 2 by 30 yrs out

Taxation est. · year 1

• Rental income: $43,488
• − Mortgage interest: −$18,317
• − Property taxes: −$4,237
• − Insurance: −$6,754
• − Repairs & maintenance: −$3,479
• − Management: −$3,479
• − HOA: −$7,380
• − Depreciation: −$9,513
• Taxable loss: −$9,671
• Est. tax savings @ 24.0%: +$2,321
• After-tax cash flow: $-2,272/yr

For passive investors: Depreciation is non-cash, so a rental often shows a tax loss while cash-flowing — sheltering income. Rental losses are passive: they offset passive income freely, and up to $25,000/yr can offset ordinary (W-2) income if you actively participate and your MAGI is under $100k (phasing out to $0 by $150k); unused losses carry forward. On sale, claimed depreciation is recaptured at up to 25%, and gains may owe capital-gains tax (a 1031 exchange can defer both). Figures are a year-1 estimate at your 24.0% rate — not tax advice; consult a CPA.

Schools (NCES district)

• District: Miami-Dade
• NCES district ID: 1200390
• Math proficiency: 45% ▼ -16.00%
• Reading proficiency: 54% ▼ -5.00%
• Median HH income: $43,928
• Composite: 41.76/100
• National rank: #3397
• State rank: #40 of 73 in FL

Livability — Sunny Isles Beach

• Score: 86/100
• State rank: #20
• US rank: #434

Category grades

Amenities A+ Commute A- Cost of living F Crime A Employment C Housing C- Health & safety A+ User ratings A+

Schools grade is shown separately in the Schools card above.

Census & demographics

• Census place: Sunny Isles Beach, FL
• County: Miami-Dade County · 2,697,751 people
• Metro: Miami-Fort Lauderdale-Pompano Beach, FL
• Population (ZIP): 43,718
• Household income: $67,040
• Rent vs Own: 41.0% rent · 59.0% own
• Severe rent burden: 3106.0

Population outlook (Miami-Dade County) Hauer SSP2

• Today (2025): 3,126,439 people
• By 2030: 3,325,765 · +6.4%
• By 2040: 3,697,561 · +18.3%
• By 2050: 4,012,134 · +28.3%
• By 2075: 4,605,612 · +47.3%
• By 2100: 4,866,598 · +55.7%

Race, ethnicity, and origin ACS 2023

• Neighborhood character: Diverse neighborhood (Simpson 0.59)
• Race & ethnicity: Hispanic / Latino 46% White 44% Two or more races 27% Black 4% Asian 2%
• Hispanic origin (detail): Mexican 1% Puerto Rican 3% Cuban 8% Dominican 1% Salvadoran 4%
• Common ancestry: Scotch-Irish 8% Hispanic 3% Subsaharan African 3%
• Foreign-born: 61% · Canada, Jamaica, Dominican Republic
• Languages at home: 29% English-only · Spanish 45% Russian/Polish/Slavic 12% Other Indo-European 5%

Political lean MEDSL · Miami-Dade

• 2024 margin: R (+11.4) · D 43.9% · R 55.4%
• 2008→2024 swing: -27.6pp toward R · 2008: 16.1pp · 2024: -11.4pp
• All cycles: 2024: R+11.4 2020: D+7.3 2016: D+29.6 2012: D+23.7 2008: D+16.1

Not yet ingested

• Civics: —

Market trends

• HPI YoY: ▲ 0.53%
• Current HPI: 284.9293
• Rent YoY: ▲ 0.94%
• Metro: Miami-Fort Lauderdale-Pompano Beach, FL
• State GDP YoY: ▲ 3.28%
• F500 in state: 36

Industry mix (Fortune 500 HQ in FL)

Industry	F500 HQs	Revenue
▸Industrial Technology	2	$29B
▸Insurance	2	$17B
▸Retail	1	$60B
▸Technology Distribution	1	$58B
▸Homebuilding	1	$35B
▸Technology Manufacturing	1	$35B

Price history

-100.0% since first listed

21 events — show timeline

• 2026-05-22 Price Changed $2,125 MARMLS
• 2026-05-21 Price Changed $328,000 MARMLS
• 2026-04-28 Price Changed $2,225 MARMLS
• 2026-04-13 Price Changed $2,125 MARMLS
• 2026-03-26 Price Changed $2,150 MARMLS
• 2026-03-20 Listed $335,000 MARMLS
• 2026-03-19 Listed for Rent $2,199 MARMLS
• 2026-02-18 Rental Removed $2,225 MARMLS
• 2026-02-04 Listed for Rent $2,225 MARMLS
• 2026-01-28 Rental Removed $2,250 MARMLS
• 2026-01-06 Price Changed $2,250 MARMLS
• 2025-12-27 Price Changed $2,350 MARMLS
• 2025-12-05 Listed for Rent $2,390 MARMLS
• 2025-11-26 Rental Removed $2,400 MARMLS
• 2025-11-04 Listed for Rent $2,400 MARMLS
• 2023-10-03 Rental Removed $2,300 MARMLS
• 2023-10-02 Listed for Rent $2,300 MARMLS
• 2014-10-28 Sold (Public Records) $258,000 Public Records
• 2014-10-22 Sold (MLS) $258,000 MARMLS
• 2014-07-03 Listed $268,000 MARMLS
• 2004-05-14 Sold (Public Records) $119,500,000 Public Records

Property tax history

+6.5%/yr

Latest (2025): $4,237 · +5.0% YoY. Source: county tax records.