From the lights of Paris to the relaxing countryside, France is one of the most alluring countries in the world.
Tempting cuisine such as sauces, cheeses, bread, and pastries wait inside charming cafés. French families indulge in joyous, long meals with families drawn close together for conversation.
Many villages retain surprisingly their historic architecture, gorgeous views and quiet pace of life.
Paris is so shining that sometimes overshadow the other beautiful regions.
Brittany and Normandy feel like a distinct region, with a jagged coastline of wide bays and granite cliffs. Pays-de la Loire offers is spectacular with lush and amazing scenery, including the dramatic Atlantic coast with its delightful beaches
The Rhone-Alpes is home to the French Alps and offers dazzling resorts available throughout the year. Burgundy is a paradise for those who love wine as well as delectable food. The Central Loire Valley is famous for its castles, the magnificent gardens, and quiet lakes.
In the eastern region of France, you will find the areas that border Germany, Switzerland, Belgium and Luxembourg. The Franche-Comte is here, characterized by an amazing landscape of woods and rivers.
The south offers a completely different atmosphere with the buzzing Cote Azur and the quiet and amazing Provence
France Experiences
select al.*,a.* from tbl_tours t join tbl_countries cn on t.tour_starting_country=cn.countries_iso_code_2 left join tbl_locations l on t.tour_starting_city=l.location_id LEFT JOIN tbl_character_area_locations al ON l.location_id = al.al_location_id LEFT JOIN tbl_character_location_areas a ON a.area_id = al.al_area_id left join tbl_suppliers sp on t.tour_supplier_id=sp.supplier_id where tour_category NOT IN (1,3) and tour_id in (select distinct(season_tour_id) from tbl_tour_season_pricing where (year(season_start_date) = '2025' or year(season_end_date) = '2025') and season_status='Active') and tour_status='Active' and available_on_library='Yes' and FIND_IN_SET ('1', tour_websites) and (a.area_id IN (select DISTINCT (area_id) from tbl_locations l LEFT JOIN tbl_character_area_locations al ON l.location_id = al.al_location_id LEFT JOIN tbl_character_location_areas a ON a.area_id = al.al_area_id where a.area_status='Active' and l.location_status='Active' and area_country_id='FR' and al_location_id is NOT NULL ) or l.location_id IN (2260,2198) ) GROUP BY al_area_id order by area_name asc
