Brickell Listings

Features
: Auto Pool Clean , Automatic Chlorination
: Furnished
1
1
Property Description

.LOCATION*LOCATION*LOCATION*ONE BLOCK FROM PRESTIGIOUS SUNNY ISLES BEACH SURROUNDED BY MULTI-MILLION DOLLAR HIGHRISES, WALK TO GREAT RESTAURANTS, SHOPPING, MINUTES TO AVENTURA MALL, CASINOS, GOLF COURSES, RACETRACK, VERY CENTRALLY LOCATED. UNIT IS UPGRADED WITH BRAND NEW APPLIANCES (just installed) ….VERY AFFORDABLE…….THIS ONE WILL NOT LAST! Available from April 29 2024 for 6 mo

Condo For Rent at AVILA SOUTH CONDO

210 172nd St #329, Sunny Isles Beach, Florida 33160

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 725 Sqft
$2,400
Listing ID#A11569801
QR Code
Basic Details
Subdivision : 210 172nd
Building Name : AVILA SOUTH CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11569801
Price : $2,400
Original Price : $2,500
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 725 Sqft
Year Built : 1974
Property Sub Type : Condominium
DOM : 4
Search Results

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

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent