Features & Amenities

Interior

  • Other Interior Features

    Walk-In Closet(s), Elevator

  • Total Bedrooms

    2

  • Bathrooms

    2

  • Cooling YN

    YES

  • Cooling

    Central Air, Electric

  • Heating YN

    YES

  • Heating

    Central, Electric

  • Pet friendly

    No

Exterior

  • Garage

    Yes

  • Garage spaces

    1

  • Construction Materials

    Block

  • Other Exterior Features

    Balcony

  • Parking

    Covered

  • Patio and Porch Features

    Screened

  • Pool

    No

  • Waterfront YN

    NO

  • View

    Garden

Area & Lot

  • Property Type

    Residential

  • Property Sub Type

    Condominium

Price

  • Sales Price

    $675,000

  • Tax Amount

    $7,075

  • Sq. Footage

    2, 054

  • Price/SqFt

    $328

HOA

  • Association

    Yes

  • Association Fee

    $1,290

  • 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

    6

  • Association Amenities

    Clubhouse, Barbecue, Picnic Area

  • 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 Jorge Perez , NB Elite Realty

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 David  Jean-Louis

AGENT

David Jean-Louis

Call David 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.
Spacious and bright 2-bedroom, 2-bathroom condo in the well-maintained Le Frontenac building in Sunny Isles Beach. This unit features a functional layout with abundant natural light, a private balcony, and in-unit laundry. The building offers gated entry, a pool, and assigned parking in a quiet boutique-style setting. Ideally located just a short walk to the beach, shopping, restaurants, parks, and A-rated schools. A great opportunity for a primary residence, vacation home, or investment in an excellent location.

17801 N Bay Rd 614

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

New on site 1 day ago
Positioned on the 18th floor of Sole on the Ocean, an oceanfront condo-hotel in Sunny Isles Beach, this residence offers open city views and is currently enrolled in the building's hotel rental program, giving owners a turnkey opportunity to generate income while maintaining full personal use flexibility, making it an ideal structure for investors and second-home buyers seeking a property that works for them. The building delivers a full suite of hotel-grade services, including concierge, valet, and direct beach access, complemented by an oceanfront pool, fitness center, spa, beach cabanas, the beachfront BALEENkitchen restaurant and bar, and a lobby boutique. Its oceanfront positioning places residents steps from the sand with Bal Harbour Shops and Aventura Mall just minutes away, and a thriving dining and retail corridor surrounding the building makes everyday convenience as effortless as the white-glove service. Whether as a primary residence, a second home, or an income-producing asset, this unit presents a compelling opportunity in one of South Florida's most active condo-hotel markets.
#A11979188

Sunny Isles Beach

2 Beds

2 Baths

908 Sq.Ft.

$595,000

MLS#: A11979188

New on site 1 day ago
Rarely available "17" line corner residence at Winston Towers 200. Boasting the building’s premier floor plan with 1,544 sq. ft. of interior space, this renovated 2BR/2BA home features a massive wrap-around balcony with breathtaking, unobstructed sunset views over the Intracoastal and skyline.

This residence has total peace of mind with full IMPACT WINDOWS/DOORS and a BRAND NEW HVAC system—upgrades that ensure safety, silence, and significant insurance savings. The interior shines with high-gloss porcelain tile, an updated kitchen with stone counters, and a custom primary walk-in closet.

Enjoy resort amenities: 24-hour security, heated pool, gym, and tennis. Ideally located one block from the beach, parks, A-rated K-8 school, and within walking distance to houses of worship. This turn
#A11980355

Sunny Isles Beach

251 174th St 1517

2 Beds

2 Baths

1,544 Sq.Ft.

$589,000

MLS#: A11980355

New on site 1 day ago
Rare corner penthouse with sweeping direct bay views, exceptional privacy, and abundant natural light. This top-floor residence features a spacious open layout, large bedrooms and stunning water views throughout the day. Includes two assigned parking spaces — a valuable feature. Ideally located steps from the beach, with shops, restaurants, and daily conveniences within walking distance. Pet-friendly building with healthy reserves and low condo fees.  Priced for a quick sale.
#A11980266

Sunny Isles Beach

17100 N Bay Rd 1904

3 Beds

2 Baths

1,264 Sq.Ft.

$599,900

MLS#: A11980266

