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='31' AND i.activo='1' AP Ibiza
CHALLENGER 300

Maximum Range 7.2 hours Baggage Space 106 ft3 Lavatory Full

Properties:
Passengers 9 Cabin Size 6.1 ft. H


7.2 ft. W


28.6 ft. L
MAKE YOUR RESERVATION

All fields are required!

Our Partners
Our partners
Our partners
Our partners
Our partners