Hue

Thua Thien Hue Province is located in Central Viet Nam. Thua Thien-Hue offers very diversified and beautiful landscapes. Nature and human beings create a harmoniously beauty with Bach Ma (White Horse) National Park and other attractive beaches such as Thuan An, Lang Co and Canh Duong. Besides, tourist is able to enjoy many traditional famous dishes and find out about sophisticated handicraft here.

Learn more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0012979507446289
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00064897537231445
3	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.0037760734558105
4	SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1	0.00033903121948242
5	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='54' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0039360523223877
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00033116340637207
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.0037410259246826
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.00030708312988281
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.0036711692810059
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00030803680419922
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.0037319660186768
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00030684471130371
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.0036630630493164
14	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.0034070014953613
15	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.0048329830169678
16	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) AND city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0 ) order by order_no ASC	0.0037698745727539
17	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.0034830570220947
18	SELECT service_id,title,slug FROM default_service WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0036880970001221
19	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0013680458068848
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00057506561279297
21	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.0035631656646729
22	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.00347900390625
23	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00054407119750977
24	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0012199878692627
25	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00032901763916016
26	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0011739730834961
27	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00036287307739258
28	SELECT country_id,title,banner,intro,content FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 and slug='vietnam' LIMIT 0,1	0.0024850368499756
29	SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and slug='hue' LIMIT 0,1	0.0025260448455811
30	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0025129318237305
31	SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='426') and (number_day=1 or duration_type=1)	0.0029871463775635
32	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00026607513427734
33	SELECT slug FROM default_country WHERE country_id='1'	0.00025701522827148
34	SELECT slug FROM default_city WHERE city_id='426'	0.00020694732666016
35	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='426') and (number_day=1 or duration_type=1) order by order_no asc LIMIT 0,15	0.0025990009307861
36	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='426') and (number_day=1 or duration_type=1)	0.0024971961975098
37	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='426') and (number_day=1 or duration_type=1)	0.002540111541748
38	SELECT title FROM default_city WHERE city_id='426'	0.00028014183044434
39	SELECT title FROM default_country WHERE country_id='1'	0.00022506713867188
40	SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0010099411010742
41	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026607513427734
42	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.0026688575744629
43	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/destinations/vietnam/hue' or config_link='/destinations/vietnam/hue') limit 1	0.0028281211853027
44	SELECT * FROM default_featurepackage WHERE mod_page='setting' and act_page='cart' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0009770393371582
45	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026702880859375
46	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00087594985961914
47	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026106834411621
48	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.0002899169921875
49	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00023603439331055
50	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00019311904907227
51	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00031304359436035
52	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00025820732116699
53	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00019693374633789
54	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.0002748966217041
55	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00024104118347168
56	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00018692016601562
57	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00022602081298828
58	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.00027585029602051
59	SELECT slug FROM default_country WHERE country_id='1'	0.00023078918457031
60	SELECT slug FROM default_city WHERE city_id='392'	0.00027704238891602
61	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00024199485778809
62	SELECT slug FROM default_country WHERE country_id='1'	0.00022101402282715
63	SELECT slug FROM default_city WHERE city_id='426'	0.00026798248291016
64	SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1	0.00024199485778809
65	SELECT slug FROM default_country WHERE country_id='1'	0.00027894973754883
66	SELECT slug FROM default_city WHERE city_id='415'	0.00027012825012207
67	SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1	0.00024199485778809
68	SELECT slug FROM default_country WHERE country_id='1'	0.00027894973754883
69	SELECT slug FROM default_city WHERE city_id='383'	0.00023484230041504
70	SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1	0.00026798248291016
71	SELECT slug FROM default_country WHERE country_id='1'	0.00026988983154297
72	SELECT slug FROM default_city WHERE city_id='399'	0.00021505355834961
73	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00085687637329102
74	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026607513427734
75	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00081300735473633
76	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002748966217041
77	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00077986717224121
78	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028085708618164
79	SELECT * FROM default_service WHERE service_id='5'	0.00032782554626465
80	SELECT slug FROM default_service WHERE service_id='5'	0.0003058910369873
81	SELECT * FROM default_service WHERE service_id='19'	0.00034499168395996
82	SELECT slug FROM default_service WHERE service_id='19'	0.00020003318786621
83	SELECT * FROM default_service WHERE service_id='16'	0.00031685829162598
84	SELECT slug FROM default_service WHERE service_id='16'	0.00031495094299316
85	SELECT * FROM default_service WHERE service_id='2'	0.00030899047851562
86	SELECT slug FROM default_service WHERE service_id='2'	0.00025200843811035
87	SELECT * FROM default_service WHERE service_id='6'	0.00025701522827148
88	SELECT slug FROM default_service WHERE service_id='6'	0.00023198127746582
89	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='' and is_trash=0 and type='DEPARTUREPOINT' and country_id='1' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0037620067596436
90	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and city_id IN(392,400,383,399,426,650,379,415)	0.0024330615997314
91	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00027704238891602
92	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00097012519836426
93	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026297569274902
94	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '540' and type='tour'	0.0025198459625244
95	SELECT more_information FROM default_discount WHERE lang_id='' and is_trash=0 and is_online=1 and discount_id IN (4,16,2,3) and 1730826000 between booking_date_from and booking_date_to and 1730826000 between travel_date_from and travel_date_to order by travel_date_from ASC limit 0,1	0.0028879642486572
96	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0012500286102295
97	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025391578674316
98	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '536' and type='tour'	0.0025098323822021
99	SELECT * FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00085687637329102
100	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024294853210449
101	SELECT * FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00080704689025879
102	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023913383483887
103	SELECT * FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00080585479736328
104	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023794174194336

Hue

Travel Tours Vietnam

From Hue: Small Group Tour to Demilitarized Zone (DMZ)

From Hue: Trekking in Bach Ma National Park Group Tour with Picnic Lunch

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel