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 = '360.'
#AND m.img_type = 'offer'
ORDER BY positionOrder
Villa Creole | Self Caterings
4 chalets | Beachfront
Anse Reunion / La Digue | La Digue
1.4 km from Jetty
4 creole style wooden chalets located direct on Anse Reunion beach Set in a nice garden with seaview and fantastic sunset Breakfast and Creole dinner upon request Bicycle rental
The "Villa Creole" consist of four appartments, which were build at the creole style. The exclusive and high class well appointed chalets were completed in 2007 and are one of the best adresses on La Digue. The spacious rooms were arranged functional with many love to every detail.
On the left site of the bungalows you will find the main entrance (entrance to livingroom and kitchen). The right one leads you to the bedroom.
Villa Creole is located direct on the beach Anse Reunion. You can enyoy seaview from each of the four "Villa Creole".
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!!!