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

Manresa | Guest Houses


  • Anse Etoile / North Mahe | Mahe
  • 4.5 km from Victoria / 13.3 km from Airport
  • Hotel situated on the sea front in Anse Etoile
    Restaurant offers a variety of mouth-watering local and continental dishes