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 = '409.' #AND m.img_type = 'offer' ORDER BY positionOrder
sunset-beach, Beaches in Seychelles Islands

Sunset Beach | Beaches

Info

  • Swimming | Sunset
  • Sunset Beach / North Mahe | Mahe
  • 7.5 km from Victoria / 16.7 km from Airport
  • Small beach closed to the Sunset Beach Hotel
    Access by taking a path from the main Rd or by the hotel car park
    Swimming, good snorkelling along the rocks
    Very relaxing under the palm trees
    Breathtaking sunsets, waves during certain periods

Sunset Beach