SELECT COUNT(DISTINCT(ca.id)) AS nombre FROM camping ca LEFT JOIN camping_prestation cp ON cp.id_camping=ca.id WHERE ca.abonne=1 AND ca.id_statut=1 AND ( cp.id_service=26 )

SELECT ca.* FROM camping ca LEFT JOIN camping_prestation cp ON cp.id_camping=ca.id WHERE ca.abonne=1 AND ca.id_statut=1 AND ( cp.id_service=26 ) GROUP BY ca.id LIMIT 0,30
Home
Quick search
Advanced search
Region :
Department :
Environment
Shaded
Very shaded
Mountain
Natural reserve
River
Lake or pond
Sea
Rentals
Canoë-kayak
Mobil home
Tent
Bicycle
Caravan
Bungalow
Chalet
Sailing bungalow
Yurt
Services
Services
Games children
Bar
Laundry
Nursery
Night club
Hot shower
Grocery
Ice
Equipment for handicap
Games
Games adult
Washing-machines
Bakery
Pizzeria
Dishes to be carried
Restaurant
Organized Animations
TV room
Animals forbidden
Camping-car area
Dancing parties
Snow camping
Washing room for babies
Barbecue
Carpark obligatory
Holidays check
WIFI
Sports
Horsemanship
Golf course
Swimming pool
Nautic skiing
Tennis
ULM
Sailing boats
Volley ball
Moutain bike
Archery
Leisures
Bowling
Excursions
Tasting
Expositions
Stretching
Bathe
Mini-golf
Children swimming pool
Fish
Game of bowls
Ping pong
Sauna
Beach

Warning: sizeof(): Parameter must be an array or an object that implements Countable in /home/skiplanet/domains/lescampingsdefrance.com/public_html/test/includes/moteur.php on line 120
The most visited
Image not found
Campéole Plage Sud
Landes
Image not found
Sunelia les 3 Vallées
Hautes Pyrénées
Image not found
Campéole Les Sirènes
Vendée
Image not found
Les Paludiers
Loire Atlantique
Image not found
Village Center la F...
Gironde
Image not found
Campéole Plage des ...
Vendée
Image not found
Campéole la Grande ...
Vendée
Image not found
Campéole Les Tourte...
Landes
Mountain holidays

Search result :

14 campsites found
Camping Les Prairies  ***100 places
Image not found
La Haute Gréyère
04140 - Seyne
Tel : 04 92 35 10 21
Fax : 04 00 00 00 00
Send an email
Camping Le Haut Salat  ***136 places
Image not found
Route de Soueix
09140 - Seix
Tel : 0682160036 - 0561668178
Fax : N.C.
Send an email
Camping Clair matin  ***194 places
Image not found
20 Rue de Pommiers
38580 - Allevard
Tel : 04 76 97 55 19
Fax : 04 76 45 87 15
Send an email
Camping Caravaneige Les Buissonnets  ***109 places
Image not found
LES GRANGEONS
38112 - Meaudre
Tel : 04 76 95 21 04
Fax : 09.70.62.85.21
Send an email
Camping Le Galier  **77 places
Image not found
Route de St Chély
48120 - Saint Alban sur Limagnole
Tel : 04 66 31 58 80
Fax : N.C.
Send an email
Camping Les Bouleaux  ****100 places
Image not found
Rue des Bouleaux
68470 - Ranspach
Tel : 03 89 82 64 70
Fax : 03 89 39 14 17
Send an email
Camping Le Reclus  **100 places
Image not found
Route de Tignes
73700 - Bourg Saint Maurice
Tel : 04 79 41 01 05
Fax : 04 79 41 01 05
Send an email
Camping Bornand  **69 places
Image not found
57, route du grand bois
74120 - Megève
Tel : 04 50 93 00 86
Fax : 04 50 93 02 48
Send an email
Camping Le Madrid  ***109 places
Image not found
410, Route de Saint Félix
74150 - Rumilly
Tel : 04 50 01 12 57
Fax : N.C.
Send an email
Camping Les Acacias  ***50 places
Image not found
191 rue Léonard de Vinci
88650 - Anould
Tel : 03 29 57 11 06
Fax : N.C.
Send an email
Camping Le Pyrénéen  ***75 places
Image not found
7 molles
31110 - Salles et Pratviel
Tel : 05 61 79 59 19
Fax : N.C.
Send an email
Camping Les Sources  ****250 places
Image not found
Route des Crêtes
68700 - Wattwiller
Tel : 03 89 75 44 94
Fax : 03 89 75 71 98
Send an email
Camping Sunelia les 3 Vallées  ****483 places
Image not found
Avenue des Pyrénées
65400 - Argelès Gazost
Tel : 05 62 90 35 47
Fax : 05 62 90 35 48
Send an email
Camping les Cigales  **33 places
Image not found
Allée des platanes
26110 - SAINTE JALLE
Tel : 0475273488
Fax : 0475273432
Send an email