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

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Perfect Properties of Florida Real Estate via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Related Properties

New on site 1 day ago
Experience luxurious living with breathtaking intracoastal views in this fully upgraded 2-bedroom, 2-bathroom unit located in the prestigious Ocean Reserve Condo. Perfectly situated in a short-term rental approved building, this property is an ideal investment opportunity or a dream home. - Fully Upgraded: Modern finishes and upgrades throughout the unit ensure a stylish and comfortable lifestyle. - Amenities Galore: Take advantage of fantastic building amenities, including: - Refreshing pool - State-of-the-art modern gym - Tennis court - All amenities open to owners and tenants Additional Benefits: - Assessment Paid in Full: No additional assessments to worry about, as the seller has paid in full.
#A12015704

Sunny Isles Beach

19370 Collins Ave 826

2 Beds

2 Baths

1,526 Sq.Ft.

$619,000

MLS#: A12015704

New on site 1 day ago
Spacious and beautifully updated 2BD/2BA condo in the desirable Porto Bellagio community in Sunny Isles Beach! This fully furnished unit offers a comfortable open layout, abundant natural light, and peaceful water views from the private balcony. The modern kitchen features quality appliances and functional design, while the entire unit is clean, well-maintained, and move-in ready.
Located just a short walk to the beach, restaurants, shops, parks, and public transportation. The unit includes one assigned covered parking space.
Enjoy resort-style amenities including a heated pool, fitness center, clubhouse, yoga room, business center, and beautifully maintained common areas.
Excellent opportunity to enjoy convenient living in the heart of Sunny Isles Beach.
#A12015827

Sunny Isles Beach

17150 N Bay Rd 2905

2 Beds

2 Baths

1,116 Sq.Ft.

$635,000

MLS#: A12015827

New on site 3 days ago
PICKY BUYERS-WELCOME***PRIME LOCATION*  ACROSS THE OCEAN IN PRESTIGIOUS SUNNY ISLES BEACH-- 600 WINSTON TOWERS! COMPLETELY RENOVATED HIGH-END 2BD/2BA - 1,507 SF OF LUXURY LIVING AND BREATHTAKING OCEAN & CITY VIEWS FROM THE 8TH FLOOR***FEATURES OPEN-CONCEPT KITCHEN, DESIGNER FINISHES, CUSTOM ONYX BATHROOM WALLS, BRAND-NEW HURRICANE-IMPACT WINDOW & BALCONY DOORS IN EVERY ROOM, WASHER/DRYER IN UNIT, FULLY FURNISHED & EQUIPPED — TRULY MOVE-IN READY.  HOA INCLUDES: INTERNET, WATER, TV-CABLE, 1 PARKING *** RESORT-STYLE AMENITIES INCLUDE:24 HRS SECURITY, POOL, GYM, TENNIS COURT, LIBRARY, AND PING PONG ROOM. WALKING DISTANCE TO ALL CITY INFRASTRUCTURE: WALGREENS, PUBLIX, RESTAURANTS, POST OFFICE, TOP-RATED A-GRADE K-8 SCHOOL. JUST STEPS TO THE BEACH, SHOPPING, DINING. CLOSE TO BAL-HARBOUR & AVENTURA MALL. DON'T MISS OUT!
#A12014684

Sunny Isles Beach

210 174th St 811

2 Beds

2 Baths

1,507 Sq.Ft.

$795,000

MLS#: A12014684

New on site 3 days 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
#A12014016

Sunny Isles Beach

251 174th St 1517

2 Beds

2 Baths

1,544 Sq.Ft.

$569,900

MLS#: A12014016

Make this your new home in the heart of Sunny Isles, and every day will feel like a getaway. Step into this beautifully renovated 2-bed, 2-bath condo filled with natural light. Porcelain floors lead through a modern layout, with a nice kitchen featuring stainless steel appliances and granite countertops. Wake up just two minutes from the beach and enjoy your morning coffee with a sea breeze. After a day in the sun, come home to comfort with your in-unit washer/dryer and generous closet space. In the evening, enjoy resort-style amenities: a heated pool, gym, business center, and clubhouse. Plus, you’re only a steps from top restaurants, shops, and entertainment. Perfect as a full-time home, vacation retreat, or investment this condo offers the ideal mix of style, convenience, and location.
#A12011356

Sunny Isles Beach

17100 N Bay Rd 1610

2 Beds

2 Baths

1,024 Sq.Ft.

