Brickell Listings

Features
: In Ground , Community
: Pool
: Unfurnished
1
1
Property Description

Amazing and spacious 2 bedroom and 2 bathroom corner unit!!! Large master bedroom with walk-in closet and master bathroom, extra natural light, brand new stainless steel appliances. Enjoy the views from any room or enjoy the serenity from the balcony. fabulous community pool. great community, secure and well maintained. Excellent location, less than 10 min from Aventura Mall and Sunny Isles with popular stores and restaurants. Easy access to Interstate I-95. MAKE YOUR OFFER NOW!!! NO PETS ALLOWED!!!

Condo For Rent at WILSHIRE CONDO

1200 NE Miami Gardens Dr #213W, Miami, Florida 33179

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,222 Sqft
$2,200
Listing ID#A11525597
QR Code
Basic Details
Subdivision : 1200 NE Miami Gardens
Building Name : WILSHIRE CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11525597
Price : $2,200
Original Price : $2,350
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,222 Sqft
Year Built : 1975
Property Sub Type : Condominium
DOM : 82
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