CocoWalk, 3015 Grand Avenue, Miami, FL 33133, USA
Spacious and fabulous home in prime location. This executive style four bed, four bath home has impact resistant windows, renovated kitchen with wood cabinets, granite countertops and luminous breakfast area. All bathrooms are tastefully redone with contemporary elements and vanities.
Open floor plan leads to the patio, pool and backyard for great entertainment or relaxation. Live in the city beautiful, enjoy the best shopping, restaurants, schools, and much more this home offers.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
) AND wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish' OR' at line 6]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.ID NOT IN (91) AND wp_posts.post_parent NOT IN (91) AND (
wp_term_relationships.term_taxonomy_id IN (46)
wp_term_relationships.term_taxonomy_id IN (,)
) AND wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','faq','agent','property','partners','slide' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','faq','agent','property','partners','slide' ) ) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 2