Le Frontenac, 17801 N Bay Rd #210

2
Beds
2
Baths
1,330
SqFt
$301
$/SqFt
Sold - Sep 15, 2026
Condo
Built in 1991
1 Parking
Pool View
$835/mo HOA
Balcony
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
MLS Number: A12006028
On Site: 146 Days
Updated: 1 Days ago
Page Views: 0

Features

Bedrooms
  • Bedrooms: 2
Bathrooms
  • Bathrooms: 2
  • Half Bathrooms: No info
Exterior and Lot Features
  • Exterior Features: Balcony
  • View: Pool
Interior, Heating and Cooling
  • Interior Features: BreakfastBar, BedroomOnMainLevel, Bathtub, FirstFloorEntry, LivingDiningRoom, MainLevelPrimary, WalkInClosets, Elevator
  • Equipment / Appliances: Dryer, Dishwasher, ElectricRange, ElectricWaterHeater, Microwave, Refrigerator, Washer
  • Heating Description: Central
  • Cooling Description: CentralAir
Building and Construction
  • Floor Description: CeramicTile
  • Year Built: 1991
  • Year Built Description: Effective Year Built
  • Style: Other
Waterfront and Water Access
  • Waterfront Frontage: No info
School Information
  • Elementary School: Norman S. Edelcup K-8
  • Middle School: Highland Oaks
Other Property Info
  • Garage: 1
  • Listing Date: 2026-04-23T17:38:48.000-00:00
  • Pets Allowed: No
Taxes, Fees & More
  • Maintenance Includes: Amenities, CommonAreas, Hvac, MaintenanceGrounds, MaintenanceStructure, Parking, Pools, RecreationFacilities, Trash, Water
  • Taxes: 5769
  • Security Information: ComplexFenced, SmokeDetectors
  • Parking Description: Assigned,OneSpace
  • Total Floors in Building: 6

Apples-to-Apples Comparables

 Closest-Match Comparables
See closest-match comps for this subdivision
No obligation
Verified
Trends
Insights
Best of Luxury Realty
Talk to a local advisor
Licensed advisors answering your questions across Sunny Isles Beach, FL
01
Licensed Brokerage
02
Local Advisors
03
Direct Answers
Exclusive real estate service partner

Price History

Current
$400K
High
$400K
Low
$399K
Total Change
0.3%
$400K$400K$399KApr 26Apr 26Sep 26
Date
Event
Price
Change
Price Per
09/15/2026
Sold
$400K
0%
$301 ft2
$3,237 m2
04/22/2026
Price Increased
$400K
0.25%
$301 ft2
$3,237 m2
04/22/2026
Listed
$399K
 
$300 ft2
$3,229 m2
09/15/2026
$400K
Event
Sold
Change
0%
Price Per
$301 ft2
$3,237 m2
04/22/2026
$400K
Event
Price Increased
Change
0.25%
Price Per
$301 ft2
$3,237 m2
04/22/2026
$399K
Event
Listed
Price Per
$300 ft2
$3,229 m2
Price per square foot and days on website are not provided values and are calculated by Subdivisions.
Listed by Valerie Benarous OutmezguineMiami Dream Real Estate • Buyer Agency Compensation .

Listing Location & Street View
MapStreet View

Peer Listings

Active listings from matched communities
Results 0 of 0
No listings found
Try adjusting your filters or changing your location to see available listings
Turn on listing alerts and we'll notify you
when matching listings appear

Scores

Walk Score®
Very Walkable. Most errands can be accomplished on foot
75

100
Transit Score®
Some Transit. A few nearby public transportation options
42

100
Bike Score®
Bikeable. Some bike infrastructure
59

100
Sound Score®
Bearable noise
76

100
Airport Score
Close to airports. Noticeable airport activity
0

100
Traffic Score
Congested area. Frequent traffic delays
31

100
Local Score
Limited local amenities nearby
0

100
Community Snapshot
2 – 2 BR
Bedrooms
$455K – $675K
Price Tier
1,330 - 2,054
SqFt Range
1991
Year Build
6
Total Floors
70
Total Units

Subdivision Amenities

Barbecue
Bike Storage
Clubhouse
Community Kitchen
Elevators
Hobby Room
Maintenance
Pool
Sauna
Shuffleboard Court
Trash
Vehicle Wash Area

Sunny Isles Beach
Entry-Level
Entry-Level Homes & Condos