Overview

Itinerary: Full day
Depart from: Ha Noi
Destinations: Ha Noi

Sometimes, we will switch schedule to visit Tam Coc first and then Hoa Lu later.

Please be ready at your hotel’s lobby from 07:30AM to 08:00AM.

Available

Itinerary

Full day

Full day: (Lunch) November 07, 2024

In the morning

Our guide and driver will pick you up at your hotel in Hanoi from 07:30AM to 08:00AM.

Have a short break (15-20mins) along the way head to Ninh Binh Province.

10:30AM, visit Hoa Lu Ancient Capital where you will have a chance to learn about Vietnamese history.

Have a buffet lunch at 11:45PM (Goat meat is the must try cannot missed, vegetarian option is available for your choices).

In the afternoon

Make our way to Tam Coc and enjoy 1.5hours bamboo boat ride will give you the answer that why people called this place name “Ha Long Bay on land”.

03:00PM, cycling around local village to discover Vietnamese daily life.

Turning back to the bus is waiting for our trip transferred to Ha Noi at 04:00PM.

Drop you off at your hotel around 06:00PM and the tour ends.

Important noted

Trip Inclusion
- English speaking guide
- Entrance fee
- Bicycle tour
- Rowing boat tour
- Buffet lunch
- Full transfers by limousine bus (with A/C, purified bottled water, wifi, wet tissue)
- One bottle water/pax
Trip Exclusions
- Other drinks
- Tipping for driver, guide and rowing boat
- Personal expense
Thing To Carry

We highly recommend bring comfortable clothing with long pant (pagoda’s entrance request), hat, umbrella.
Payments Policy

Full payment required before your departure.
Cancellation Policy

Free of charge before 5pm of 1 day in advance.

Reviews

Your Rating:

Overall rating

Excellent 0

Very good 0

Good 0

Average 0

Poor 0

From Contact us per traveler

FAQs