$550,000

MLS#: A12011356

Turnkey income-producing opportunity in the heart of Sunny Isles Beach. This fully renovated 1-bedr + Den residence is located in a high-demand and steps from the ocean building, that allows daily short-term rentals, including Airbnb—making it ideal for maximizing cash flow and occupancy year-round. The unit features modern finishes and is move-in/rent-ready, perfect for immediate revenue generation. Sold furnished. The building offers resort-style amenities including a heated pool, fitness center, tennis courts, on-site café, and convenience store—highly attractive features for short-term guests. Prime location directly across from the beach with strong rental demand, just minutes from Aventura Mall, world-class dining, and entertainment. Ideal for investors seeking a high-performing asset in one of South Florida’s most desirable short-term rental markets, with excellent potential for consistent occupancy and strong returns. 
The customer database and Super Host accounts on Airbnb / VRBO can be transferred upon request. Short-term license is valid until October 2026. You can start renting it out right away.
#A12007560

Sunny Isles Beach

19370 Collins Ave 1612

1 Beds

1 Baths

1,005 Sq.Ft.

$546,700

MLS#: A12007560

Remodeled ,Amazing 2 bedroom/2bathroom unit at Arlen House! If you are looking for a great place to live in Sunny Isles is the place! Walk to the beach whenever you wish! and Next to Oleta Park! Unit has an awesome views from a large size balcony and had impact doors slide windows. Building has gone through a massive renovation and is looking brand new!Building amenities, including a pool, gyms, tennis courts, 24-hour security, and a newly remodeled lobby, elevating your living experience
#A12006358

Sunny Isles Beach

100 bayview dr PH31

2 Beds

2 Baths

1,357 Sq.Ft.

$749,000

MLS#: A12006358

Welcome to one of the most exclusive and private units in Sunny Isles, where elegance meets comfort in the best-priced building in the city. This beautifully remodeled 2bed, 2bath + den offers a very spacious layout. With its warm and private ambiance, this unit stands out not only for its size but also for its thoughtful design. The master suite features a private balcony, adding to the two total balconies. Unique design elements, such as exquisite wallpapers, a sophisticated wooden entryway piece, and a master closet that is truly a masterpiece, enhance the refined atmosphere. Also its exceptional amenities, including pool, jacuzzi, tennis courts, private marina, gym, spa, two restaurants, and a convenience store—all just steps from the beach. Schedule your showing with me today!!
#A12006355

Sunny Isles Beach

100 Bayview Dr 216

2 Beds

2 Baths

1,603 Sq.Ft.

$800,000

MLS#: A12006355

Discover this beautifully maintained 3BD/2BA residence in the heart of Sunny Isles Beach, offering 1,234 SF plus a private terrace. Thoughtfully updated, granite countertops, newer appliances, modern fixtures, and the convenience of an in-unit washer and dryer. A recently installed new A/C unit adds efficiency and comfort year-round. All building assessments have been fully paid, adding further value and ease for the next owner. The residence also includes 2 dedicated parking spaces, an exceptional benefit in this area.
Ideally located within walking distance to top-rated A+ schools, restaurants, shopping, and grocery stores, and just a short stroll to the beach.
The pet-friendly community (up to 100 lbs) offers resort-style amenities, including two pools, two jacuzzis, a fully equipped fitness center, dance studio, clubhouse, and business center.
#A12005154

Sunny Isles Beach

17125 N Bay Rd 3505

3 Beds

2 Baths

1,264 Sq.Ft.

$560,000

MLS#: A12005154

Amazing views to the intercostal, Marina and Aventura. Across the street to the Ocean. This unit have ceramic floors, floor-to-ceiling sliding impact doors and expansive private glass balconies, with stainless steel appliances, Split bedrooms, master suite with walk-in closet. Prime location across from the Ritz-Carlton. Spectacular Lobby, gym, 2 Tennis Court, Jacuzzi, Large Pool Deck, Library, Pool Tables, Sauna, Bike/Jog Path, Boat Dock, Picnic Area, Business center, Community Room, Exercise Room, Child Play Room Area, Pool, and the amazing beach across the street to the building.
#A12004757

Sunny Isles Beach

100 bayview dr 1503

2 Beds

2 Baths

1,331 Sq.Ft.

$549,000

MLS#: A12004757

 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Perfect Properties of Florida Real Estate via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

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

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Perfect Properties of Florida Real Estate via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

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.