Hotels in Hue

View Detail

From:

250 USD

Hue Imperial Hotel

8 Hung Vuong Street, Hue, Thua Thien-Hue, Vietnam

View Detail

From:

400 USD

Vedana Lagoon Resort And Spa

Zone 1, Phu Loc District, Thua Thien - Hue, Vietnam

View Detail

From:

25 USD

Eldora Hotel

60 Ben Nghe, Thua Thien-Hue, Vietnam

View Detail

From:

20 USD

Thanh Lich 2 Hotel

59 Vo Thi Sau Street, Phu Hoi Ward, Hue, Vietnam

A-Z Hotels of Other Destinations

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='hotel'	0.002202033996582
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00096607208251953
3	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0045609474182129
4	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no asc	0.0092370510101318
5	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.030531167984009
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00066399574279785
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='2' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0086629390716553
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.0005500316619873
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='4' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.013586044311523
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00061702728271484
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='3' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.036991834640503
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00043296813964844
13	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='1' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.012720108032227
14	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no ASC	0.01057505607605
15	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0051620006561279
16	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0061111450195312
17	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.020864963531494
18	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00063800811767578
19	SELECT guidecat_id,title,slug FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.010164022445679
20	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and slug = 'hue' limit 0,1	0.0073690414428711
21	SELECT title,slug,intro,content,intro_hotel,image_hotel FROM default_city WHERE city_id='426'	0.0004730224609375
22	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00042891502380371
23	SELECT country_id FROM default_city WHERE city_id='426'	0.0013480186462402
24	SELECT slug FROM default_city WHERE city_id='426'	0.00036907196044922
25	SELECT region_id,title FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' order by order_no ASC	0.0092928409576416
26	SELECT city_id,title FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and region_id=0 and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC	0.015653848648071
27	SELECT hotel_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and city_id='426'	0.015810012817383
28	SELECT hotel_id,star_id,slug,title,address,intro,image FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and city_id='426' order by order_no ASC LIMIT 0,12	0.005669116973877
29	SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_online=1 and blog_id IN (SELECT blog_id FROM default_blog_destination WHERE country_id='' and city_id='426')	0.017374992370605
30	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'a%' or slug like 'A%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0070340633392334
31	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'b%' or slug like 'B%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.023253202438354
32	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'c%' or slug like 'C%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.032320022583008
33	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'd%' or slug like 'D%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.032710075378418
34	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'e%' or slug like 'E%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0095281600952148
35	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'f%' or slug like 'F%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.060825824737549
36	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'g%' or slug like 'G%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.02766489982605
37	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'h%' or slug like 'H%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.005748987197876
38	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'i%' or slug like 'I%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.014868021011353
39	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'j%' or slug like 'J%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.010548114776611
40	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'k%' or slug like 'K%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.06029200553894
41	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'l%' or slug like 'L%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.037402868270874
42	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'm%' or slug like 'M%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.042865037918091
43	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'n%' or slug like 'N%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.021728992462158
44	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'o%' or slug like 'O%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.029769897460938
45	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'p%' or slug like 'P%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0171959400177
46	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'q%' or slug like 'Q%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0093820095062256
47	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'r%' or slug like 'R%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.051257848739624
48	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 's%' or slug like 'S%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.025758981704712
49	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 't%' or slug like 'T%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.035055875778198
50	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'u%' or slug like 'U%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.023496866226196
51	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'v%' or slug like 'V%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.026432037353516
52	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'w%' or slug like 'W%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.022767066955566
53	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'x%' or slug like 'X%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.017016172409058
54	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'y%' or slug like 'Y%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.020596981048584
55	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'426' and (slug like 'z%' or slug like 'Z%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.015543937683105
56	SELECT intro FROM default_city WHERE city_id='426'	0.0057339668273926
57	SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc	0.0061850547790527
58	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/en/hotels/vietnam/hue' or config_link='/en/hotels/vietnam/hue') limit 1	0.0081851482391357
59	SELECT slug FROM default_country WHERE country_id='7'	0.016847848892212
60	SELECT slug FROM default_country WHERE country_id='1'	0.013185024261475
61	SELECT slug FROM default_country WHERE country_id='37'	0.00037503242492676
62	SELECT slug FROM default_country WHERE country_id='52'	0.00035619735717773
63	SELECT slug FROM default_country WHERE country_id='3'	0.0003509521484375
64	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00022196769714355
65	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00033307075500488
66	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00026798248291016
67	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00024509429931641
68	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.000244140625
69	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00040197372436523
70	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00029921531677246
71	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00034689903259277
72	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00027203559875488
73	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00027990341186523
74	SELECT title FROM default_tour_category WHERE tourcat_id='402'	0.00029206275939941
75	SELECT slug FROM default_tour_category WHERE tourcat_id='402'	0.00031304359436035
76	SELECT title FROM default_tour_category WHERE tourcat_id='3'	0.00036501884460449
77	SELECT slug FROM default_tour_category WHERE tourcat_id='3'	0.00032496452331543
78	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.0036380290985107
79	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.0042309761047363
80	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.01596212387085
81	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='47'	0.00039005279541016
82	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.0044260025024414
83	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.043241024017334
84	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0040898323059082
85	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0079410076141357
86	SELECT hotel_price_range_id,title FROM default_hotel_price_range WHERE lang_id='' and 1=1 and is_trash=0 order by order_no asc	0.014086961746216
87	SELECT country_id,title FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.01455283164978
88	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='367' and price >0 order by price ASC	0.0047478675842285
89	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00058412551879883
90	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='369' and price >0 order by price ASC	0.06302809715271
91	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00034189224243164
92	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='378' and price >0 order by price ASC	0.0019440650939941
93	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00044393539428711
94	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='380' and price >0 order by price ASC	0.0021507740020752
95	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00042581558227539
96	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '23'	0.0084888935089111
97	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '15'	0.0064980983734131
98	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '13'	0.065323829650879
99	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '1'	0.0089459419250488
100	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '16'	0.011580944061279
101	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '9'	0.02170991897583
102	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '2'	0.009382963180542
103	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '12'	0.02106785774231
104	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '426' and cat_id = '14'	0.12595200538635

Hotels in Hue

Hue Imperial Hotel

Vedana Lagoon Resort And Spa

Eldora Hotel

Thanh Lich 2 Hotel

A-Z Hotels of Other Destinations

VietISO Company

About isoCMS

Travel Styles

Other

Follow Us

Payment Channel