Beautiful single family, 2-story home. Completely renovated, freshly painted, two story home with attached garage, stainless steel appliances and amazing, secure fence view from backyard. Gated community in good schools district, quiet neighborhood with fabulous landscaping and palm trees. Only minutes from Aventura mall and close to I95 and 441. Great access to highways !! Community features game room, party room, ping pong room, tennis courts, swimming pool, jacuzzi, basketball courts. 24 hours security !!
Single Family Home For Sale SAN SIMEON HOMES1,854 Sqft
202 NE 211th Ter, Miami, Florida 33179
- Bedrooms : 4
- Bathrooms : 3
- Square Footage: 1,854 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 574
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com
