SELECT m.id, name_pic Name,thumbnail_name thumbnail,img_name picture, m.id mediaID, m.status, m.title, c.id clientID,m.position_order positionOrder, m.promo Promo
FROM clients c
LEFT JOIN medias m ON c.user_id = m.user_id
WHERE c.id = '1884.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Villa Charme de Lile | Self Caterings
4 appartments | Tropical garden
La Passe / La Digue | La Digue
0.2 km from Jetty
Four garden view self-catering apartments, just a few minutes away from famous Anse Source d'Argent
Located amidst a tropical garden with beautiful fruit trees and colourful plants and its own pool
Double bedroom with kingsize bed, bathroom with shower and toilet, fully-equipped kitchen, lounge
Private garden and veranda and a barbeque area
Rental bikes available near the apartments. Breakfast can be served to guests on request
Each apartment comes with a double bedroom with kingsize bed, a bathroom with shower and toilet, a fully-equipped kitchen, a small lounge, satellite TV, air-conditioning, Wifi. Each apartment is luxuriously-equipped with a private garden and veranda and a barbeque area. Guests have also access to a small pool and comfortable sunloungers. There are rental bikes available near the apartments. Breakfast can be served to guests on request. Laundry and ironing service are also on offer.
The Maison Charme de l'Ile offers four garden view self-catering apartments, just a few minutes away from the world-renowned Anse Source d'Argent beach. This charming, modern holiday home is located amidst a tropical garden with beautiful fruit trees and colourful plants and has its own pool.