SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(52.337000) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(4.780034) ) + sin( radians(52.337000) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 51.887339832254 AND 52.786660167746 ) AND ( longitude BETWEEN 4.0441118717948 AND 5.5159561282052 ) AND hoteltype_id IN(221,231,216,202,222,208,229,201,219,205,218,224,207) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC Kamers te huur in Badhoevedorp, 1508 kamers - Gabinohome
Kamers te huur Badhoevedorp . 1508 kamers Badhoevedorp. Erasmus Kamers Badhoevedorp
Kamers te huur in Badhoevedorp :
loading