Brickell Listings

Features
: Garden
: Maximum 20 Lbs
: Furnished
1
1
Property Description

Enjoy centrally located 2 bed 2 bath condo in The Shamrock at the Gables, split floor plan, 1 assigned parking. Washer/Dryer in unit. Pedestrian friendly Coral Way , close to shopping, minutes from Coral Gables, Brickell, Cocowalk, US-I , Miami Children’s Hospital, UM, and Miami Airport. Walk to supermarket. NO amenities. Unfurnished or Partially Furnished.

Condo For Rent at SHAMROCK BY THE GABLES CO,Shamrock by the Gabl

2280 SW 32nd Ave #613, Miami, Florida 33145

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 923 Sqft
$2,850
Listing ID#A11557463
QR Code
Basic Details
Subdivision : 2280 SW 32nd
Building Name : SHAMROCK BY THE GABLES CO,Shamrock by the Gabl
Property Type : Condo
Listing Type : For Rent
Listing ID : A11557463
Price : $2,850
Original Price : $2,850
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 923 Sqft
Year Built : 2004
Property Sub Type : Condominium
DOM : 21
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