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

Eustache Sarde's House | Places of Interest

Info

  • Culture | Tradition
  • Anse Reunion / La Digue | La Digue
  • 1.5 km from Jetty
  • One of the few remaining buildings made of timber in Seychelles
    Verandah decorated with wooden balusters
    Open architecture giving natural ventilation

Eustache Sarde's House