Chat with us

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour_new'	0.00082492828369141
2	SELECT COUNT(*) AS totalitem FROM default_module WHERE site='FRONTPAGE' and name='tour'	0.00033092498779297
3	SELECT * FROM default_setting WHERE setting_id='1'	0.00040888786315918
4	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.0027430057525635
5	SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1	0.00026178359985352
6	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.0030350685119629
7	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00037097930908203
8	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.0039529800415039
9	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.00036311149597168
10	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.0027940273284912
11	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00025701522827148
12	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.0029091835021973
13	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00025796890258789
14	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.0028259754180908
15	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.0024189949035645
16	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.0035169124603271
17	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.0028750896453857
18	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.0034139156341553
19	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.0037300586700439
20	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.0011940002441406
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00036096572875977
22	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.0042431354522705
23	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.0034699440002441
24	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.0003509521484375
25	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.0012161731719971
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00037193298339844
27	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.0010738372802734
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00034189224243164
29	SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id='551' and slug='from-ha-noi-small-group-tour-to-hoa-lu-tam-coc'	0.0034310817718506
30	SELECT cat_id,is_online,departure_point_id,key_information,list_activities_id,adult_group_size,child_group_size,title,infant_group_size,inclusion,exclusion,thing_to_carry,cancellation_policy,refund_policy,confirmation_policy,overview,slug FROM default_tour WHERE tour_id='551'	0.00041818618774414
31	SELECT * FROM default_featurepackage WHERE mod_page='promotionpro' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1	0.0012040138244629
32	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00034403800964355
33	SELECT promotion_id FROM default_promotion WHERE lang_id='' and promotion_id IN() order by promotion_id desc	0.003093957901001
34	SELECT * FROM default_featurepackage WHERE mod_page='promotionpro' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1	0.0010850429534912
35	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00034117698669434
36	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_gallery' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0011510848999023
37	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00036096572875977
38	SELECT tour_image_id,image,title FROM default_tour_image WHERE lang_id='' and is_trash=0 and table_id='551' and image<>'' order by order_no ASC	0.0038619041442871
39	SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='activities' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0011708736419678
40	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00034523010253906
41	SELECT activities_id FROM default_activities WHERE lang_id='' and is_trash=0 and is_online=1 and activities_id IN(45) order by order_no asc	0.0036129951477051
42	SELECT fieldvalue,fieldname FROM default_tour_customfield WHERE lang_id='' and tour_id='551' and fieldtype='CUSTOM' order by order_no ASC	0.0033719539642334
43	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and type='NATIONALITY' order by order_no asc	0.0031471252441406
44	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and type='VISITORTYPE' order by order_no asc	0.0024311542510986
45	SELECT distinct number_to FROM default_tour_option where tour_option_id= LIMIT 0,1	0.00013303756713867
46	SELECT distinct number_to FROM default_tour_option where tour_option_id= LIMIT 0,1	0.00011801719665527
47	SELECT distinct number_to FROM default_tour_option where tour_option_id= LIMIT 0,1	0.00011682510375977
48	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='store' and type='default' and type_page='REVQQVJUVVJFLVZpZXRJU08=' order by order_no ASC limit 0,1	0.00081682205200195
49	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00029802322387695
50	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='itinerary' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00085783004760742
51	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026988983154297
52	SELECT tour_itinerary_id,image,content,tour_itinerary_id,transport,is_show_image,day,day2,tour_id,title,meals FROM default_tour_itinerary WHERE lang_id='' and is_trash=0 and tour_id='551' and title_contingency='' order by order_no asc	0.002500057220459
53	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/t551-from-ha-noi-small-group-tour-to-hoa-lu-tam-coc.html'	0.0024271011352539
54	SELECT distinct image FROM default_tour where tour_id=551 LIMIT 0,1	0.00026702880859375
55	SELECT distinct tour_option FROM default_tour where tour_id=551 LIMIT 0,1	0.00025701522827148
56	SELECT distinct adult_group_size FROM default_tour where tour_id=551 LIMIT 0,1	0.00027179718017578
57	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.00086593627929688
58	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00044798851013184
59	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.0025970935821533
60	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/t551-from-ha-noi-small-group-tour-to-hoa-lu-tam-coc.html' or config_link='/t551-from-ha-noi-small-group-tour-to-hoa-lu-tam-coc.html') limit 1	0.0027410984039307
61	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.0010180473327637
62	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026702880859375
63	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.00082898139953613
64	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024318695068359
65	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.00026297569274902
66	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00020408630371094
67	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00025796890258789
68	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00021696090698242
69	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00027012825012207
70	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00020289421081543
71	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00017809867858887
72	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00024199485778809
73	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00020194053649902
74	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00023603439331055
75	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.0003211498260498
76	SELECT slug FROM default_country WHERE country_id='1'	0.00032997131347656
77	SELECT slug FROM default_city WHERE city_id='392'	0.00032711029052734
78	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00028705596923828
79	SELECT slug FROM default_country WHERE country_id='1'	0.00021815299987793
80	SELECT slug FROM default_city WHERE city_id='426'	0.00033402442932129
81	SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1	0.00028896331787109
82	SELECT slug FROM default_country WHERE country_id='1'	0.00022506713867188
83	SELECT slug FROM default_city WHERE city_id='415'	0.00033187866210938
84	SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1	0.00028014183044434
85	SELECT slug FROM default_country WHERE country_id='1'	0.00022196769714355
86	SELECT slug FROM default_city WHERE city_id='383'	0.0002598762512207
87	SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1	0.00026893615722656
88	SELECT slug FROM default_country WHERE country_id='1'	0.00018906593322754
89	SELECT slug FROM default_city WHERE city_id='399'	0.00022697448730469
90	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.00092697143554688
91	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027608871459961
92	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.00077700614929199
93	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028109550476074
94	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.00082993507385254
95	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025486946105957
96	SELECT * FROM default_service WHERE service_id='5'	0.00025796890258789
97	SELECT slug FROM default_service WHERE service_id='5'	0.00020003318786621
98	SELECT * FROM default_service WHERE service_id='19'	0.00033402442932129
99	SELECT slug FROM default_service WHERE service_id='19'	0.00028491020202637
100	SELECT * FROM default_service WHERE service_id='16'	0.00029397010803223
101	SELECT slug FROM default_service WHERE service_id='16'	0.00027894973754883
102	SELECT * FROM default_service WHERE service_id='2'	0.00027108192443848
103	SELECT slug FROM default_service WHERE service_id='2'	0.00020980834960938
104	SELECT * FROM default_service WHERE service_id='6'	0.00029277801513672
105	SELECT slug FROM default_service WHERE service_id='6'	0.00026607513427734
106	SELECT title FROM default_tour WHERE tour_id='551'	0.00033712387084961
107	SELECT title,slug FROM default_tour_category WHERE tourcat_id='410'	0.0002129077911377
108	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.0010340213775635
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026106834411621
110	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0027508735656738
111	SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='551'	0.00024294853210449
112	SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (99)	0.0023839473724365
113	SELECT image FROM default_tour_image WHERE tour_image_id=''	0.00021910667419434
114	SELECT * FROM default_featurepackage WHERE mod_page='reviews' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1	0.00087594985961914
115	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002741813659668
116	SELECT tour_destination_id,placetogo_id,city_id FROM default_tour_destination WHERE is_trash=0 and tour_id='551' and city_id IN (SELECT city_id from default_city WHERE is_trash=0 and is_online=1) order by order_no asc	0.00090909004211426
117	SELECT title,slug,country_id FROM default_city WHERE city_id='392'	0.0002751350402832
118	SELECT slug FROM default_country WHERE country_id='1'	0.00023698806762695
119	SELECT list_departure_point_id FROM default_tour WHERE tour_id='551'	0.00023007392883301
120	SELECT title,slug,country_id FROM default_city WHERE city_id='392'	0.00028085708618164
121	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.00023794174194336
122	SELECT slug FROM default_country WHERE country_id='1'	0.0002739429473877
123	SELECT slug FROM default_city WHERE city_id='392'	0.00024294853210449
124	SELECT duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='551'	0.00022101402282715
125	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.00089907646179199
126	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024795532226562
127	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='destination' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00081896781921387
128	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002439022064209
129	SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (19) order by order_no ASC	0.0024089813232422
130	SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='551'	0.00029516220092773
131	SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (99)	0.0023880004882812
132	SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00094008445739746
133	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025510787963867
134	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00081300735473633
135	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026392936706543
136	SELECT * FROM default_featurepackage WHERE mod_page='hotel' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00083088874816895
137	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002601146697998
138	SELECT * FROM default_featurepackage WHERE mod_page='tour_exhautive' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00093603134155273
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002439022064209
140	SELECT * FROM default_featurepackage WHERE mod_page='reviews' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1	0.00080204010009766
141	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002439022064209
142	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.00087213516235352
143	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024294853210449
144	SELECT reviews_id,profile_id, review_date,table_id,rates,content,fullname FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and table_id = '551' and type='tour' and profile_id = 0 order by order_no DESC	0.0024409294128418
145	SELECT country_id FROM _country WHERE is_trash=0 and country_id<>'9' order by order_no asc	0.0014529228210449
146	SELECT title FROM _country WHERE country_id='247'	0.00023007392883301
147	SELECT title FROM _country WHERE country_id='2'	0.00029110908508301
148	SELECT title FROM _country WHERE country_id='3'	0.00023913383483887
149	SELECT title FROM _country WHERE country_id='4'	0.0002138614654541
150	SELECT title FROM _country WHERE country_id='5'	0.00026297569274902
151	SELECT title FROM _country WHERE country_id='6'	0.0002129077911377
152	SELECT title FROM _country WHERE country_id='7'	0.00026202201843262
153	SELECT title FROM _country WHERE country_id='8'	0.00023007392883301
154	SELECT title FROM _country WHERE country_id='10'	0.00027704238891602
155	SELECT title FROM _country WHERE country_id='11'	0.00023412704467773
156	SELECT title FROM _country WHERE country_id='12'	0.00028109550476074
157	SELECT title FROM _country WHERE country_id='13'	0.00024914741516113
158	SELECT title FROM _country WHERE country_id='14'	0.00020885467529297
159	SELECT title FROM _country WHERE country_id='15'	0.00025701522827148
160	SELECT title FROM _country WHERE country_id='16'	0.00020384788513184
161	SELECT title FROM _country WHERE country_id='17'	0.00027680397033691
162	SELECT title FROM _country WHERE country_id='18'	0.00022506713867188
163	SELECT title FROM _country WHERE country_id='19'	0.00027203559875488
164	SELECT title FROM _country WHERE country_id='20'	0.00021791458129883
165	SELECT title FROM _country WHERE country_id='21'	0.00028800964355469
166	SELECT title FROM _country WHERE country_id='22'	0.00023508071899414
167	SELECT title FROM _country WHERE country_id='23'	0.00028395652770996
168	SELECT title FROM _country WHERE country_id='24'	0.00023007392883301
169	SELECT title FROM _country WHERE country_id='25'	0.00029397010803223
170	SELECT title FROM _country WHERE country_id='26'	0.00025177001953125
171	SELECT title FROM _country WHERE country_id='27'	0.0001978874206543
172	SELECT title FROM _country WHERE country_id='28'	0.00024580955505371
173	SELECT title FROM _country WHERE country_id='29'	0.00020909309387207
174	SELECT title FROM _country WHERE country_id='31'	0.00025606155395508
175	SELECT title FROM _country WHERE country_id='32'	0.00020313262939453
176	SELECT title FROM _country WHERE country_id='33'	0.00025010108947754
177	SELECT title FROM _country WHERE country_id='34'	0.0002131462097168
178	SELECT title FROM _country WHERE country_id='35'	0.00026106834411621
179	SELECT title FROM _country WHERE country_id='36'	0.00020718574523926
180	SELECT title FROM _country WHERE country_id='40'	0.00025415420532227
181	SELECT title FROM _country WHERE country_id='41'	0.00021696090698242
182	SELECT title FROM _country WHERE country_id='42'	0.00027298927307129
183	SELECT title FROM _country WHERE country_id='43'	0.00022101402282715
184	SELECT title FROM _country WHERE country_id='44'	0.00026798248291016
185	SELECT title FROM _country WHERE country_id='45'	0.00023388862609863
186	SELECT title FROM _country WHERE country_id='46'	0.00029802322387695
187	SELECT title FROM _country WHERE country_id='47'	0.00024604797363281
188	SELECT title FROM _country WHERE country_id='48'	0.00021505355834961
189	SELECT title FROM _country WHERE country_id='49'	0.00026392936706543
190	SELECT title FROM _country WHERE country_id='50'	0.00021100044250488
191	SELECT title FROM _country WHERE country_id='51'	0.00025796890258789
192	SELECT title FROM _country WHERE country_id='52'	0.00022482872009277
193	SELECT title FROM _country WHERE country_id='53'	0.00027322769165039
194	SELECT title FROM _country WHERE country_id='54'	0.00022101402282715
195	SELECT title FROM _country WHERE country_id='55'	0.00026702880859375
196	SELECT title FROM _country WHERE country_id='56'	0.00023007392883301
197	SELECT title FROM _country WHERE country_id='57'	0.00027799606323242
198	SELECT title FROM _country WHERE country_id='58'	0.00023913383483887
199	SELECT title FROM _country WHERE country_id='59'	0.00018906593322754
200	SELECT title FROM _country WHERE country_id='60'	0.00025105476379395
201	SELECT title FROM _country WHERE country_id='61'	0.00019979476928711
202	SELECT title FROM _country WHERE country_id='62'	0.00024700164794922
203	SELECT title FROM _country WHERE country_id='63'	0.00022602081298828
204	SELECT title FROM _country WHERE country_id='64'	0.00029778480529785
205	SELECT title FROM _country WHERE country_id='65'	0.00026392936706543
206	SELECT title FROM _country WHERE country_id='66'	0.00021004676818848
207	SELECT title FROM _country WHERE country_id='67'	0.00025701522827148
208	SELECT title FROM _country WHERE country_id='68'	0.00022315979003906
209	SELECT title FROM _country WHERE country_id='69'	0.00027012825012207
210	SELECT title FROM _country WHERE country_id='70'	0.00021505355834961
211	SELECT title FROM _country WHERE country_id='71'	0.00026297569274902
212	SELECT title FROM _country WHERE country_id='72'	0.00023078918457031
213	SELECT title FROM _country WHERE country_id='73'	0.00027704238891602
214	SELECT title FROM _country WHERE country_id='74'	0.00023794174194336
215	SELECT title FROM _country WHERE country_id='75'	0.00018596649169922
216	SELECT title FROM _country WHERE country_id='76'	0.00026988983154297
217	SELECT title FROM _country WHERE country_id='77'	0.00021696090698242
218	SELECT title FROM _country WHERE country_id='78'	0.00026392936706543
219	SELECT title FROM _country WHERE country_id='79'	0.00021004676818848
220	SELECT title FROM _country WHERE country_id='80'	0.00027799606323242
221	SELECT title FROM _country WHERE country_id='81'	0.00022602081298828
222	SELECT title FROM _country WHERE country_id='82'	0.00027203559875488
223	SELECT title FROM _country WHERE country_id='83'	0.00021886825561523
224	SELECT title FROM _country WHERE country_id='84'	0.00028800964355469
225	SELECT title FROM _country WHERE country_id='85'	0.0002448558807373
226	SELECT title FROM _country WHERE country_id='86'	0.00019192695617676
227	SELECT title FROM _country WHERE country_id='87'	0.00023794174194336
228	SELECT title FROM _country WHERE country_id='88'	0.00020194053649902
229	SELECT title FROM _country WHERE country_id='89'	0.00024890899658203
230	SELECT title FROM _country WHERE country_id='90'	0.00019502639770508
231	SELECT title FROM _country WHERE country_id='92'	0.00024294853210449
232	SELECT title FROM _country WHERE country_id='93'	0.00020599365234375
233	SELECT title FROM _country WHERE country_id='94'	0.00025200843811035
234	SELECT title FROM _country WHERE country_id='95'	0.0001988410949707
235	SELECT title FROM _country WHERE country_id='96'	0.00024580955505371
236	SELECT title FROM _country WHERE country_id='97'	0.00020790100097656
237	SELECT title FROM _country WHERE country_id='98'	0.00026583671569824
238	SELECT title FROM _country WHERE country_id='99'	0.00021100044250488
239	SELECT title FROM _country WHERE country_id='100'	0.00025796890258789
240	SELECT title FROM _country WHERE country_id='101'	0.00022196769714355
241	SELECT title FROM _country WHERE country_id='102'	0.00026893615722656
242	SELECT title FROM _country WHERE country_id='103'	0.0002140998840332
243	SELECT title FROM _country WHERE country_id='105'	0.00026106834411621
244	SELECT title FROM _country WHERE country_id='106'	0.00023698806762695
245	SELECT title FROM _country WHERE country_id='107'	0.00028514862060547
246	SELECT title FROM _country WHERE country_id='108'	0.00023078918457031
247	SELECT title FROM _country WHERE country_id='109'	0.00027799606323242
248	SELECT title FROM _country WHERE country_id='110'	0.00024986267089844
249	SELECT title FROM _country WHERE country_id='111'	0.00019598007202148
250	SELECT title FROM _country WHERE country_id='112'	0.00024294853210449
251	SELECT title FROM _country WHERE country_id='113'	0.0002131462097168
252	SELECT title FROM _country WHERE country_id='114'	0.00026202201843262
253	SELECT title FROM _country WHERE country_id='115'	0.00021910667419434
254	SELECT title FROM _country WHERE country_id='116'	0.00026607513427734
255	SELECT title FROM _country WHERE country_id='117'	0.00023007392883301
256	SELECT title FROM _country WHERE country_id='118'	0.00027799606323242
257	SELECT title FROM _country WHERE country_id='119'	0.00022482872009277
258	SELECT title FROM _country WHERE country_id='120'	0.00027585029602051
259	SELECT title FROM _country WHERE country_id='121'	0.00023984909057617
260	SELECT title FROM _country WHERE country_id='122'	0.00018692016601562
261	SELECT title FROM _country WHERE country_id='123'	0.00023388862609863
262	SELECT title FROM _country WHERE country_id='124'	0.00028204917907715
263	SELECT title FROM _country WHERE country_id='125'	0.00024294853210449
264	SELECT title FROM _country WHERE country_id='126'	0.00018906593322754
265	SELECT title FROM _country WHERE country_id='127'	0.00024795532226562
266	SELECT title FROM _country WHERE country_id='129'	0.00019383430480957
267	SELECT title FROM _country WHERE country_id='130'	0.0002591609954834
268	SELECT title FROM _country WHERE country_id='131'	0.00020599365234375
269	SELECT title FROM _country WHERE country_id='132'	0.00025296211242676
270	SELECT title FROM _country WHERE country_id='133'	0.00020003318786621
271	SELECT title FROM _country WHERE country_id='134'	0.00026583671569824
272	SELECT title FROM _country WHERE country_id='135'	0.00021195411682129
273	SELECT title FROM _country WHERE country_id='136'	0.00025796890258789
274	SELECT title FROM _country WHERE country_id='137'	0.00020503997802734
275	SELECT title FROM _country WHERE country_id='138'	0.00026988983154297
276	SELECT title FROM _country WHERE country_id='139'	0.00021910667419434
277	SELECT title FROM _country WHERE country_id='140'	0.00027704238891602
278	SELECT title FROM _country WHERE country_id='141'	0.00022411346435547
279	SELECT title FROM _country WHERE country_id='142'	0.00029110908508301
280	SELECT title FROM _country WHERE country_id='143'	0.00024080276489258
281	SELECT title FROM _country WHERE country_id='144'	0.00019001960754395
282	SELECT title FROM _country WHERE country_id='145'	0.00023794174194336
283	SELECT title FROM _country WHERE country_id='146'	0.00020790100097656
284	SELECT title FROM _country WHERE country_id='147'	0.00025701522827148
285	SELECT title FROM _country WHERE country_id='148'	0.00020599365234375
286	SELECT title FROM _country WHERE country_id='149'	0.00025606155395508
287	SELECT title FROM _country WHERE country_id='150'	0.00022196769714355
288	SELECT title FROM _country WHERE country_id='151'	0.00027203559875488
289	SELECT title FROM _country WHERE country_id='152'	0.00023484230041504
290	SELECT title FROM _country WHERE country_id='153'	0.00028514862060547
291	SELECT title FROM _country WHERE country_id='154'	0.00025582313537598
292	SELECT title FROM _country WHERE country_id='155'	0.00020408630371094
293	SELECT title FROM _country WHERE country_id='156'	0.00025486946105957
294	SELECT title FROM _country WHERE country_id='157'	0.00020408630371094
295	SELECT title FROM _country WHERE country_id='158'	0.0002739429473877
296	SELECT title FROM _country WHERE country_id='159'	0.00022101402282715
297	SELECT title FROM _country WHERE country_id='160'	0.00026798248291016
298	SELECT title FROM _country WHERE country_id='161'	0.0002140998840332
299	SELECT title FROM _country WHERE country_id='162'	0.00028204917907715
300	SELECT title FROM _country WHERE country_id='163'	0.00023794174194336
301	SELECT title FROM _country WHERE country_id='164'	0.00018596649169922
302	SELECT title FROM _country WHERE country_id='165'	0.00023198127746582
303	SELECT title FROM _country WHERE country_id='166'	0.00029492378234863
304	SELECT title FROM _country WHERE country_id='167'	0.00025200843811035
305	SELECT title FROM _country WHERE country_id='168'	0.0001990795135498
306	SELECT title FROM _country WHERE country_id='169'	0.00024509429931641
307	SELECT title FROM _country WHERE country_id='170'	0.00020909309387207
308	SELECT title FROM _country WHERE country_id='171'	0.00027608871459961
309	SELECT title FROM _country WHERE country_id='172'	0.00023913383483887
310	SELECT title FROM _country WHERE country_id='173'	0.00020599365234375
311	SELECT title FROM _country WHERE country_id='174'	0.00025701522827148
312	SELECT title FROM _country WHERE country_id='175'	0.00020289421081543
313	SELECT title FROM _country WHERE country_id='176'	0.00024890899658203
314	SELECT title FROM _country WHERE country_id='177'	0.00021600723266602
315	SELECT title FROM _country WHERE country_id='178'	0.00026488304138184
316	SELECT title FROM _country WHERE country_id='179'	0.00021195411682129
317	SELECT title FROM _country WHERE country_id='180'	0.00025796890258789
318	SELECT title FROM _country WHERE country_id='181'	0.00022411346435547
319	SELECT title FROM _country WHERE country_id='182'	0.00027108192443848
320	SELECT title FROM _country WHERE country_id='184'	0.00022697448730469
321	SELECT title FROM _country WHERE country_id='185'	0.00027203559875488
322	SELECT title FROM _country WHERE country_id='186'	0.00023388862609863
323	SELECT title FROM _country WHERE country_id='187'	0.00028181076049805
324	SELECT title FROM _country WHERE country_id='188'	0.0002288818359375
325	SELECT title FROM _country WHERE country_id='189'	0.0002748966217041
326	SELECT title FROM _country WHERE country_id='190'	0.00023603439331055
327	SELECT title FROM _country WHERE country_id='191'	0.00028586387634277
328	SELECT title FROM _country WHERE country_id='192'	0.00023198127746582
329	SELECT title FROM _country WHERE country_id='193'	0.00027704238891602
330	SELECT title FROM _country WHERE country_id='194'	0.00023698806762695
331	SELECT title FROM _country WHERE country_id='195'	0.00018501281738281
332	SELECT title FROM _country WHERE country_id='196'	0.00024199485778809
333	SELECT title FROM _country WHERE country_id='197'	0.00018692016601562
334	SELECT title FROM _country WHERE country_id='198'	0.00024795532226562
335	SELECT title FROM _country WHERE country_id='199'	0.00019407272338867
336	SELECT title FROM _country WHERE country_id='200'	0.00023984909057617
337	SELECT title FROM _country WHERE country_id='201'	0.00018596649169922
338	SELECT title FROM _country WHERE country_id='202'	0.00024700164794922
339	SELECT title FROM _country WHERE country_id='203'	0.00019311904907227
340	SELECT title FROM _country WHERE country_id='204'	0.00023794174194336
341	SELECT title FROM _country WHERE country_id='205'	0.00018501281738281
342	SELECT title FROM _country WHERE country_id='206'	0.00024509429931641
343	SELECT title FROM _country WHERE country_id='207'	0.00019121170043945
344	SELECT title FROM _country WHERE country_id='208'	0.00024819374084473
345	SELECT title FROM _country WHERE country_id='210'	0.00019383430480957
346	SELECT title FROM _country WHERE country_id='211'	0.0002591609954834
347	SELECT title FROM _country WHERE country_id='212'	0.00020599365234375
348	SELECT title FROM _country WHERE country_id='213'	0.00025200843811035
349	SELECT title FROM _country WHERE country_id='214'	0.0001978874206543
350	SELECT title FROM _country WHERE country_id='215'	0.00027990341186523
351	SELECT title FROM _country WHERE country_id='216'	0.00022602081298828
352	SELECT title FROM _country WHERE country_id='217'	0.00028491020202637
353	SELECT title FROM _country WHERE country_id='218'	0.00023508071899414
354	SELECT title FROM _country WHERE country_id='219'	0.00030398368835449
355	SELECT title FROM _country WHERE country_id='220'	0.00025010108947754
356	SELECT title FROM _country WHERE country_id='221'	0.00019598007202148
357	SELECT title FROM _country WHERE country_id='222'	0.00024080276489258
358	SELECT title FROM _country WHERE country_id='223'	0.00020599365234375
359	SELECT title FROM _country WHERE country_id='224'	0.00025081634521484
360	SELECT title FROM _country WHERE country_id='225'	0.00020503997802734
361	SELECT title FROM _country WHERE country_id='226'	0.00025200843811035
362	SELECT title FROM _country WHERE country_id='227'	0.00021696090698242
363	SELECT title FROM _country WHERE country_id='228'	0.00026297569274902
364	SELECT title FROM _country WHERE country_id='229'	0.00020909309387207
365	SELECT title FROM _country WHERE country_id='230'	0.00025510787963867
366	SELECT title FROM _country WHERE country_id='231'	0.00021910667419434
367	SELECT title FROM _country WHERE country_id='232'	0.00026416778564453
368	SELECT title FROM _country WHERE country_id='233'	0.00020980834960938
369	SELECT title FROM _country WHERE country_id='234'	0.00025606155395508
370	SELECT title FROM _country WHERE country_id='235'	0.00021886825561523
371	SELECT title FROM _country WHERE country_id='236'	0.00028181076049805
372	SELECT title FROM _country WHERE country_id='237'	0.00024199485778809
373	SELECT title FROM _country WHERE country_id='238'	0.00018811225891113
374	SELECT title FROM _country WHERE country_id='239'	0.00027108192443848
375	SELECT title FROM _country WHERE country_id='240'	0.00021815299987793
376	SELECT title FROM _country WHERE country_id='242'	0.00026392936706543
377	SELECT title FROM _country WHERE country_id='245'	0.00021004676818848
378	SELECT title FROM _country WHERE country_id='246'	0.00029301643371582
379	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.002734899520874
380	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and rates='5' and type='tour'	0.0025699138641357
381	SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='551' and type='tour' and rates >= 5	0.0024139881134033
382	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0025990009307861
383	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and rates='4' and type='tour'	0.002540111541748
384	SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='551' and type='tour' and rates >= 4 and rates < 5	0.0024988651275635
385	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0024640560150146
386	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and rates='3' and type='tour'	0.002479076385498
387	SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='551' and type='tour' and rates >= 3 and rates < 4	0.0024130344390869
388	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0024640560150146
389	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and rates='2' and type='tour'	0.0023479461669922
390	SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='551' and type='tour' and rates >= 2 and rates < 3	0.0023210048675537
391	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0025179386138916
392	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and rates='1' and type='tour'	0.0026860237121582
393	SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='551' and type='tour' and rates >= 1 and rates < 2	0.0024251937866211
394	SELECT price_text FROM default_promotion WHERE promotion_id=''	0.00029301643371582
395	SELECT check_mem_set FROM default_promotion WHERE promotion_id=''	0.00025296211242676
396	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.00090479850769043
397	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026106834411621
398	SELECT faq_id,title,slug FROM default_faq WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc limit 0,4	0.0030450820922852
399	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_related' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0008549690246582
400	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028395652770996
401	SELECT tour_2_id FROM default_tour_extension WHERE lang_id='' and is_trash=0 and tour_1_id='551' and tour_2_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no asc	0.0024850368499756
402	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.00096297264099121
403	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028800964355469
404	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.00088405609130859
405	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025415420532227
406	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.00083398818969727
407	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024294853210449

From Ha Noi: Small Group Tour to Hoa Lu, Tam Coc

Overview

Available

Itinerary

Full day: (Lunch) November 07, 2024

Important noted

Trip Inclusion

Trip Exclusions

Thing To Carry

Payments Policy

Cancellation Policy

Reviews

Overall rating

FAQs

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel