SELECT h.hotel_id, hotel_name, star_rating FROM hotels h INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id) WHERE haa.area_id = 1285 AND star_rating <= "2.5" AND star_rating > "1.0" ORDER BY RAND() LIMIT 0, 1SELECT h.hotel_id, hotel_name, star_rating FROM hotels h INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id) WHERE haa.area_id = 1285 AND star_rating <= "5.0" AND star_rating > "3.5" ORDER BY RAND() LIMIT 0, 1
Overview of BUR DUBAI Dubai Hotels |
The main administrative and shopping district, Bur Dubai contains some of Dubais oldest buildings. Bastakiya is a carefully restored heritage quarter of narrow alleys and courtyard houses cooled by wind-towers. Sheikh Maktoums House (now a museum) is a fine example of 19th-century Arabian architecture. The nearby Dubai Museum offers a succinct account of the Emirates history, while the Heritage & Diving Village recreates its maritime past. |
| |||||
| |||||
|
![]() ALL BUR DUBAI - DUBAI HOTELS
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|