Brickell Listings

Features
: Restrictions Or Possible Restrictions , No
: Unfurnished
0
0
Property Description

1st Floor Spacious 2b/2b condo available in the highly desirable “The Moors community”.
Completely remodeled with in-unit washer and dryer. Many amenities within The Moors community include a gated entrance, community pool, fitness center, basketball, tennis courts and much more. Centrally located near major highways, shopping centers and restaurants. Your new home is ready for you to move in! 650 minimum credits and no association fees.

1 assigned parking space with plenty of guest parking and much more.

Condo For Rent at MOORS POINTE CONDO,The Moors

18266 Mediterranean Blvd #803, Hialeah, Florida 33015

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 900 Sqft
$2,550
Listing ID#A11549212
QR Code
Basic Details
Subdivision : 18266 Mediterranean
Building Name : MOORS POINTE CONDO,The Moors
Property Type : Condo
Listing Type : For Rent
Listing ID : A11549212
Price : $2,550
Original Price : $2,550
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 900 Sqft
Year Built : 1987
Property Sub Type : Condominium
DOM : 45
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