Brickell Listings

Features
: In Ground , Community
: Direct Ocean , Ocean
: Unfurnished
1
1
Property Description

Condo for rent in Miami Beach, VIEW TO THE BEACH, in the middle of South Beach
beautiful view, enjoy the beach. Includes one parking, rent second.

Condo For Rent at TRITON TOWER CONDO

2899 Collins Ave #903, Miami Beach, Florida 33140

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 775 Sqft
$2,400
Listing ID#A11450468
QR Code
Basic Details
Subdivision : 2899 Collins
Building Name : TRITON TOWER CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11450468
Price : $2,400
Original Price : $3,200
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 775 Sqft
Year Built : 1966
Property Sub Type : Condominium
DOM : 234
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