Brickell Listings

Features
: In Ground
: Furnished
1
1
Property Description

Spacious 1 bedroom condo available for rent April 1st. Beautiful view on intracoastal. Building has pool, gym, tennis court and rent includes basic cable, internet and parking. Great location, short walk from the beach, shops, Heritage park, restaurants and houses of worship. Unit comes fully furnished. Easy to show. Contact listing agent. No Saturday showings.

Condo For Rent at OCEANVIEW BUILDING A COND

19390 Collins Ave #1225, Sunny Isles Beach, Florida 33160

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 1,000 Sqft
$2,350
Listing ID#A11549031
QR Code
Basic Details
Subdivision : 19390 Collins
Building Name : OCEANVIEW BUILDING A COND
Property Type : Condo
Listing Type : For Rent
Listing ID : A11549031
Price : $2,350
Original Price : $2,500
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,000 Sqft
Year Built : 1971
Property Sub Type : Condominium
DOM : 28
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