17670 SW 154th Pl

Miami, FL 33187 · single_family · For Sale · 44 days on market
Asking price$819,900
4 beds 4 baths 3,090 sqft
View on Realtor.com →
Listed by Alejandro Mirambell · Chez Realty, LLC.
Typesingle_family
Built2014
Price / sqft$265
Est. value (own analysis)$1,141,848
Rent estimate (own analysis)$4,350/mo
HOA$195/mo
Street view
View full map & nearby schools →

Neighborhood

Show every detail
Statusfor_sale
Listed date2026-07-20
Removed date
MLSMiamiMLS #A12054445
Coordinates25.60268, -80.44394
Address17670 SW 154th Pl
CityMiami
StateFL
Zip33187
Listing ID5940699849
Sourceus-real-estate-listings, cached 2026-08-28

ZIP market snapshot (33187)

Typical home value (ZHVI)$720,811
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$819,900
Down payment (20.0%)$163,980
Loan amount$655,920
Closing costs (5.0%)$40,995
Total cash to close$204,975
Rent (comp-derived)$4,350$52,200
Vacancy loss (8.0%)

Vacancy Loss

Gross Scheduled Rent × Vacancy Rate

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

$52,200 × 8.0% = $4,176

Effective gross income$4,002$48,024
Property tax (placeholder 1.9% of price)$1,298$15,578
Insurance (placeholder 0.8% of price)$547$6,559
HOA dues$195$2,340
Management (0.0% of EGI)$0$0
Maintenance (5.0% of GSR)$218$2,610
Total operating expenses$2,257$27,087
Net operating income (NOI)

Net Operating Income (NOI)

Effective Gross Income − Total Operating Expenses

Effective gross income derived$48,024
Total operating expenses derived$27,087

$48,024 − $27,087 = $20,937

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

$655,920 amortized at 6.7% over 30 years = $4,215/mo

CapEx reserve (5.0% of GSR)$218$2,610
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$20,937
Annual debt service derived$50,581
Annual CapEx reserve assumption$2,610
Annual PMI assumption$0

($20,937 − $50,581 − $2,610 − $0) ÷ 12 = -$2,688

Cap rate

Cap Rate

NOI ÷ Purchase Price

NOI derived$20,937
Purchase price data$819,900

$20,937 ÷ $819,900 = 2.6%

Cash-on-cash

Cash-on-Cash Return

Annual Cash Flow ÷ Total Cash Invested

Annual cash flow derived-$32,255
Total cash to close derived$204,975

-$32,255 ÷ $204,975 = -15.7%

DSCR

Debt Service Coverage Ratio (DSCR)

NOI ÷ Annual Debt Service

NOI derived$20,937
Annual debt service derived$50,581

$20,937 ÷ $50,581 = 0.41

Rent-to-price (1% rule)

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

(Gross Scheduled Rent ÷ 12) ÷ Purchase Price

Gross scheduled rent (annual) comp$52,200
Purchase price data$819,900

($52,200 ÷ 12) ÷ $819,900 = 0.5%

Gross rent multiplier

Gross Rent Multiplier (GRM)

Purchase Price ÷ Gross Scheduled Rent

Purchase price data$819,900
Gross scheduled rent (annual) comp$52,200

$819,900 ÷ $52,200 = 15.7

Operating expense ratio

Operating Expense Ratio

Total Operating Expenses ÷ Effective Gross Income

Total operating expenses derived$27,087
Effective gross income derived$48,024

$27,087 ÷ $48,024 = 56.4%

Break-even occupancy

Break-Even Occupancy

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

Total operating expenses derived$27,087
Annual debt service derived$50,581
Annual PMI assumption$0
Gross scheduled rent (annual) comp$52,200

($27,087 + $50,581 + $0) ÷ $52,200 = 148.8%

Comparables

Same ZIP. Real active rental listings, used to derive the rent estimate above.

AddressTypeBedsBathsSqftAsking rentListedDays on market
single_family432,630$5,9002026-08-21
single_family422,070$4,1502026-08-16
single_family423,058$4,5002026-06-25
single_family432,630$5,9002026-06-25
single_family432,522$3,780
single_family422,026$4,2002026-08-25
single_family422,341$3,900
single_family433,948$7,4002026-08-31

21375 SW 177th Ct # 33187

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 3 ba
Square footage2,630
Listed2026-08-21
Days on market

Asking rent: $5,900

View on Zillow →

14842 SW 171st Ter

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage2,070
Listed2026-08-16
Days on market

Asking rent: $4,150

View on Zillow →

18370 SW 212th St

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage3,058
Listed2026-06-25
Days on market

Asking rent: $4,500

View on Zillow →

21365 SW 177th Ct

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 3 ba
Square footage2,630
Listed2026-06-25
Days on market

Asking rent: $5,900

View on Zillow →

17111 SW 153rd Pl

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 3 ba
Square footage2,522
Listed
Days on market

Asking rent: $3,780

View on Zillow →

15660 SW 152nd Pl

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage2,026
Listed2026-08-25
Days on market

Asking rent: $4,200

View on Zillow →

14865 SW 166th St

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 2 ba
Square footage2,341
Listed
Days on market

Asking rent: $3,900

View on Zillow →

16200 SW 173rd Ave Unit 1

Miami, 33187 · rent comp

Bedrooms / bathrooms4 bd / 3 ba
Square footage3,948
Listed2026-08-31
Days on market

Asking rent: $7,400

View on Zillow →

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.

AddressTypeBedsBathsLiving sqftSale priceSale date
18280 SW 202nd Stsingle_family435,310$1,275,0002026-08-31
15102 SW 177th Tersingle_family442,612$720,0002026-08-19
17766 SW 154th Plsingle_family421,627$615,0002026-08-10
15530 SW 155th Avesingle_family422,667$850,0002026-07-30
20520 SW 190th Stsingle_family433,540$1,400,0002026-07-20
14802 SW 176th Tersingle_family421,723$776,0002026-07-20
19155 SW 190th Stsingle_family421,899$650,0002026-07-15
18163 SW 149th Plsingle_family442,342$799,0002026-07-14
16101 SW 153rd Avesingle_family432,396$787,0002026-07-14
15296 SW 168th Stsingle_family432,107$945,0002026-07-09
15523 SW 171st Stsingle_family432,166$710,0002026-06-30
14856 SW 174th Stsingle_family421,522$645,0002026-06-26
18895 SW 212th Stsingle_family441,264$950,0002026-06-26
19530 SW 210th Stsingle_family432,111$950,0002026-06-16
14721 SW 170th Tersingle_family421,753$760,0002026-06-05
15299 SW 167th Stsingle_family422,592$1,000,0002026-06-04
17113 SW 215th Tersingle_family432,805$984,0002026-05-30
15519 SW 182nd Lnsingle_family431,765$730,0002026-05-19
15182 SW 171st Stsingle_family432,001$699,0002026-05-18
15382 SW 153rd Stsingle_family421,898$839,0002026-05-18
21551 SW 187th Avesingle_family421,834$950,0002026-04-29
15235 SW 152nd Ctsingle_family422,338$849,9752026-04-29
14833 SW 164th Tersingle_family422,341$900,0002026-04-28
17475 SW 153rd Avesingle_family433,090$890,0002026-04-22
15322 SW 177th Tersingle_family421,647$665,0002026-04-17
16925 SW 170th Avesingle_family454,870$1,450,0002026-04-17
16122 SW 148th Avesingle_family432,324$740,0002026-04-15
15460 SW 176th Lnsingle_family432,265$620,0002026-04-06
15286 SW 178th Tersingle_family421,817$610,0002026-04-06
15845 SW 153rd Avesingle_family432,512$975,0002026-04-06
15280 SW 153rd Stsingle_family422,067$820,0002026-04-01
15151 SW 166th Stsingle_family422,881$862,0002026-03-27
18128 SW 151st Avesingle_family421,786$632,0002026-03-27
16141 SW 156th Avesingle_family432,576$950,0002026-03-26
19225 SW 186th Stsingle_family432,434$1,200,0002026-03-19
17023 SW 149th Plsingle_family422,055$679,0002026-03-18
18110 SW 153rd Ctsingle_family431,850$685,0002026-03-16
15151 SW 164th Tersingle_family422,592$1,250,0002026-03-11
19790 SW 208th Stsingle_family442,593$1,185,0002026-03-06
18263 SW 149th Plsingle_family431,987$749,0002026-03-05
15265 SW 173rd Stsingle_family432,265$750,0002026-03-03
18203 SW 152nd Plsingle_family432,382$750,0002026-02-17
17870 SW 155th Ctsingle_family421,760$660,0002026-02-09
15263 SW 162nd Stsingle_family432,774$885,0002026-02-06
20230 SW 184th Stsingle_family441,980$1,100,0002026-01-26
15305 SW 173rd Stsingle_family432,265$700,0002026-01-23
16934 SW 215th Tersingle_family432,468$910,0002026-01-09
16137 SW 155th Avesingle_family432,416$900,0002026-01-07
14789 SW 176th Stsingle_family421,535$665,0002025-12-30
15333 SW 184th Stsingle_family421,952$712,0002025-12-29

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
15012 SW 177th Tersingle_family442,393$755,990
15735 SW 153rd Avesingle_family422,976$799,990
single_family443,439$1,100,000
19601 SW 187th Avesingle_family432,630$1,000,000
18390 SW 200th Stsingle_family453,367$2,150,000
19690 SW 210th Stsingle_family442,563$1,799,000
14843 SW 152nd Tersingle_family421,499$695,000
single_family433,088$950,000

10-year hold projection

IRR-0.5%
Equity multiple0.92x
Total return (10yr)$91,637
YearProperty valueNOICash flowLoan balanceEquity
1$844,497$20,937-$32,255$648,808$195,689
2$869,832$21,700-$31,556$641,208$228,624
3$895,927$22,490-$30,834$633,086$262,840
4$922,805$23,307-$30,085$624,407$298,398
5$950,489$24,152-$29,310$615,131$335,358
6$979,003$25,026-$28,508$605,218$373,785
7$1,008,374$25,930-$27,678$594,625$413,748
8$1,038,625$26,865-$26,819$583,304$455,321
9$1,069,784$27,832-$25,929$571,206$498,577
10$1,101,877$28,832-$25,009$558,277$543,600
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.