SELECT i.*,il.titulo,il.mini,il.descripcion,c.categoria,c.url,c.portada FROM items i LEFT JOIN categorias c ON i.id_categoria=c.id LEFT JOIN items_lang il ON i.id=il.id_item AND il.id_lang='1' WHERE i.id='44' AND i.activo='1'
AP Ibiza
Sophisticated yet integrated in nature, Destino’s luminous energy makes it the ideal place to let go and immerse yourself in the island vibe by day or under the moonlight.
Properties:
With a privileged position on the secluded cliff top of Cap Martinet in Talamanca Bay, Destino overlooks the town of Ibiza, Formentera island and the Mediterranean.
