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 = '1837.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Le Bon Coin | Bars / Restaurants
Beachfront | Seafood
La Passe / La Digue | La Digue
0.6 km from Jetty
Seafood, Creole Grill & Chinese food, Sunset Cocktails Pizzas, seafood pasta Meat and fish dishes Romantic dinner with amazing sunset Beach fiesta every friday with Live band and Traditional dance show starts at 7.30pm (free entrance
Seafood, Creole Grill & Chinese Food, Sunset Cocktails, wide selection of meat and fish dishes, pizzas, seafood pasta.
Beach fiesta every friday with Live band and Traditional dance show starts at 7.30pm (free entrance live music food and drinks).
Sea breezes drift among the rustic woods under high burlap roofs at Le Bon Coin restaurant & Bar, almost set over water. Sea breezes drift. Edible memories enhanced by enchanting tropical vistas, from inspiring equatorial sunrises above the translucent turquoise lagoon waters to romantic orange-coloured sunsets that dissolve into the evening sea. Dinner is à la carte.
By creating seychellespromo.com, our primary goal is to build a platform that will allow all users to find the information they are looking for within 3 clicks.
As a second step, our target is to bring a real contribution to the development of Seychelles tourism at a national and international level.
Because locals and visitors deserve it...
A Multimedia (SEYCHELLES) initiative!!!