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='7' AND i.activo='1'
This Villa is an impressive and elegant 5 bedroom property, set high above the sea with absolutely breathtaking views overlooking the bay of Sol den Serra, one of the most renowned beauty spots on the island, with sparkling beautiful turquoise waters. This villa is close to the local amenities of the vibrant town of Cala Llonga and is only a short walk from the delightful and luxurious beach club 'Amante’. The living areas of this Villa are furnished to a very high standard with natural sunlight flooding through the floor to ceiling windows. The large, open-plan living room is divided over two levels and includes inviting sofas, with luxurious fittings and tasteful artwork creating an air of style and sophistication which abounds throughout this delightful home. The unique furniture has a retro 50´s and 70´s vintage style that coexists in perfect harmony with the modern architecture. The kitchen is integrated into the open plan living area and is fu