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='3' AND i.activo='1'
A charming holiday villa situated in a unique location within the secure prestigious community of Vista Alegre with stunning front line sea views. The stunning villa has exterior dining area with BBQ on an elevated terrace surrounding the house, carefully arranged gardens and exterior and interior lounges with sea views provide an extraordinary experience of simplicity combined with luxury. The Villa has Frontal sea views with direct sea access, shares a community swimming pool, Bose music and a ping pong table. This villa is perfect for guests who wish to unwind under the bright blue skies of Ibiza while gazing over the majestic blue waters of the Mediterranean. License Number: ETV-2573–E