Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$399,000

  • For Sale
  • Active
  • Condo
  • 2 Beds
  • 2 Full Baths
  • 1,330 Sq. Ft.
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 Rd #210

General

  • Price: $399,000
  • HOA FEE: $835/month
  • Taxes: $5,769 (2026)
  • Status: Active
  • Type: Condo
  • Source: Greater_Miami
  • MLS ID: A12006028
  • Updated: 4/24/2026
  • Added to Site: 80 day(s) ago

Interior

  • Interior Features: First Floor Entry, Walk-In Closet(s)
  • Appliances: Dishwasher, Dryer, Electric Water Heater, Microwave, Electric Range, Refrigerator, Washer
  • Flooring: Ceramic Floor

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 2
  • Bedroom Features: At Least 1 Bedroom Ground Level, Entry Level, Primary Bath Tub, Primary Bedroom Ground Level

Other Rooms

  • Dining Room: Dining/Living Room, Snack Bar/Counter

Additional Information

  • Shared Amenities: Community Room, Elevator(s), Pool
  • Maint. Includes: Air Conditioning Maintenance, All Amenities, Common Area, Elevator, Landscaping/Lawn Maintenance, Outside Maintenance, Parking, Pool Service, Recreation Facilities, Trash Removal, Water
  • Security/Safety: Fire Alarm, Smoke Detector, Complex Fenced
  • Equipment: Elevator

Exterior

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

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Covered Spaces: 1
  • Parking Features: 1 Space, Assigned

Location

  • Area: Le Frontenac Condo
  • County: Miami-Dade County
  • Subdivision: LE FRONTENAC CONDO
  • Building Name: LE FRONTENAC

School Information

  • Elementary School: Norman S. Edelcup K-8
  • Middle School: Highland Oaks

Community

  • Community Name: Le Frontenac Condo
  • Association: Yes

Heating & Cooling

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

Structural Information

  • Structure Type: Condo 5+ Stories, Condo
  • Detached/Attached: Detached
  • Construction: Concrete Block Construction
  • Entry Floor Number: 2
  • Building Size: 1330
  • Square Feet: 1,330
  • Living Area: 1,330 Sq. Ft.
  • Year Built: 1991

Lot Features

  • Property View: Pool Area View

Financial Considerations

  • Price Per Sq. Ft.: $300
  • Association Fee: $835
  • Assoc Fee Freq.: Monthly
  • Tax Amount: $5,769
  • Tax Year: 2026
  • Terms: All Cash, Conventional

Disclosures and Reports

  • 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-053-0460
  • Restrictions: No Restrictions, Ok To Lease, Okay To Lease 1st Year, See Broker Remarks
  • 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 Rd #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 Rd #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 Rd #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 Rd #210

Year
Property Taxes
Change
Tax Assessment
Change
2024
$5,492
—
$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 Rd #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 Rd #210

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

201 178th Dr, Sunny Isles Beach, FL 33160 - Photo 1
$399,000

201 178th Dr  #332  Sunny Isles Beach, FL 33160

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 902
    Sq. Ft.
230 174th St, Sunny Isles Beach, FL 33160 - Photo 1
$399,000

230 174th St  #1916  Sunny Isles Beach, FL 33160

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

18151 NE 31st Ct  #1912  Aventura, FL 33160

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 1,104
    Sq. Ft.
3530 Mystic Pointe Dr, Aventura, FL 33180 - Photo 1
$399,000

3530 Mystic Pointe Dr  #2108  Aventura, FL 33180

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 1,181
    Sq. Ft.
Listed by Yosef Razon (917) 287-6752 and Ronit Razon (516) 972-3384

Just Listed near 17801 N Bay Rd #210

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

19667 Turnberry Way, Aventura, FL 33180 - Photo 1 Just Listed
$895,000

19667 Turnberry Way  #19K  Aventura, FL 33180

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,901
    Sq. Ft.
Listed by Denise Rubin (305) 409-0019
20332 NE 34th Ct, Aventura, FL 33180 - Photo 1 Just Listed
$345,000

20332 NE 34th Ct  #26  Aventura, FL 33180

  • Condo
  • Active
  • Updated 4 days ago
  • 1
    Bed
  • 2
    Total Baths
  • 872
    Sq. Ft.
3250 NE 188th St, Aventura, FL 33180 - Photo 1 Just Listed
$1,865,000

3250 NE 188th St  #608  Aventura, FL 33180

  • Condo
  • Active
  • Updated 9 hours ago
  • 3
    Beds
  • 5
    Total Baths
  • 2,518
    Sq. Ft.
3440 NE 192 St, Aventura, FL 33180 - Photo 1 Just Listed
$389,000

3440 NE 192 St  #1P-A  Aventura, FL 33180

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

Price Reduced near 17801 N Bay Rd #210

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

3188 NE 211th Terrace, Aventura, FL 33180 - Photo 1 Price Reduced
-$100,000 (-4%)
$2,399,000

3188 NE 211th Terrace  Aventura, FL 33180

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 2,949
    Sq. Ft.
Listed by Rafael Szydlowski (786) 385-4824 and Natalia Abecasis (786) 385-2699
2780 NE 183rd St, Aventura, FL 33160 - Photo 1 Price Reduced
-$10,500 (-5.54%)
$179,000

2780 NE 183rd St  #1007  Aventura, FL 33160

  • Condo
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,058
    Sq. Ft.
Listed by Alejandro Pis-Dudot (786) 493-6974
20281 E Country Club Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$54,500 (-7.27%)
$695,000

20281 E Country Club Dr  #608  Aventura, FL 33180

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,080
    Sq. Ft.
Listed by Denise Rubin (305) 409-0019
3675 N Country Club Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$100 (-0.05%)
$194,900

3675 N Country Club Dr  #2201  Aventura, FL 33180

  • Condo
  • Active
  • Updated 1 day ago
  • 1
    Bed
  • 2
    Total Baths
  • 896
    Sq. Ft.
Listed by Heather Lopez (786) 390-7586

Recent Sales near 17801 N Bay Rd #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.
201 178th Dr, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$380,000

201 178th Dr  #340  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 907
    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.
[Address not provided], Sunny Isles Beach, FL 33160 - Photo 1 Sold
$446,500

[Address not provided]  Sunny Isles Beach, FL 33160

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

17801 N Bay Rd #210, Sunny Isles Beach, FL 33160 (MLS# A12006028) is a Condo property with 2 bedrooms and 2 full bathrooms. 17801 N Bay Rd #210 is currently listed for $399,000 and was received on April 22, 2026. Want to learn more about 17801 N Bay Rd #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