SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(52.632355) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(4.750677) ) + sin( radians(52.632355) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 52.182694832254 AND 53.082015167746 ) AND ( longitude BETWEEN 4.0097970143968 AND 5.4915569856032 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(52.632355) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(4.750677) ) + sin( radians(52.632355) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 52.182694832254 AND 53.082015167746 ) AND ( longitude BETWEEN 4.0097970143968 AND 5.4915569856032 ) AND hoteltype_id IN(216,220,208,229,201,219,218,227,209,224,207) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC Appartement te huur in Alkmaar, 1710 Appartementen - Gabinohome
Appartementen te huur in Alkmaar. Biedt verhuur appartement in Alkmaar, direct eigenaar. Verhuur van appartementen in het centrum van de stad, huur appartementen, appartementen te skiën.
Appartement te huur in Alkmaar :
loading