logo
Properties
Explore our listings
Buy
Listings for sale
Rent
Listings for rent
Explore
Neighborhoods, buildings & trends
Neighborhoods
Check neighborhoods information
Buildings
Check buildings information
Pre-Construction
New developments on sale
Market Trends
Monthly market data & analysis
Resources
Blog, tools & guides
Blog
Articles & guides
Tax Calculator
Compare tax savings
Property Tax Calculator
Estimate your annual tax
Sell Your Home
Get a free home valuation
Contact
Tell us about your needs
Language
Change website language
English
Русский
Español
中文(简体)
Sign In
Sign in or register

17801 N Bay Rd # 210, Sunny Isles Beach FL 33160

Condo/Co-op Active With Contract
$399,000

BTC: 6.23924941

ETH: 209.70861540

93 days
2 bds
2 ba
1,330 sqft

Overview

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

Location

Florida • Sunny Isles Beach • 33160 • Condo/Co-op • Active With Contract

Details

Type:
Residential
Parking:
1 Space / Assigned
Year Built:
1991
Lot:
No Data
Heating:
Central
Price/sqft:
$300
Cooling:
Central Air
HOA:
$835

Valuation

Our model vs. what's actually selling nearby.
Estimate
$470,000
$319K – $654K
Confidence Low
List vs. estimate
$71K below estimate
List $399,000 · -15.1%
Our model says this listing is priced below recent comparable activity. Expect competition.
Price per sq ft
$300
-46.7% vs. city median $562
Based on
536 MLS comparables
+ 30 public-records sales within 0.5 mi
Median actual sale: $578K
Median of recent comparable listings. Sold comps use closing price, active listings use list price.

Highlights

Annual tax
$5,769
2026
HOA
$835/mo
View
Pool Area View
Garage
1 car garage
Pets
Not allowed
All facts and features

  • Flooring

    • Ceramic Floor

    Heating

    • Central

    Cooling

    • Central Air

    Appliances

    • Dishwasher

    • Dryer

    • Electric Water Heater

    • Microwave

    • Electric Range

    • Refrigerator

    • Washer

    Other interior features

    • First Floor Entry

    • Walk-In Closet(s)

    Bedrooms and bathrooms

    • Bedrooms: 2

    • Full bathrooms: 2

  • Parking

    • 1 Space

    • Assigned

    Property

    • Exterior Features: Other / Open Balcony

    Other Property Information

    • Parcel Number: 31-22-11-053-0460

  • Type and style

    • Property Type: Residential

    • Property Sub Type: Condominium

  • Other financial information

    • HOA: $835

    • HOA Frequency: Monthly

    • Annual tax amount: $5,769

  • Source details

    • MLS ID: A12006028

    Other facts

    • Construction Materials: Concrete Block Construction

    • Patio And Porch Features: Open Balcony

    • Garage Spaces: 1

    • Garage: Yes

    • Living Area: 1330

    • Subdivision Name: LE FRONTENAC CONDO

Private inquiry
Talk to the advisor on this listing.
Floor plans, HOA docs, off-market comparables, scheduling a private showing — one message, direct to the local specialist.

More like this

Active With Contract
$500,000
Condo/Co-op
2 bds · 2 ba · 1,945 sqft
MEDITERRANEAN VILLAGE CON, Aventura
3500 Island Blvd # 203, Aventura FL 33160
New
Active With Contract
$469,000
Condo/Co-op
2 bds · 2 ba · 1,610 sqft
100 HIDDEN BAY CONDO, Aventura
3370 Hidden Bay Dr # 507, Aventura FL 33180
+$126K
Active With Contract
$425,000
Penthouse
2 bds · 2 ba · 1,361 sqft
Mystic Pointe, Aventura
19101 Mystic Pointe Dr, Aventura FL 33180
New
Active With Contract
$389,000
Condo/Co-op
1 bds · 2 ba · 816 sqft
UPTOWN MARINA LOFTS CONDO, Aventura
3029 NE 188th St # 819, Aventura FL 33180
Active With Contract
$505,000
House
3 bds · 3 ba · 1,170 sqft
FULFORD BY THE SEA, North Miami Beach
1869 NE 181st St, North Miami Beach FL 33162
Active With Contract
$415,000
House
3 bds · 2 ba · 1,360 sqft
TRAILER CITY, North Miami Beach
2475 NE 137th St, North Miami Beach FL 33181
Active With Contract
$448,000
Condo/Co-op
2 bds · 2 ba · 1,530 sqft
HARBOR TWS AT THE WATERWA, Aventura
3598 Yacht Club Dr, Aventura FL 33180
Active With Contract
$475,000
Condo/Co-op
2 bds · 2 ba · 1,138 sqft
WATERVIEW CONDO, Aventura
20505 E Country Club Dr # 1133, Aventura FL 33180

Market around this address

Live counts in the same area.
View all
This zip
33160
1,796
median $585K
Active
Same city
Sunny Isles Beach
1,133
median $740K
Active
Same type
Condo/Co-op
1,069
median $699K
Active
Similar price
$279K – $518K
289
median $385K
Active

The multiple listing information is provided by the Miami Association of REALTORS® from a copyrighted compilation of listings. The compilation of listings and each individual listing are ©2026-present Miami Association of REALTORS®. All Rights Reserved. The information provided is for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All properties are subject to prior sale or withdrawal. All information provided is deemed reliable but is not guaranteed accurate, and should be independently verified. Listing courtesy of: Miami Dream Real Estate