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

Beau Sejour Hotel | Guest Houses

Info

  • Bel Air - Victoria / Mahe | Mahe
  • 2.1 km from Victoria / 10.7 km from Airport
  • 9 inviting rooms and escape the stresses of the day
    Family run establishment offering bed & breakfast accommodation
    Discover a piece of Seychelles paradise
    Enjoy the natural cooling and refreshing breeze on the balcony after a long day touring around Mahe

Beau Sejour Hotel