Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 38

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 39

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 129

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 130
Hotel , réservation hotels

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 236

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /servers/apache/sites/cybevasion.fr/htdocs/hotels_villes.php on line 237
AccueilHotels & Apart'HotelsLocation voitureTourisme

Hotels


Découvrez nos hotels à avec de nombreuses promotions.
Comparez les tarifs, les notes des clients et situez les hôtels disponibles sur .

  
options

Classer parAvis Distance Étoiles  
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) + COS(RADIANS(lat_hotel)) * COS(RADIANS()) * COS(RADIANS(lon_hotel - )))) * ' at line 1 - SELECT id_hotel, REPLACE(nom_hotel, "''", "'") AS nom_hotel, nb_etoiles, adresse_hotel, code_postal, cp_monde, id_ville_hotel, id_ville_affichee_hotel, type_etab, REPLACE(ville_fr, "''", "'") AS ville, anim_360_chambres<>'' AS anim_360_chambres, anim_360_photos<>'' AS anim_360_photos, promotion_fr, ranking_hotel, note_qualite, nb_comms, id_chaine_hotel, url_resa, url_ressources, tarif_minimum, url_photos, importance, importance_contrat, url_plan, pdj_fr, ville_id, langues_contrat, disp_logo_chaine, nom_quartier, lat_hotel, lon_hotel, cyb_select, id_type_contrat, id_hotel_assoc, DEGREES(ACOS(SIN(RADIANS(lat_hotel)) * SIN(RADIANS()) + COS(RADIANS(lat_hotel)) * COS(RADIANS()) * COS(RADIANS(lon_hotel - )))) * 60 * 1.1515 * 1.609344 AS distance FROM hotels_contrat, geo_cp, hotels LEFT JOIN geo_quartiers ON id_quartier_autre=id_quartier WHERE lat_hotel<>0 AND lon_hotel<>0 AND importance_contrat>=20 AND id_contrat=id_type_contrat AND type_etab IN ('0','1','5','7','8') AND autorisation_hotel='1' AND id_ville_hotel=id_code AND region_id_monde= AND (DEGREES(ACOS(SIN(RADIANS(lat_hotel)) * SIN(RADIANS()) + COS(RADIANS(lat_hotel)) * COS(RADIANS()) * COS(RADIANS(lon_hotel - )))) * 60 * 1.1515 * 1.609344<=4 OR ville_id=169353) ORDER BY cyb_select='1' DESC, ranking_hotel DESC, note_qualite DESC, tarif_minimum<>9999 DESC, tarif_minimum<>0 DESC, DEGREES(ACOS(SIN(RADIANS(lat_hotel)) * SIN(RADIANS()) + COS(RADIANS(lat_hotel)) * COS(RADIANS()) * COS(RADIANS(lon_hotel - )))) * 60 * 1.1515 * 1.609344 ASC LIMIT 0, 200