Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$399,000 Just Listed

  • For Sale
  • Active
  • Condo
  • 2 Beds
  • 2 Full Baths
  • 1,330 Sq. Ft.
  • Updated 3 days 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 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: 5 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.

3000 Island Blvd, Aventura, FL 33160 - Photo 1
$399,000

3000 Island Blvd  #WSTE1  Aventura, FL 33160

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

17021 N Bay Rd  #124  Sunny Isles Beach, FL 33160

  • Condo
  • Active
  • 2
    Beds
  • 2
    Total Baths
  • 988
    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 Price Reduced
-$10,000 (-2.44%)
$399,000

3530 Mystic Pointe Dr  #2108  Aventura, FL 33180

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

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.

20505 E Country Club Dr, Aventura, FL 33180 - Photo 1 Just Listed
$419,000

20505 E Country Club Dr  #836  Aventura, FL 33180

  • Condo
  • Active
  • Updated 15 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,136
    Sq. Ft.
18041 Biscayne Blvd, Aventura, FL 33160 - Photo 1 Just Listed
$380,000

18041 Biscayne Blvd  #804  Aventura, FL 33160

  • Condo
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,605
    Sq. Ft.
2801 NE 183rd St, Aventura, FL 33160 - Photo 1 Just Listed
$178,000

2801 NE 183rd St  #603W  Aventura, FL 33160

  • Condo
  • Active
  • Updated 3 hours ago
  • 1
    Bed
  • 2
    Total Baths
  • 1,066
    Sq. Ft.
2600 Island Blvd, Aventura, FL 33160 - Photo 1 Just Listed
$5,800,000

2600 Island Blvd  #PH-1  Aventura, FL 33160

  • Condo
  • Active
  • Updated 13 hours ago
  • 5
    Beds
  • 5
    Total Baths
  • 4,930
    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.

3020 Marcos Dr, Aventura, FL 33160 - Photo 1 Price Reduced
-$5,000 (-3.57%)
$135,000

3020 Marcos Dr  #S109  Aventura, FL 33160

  • Condo
  • Active
  • Updated 4 days ago
  • 1
    Bed
  • 1
    Total Bath
  • 768
    Sq. Ft.
Listed by Ilaria Cunningham (305) 202-4754 and Lori Murphy (954) 303-1093
3500 Mystic Pointe Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$50,000 (-5.59%)
$845,000

3500 Mystic Pointe Dr  #3601  Aventura, FL 33180

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,714
    Sq. Ft.
Listed by Sara Ludmir (786) 256-0817
19655 E Country Club Dr, Aventura, FL 33180 - Photo 1 Price Reduced
-$36,000 (-7.42%)
$449,000

19655 E Country Club Dr  #6108  Aventura, FL 33180

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,100
    Sq. Ft.
Listed by Rafael Szydlowski (786) 385-4824 and Natalia Abecasis (786) 385-2699
229 Golden Beach Dr, Golden Beach, FL 33160 - Photo 1 Price Reduced
-$255,000 (-2.91%)
$8,495,000

229 Golden Beach Dr  Golden Beach, FL 33160

  • Single Family
  • Active
  • Updated 4 days ago
  • 7
    Beds
  • 7
    Total Baths
  • 4,513
    Sq. Ft.
Listed by Jonathan Mann (786) 877-6201

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.

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.
17720 N Bay Rd, Sunny Isles Beach, FL 33160 - Photo 1 Sold
$447,000

17720 N Bay Rd  #802  Sunny Isles Beach, FL 33160

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,413
    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