h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(52.509935) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(4.945018) ) + sin( radians(52.509935) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 52.060274832254 AND 52.959595167746 ) AND ( longitude BETWEEN 4.2062034348463 AND 5.6838325651537 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(52.509935) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(4.945018) ) + sin( radians(52.509935) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 52.060274832254 AND 52.959595167746 ) AND ( longitude BETWEEN 4.2062034348463 AND 5.6838325651537 ) 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 Purmerend, 1907 Appartementen - Gabinohome
Appartementen te huur in Purmerend. Biedt verhuur appartement in Purmerend, direct eigenaar. Verhuur van appartementen in het centrum van de stad, huur appartementen, appartementen te skiën.
loading