5 Apartments for rent in KwaZulu-Natal in KwaZulu-Natal - Gabinohome

Apartments for rent in KwaZulu-Natal

in KwaZulu-Natal
SELECT t1.hotel_id, t1.name, t1.latitude AS lat, t1.longitude AS lng, ( 6371 * acos( cos( radians(-28.530553) ) * cos( radians( t1.latitude ) ) * cos( radians( t1.longitude ) - radians(30.895824) ) + sin( radians(-28.530553) ) * sin( radians( t1.latitude ) ) ) ) AS distance FROM `hotels` AS t1 WHERE ( latitude BETWEEN -28.800349100648 AND -28.260756899352 ) AND ( longitude BETWEEN 30.58873590147 AND 31.20291209853 ) AND t1.hotel_type_id IN(217,231,204,216,203,202,221,218,205,208,227,209,225,229,220,228,232,219,206,222,201,210,224,213,207,226,223) GROUP BY t1.hotel_id ORDER BY FIELD(hotel_type_id,217,231,204,216,203,202,221,218,205,208,227,209,225,229,220,228,232,219,206,222,201,210,224,213,207,226,223), distance ASC, t1.date_mod DESC, t1.review_score DESC LIMIT 0,5
Apartments for rent in KwaZulu-Natal short or long term. 0 Apartments for rent in KwaZulu-Natal with photos and reviews. Apartments for rent vacation rentals book directly. Apartments for rent owners contact.
Similar ads
Check-in
Check-out
1
1
Receive emails about new adverts in KwaZulu-Natal