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

Bougainvillea | Self Caterings

Info

  • Bougainville / South East Mahe | Mahe
  • 22.5 km from Victoria / 13.2 km from Airport
  • Situated at Bougainville on Mahe
    Only 600 metres from the coast in the mountainside, minutes away from beautiful beaches
    A perfect place to relax and unwind peacefully

Bougainvillea