SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-12.159071) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.929735) ) + sin( radians(-12.159071) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.293969050324 AND -12.024172949676 ) AND ( longitude BETWEEN -77.067728718064 AND -76.791741281936 ) 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.159071) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-76.929735) ) + sin( radians(-12.159071) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.293969050324 AND -12.024172949676 ) AND ( longitude BETWEEN -77.067728718064 AND -76.791741281936 ) 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 Villa María del Triunfo, 1 Casas - Gabinohome
Anuncios parecidos
Venta de casas en Villa María del Triunfo. 1 $this-mini_cat Villa María del Triunfo. Departamentos en Villa María del Triunfo directo del propietario, contacto directo.
Venta de casas en Lima :
loading