Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$399,000 Sale Pending

  • For Sale
  • Pending
  • Condo
  • 2 Beds
  • 2 Full Baths
  • 1,330 Sq. Ft.
  • Updated 1 day ago
See This Home
Save This Home
See This Home
Save This Home
Welcome to this beautiful and spacious 2/2 in the gated Boutique Le Frontenac. Step into a fully operational investment with this high performing short term rental already active across major booking plateforms, such as Airbnb, Booking.com or Vrbo. Benefiting from strong visibility and a consistent stream of bookings, this property generates reliable income with zero setup required. Everything is already in place for a seamless transition: the apartment is fully furnished, with washer and dryer inside the unit and is fully managed by an experienced company overseeing reservation, guest communication, accounting, housekeeping and maintenance. Don't miss this opportunity. For showing see broker remarks

Full Property Details for 17801 N Bay #210

General

  • Price: $399,000
  • Taxes: $5,769 (2026)
  • Status: Pending
  • Type: Condo
  • Source: Martin_County
  • MLS ID: A12006028
  • Updated: 9/6/2026
  • Added to Site: 139 day(s) ago

Interior

  • Interior Features: Breakfast Bar, Primary Downstairs, Living/Dining Room, Walk-In Closet(s)
  • Appliances: Some Electric Appliances, Dryer, Dishwasher, Electric Range, Microwave, Refrigerator, Water Heater, Washer
  • Flooring: Ceramic Tile

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 2

Additional Information

  • Shared Amenities: Elevator(s)
  • Pool: Yes
  • Pool Description: Community
  • Security/Safety: Smoke Detector(s)

Exterior

  • Exterior Features: Balcony
  • Porch/Patio/Deck: Balcony, Open

Parking

  • Covered Spaces: 1
  • Total Spaces: 1
  • Parking Features: Assigned

Location

  • Area: 2220
  • County: Miami-Dade
  • Subdivision: LE FRONTENAC

Community

  • Community Name: 2220
  • Assoc. Fees Include: Common Areas, Maintenance Grounds, Other, Parking, Pool(s), Recreation Facilities, Trash, Water

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air
  • Heating Type: Central

Structural Information

  • Construction: Block, Concrete
  • Entry Floor Number: 2
  • Elevator: Yes
  • Square Feet: 1,330
  • Living Area: 1,330 Sq. Ft.
  • Year Built: 1991

Lot Features

  • Property View: Pool

Financial Considerations

  • Tax Amount: $5,769
  • Tax Year: 2026
  • Terms: Cash, Conventional

Disclosures and Reports

  • Special Conditions: Listed As-Is
  • Legal Description: LE FRONTENAC CONDO UNIT 210 UNDIV 1.282% INT IN COMMON ELEMENTS OFF REC 15143-1999 OR 17079-3343 1295 5 F/A/U 30-2211-05
  • Disclosures/Rstr.: Foreign Seller
  • Property ID: 31-22-11-053-0460

Listed by Miami Dream Real Estate

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 17801 N Bay #210 —

  • Miami Dream Real Estate

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 17801 N Bay #210

School District:Dade County School District
NameGradesDistance
Norman S. Edelcup/Sunny Isles Beach K-8
201 182nd Drive, Sunny Isles Beach, FL 33160
PK-50.2 mi
Highland Oaks Middle School
2375 Northeast 203rd Street, Miami, FL 33180
6-82.4 mi
Alonzo And Tracy Mourning Senior High Biscayne Bay Campus
2601 Ne 151st St, Miami, FL 33160
9-122.2 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 17801 N Bay #210 Get Price Alerts and Save Property

Date
Details
Price
Change
Source
4/22/2026
Listed
$399,000
33.44%
MLS
12/10/2018
Sold
$299,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 17801 N Bay #210

Year
Property Taxes
Change
Tax Assessment
Change
2025
$5,769
5%
$339,405
-4%
2024
$5,492
6%
$353,430
5%
2023
$5,157
17%
$336,600
35%
2021
$4,394
1%
$250,000
-2%
2022
$4,369
-1%
$255,000
14%
2021
$4,394
10%
$223,000
—
2019
$4,009
3%
$223,000
—
2018
$3,909
-7%
$222,918
-5%
2017
$4,196
-3%
$234,650
—
2016
$4,309
-2%
$234,650
—
2015
$4,418
-3%
$234,650
—
2014
$4,535
5%
$234,650
8%
2013
$4,339
—
$216,323
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 17801 N Bay #210

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Miami Dream Real Estate

Similar Properties near 17801 N Bay #210

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

17150 N Bay, Sunny Isles Beach, FL 33160 - Photo 1
$399,000

17150 N Bay  #2902  Sunny Isles Beach, FL 33160

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,024
    Sq. Ft.
17150 N Bay Rd, Sunny Isles Beach, FL 33160 - Photo 1
$399,000

17150 N Bay Rd  #2902  Sunny Isles Beach, FL 33160

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,024
    Sq. Ft.
2000 Island Blvd, Aventura, FL 33160 - Photo 1
$399,000

2000 Island Blvd  #308  Aventura, FL 33160

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 1,560
    Sq. Ft.
18151 NE 31st, Aventura, FL 33160 - Photo 1
$399,000

18151 NE 31st  #1912  Aventura, FL 33160

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,104
    Sq. Ft.

Just Listed near 17801 N Bay #210

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

20281 E Country Club Dr, Aventura, FL 33180 - Photo 1 Just Listed
$62,000

20281 E Country Club Dr  #CAB3  Aventura, FL 33180

  • Condo
  • Active
  • Updated 6 days ago
  • 180
    Sq. Ft.
Listed by Denise Rubin (305) 409-0019 and Judith Weinberg (305) 401-8543
19101 NE 36th Ct, Aventura, FL 33180 - Photo 1 Just Listed
$524,900

19101 NE 36th Ct  #1704  Aventura, FL 33180

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,181
    Sq. Ft.
2820 NE 214th St, Aventura, FL 33180 - Photo 1 Just Listed
$52

2820 NE 214th St  #1006  Aventura, FL 33180

  • Commercial Lease
  • Active
3123 NE 210th St, Aventura, FL 33180 - Photo 1 Just Listed
$1,649,000

3123 NE 210th St  Aventura, FL 33180

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,338
    Sq. Ft.

Price Reduced near 17801 N Bay #210

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

3600 Mystic Pointe Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$14,000 (-3.26%)
$415,000

3600 Mystic Pointe Dr  #513  Aventura, FL 33180

  • Condo
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,353
    Sq. Ft.
Listed by Rafael Szydlowski (786) 385-4824 and Natalia Abecasis (786) 385-2699
18800 NE 29th Ave, Aventura, FL 33180 - Photo 1 Price Reduced
-$15,000 (-2.94%)
$495,000

18800 NE 29th Ave  #418  Aventura, FL 33180

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,432
    Sq. Ft.
18409 NE 27th Ct, Aventura, FL 33160 - Photo 1 Price Reduced
-$5,000 (-0.8%)
$620,000

18409 NE 27th Ct  #156  Aventura, FL 33160

  • Townhouse
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 3
    Total Baths
  • 1,745
    Sq. Ft.
20379 W Country Club Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$100 (-0.03%)
$399,500

20379 W Country Club Dr  #1436  Aventura, FL 33180

  • Condo
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,313
    Sq. Ft.

Recent Sales near 17801 N Bay #210

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

17801 N Bay Rd, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$425,000

17801 N Bay Rd  #607  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,330
    Sq. Ft.
17900 N Bay Rd, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$410,000

17900 N Bay Rd  #408  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,050
    Sq. Ft.
201 180th Dr, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$340,000

201 180th Dr  #114  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 970
    Sq. Ft.
231 174th St, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$450,000

231 174th St  #2018  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,856
    Sq. Ft.

17801 N Bay #210, Sunny Isles Beach, FL 33160 (MLS# A12006028) is a Condo property with 2 bedrooms and 2 full bathrooms. 17801 N Bay #210 is currently listed for $399,000 and was received on April 22, 2026. Want to learn more about 17801 N Bay #210? Do you have questions about finding other Condo real estate for sale in Sunny Isles Beach? You can browse all Sunny Isles Beach real estate or contact a Coldwell Banker agent to request more information.

Tour this property