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 For Sale
$399,000

BTC: 6.23437500

ETH: 228.52233677

41 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 • For Sale

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
$475,000
$320K – $659K
Confidence Low
List vs. estimate
$76K below estimate
List $399,000 · -16.0%
Our model says this listing is priced below recent comparable activity. Expect competition.
Price per sq ft
$300
-48.1% vs. city median $577
Based on
530 MLS comparables
+ 30 public-records sales within 0.5 mi
Median actual sale: $375K
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

New
For Sale
$289,000
Condo/Co-op
2 bds · 2 ba · 1,110 sqft
CORAL ISLE WEST CONDO, North Miami Beach
3545 NE 166th St # 1004, North Miami Beach FL 33160
New
For Sale
$400,000
Condo/Co-op
2 bds · 2 ba · 1,763 sqft
THE OAKS I CONDO,151 AT BISCAYNE, North Miami
15051 Royal Oaks Ln # 101, North Miami FL 33181
New
For Sale
$505,000
Condo/Co-op
3 bds · 2 ba · 1,367 sqft
VENTURE AT AVENTURA WEST, Aventura
2775 NE 187th St # 314, Aventura FL 33180
New
For Sale
$409,000
Condo/Co-op
2 bds · 2 ba · 747 sqft
LE CARTIER CONDO, Sunny Isles Beach
201 178th Dr # 315, Sunny Isles Beach FL 33160
New
For Sale
$347,500
Condo/Co-op
1 bds · 1 ba · 736 sqft
PARKER PLAZA ESTATES COND, Hallandale Beach
2030 S Ocean Dr # 1111, Hallandale Beach FL 33009
New
For Sale
$474,999
Condo/Co-op
1 bds · 1 ba · 1,005 sqft
OCEAN RESERVE CONDO, Sunny Isles Beach
19370 Collins Ave # 621, Sunny Isles Beach FL 33160
New
For Sale
$299,900
Condo/Co-op
2 bds · 2 ba · 1,083 sqft
POINT EAST SEC 4 CONDO, Aventura
3010 Marcos Dr # R314, Aventura FL 33160
New
For Sale
$299,000
Condo/Co-op
2 bds · 2 ba · 1,200 sqft
REEF EAST CONDO, North Miami Beach
16558 NE 26th Ave # 4J, North Miami Beach FL 33160

Market around this address

Live counts in the same area.
View all
This zip
33160
1,770
median $599K
Active
Same city
Sunny Isles Beach
1,107
median $775K
Active
Same type
Condo/Co-op
1,027
median $750K
Active
Similar price
$279K – $518K
279
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