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 = '222.' #AND m.img_type = 'offer' ORDER BY positionOrder

Le Niol Health Resort | Self Caterings

Info

  • Le Niole / North Mahe | Mahe
  • 2.8 km from Victoria / 12.0 km from Airport
  • Located in the North of Mahé
    Attached gym, swimming pool and Ayurvedic health centre
    5 minutes' drive from Beau Vallon Bay

Le Niol Health Resort