Brickell Listings

Features
: Unfurnished
1
1
Property Description

Conveniently located beautiful end unit townhouse within a gated community. One minute away from Turnpike, five minutes away from the Hard Rock Stadium and about ten minutes away from the Hard Rock Casino. This property comes with 4 spacious bedrooms and three full bathrooms with One bedroom and full bathroom on the main floor. Upstairs, you will see the beautiful laminate wood flooring throughout. Master bedroom comes with two walking closets, his and hers vanity, roman tub, and a separate shower. AC unit is brand new and roof is two years old. For showing, use showtime assist. Please allow one hour notice. For any other questions contact listing agent.

Condo For Rent at MAJORCA ISLES IV CONDO

21011 NW 14th Pl #154, Miami Gardens, Florida 33169

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,689 Sqft
$3,400
Listing ID#A11529588
QR Code
Basic Details
Subdivision : 21011 NW 14th
Building Name : MAJORCA ISLES IV CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11529588
Price : $3,400
Original Price : $3,400
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,689 Sqft
Year Built : 2009
Property Sub Type : Townhouse
DOM : 9
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