Beautiful 2 story corner unit in 1st floor, 2 bed, 2.5 bath. Totally renovated, Open and modern concept, Quartz Counter Top, Stainless Steel appliances. Gated community with Great amenities to enjoy like kids play ground, pool, gym, club house, tennis court, pet friendly. Centrally located with easy access to the major expressways Turnpike and Palmetto, I-75 as well as shopping centers, restaurants, supermarkets and much more. NO RENTAL RESTRICTIONS
Condo For Sale at MIRASSOU CONDO,Mirassaou Condominiu
6045 NW 186th St #117, Hialeah, Florida 33015
- Bedrooms : 2
- Bathrooms : 3
- Square Footage: 1,041 Sqft
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
- Prev
- Result of 570
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com