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='36' AND i.activo='1' AP Ibiza
AVANTE - 2 PX

Sleeps: 2 px - 4 px Rooms: 1 Bathrooms: 1 Sofa bed Area: Marina Botafoch Full equip : Wi-Fi /
Air conditioner / Fridge / Washing machine / Microwave / Coffee Machine /
Toaster / Iron / Hair Dryer . Check in : After 15:00 hs Check out: Before 10:00 hs Deposit: 1.000 € Final clean : 150 €

Properties:
MARINA BOTAFOCH - FIRST LINE SLEEPS: 2 PX
MAKE YOUR RESERVATION

All fields are required!

Our Partners
Our partners
Our partners
Our partners
Our partners