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

📅 View days on the market

Days on the market

17801 N Bay Road 210, Sunny Isles Beach, FL 33160

Price
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
Property Status and Type
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
Rooms Distribution
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
Measures
Living Area:
1,330 Sqft
Built-Up Area:
1,330 Sqft
Property Features
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
Construction
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
Taxes and Expenses
Tax Annual Amount:
$5,769.00
Tax Year:
2026
Association Fee:
$835.00
Association Fee Frequency:
Monthly
Property Tax Details:
Tax Reflects No Exemptions
Parking
Garage
Garage Spaces:
1
Covered Spaces:
1
Parking Features:
Assigned
Utilities
Electric:
Circuit Breakers
Community
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
Terms
Listing Terms Considered by Seller:
Cash, Conventional
Buyer Possession:
Close Of Escrow
Zoning and Legal
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
Public Schools Assigned
High School:
Alonzo And Tracy Mourning
Middle Or Junior School:
Highland Oaks
Listing History
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
Additional Information
Courtesy of:
Miami Dream Real Estate
Attribution:
Not provided
Location
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
Property Map

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

Median Household Income $62,413
Median Home Value $360,200
Median Rent $1,990/mo
Median Age 48
Population 43,225
Mortgage Calculator

Please note: Monthly HOA / Condo Fees Not Included. The calculator shows the listing price as home value. Update all fields at your convenience.

Calculate Your Mortgage Payment

$.00
$.00
6.5
30

Taxes and Insurance

$.00
$.00
%

Financial Analysis

%

%

$

$

$

$

$
Ver la Propiedad Ver la propiedad 17801 N Bay Road 210, Sunny Isles Beach, FL 33160
Association of REALTORS®
Disclaimer: IDX listing information is presented by Rebonus Brokerage LLC for consumer informational purposes only. The information provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by the MLS or the real estate broker. This page presents structured listing information sourced directly from the MLS via the RESO Web API feed. Rebonus prioritizes maximum field coverage and data completeness, displaying the most granular MLS-provided attributes available.