Wyniki

Wakacje na kempingu w regionie Rhône-Alpes we Francji to wspaniały sposób na poznanie wspaniałych krajobrazów i bogatej kultury tego regionu. Region Rhône-Alpes jest znany z imponujących gór, takich jak Alpy, wąwozy Ardèche i Mont Blanc. W regionie znajduje się wiele zabytkowych miast i wsi, w tym Lyon, Grenoble i Annecy.

Świetnym sposobem na zwiedzanie regionu jest zarezerwowanie kempingu w pobliżu Lyonu, Grenoble lub Annecy. Stamtąd można wybrać się na wiele wycieczek po okolicy. Istnieje wiele tras pieszych, które prowadzą przez góry i wąwozy, a wycieczki rowerowe są również popularną opcją.

Osoby zainteresowane historią i kulturą regionu Rhône-Alpes z pewnością znajdą to, czego szukają w Lyonie, Grenoble i Annecy. Wszystkie trzy miasta są bogate w architekturę i atrakcje, w tym Musée des Beaux-Arts w Lyonie, Musée de Grenoble i Musée-Château d'Annecy. Jest też wiele okazji, by skosztować regionalnej kuchni i win z regionu Rhône-Alpes.

Osoby wybierające wakacje na kempingu w Rodanach-Alpach mają do wyboru wiele kempingów w tym regionie. Są tu zarówno mniejsze obiekty z kilkoma stanowiskami, jak i większe, z kilkuset stanowiskami i szeroką ofertą noclegową. Niektóre miejsca oferują także różne atrakcje, takie jak baseny, place zabaw i obiekty sportowe.

Jeśli wybierzesz wakacje na kempingu w regionie Rodan-Alpy, koniecznie wybierz się na wycieczkę w słynne góry i wąwozy tego regionu. Alpy, wąwozy Ardèche i Mont Blanc to tylko kilka przykładów z wielu naturalnych atrakcji, jakie ma do zaoferowania region Rodan-Alpy.

W sumie Rhône-Alpes oferuje wiele możliwości urozmaicenia wakacji na kempingu.

An Error occured!SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'
( select ''as tt_campsite_id, c.campsite_id, /*str_radius*/ c.campsite_name, ifnull(c.campsite_bestplace,0) as campsite_bestplace, ifnull(c.campsite_status,0) as campsite_status, c.campsite_latlong, co.country_value_pl as country_name, cr.country_region_value_pl as region_name, c.campsite_zip, c.campsite_phone, c.campsite_email, c.campsite_website, c.campsite_city, c.campsite_country, c.campsite_region,c.campsite_street, GROUP_CONCAT( cc.campsite_characteristic_id ) as defids , ( select concat('[', GROUP_CONCAT( DISTINCT( concat('{"id":"', cc.campsite_characteristic_id, '","title":"', cc.campsite_characteristic_name_pl , '","icon": "', cc.campsite_characteristic_type_icon,'"}' ) ) ) ,']') ) as char_defs, ( select concat('[', (select GROUP_CONCAT(DISTINCT CONCAT(' {"image":"', ac.campsite_accommodation_type_icon ,'", "id":"', ac.campsite_accommodation_type_id,'", "pos":"', ac.sortposition,'", "text":"', ac.campsite_accommodation_type_value_pl,'"}' ) ) from campsite_accommodations_combinations acc inner join campsite_accommodation_type ac on ac.campsite_accommodation_type_id = acc.campsite_accommodation_type_id where acc.campsite_id=c.campsite_id GROUP by acc.campsite_id ) ,']') ) as json_accos, ( select concat('[', (select GROUP_CONCAT(DISTINCT CONCAT('{"provider":"',p.campsite_provider_name, '", "provider_id":"',p.campsite_provider_id, '", "provider_image":"', ifnull(p.campsite_provider_image,'') , '", "id":"', cpc.campsite_provider_combination_id , '","deeplink":"', cpc.deeplink, '","premium":"', (select count(*) from campsite_provider_premium cpp where cpp.campsite_provider_id = cpc.campsite_provider_id and cpp.campsite_id =c.campsite_id ),'"}' ) order by (select count(*) from campsite_provider_premium cpp where cpp.campsite_provider_id = cpc.campsite_provider_id and cpp.campsite_id =c.campsite_id ) desc ) from campsite_provider p inner join campsite_provider_combinations cpc on cpc.campsite_provider_id = p.campsite_provider_id inner join campsite_accommodations_combinations cac on (cac.campsite_provider_id = p.campsite_provider_id and cac.campsite_id = cpc.campsite_id ) left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = cpc.campsite_id ) where cpc.campsite_id=c.campsite_id and cpc.language='pl' and cpc.deeplink!='' and ifnull(p.campsite_provider_status,1)<=1 and ifnull(p.campsite_provider_activ_pl,1)=1 and ifnull(s.campsite_provider_status_value,1)=1 ) ,']') ) as provider_json, ifnull(c.campsite_description_pl,'') as campsite_description, c.campsite_stars /*, ( select GROUP_CONCAT(post_id) as posts from wp_postmeta WHERE meta_key='cb_campsite_id' and meta_value=c.campsite_id ) as post_ids */ from campsites c inner join campsite_characteristics_combinations ccc on ccc.campsite_id = c.campsite_id inner join campsite_characteristics cc on cc.campsite_characteristic_id=ccc.campsite_characteristic_id inner join country co on co.country_id = c.campsite_country inner join country_region cr on cr.country_region_id = c.campsite_region where (select count(*) from imagepool_images iip where iip.campsite_id = c.campsite_id and isnull(iip.deleted_date) ) >0 and c.campsite_country='1' and c.campsite_region='153' and (select count(*) from campsite_provider_combinations acc_main inner join campsite_provider p on p.campsite_provider_id = acc_main.campsite_provider_id left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = acc_main.campsite_id ) where acc_main.campsite_id=c.campsite_id and acc_main.language='pl' and ifnull(p.campsite_provider_activ_pl,1)=1 and ifnull(s.campsite_provider_status_value,1)=1 and acc_main.deeplink!='') >0 and c.campsite_online=1 and ifnull(c.campsite_online_pl,1)=1 group by c.campsite_id order by ifnull(c.campsite_bestplace,0) desc, -c.campsite_description_de DESC, FIELD(c.campsite_status, '7') DESC, (select count(*) from campsite_provider_combinations acc_main where acc_main.campsite_id=c.campsite_id and acc_main.language='pl' and acc_main.deeplink!='') desc ) UNION ( SELECT t.tt_campsite_id, t.campsite_id AS campsite_id, t.name AS campsite_name, 0 AS campsite_bestplace, 1 AS campsite_status, concat(t.latitude, ',', t.longitude) AS campsite_latlong, t.country AS country_name, t.region AS region_name, '' AS campsite_zip, '' AS campsite_phone, '' AS campsite_email, '' AS campsite_website, t.city AS campsite_city, t.country AS campsite_country, t.region AS campsite_region, t.address AS campsite_street, '' AS defids, '' AS char_defs, '' AS json_accos, '' AS provider_json, '' AS campsite_description, '' AS campsite_stars FROM tradetracker_campsites t where t.language = 'pl' )limit 0,12