Features & Amenities

Interior

  • Other Interior Features

    Other, Walk-In Closet(s)

  • Total Bedrooms

    2

  • Bathrooms

    2

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Heating YN

    YES

  • Heating

    Central

  • Pet friendly

    No

Exterior

  • Garage

    No

  • Construction Materials

    Block

  • Parking

    Guest

  • Patio and Porch Features

    Porch

  • Pool

    Yes

  • Pool Features

    Association

  • Waterfront YN

    NO

  • View

    Bay

Area & Lot

  • Property Type

    Residential

  • Property Sub Type

    Condominium

Price

  • Sales Price

    $465,000

  • Tax Amount

    5690.0

  • Sq. Footage

    1, 330

  • Price/SqFt

    $349

HOA

  • Association

    Yes

  • Association Fee

    $755

  • Association Fee Frequency

    Monthly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    Norman S. Edelcup K-8

  • Middle School

    Highland Oaks

  • High School

    N/A

Property Features

  • Stories

    5

  • Association Amenities

    Clubhouse, Elevator(s), Pool, Spa/Hot Tub

  • Senior Community YN

    NO

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Miami-Dade

Elementary School

Norman S. Edelcup K-8

Middle School

Highland Oaks

High School

Listing Courtesy of Jacqueline Zarate , Miami Life Realty LLC

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Jarrod Gaylis

Realtor

Jarrod Gaylis

Call Jarrod today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Stunning, Fully Renovated 2-Bed/2-Bath Condo with Bay Views in Sunny Isles Beach! Fall in love with this bright and stylish residence at the boutique Le Frontenac. Featuring a modern split floor plan, in-unit washer & dryer, sleek finishes throughout, and a private balcony with partial bay views, this home is being offered fully furnished with contemporary décor just bring your suitcase! The building offers secure gated entry, a sparkling pool, relaxing hot tub, and covered assigned parking all in a peaceful, low-rise community. Perfectly situated in the heart of Sunny Isles, you’ll be just steps from the beach, supermarkets, restaurants, shops, parks, and top-rated schools

17801 N Bay Rd 505

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

New on site today
This stunning corner-unit condo offers breathtaking, unobstructed views of both the ocean and bay, delivering sweeping water vistas from every room. Featuring 2 bedrooms and 2 baths, this residence embodies the ultimate coastal lifestyle just a short walk from the beach.  Covered Parking spot #522

Located in a full-service building with 24-hour security, attended lobby, and valet parking, residents enjoy resort-style amenities including a heated pool, tennis courts, state-of-the-art fitness center, and game rooms with billiards and table tennis.   

Ideal as a primary residence, second home, or investment opportunity in a high-demand coastal market, with close proximity to Bal Harbour, Bay Harbor Islands, and Aventura.
#A11955649

Sunny Isles Beach

500 Bayview Dr 1422

2 Beds

2 Baths

1,295 Sq.Ft.

$550,000

MLS#: A11955649

New on site today
Rare opportunity in Sunny Isles Beach. A true 3-bedroom residence plus home office, offering a size and layout that is increasingly rare in this price range, especially when compared to nearby newer buildings where similar space typically trades much higher. Only a handful of residences like this come to market each year, making it an exceptional find for families ready to settle in.

Set in a top-rated school district, just steps from the beach, parks, bike path, and daily conveniences. Bright and sun-filled throughout, with a large wraparound balcony and ample closet space. The functional layout supports family life, remote work, and study—while the location invites connection and balance, from sunrise walks by the ocean, to evening strolls along the beach or nearby parks, and quiet moments together after busy days.

Located in a full-service, family-friendly gated private island offering tennis courts, pool, fitness center, sauna, children’s play areas, meeting rooms, mini market, beauty salon, valet parking, covered garage, 24-hour security, and on-site management. All district schools and American Heritage School buses stop at the community entrance. A rare blend of space, schools, amenities, and lifestyle in one of Sunny Isles Beach’s most desirable locations.
#A11958933

Sunny Isles Beach

300 Bayview Dr 206

3 Beds

2 Baths

1,570 Sq.Ft.

$535,000

MLS#: A11958933

New on site today
Impeccable unobstructed views! Spacious 2BR/2BA condo located in the heart of Sunny Isles Beach, just steps from the beach. This well-maintained residence features stylish finishes and has been kept in excellent condition, with new flooring, new balcony doors, and numerous additional improvements. Situated in a full-service building offering 24-hour security, doorman and valet parking. Amenities include a heated pool, tennis courts, fully equipped gym, and game rooms with billiards and table tennis. Ideal as a primary residence, second home, or investment opportunity in a highly desirable coastal location.
#A11942737

