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 = 1290 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 = 1290 AND star_rating <= "5.0" AND star_rating > "3.5" ORDER BY RAND() LIMIT 0, 1 Sharjah - Deals On Dubai Hotels - i4dubai

Overview of SHARJAH Dubai Hotels


Dubais closest neighbour, Sharjah is the third-largest Emirate. Oil and natural gas changed the fortunes of this old sheikhdom, and UNESCO declared it cultural capital of the Arab world in 1998. Historic buildings rub shoulders with striking modern architecture, while rugs, cosmetics and jewellery are all on sale at the Blue Souk. Visitors should note that Sharjah is more conservative than Dubai, (no alcohol or revealing clothing).
i4dubai.com process bar i4dubai.com better price
Proudly serving 1,399,582 happy customers.
Call (800) 997-1423 to speak with an i4dubai specialist.
Over 12 years experience.
Return To Home Page Versign BBB Secured Versign BBB Secured
SEARCH RATES NOW!
Proudly serving 1,399,582 happy customers.
Over 12 years experience.
Call (800) 997-1423 to speak with an i4dubai specialist.
better price
Processing
Please wait while we process your request.
Versign BBB Secured Return To Home Page
Call (800) 997-1423 to speak with an i4dubai specialist.
Proudly serving 1,399,582 happy customers.
Over 12 years experience.
 
1-800-997-1423
FEATURED HOTEL
Belvedere Court Hotel Apartments Sharjah Dubai Hotels
Belvedere Court Hotel Apartments
SHARJAH Dubai WEATHER

CURRENT WEATHER
Wednesday, September 18th 2019
   
SHARJAH Dubai HOTELS