New on site 2 days ago
Step inside this beautiful and well maintained 3BR/2BA residence at St. Tropez II in the heart of Sunny Isles Beach. Move-in ready unit with over 1,460 sq ft of living space and a large wraparound terrace. Split floor plan with white porcelain tile floors, high ceilings, and floor-to-ceiling impact windows for abundant natural light. Open kitchen with high-end appliances, ample cabinetry, and breakfast bar overlooking the living area. Spacious primary suite with walk-in closet and bath with separate tub and shower.

Comes with 2 parking spaces (1 assigned, 1 valet) and storage. Furniture negotiable.
Just 1 block from the beach! This full-service building features resort-style amenities including pool, jacuzzi, fitness center, sauna, entertainment room, waterfront path, 24/7 doorman, concierge and valet. Ground floor feautures restaurants, cafes, salons, flower shop, and much more.  Residents can also enjoy Beach Club service at Sole hotel.
#A11979437

Sunny Isles Beach

200 Sunny Isles Blvd 2-702

3 Beds

2 Baths

1,461 Sq.Ft.

$775,000

MLS#: A11979437

New on site 4 days ago
Winston Towers 400 2/2 condo in the heart of Sunny Isles Beach. Besides location, walking distance to the beach, shops restaurants this property is completely remodeled, new impact windows, view. Take a look at the pictures and schedule a showing. See you soon.
#A11978465

Sunny Isles Beach

231 174th St 1501

2 Beds

2 Baths

1,488 Sq.Ft.

$650,000

MLS#: A11978465

PRICE HAS BEEN JUST REDUCED. Experience luxury Oceanfront living at this high floor corner 2 bedrooms, 2 bathrooms offering two open balconies and large floor to ceiling windows with breathtaking Ocean views at Sole Sunny Isles. This turn-key residence offers access to a world of resort-style amenities, including an award-winning restaurant, ocean-side pool, private beach club, state-of-the-art fitness room, sauna and steam rooms. Very well-priced and ready to have a new owner. This unit has two sides, one is an Ocean view room with balcony and full bathroom. The other is a one bedroom suite. Building offers a hotel rental program, allowing you to generate income when you're not enjoying the property yourself. Rent both sides or rent one side and use the other side, your choice.
#A11978340

Sunny Isles Beach

17315 Collins Ave 2105

2 Beds

2 Baths

908 Sq.Ft.

$545,000

MLS#: A11978340

Bright 1-bedroom, 1-bath condo-hotel unit on the 23rd floor with partial ocean views in Sunny Isles Beach. Fully furnished with full kitchen, washer and dryer inside the unit, and spacious layout. Perfect as a vacation home, second residence, or income-producing investment. Full-service building managed by DoubleTree by Hilton with resort-style amenities including private beach access with beach service, oceanfront pool, fitness center, spa, restaurant, pool bar, mini market, Starbucks café, 24-hour valet, and 24/7 security. Prime location near shopping, restaurants, parks, Aventura Mall, and Bal Harbor Shops. Condo fee includes electricity, water, cable, and internet.  Must see!
#A11975985

Sunny Isles Beach

17375 Collins Ave 2305

1 Beds

1 Baths

990 Sq.Ft.

$599,000

MLS#: A11975985

2 BEDROOM 2 BATHROOM RENOVATED UNIT. SS APPLIANCES. PORCELAIN TILES THROUGHOUT. BEAUTIFUL POOL AND INTER COASTAL VIEWS. MEDITERRANEAN STYLE BUILDING WITH GORGEOUS AMENITIES: HEATED POOL, JACUZZI, GYM, PLAYROOM, BUSINESS CENTER AND CONFERENCE ROOM. GREAT LOCATION. IN THE HEART OF SUNNY ISLES, WALKING DISTANCE TO THE BEACH, RESTAURANTS AND SHOPS.
#A11976714

Sunny Isles Beach

2 Beds

2 Baths

1,024 Sq.Ft.

$550,000

MLS#: A11976714

Beautifully upgraded 2-bedroom, 2-bath lower penthouse in the heart of Sunny Isles Beach, featuring southern exposure, tile flooring, in-unit laundry, and an open-concept kitchen. The spacious primary suite offers a large bathroom with double sinks, a linen closet, and a walk-in closet, while the balcony provides partial bay and city views with space to dine or unwind. Enjoy resort-style amenities at Porto Bellagio, including two pools, a jacuzzi, a new gym, clubhouse, private promenade, and more. Covered, assigned parking included. Walking distance to the beach, shops, restaurants, and a top-rated K–8 school. Pet-friendly community.
#A11975490

Sunny Isles Beach

17100 N Bay Rd 1802

2 Beds

2 Baths

1,024 Sq.Ft.

$585,000

MLS#: A11975490

 - 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.