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='4' AND i.activo='1'
This Villa is located on a dreamlike 8.000m² large property behind Can Furnet and near Ibiza Town Enjoy the absolute tranquility on the spacious sun terraces. The "sundeck" features a great BBQ area with a small outdoor kitchen and a refrigerator, as well as an outdoor shower (hot/cold) and a toilet. The property consists of 3 buildings. You will rent the two building by the pool, each with a bedroom with double bed, air conditioning and private bathroom in each. The third uilding by the parking lot remains locked and is only for the owners private use. The villa is furnished with great attention to detail. In the left building seen from the pool, it has a double bedroom, bathroom with double sinks, a bathtub and a shower and a living room with sofa bed for a maximum of 2 children and a private terrace. In the right complex seen from the pool, it has a double bedroom with bathroom en suite, sink and shower as well as a dining / livi