Sunny Isles Beach

300 Bayview Dr 1110

2 Beds

2 Baths

1,220 Sq.Ft.

$500,000

MLS#: A11942737

New on site 1 day ago
Beautiful unit in Sunny Isles Beach featuring  stunning ocean and bay view. Locateds on the 12 floor, this unit offers an open balcony , a modern kitchen with granite countertops, and wood floring on the living room area . Enyoy large walk -in closets and a spacious layout. Just steps from the beach and minutes from Aventuta mall.
#A11957973

Sunny Isles Beach

19390 Collins Ave 1220

2 Beds

2 Baths

1,525 Sq.Ft.

$495,000

MLS#: A11957973

New on site 1 day ago
Stunning 2-bedroom, 2-bathroom condo, located on the coveted 8th floor, offers a unique layout designed to maximize space and capture breathtaking views. Enjoy an airy, white and bright interior with modern finishes—completely free of outdated popcorn ceilings. Ideally situated in one of the most desirable neighborhoods, this home is perfect for those who value location, location, location. With top-rated schools just minutes away and an unbeatable urban lifestyle at your doorstep, this property truly has it all. Don’t miss the opportunity to experience contemporary coastal living in Sunny Isles—schedule your private tour today!
#A11958667

Sunny Isles Beach

210 174th St 807

2 Beds

2 Baths

1,232 Sq.Ft.

$374,000

MLS#: A11958667

New on site today
This first-floor apartment is ideal for those seeking easy access and tranquility. With two master bedrooms, each with a private bathroom and walk-in closet, you'll enjoy a spacious and functional living area. The modern laminate flooring and LED lighting create a warm and sophisticated ambiance. The modern, open-concept kitchen features quartz countertops, perfect for cooking and socializing. Located within walking distance to the Beach and adjacent to a shopping center, shops, and restaurants. Don't miss this opportunity to live in a unique location!
#A11957439

Sunny Isles Beach

17021 N Bay Rd 124

2 Beds

2 Baths

988 Sq.Ft.

$399,000

MLS#: A11957439

New on site 2 days ago
Enjoy breathtaking direct bay views from every bedroom in this amazing 2/2 unit.  It has an expansive private glass balcony with spectacular views to Oleta Park, the intracoastal, Downtown and partial ocean view.  Floor-to-ceiling sliding impact doors, Master suite has large walk-in closet.  Spectacular lobby with 24 hours reception, 2 tennis courts, jacuzzi, large pool deck, gym, library, picnic area, pool tables, sauna, business center, community room, on-site restaurant, children's playroom, and the amazing beach across the street to the building.  May be rented immediately 1x/yr for 6m+1 day.  Maintenance includes cable, internet, water, security, & more!   Centrally located between FLL & MIA airports.
#A11957681

Sunny Isles Beach

100 S Bayview Dr 1222

2 Beds

2 Baths

1,357 Sq.Ft.

$549,000

MLS#: A11957681

New on site 3 days ago
nice 2 bedroom 2 bath with impact windows --need some up dating - in the heart of sunny island
fplit  fllor plane
9
#A11956687

Sunny Isles Beach

290 174th St 1503

2 Beds

2 Baths

1,008 Sq.Ft.

$374,000

MLS#: A11956687

Price reduced
Best Deal in Sunny Isles!!
Located in a quiet and friendly building, this well-maintained 1-bedroom convertible with 2 baths is steps away from the beach. View of the Intracoastal from the extra-large balcony. Covered parking. Located in prestigious Sunny Isles Beach. This is a great apartment. Walk to stores, restaurants, and the beach. This building has 24-hour security & valet parking. Only minutes to Aventura, Bal Harbour, and Miami Beach. Affordable luxury in the best location.
#A11953413

Sunny Isles Beach

100 Bayview Dr 1401

2 Beds

2 Baths

1,357 Sq.Ft.

$375,000

MLS#: A11953413

Incredible opportunity to purchase this large 2/2 corner wrap with a panoramic view of the ocean, city and bay views. This apartment is priced to sell, and we are still welcome to all offers. We are ready to sell. This is a pet friendly building, but no rentals allowed at this time. Easy to see, low maintenance, new recreation areas, and freshly remodeled throughout. Great deal.
#A11955077

Sunny Isles Beach

301 174th St 1912

2 Beds

2 Baths

1,856 Sq.Ft.

$549,000

MLS#: A11955077

 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.