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='42' AND i.activo='1'
Area: ES VIVE Apartment with large garden in Es Vive 5 minutes walk to the beach, bars and 15 walk to Ibiza center. • Large lounge area • 4 double bedrooms (one master bedroom, king size bed with ensuite bathroom and 3 bedrooms with standard double bed) • Each bedroom as access to the garden • Large kitchen • 2 bathrooms • Communal Swimming pool • TV • Air Con • Internet wi Area: Es Vive May 250 € x day June 350 € x day July 450 € x day August 450 € x day Sept 350 € x day Oct 250 € x day Check in : After 15:00 hs Check out: Before 10:00 hs Deposit: 1.000 € Final clean : 150 €