SELECT, name_pic Name,thumbnail_name thumbnail,img_name picture, mediaID, m.status, m.title, clientID,m.position_order positionOrder, Promo FROM clients c LEFT JOIN medias m ON c.user_id = m.user_id WHERE = '175.' #AND m.img_type = 'offer' ORDER BY positionOrder

Bougainvillea | Self Caterings


  • 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