Condo in 17801 N Bay Road 210, Sunny Isles Beach, FL 33160 for sale with MLS# A12006028
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
17801 N Bay Road 210, Sunny Isles Beach, FL 33160
- Price:
- $399,000.00
- Original List Price:
- $399,000.00
- List Price per Sq Ft (Calculated, Approx.):
- $300.00
- More Listings Same Building:
- Le Frontenac in 17801 Bay Rd Sunny Isles Beach
- Listing Type:
- For Sale
- Status:
- Pending (An offer has been accepted)
- Listing Category:
- Residential
- Property Type:
- Condominium
- Description of Last Important Update:
- Status Change
- Last Major Update on:
- July 24, 2026 9:29 pm
- Other Special Conditions:
- Sold As-is, Foreign Seller
- Bedrooms:
- 2
- Bathrooms Total:
- 2
- Full Bath:
- 2
- Master Bedroom Bath:
- Master Bdrm - Ground, Separate Tub, Bedroom On Entry Level
- Dining Area:
- Snack Bar/counter, Dining/Living Room
- Living Area:
- 1,330 Sqft
- Built-Up Area:
- 1,330 Sqft
- View from the Property:
- Pool
- Waterfront:
- No
- Security:
- Smoke Detector(s), Fire Alarm, Security Fence
- Appliances:
- Dryer, Dishwasher, Microwave, Refrigerator, Washer, Electric Range, Electric Water Heater
- Interior:
- Walk-In Closet(s), Elevator
- Exterior:
- Balcony
- Air Conditioning
- Air Conditioning System:
- Central Air
- Heating
- Heating System:
- Central
- Balcony Details:
- Balcony - Open
- Year Built:
- 1991
- Architectural Style:
- Other
- Levels:
- Two
- Entry Level (floor):
- 1
- Construction Materials:
- Block
- Flooring:
- Ceramic Tile
- Number of stories:
- 6
- Flood Zone Code:
- AE
- Tax Annual Amount:
- $5,769.00
- Tax Year:
- 2026
- Association Fee:
- $835.00
- Association Fee Frequency:
- Monthly
- Property Tax Details:
- Tax Reflects No Exemptions
- Garage
- Garage Spaces:
- 1
- Covered Spaces:
- 1
- Parking Features:
- Assigned
- Electric:
- Circuit Breakers
- Association
- Application Required
- Application Fee:
- $150.00
- Application Information:
- 1-2 Weeks Approval, Association Approval Required
- Association Type:
- Homeowner Association, Condominium
- Lease Number Times per Year Allowed:
- 20
- Amenities Provided by the Homeowner's Association (HOA):
- Pool, Community Room, Maintenance, Elevator(s), Parking
- Subdivision Name:
- LE FRONTENAC CONDO
- Association Fee Includes:
- Maintenance Grounds, Water, Trash, Common Areas, Elevator, Hvac Maintenance, Pool Service, Recreation Facility
- Senior Community:
- No
- Restrictions:
- No Restrictions, See Remarks
- Minimum Days per Lease:
- 21
- Leasing Permitted
- Leasing Permitted Details:
- Okay To Lease, Okay To Lease During First Year
- Listing Terms Considered by Seller:
- Cash, Conventional
- Buyer Possession:
- Close Of Escrow
- Tax 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
- Real Estate Folio Number (Parcel Number):
- 3122110530460
- High School:
- Alonzo And Tracy Mourning
- Middle Or Junior School:
- Highland Oaks
- Active on the market since:
- April 22, 2026
- Listing Agreement executed on:
- April 22, 2026
- Purchase Contract Date:
- July 24, 2026
- Listing Status Last Changed On:
- July 24, 2026 9:29 pm
- Photos updated on:
- July 24, 2026 9:31 pm
- Last Modified:
- July 24, 2026 9:31 pm
- Courtesy of:
- Miami Dream Real Estate
- Attribution:
- Not provided
- Floor Number:
- 2
- Street Name:
- Bay
- Street Number:
- 17801
- Unit Number:
- 210
- City:
- Sunny Isles Beach
- State:
- Florida
- Zip Code:
- 33160
- County:
- Miami-Dade
- Latitude:
- N25° 56' 30.5''
- Longitude:
- W81° 52' 31.6''
- Street Suffix:
- Road
- Street Direction Prefix:
- N

Want to schedule an in-person or virtual tour? Have questions?
Want to schedule an in-person or virtual tour? Have questions?
Schedule a Tour or Ask a Question
Neighborhood Stats
Source: U.S. Census Bureau, ACS 5-Year Estimates