2 BEDS + DEN (CAN BE USE AS A 3RD BED) AMAZING VIEW FROM ALL ROOMS, BRAND NEW KITCHEN WITH GRANITE COUNTERTOPS, STAINLESS STEEL APPLIANCES, AND ITALIAN CABINETS, ALL MARBLE TROUGH OUT (EVEN CLOSETS!). WASHER AND DRYER INSIDE UNIT. CABLE, WI-FI, INTERNET, AND TVs IN EVERY ROOM. LIVE AS YOU WOULD IN A 5 STARS HOTEL WITH AMENITIES SUCH AS A GYM OVERLOOKING THE OCEAN, JACUZZI, HEATED POOL, BUSINESS CENTER, BEACH, SERVICES, ETC. ASK FOR SEASONAL RATES. AVAILABLE NOW!!!
STR-01661
Condo For Rent at LA PERLA CONDO
16699 Collins Ave #1904, Sunny Isles Beach, Florida 33160
- Bedrooms : 3
- Bathrooms : 3
- Square Footage: 1,715 Sqft
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 1' at line 1]SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `listing` = '9' AND `property_type` = '36' AND ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-33131") "Listing ID 33131"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `f_140`='1' AND (`f_140_options` LIKE '%,1,%' OR `f_140_options` LIKE '%,3,%' OR `f_140_options` LIKE '%,4,%' OR `f_140_options` LIKE '%,5,%' OR `f_140_options` LIKE '%,6,%' OR `f_140_options` LIKE '%,7,%' OR `f_140_options` LIKE '%,8,%' OR `f_140_options` LIKE '%,9,%' OR `f_140_options` LIKE '%,10,%') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si DESC , p.id ASC LIMIT , 1
- Prev
- Result of 573
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com