Brickell Listings

Features
: In Ground
: Garden
: Furnished
1
1
Property Description

Beautiful apartment 1 Bed & 1 Bath.FULLY FURNISHED. Granite counter top kitchen with S/S appliances. Washer & dryer inside of the unit. Huge balcony with an spectacular view of the city. The location is super attractive as it is on all of LeJeune Rd, near Miami International Airport, Highway 836, Coral Gables, Little Havana, Miracle Mile, 20 minutes from Miami Beach. The Building has a security guard, swimming pool, gym, Social Room, Visitor Parking and more!!
.

Condo For Rent at MEDITERRANEA CONDO

117 NW 42nd Ave #506, Miami, Florida 33126

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 696 Sqft
$2,200
Listing ID#A11562993
QR Code
Basic Details
Subdivision : 117 NW 42nd
Building Name : MEDITERRANEA CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11562993
Price : $2,200
Original Price : $2,200
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 696 Sqft
Year Built : 2006
Property Sub Type : Condominium
DOM : 3
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