h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-12.093084) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.046491) ) + sin( radians(-12.093084) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.542744167746 AND -11.643423832254 ) AND ( longitude BETWEEN -77.506356252761 AND -76.586625747239 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-12.093084) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-77.046491) ) + sin( radians(-12.093084) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -12.542744167746 AND -11.643423832254 ) AND ( longitude BETWEEN -77.506356252761 AND -76.586625747239 ) 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 Aluguer de quartos em Lima, 942 Quartos - Gabinohome
Aluguer de Quartos em Lima. 942 Quartos Lima. Aluguer de Quartos em apartamento partilhado a estudantes em Lima.
RSS
 · My AOL  · MyYahoo  · Bloglines
Receba e-mails sobre novos anúncios em Lima
Aluguer de quartos em Lima :
loading