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

Glacis Beach | Beaches

Info

  • View | Fishermen
  • Glacis Beach / North Mahe | Mahe
  • 9.1 km from Victoria / 18.3 km from Airport
  • Lovely small beach shaded by pine trees and Takamaka trees
    Local fishermen each morning before dawn
    View on the west coast of Mahe, Silhouette and North Island
    Difficult swimming due to rocks in the wate

Glacis Beach