435 Southwest 12th Avenue, Miami, FL 33130, USA
Luxury Apartment available in an ideal location, with city and ocean views, walking distance to important Roads and lifestyle amenities, enjoy a Chic, well decorated 5 star apartment just steps away to the beach.
2 large bedrooms with a Queen size bed each, 2 full bathrooms plus a full size sofa-bed to accommodate up to 6 people.
The apartment is well equipped with everything you need for a pleasant stay, brand new appliances, complete dining set plus pots, pans, silverware, small appliances, plus TV, high speed internet WiFi and free garage parking.
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 (39) AND wp_posts.post_parent NOT IN (39) AND (
wp_term_relationships.term_taxonomy_id IN (47)
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