Miami Real EstateThe MIAMI
Confidential
Case files · 28 October 2026
Latest File · Brickell & Brickell KeyFollowing a building in these files?Tell Josh which one. He’ll send its recorded sales from the Miami-Dade record, what is on the market there now …Open the files →
Josh Stein, Miami real estate associateJosh Stein

100 Pending Deals

The Miami Confidential · The Lists

The 100 homes that most recently went under contract in Miami-Dade, Palm Beach and Broward, newest contract first, shown at asking price. MLS data; the time stamp above the table is the data date, and the list updates hourly.

The 100 homes that most recently went under contract, newest contract first, at their asking price.

Miami-Dade, Palm Beach and Broward · condos and homes · under contract

MLS data as of October 28, 2026 11:52 am · updates hourly

Reset

Showing the Top 35 · Sunny Isles Beach · condos and homes · from $500K

Photo
1Estates at Acqualina17901 Collins Avenue County record: last recorded sale $8,600,000, May 2025 · assessed $7,948,954 (2026) · folio 31-2202-086-09703004$9,900,000$2,3975 bd / 7.5 ba4,131Oct 27, 2026
2REGALIA CONDO19575 Collins Avenue County record: last recorded sale $11,520,000, Jul 2018 · assessed $12,007,420 (2026) · folio 31-2202-052-00103$19,995,000$1,9026 bd / 8 ba10,515Oct 26, 2026
318975 COLLINS CONDO18975 Collins Avenue County record: last recorded sale $2,200,000, Dec 2019 · assessed $2,083,066 (2026) · folio 31-2202-055-22102004$3,099,000$1,9562 bd / 2.5 ba1,584Oct 24, 2026
4TURNBERRY OCEAN COLONY SO16047 Collins Avenue County record: last recorded sale $1,600,000, Jul 2019 · assessed $1,735,836 (2026) · folio 31-2214-034-04301202$2,490,000$1,1092 bd / 2.5 ba2,245Oct 24, 2026
5OCEAN FOUR CONDO$1,175,000$8422 bd / 2 ba1,396Oct 22, 2026
6NORTH BISCAYNE BEACH AMEN17901 Collins Avenue County record: assessed $30,900,000 (2026) · folio 31-2202-086-1450PH-01$39,995,000$4,4036 bd / 6.5 ba9,083Oct 22, 2026
7OCEAN TWO CONDO19111 Collins Avenue403$2,399,999$1,1163 bd / 3 ba2,150Oct 21, 2026
8TRUMP ROYALE CONDO18201 Collins Avenue County record: last recorded sale $805,000, Jan 2021 · assessed $897,917 (2026) · folio 31-2211-080-25701407$1,495,000$1,0433 bd / 3 ba1,434Oct 20, 2026
9THE PINNACLE CONDO17555 Collins Avenue County record: last recorded sale $1,355,000, Sep 2013 · assessed $1,262,639 (2026) · folio 31-2211-062-08701503$1,950,000$1,0603 bd / 3 ba1,840Oct 20, 2026
10Estates at Acqualina17901 Collins Avenue County record: last recorded sale $4,050,000, Jul 2022 · assessed $4,346,283 (2026) · folio 31-2202-086-03301002$7,350,000$2,2364 bd / 5 ba3,287Oct 20, 2026
11TRUMP TOWER II CONDO15901 Collins Avenue County record: last recorded sale $1,225,000, Dec 2020 · assessed $1,433,312 (2026) · folio 31-2214-036-20201206$1,900,000$8173 bd / 3.5 ba2,327Oct 19, 2026
12JADE SIGNATURE CONDO16901 Collins Avenue County record: last recorded sale $4,250,000, Feb 2018 · assessed $3,284,103 (2026) · folio 31-2211-076-09602503$4,900,000$1,6723 bd / 4.5 ba2,931Oct 19, 2026
13TRUMP ROYALE CONDO18201 E Collins AvenueTS1$6,900,000$1,2056 bd / 4.5 ba5,727Oct 15, 2026
14516500 Collins Avenue2654$1,150,000$6442 bd / 2 ba1,786Oct 14, 2026
15700290 174th Street1602$545,000$4402 bd / 2 ba1,240Oct 14, 2026
16MARINA BAY CLUB CONDO HOT18100 N Bay Road1009$750,000$5982 bd / 2 ba1,255Oct 14, 2026
17JADE OCEAN CONDO17121 Collins Avenue County record: last recorded sale $1,950,000, Jun 2021 · assessed $1,893,560 (2026) · folio 31-2211-081-01802601$2,795,000$1,4293 bd / 3.5 ba1,956Oct 12, 2026
18Sunny Isles Beach17901 Collins Avenue County record: last recorded sale $2,968,000, Jun 2022 · assessed $3,501,750 (2026) · folio 31-2202-086-11301506$5,650,000$2,1603 bd / 4.5 ba2,616Oct 11, 2026
19TRUMP ROYALE CONDO18201 Collins Avenue County record: last recorded sale $1,100,000, Jan 2022 · assessed $917,035 (2026) · folio 31-2211-080-00801101$1,400,000$8492 bd / 2.5 ba1,649Oct 9, 2026
20PARQUE TOWERS CONDO300 Sunny Isles Boulevard County record: last recorded sale $1,140,000, May 2019 · assessed $1,005,000 (2026) · folio 31-2214-044-01204-1701$1,370,000$7243 bd / 3.5 ba1,892Oct 7, 2026
21Mansions at Acqualina17749 Collins Avenue County record: last recorded sale $4,065,000, Aug 2015 · assessed $5,302,920 (2026) · folio 31-2211-083-00901201$6,795,000$1,4743 bd / 6.5 ba4,609Oct 6, 2026
22322 189th Street$1,650,000$7332 bd / 2 ba2,250Oct 2, 2026
23LA PERLA CONDO16699 Collins Avenue County record: last recorded sale $1,025,000, Aug 2022 · assessed $793,808 (2026) · folio 31-2214-037-01001002$1,399,000$8242 bd / 2.5 ba1,698Sep 26, 2026
24TRUMP ROYALE CONDO18201 Collins Avenue County record: last recorded sale $1,400,000, Aug 2009 · assessed $2,281,995 (2026) · folio 31-2211-080-04005301$2,550,000$8453 bd / 3.5 ba3,016Sep 20, 2026
251604716047 Collins Avenue County record: last recorded sale $2,536,000, Jan 2008 · assessed $2,561,722 (2026) · folio 31-2214-034-1010704$4,299,000$1,1514 bd / 6.5 ba3,735Sep 18, 2026
26331 188th Street$1,590,000$9743 bd / 3 ba1,632Sep 15, 2026
27JADE OCEAN CONDO17121 Collins Avenue County record: last recorded sale $1,416,640, Sep 2009 · assessed $2,523,000 (2026) · folio 31-2211-081-15803905$2,795,500$1,4463 bd / 3.5 ba1,933Sep 9, 2026
28JADE OCEAN CONDO17121 Collins Avenue County record: last recorded sale $1,150,000, Nov 2023 · assessed $906,400 (2026) · folio 31-2211-081-06201503$1,150,000$1,3401 bd / 1.5 ba858Sep 2, 2026
29JADE OCEAN CONDO17121 Collins Avenue County record: last recorded sale $807,500, Dec 2012 · assessed $952,820 (2026) · folio 31-2211-081-06702003$1,150,000$1,3401 bd / 1.5 ba858Aug 31, 2026
30OCEAN FOUR CONDO17201 Collins Avenue County record: last recorded sale $1,150,000, Jun 2014 · assessed $988,852 (2026) · folio 31-2211-077-07201203$1,450,000$8822 bd / 2 ba1,644Aug 16, 2026
31TRUMP ROYALE CONDO18201 Collins Avenue County record: last recorded sale $598,500, May 2010 · assessed $890,435 (2026) · folio 31-2211-080-0050801$1,250,000$7582 bd / 2.5 ba1,649Aug 13, 2026
32TRUMP ROYALE CONDO18201 Collins Avenue County record: last recorded sale $446,500, Nov 2008 · assessed $766,022 (2026) · folio 31-2211-080-0480801A$1,100,000$8532 bd / 2 ba1,289Jun 3, 2026
33OCEAN FOUR CONDO17201 Collins Avenue County record: last recorded sale $560,000, Jul 2007 · assessed $685,440 (2026) · folio 31-2211-077-26801009$950,000$7302 bd / 2 ba1,301May 5, 2026
34ST TROPEZ ON THE BAY III250 Sunny Isles Boulevard3-1804$849,000$5823 bd / 2 ba1,458May 4, 2026
35OCEANIA II CONDO16445 Collins Avenue728$1,100,000$6252 bd / 2 ba1,760Aug 12, 2025

Photo courtesy of Beaches MLS · Photo courtesy of Miami MLS

MLS data via IDX Bloom. Lists re-rank themselves as the market moves. Rank is the list.

Source: MLS feed via IDX Bloom, time stamp above. County facts: Miami-Dade County Property Appraiser (rows marked with a check mark).

100 Pending Deals: common questions

What does pending mean here?

The 100 homes that most recently went under contract, newest contract first, at asking price.

How often does this list update?

Hourly. The time stamp above the table is the MLS data date.

Related coverage

Part of The Lists.

Direct line

Ask Josh a question

Tell me the building, the budget and the timeline. You will get an honest read, including when the answer is that you should not buy it.

+1 (305) 695-8257 · hello@joshsteinrealtor.comPhone or WhatsApp · English / Español · Licensed in Florida since 2002

The Miami Confidential

The reporting, every two weeks.

Every new case file. Every delivery date that moves. Every figure dated and sourced. No listings, no hype, no press releases dressed up as news.

Free. Built from Miami-Dade County records. Pick one or both. Unsubscribe in one click.
A–Z Buildings
Scroll to Top