Award winning meticulous mansion, truly the grand dame of Shenandoah! Sellers were honored with the prestigious 2018 Key Keeper Award from the Dade Heritage Trust! Home is restored to perfection to satisfy the most discerning buyer. Lush gardens with wood-burning outdoor fireplace on one side, and a heated pool with water feature and gazebo on the other. Large, inviting terrace off the main bedroom, surrounded by mature trees. New kitchen with sitting area, new baths, laundry room, custom closet cabinetry, 2-zone A/C, impact windows throughout. Home is located in a quiet residential area, yet close to restaurants, theaters, and Brickell Ave. This is a truly exceptional home!
Single Family Home Sold SHENANDOAH2,612 Sqft
1004 SW 16th Ave, Miami, Florida 33135
- Bedrooms : 3
- Bathrooms : 4
- Square Footage: 2,612 Sqft
WordPress database error: [Unknown column 'http' in 'order clause']SELECT x.position FROM (SELECT p.id, @rownum := @rownum + 1 AS position FROM `wp_wpl_properties` AS p JOIN (SELECT @rownum := 0) r WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC ) AS x WHERE x.`id`='572550'
WordPress database error: [Unknown column 'http' in 'order clause']SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT 0, 1
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 `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT , 1
- Result of 2440
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com