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='9' AND i.activo='1'
Upon arrival at this property , you cannot help but be instantly entranced by the exquisite and artful blend of typical Ibizan design, perfectly complemented with the allure of the striking Balinese style which abounds throughout this opulent house and its splendid gardens. Set just on the outskirts of the capital Ibiza Town, with its decadent nightlife and excellent gastronomic scene, it is a perfect location for those who wish to be close to the action yet be able to escape to their own private haven of peace and tranquility. The Asian theme is a nod to the owner’s origins, and they capture the magic of the Far East with creatively carved wooden doors, thick sabina beamed ceilings and exotic yet elegant soft furnishings. Comfort is assured here, there are several equally inviting spaces inside the house, all decorated to perfection where you can kick back and relax, and enjoy the views to the lush gardens. The sleek minimalist kitchen is fully equ