h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.900650) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.447617) ) + sin( radians(-11.900650) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.035548050324 AND -11.765751949676 ) AND ( longitude BETWEEN -76.585478148836 AND -76.309755851164 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.900650) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.447617) ) + sin( radians(-11.900650) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.035548050324 AND -11.765751949676 ) AND ( longitude BETWEEN -76.585478148836 AND -76.309755851164 ) AND hoteltype_id IN(207,213,209,227,221,232,228,220,223,230,229) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.900650) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.447617) ) + sin( radians(-11.900650) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.035548050324 AND -11.765751949676 ) AND ( longitude BETWEEN -76.585478148836 AND -76.309755851164 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.900650) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.447617) ) + sin( radians(-11.900650) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.035548050324 AND -11.765751949676 ) AND ( longitude BETWEEN -76.585478148836 AND -76.309755851164 ) AND hoteltype_id IN(207,213,209,227,221,232,228,220,223,230,229) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC LIMIT 0,10 Casas de alquiler en Surco, 2 Casas - Gabinohome
Anuncios parecidos
Casas de alquiler en Surco sin comisiones. Casas en Surco con fotos y opiniones, contacto directo. Casas de alquiler en Surco. 1a
Casas de alquiler en Lima :
loading