Switzerland

Prealpes

Switzerland

Gruyere

Prealpes

Valais

Lemanic

Countryside

Jura

Activities

Leisure

	Alpine Coaster Amusement Parks It is the highest of its kind in the world. Les Diablerets 2971m

	Dog sled ride Sightseeing & excursions A muscher experience! Les Diablerets

	Snow Bus Sightseeing & excursions A ride on the glacier, the feet in the dry! Les Diablerets

Order by:	Alphabetical order By place
results by page:

Autres suggestions:

	copyright 2003 - 2008 Cityall S.à.r.l.
	\| Tourism guide of the French-speaking Switzerland.

IDREG: 2
IDRUB: 2
IDSRUB: 1
IDSSRUB: 0 |
NBS: 3
-----------------
SELECT content.id,content.nom_e,content.minidesc_e,ville_village.nom_e as lieu FROM content,content_id,ville_village WHERE content.id = content_id.idcontent AND ville_village.id = content.id_ville_village AND content_id.idreg = '2' AND content_id.idrub = '2' AND content_id.idsrub = '1' AND content_id.existe_en_e = '1'
-----------------
SELECT content.id,content.nom_e, content.minidesc_e, content.photo_principale, content.nivdiff, content.duree, content.altitude, ville_village.nom_e as lieu, srubrique.nom_e as nomsrub, ssrubrique.nom_e as nomssrub, sssrubrique.nom_e as nomsssrub, srubrique.nom_url_e as nomurlsrub, ssrubrique.nom_url_e as nomurlssrub, sssrubrique.nom_url_e as nomurlsssrub FROM content,content_id,ville_village, srubrique,ssrubrique,sssrubrique WHERE content.id = content_id.idcontent AND ville_village.id = content.id_ville_village AND content_id.idreg = '2' AND content_id.idrub = '2' AND content_id.idsrub = '1' AND srubrique.id = content_id.idsrub AND ssrubrique.id = content_id.idssrub AND sssrubrique.id = content_id.idsssrub AND content_id.existe_en_e = '1' ORDER BY content.nom_e LIMIT 0,10