SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-10.484320) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.271477) ) + sin( radians(-10.484320) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -10.933980167746 AND -10.034659832254 ) AND ( longitude BETWEEN -77.728771822466 AND -76.814182177534 ) 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 SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-10.484320) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.271477) ) + sin( radians(-10.484320) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -10.933980167746 AND -10.034659832254 ) AND ( longitude BETWEEN -77.728771822466 AND -76.814182177534 ) 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 LIMIT 0,10 Alquiler de habitaciones en Huari, 1 Habitaciones - Gabinohome
Anuncios parecidos
Alquiler de habitaciones en Huari. Habitaciones en Huari. Alquiler de habitaciones y cuartos en casas compartidas.
Alquiler de habitaciones en Huari :
loading