SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-12.070197) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.062202) ) + sin( radians(-12.070197) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.205095050324 AND -11.935298949676 ) AND ( longitude BETWEEN -77.200149780576 AND -76.924254219424 ) AND hoteltype_id IN(217) 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(-12.070197) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.062202) ) + sin( radians(-12.070197) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.205095050324 AND -11.935298949676 ) AND ( longitude BETWEEN -77.200149780576 AND -76.924254219424 ) AND hoteltype_id IN(217) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC LIMIT 0,10 Venta de casas en Pueblo Libre, 7 Casas - Gabinohome
Anuncios parecidos
Venta de casas en Pueblo Libre. 7 $this-mini_cat Pueblo Libre. Departamentos en Pueblo Libre directo del propietario, contacto directo.
Venta de casas en Lima :
loading