Blog listing by tag Cat Ba Homestays Reviews

The Best Homestays In Cat Ba, Viet Nam

13 March, 2024 Sunny Nguyen Duong

Cat Ba island situated in the heart of Hai Phong, unveils a multitude of possibilities for a truly immersive homestay experience, where you can fully immerse yourself in the vibrant tapestry of local culture... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00095200538635254
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00032806396484375
3	SELECT country_id,title,slug,intro,image,image_menu FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0021779537200928
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.0025279521942139
5	SELECT tourcat_id,title,slug,image 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.0019760131835938
6	SELECT tour_id,list_cat_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and is_multi_country=1	0.0020780563354492
7	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.0019440650939941
8	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.0019068717956543
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00021910667419434
10	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.00089192390441895
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021576881408691
12	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.00086092948913574
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019097328186035
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='cat-ba-homestays-reviews' limit 0,1	0.0019910335540771
15	SELECT * FROM default_tag WHERE tag_id='442'	0.00020194053649902
16	SELECT title FROM default_tag WHERE tag_id='442'	0.00018596649169922
17	SELECT * FROM default_tag WHERE tag_id='442'	0.00018882751464844
18	SELECT * FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|442\|%')	0.0040202140808105
19	SELECT blog_id,cat_id,reg_date,publish_date FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|442\|%') order by order_no ASC LIMIT 0,6	0.0024199485778809
20	SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0009009838104248
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
22	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.00081610679626465
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
24	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.0018870830535889
25	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/blog/tag/cat-ba-homestays-reviews' or config_link='/blog/tag/cat-ba-homestays-reviews') limit 1	0.0028469562530518
26	SELECT slug FROM default_country WHERE country_id='1'	0.00018787384033203
27	SELECT slug FROM default_country WHERE country_id='64'	0.00019383430480957
28	SELECT slug FROM default_country WHERE country_id='3'	0.00020480155944824
29	SELECT slug FROM default_country WHERE country_id='7'	0.0002589225769043
30	SELECT * FROM default_featurepackage WHERE mod_page='tour_exhautive' and act_page='category_country' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0045318603515625
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026297569274902
32	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0022881031036377
33	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0019230842590332
34	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.0019409656524658
35	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0018429756164551
36	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0019440650939941
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00018000602722168
38	SELECT slug FROM default_country WHERE country_id='1'	0.00020194053649902
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00020194053649902
40	SELECT slug FROM default_country WHERE country_id='1'	0.00020384788513184
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00020217895507812
42	SELECT slug FROM default_country WHERE country_id='1'	0.00022602081298828
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00022411346435547
44	SELECT slug FROM default_country WHERE country_id='1'	0.00022506713867188
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00022292137145996
46	SELECT slug FROM default_country WHERE country_id='1'	0.00023198127746582
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00025296211242676
48	SELECT slug FROM default_country WHERE country_id='1'	0.00015497207641602
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00015783309936523
50	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0018448829650879
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00015902519226074
52	SELECT slug FROM default_country WHERE country_id='64'	0.00016880035400391
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00018310546875
54	SELECT slug FROM default_country WHERE country_id='64'	0.00018501281738281
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00018405914306641
56	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.0019180774688721
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00023102760314941
58	SELECT slug FROM default_country WHERE country_id='3'	0.00024008750915527
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00014019012451172
60	SELECT slug FROM default_country WHERE country_id='3'	0.00014114379882812
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00014591217041016
62	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0018610954284668
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00020503997802734
64	SELECT slug FROM default_country WHERE country_id='7'	0.00023293495178223
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00023293495178223
66	SELECT slug FROM default_country WHERE country_id='7'	0.00023698806762695
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00023698806762695
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00015807151794434
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00015997886657715
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00015997886657715
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.0001521110534668
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00014996528625488
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00014209747314453
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00013899803161621
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00018596649169922
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00018787384033203
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00019383430480957
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00019216537475586
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00018310546875
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00018095970153809
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00017094612121582
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00016903877258301
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00015997886657715
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00015783309936523
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00015020370483398
86	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.00089883804321289
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022315979003906
88	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='51' and is_trash=0 and is_online=1 order by order_no ASC	0.0018270015716553
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.0002288818359375
90	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.0018939971923828
91	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.0018329620361328
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022411346435547
93	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.0018579959869385
94	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.0018441677093506
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00013184547424316
96	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0018520355224609
97	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0017759799957275
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00016689300537109
99	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.0017859935760498
100	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.0019469261169434
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.0001370906829834
102	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.0018539428710938
103	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.0017938613891602
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00018501281738281
105	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.0017940998077393
106	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.0018689632415771
107	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.00086212158203125
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018978118896484
109	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='57' and is_trash=0 and is_online=1 order by order_no ASC	0.0018389225006104
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00022792816162109
111	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0018339157104492
112	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0018811225891113
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00017285346984863
114	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0017821788787842
115	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0019121170043945
116	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.0009000301361084
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
118	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='60' and is_trash=0 and is_online=1 order by order_no ASC	0.0018539428710938
119	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.00087213516235352
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021600723266602
121	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='54' and is_trash=0 and is_online=1 order by order_no ASC	0.0021219253540039
122	SELECT title FROM default_tag WHERE tag_id='442'	0.00019097328186035
123	SELECT title FROM default_blog WHERE blog_id='313'	0.00024509429931641
124	SELECT slug FROM default_blog WHERE blog_id='313'	0.00016617774963379
125	SELECT author FROM default_blog WHERE blog_id='313'	0.00021600723266602
126	SELECT author FROM default_blog WHERE blog_id='313'	0.00023794174194336
127	SELECT image FROM default_blog WHERE blog_id='313'	0.00016617774963379
128	SELECT image FROM default_blog WHERE blog_id='313'	0.00018906593322754
129	SELECT intro FROM default_blog WHERE blog_id='313'	0.00023293495178223
130	SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0019998550415039
131	SELECT blog_id,slug,title FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and num_view > 0 order by num_view desc limit 0,5	0.0033919811248779
132	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_blog WHERE is_trash=0 and is_online=1) order by order_no asc	0.002324104309082
133	SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='tour' and tour_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no ASC	0.002079963684082
134	SELECT slug FROM default_country WHERE country_id='1'	0.00019288063049316
135	SELECT slug FROM default_country WHERE country_id='64'	0.00019192695617676
136	SELECT slug FROM default_country WHERE country_id='3'	0.0001978874206543
137	SELECT slug FROM default_country WHERE country_id='7'	0.00019121170043945
138	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.00084495544433594
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
140	SELECT testimonial_id,title,slug,image,reg_date,rates,name,intro FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online = 1 and image<>'' order by order_no ASC limit 0,9	0.0019650459289551
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.0002288818359375
142	SELECT title FROM _country WHERE country_id='193'	0.00023484230041504
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.0001530647277832
144	SELECT title FROM _country WHERE country_id='103'	0.00014400482177734
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00015902519226074
146	SELECT title FROM _country WHERE country_id='229'	0.00014686584472656
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00016117095947266
148	SELECT title FROM _country WHERE country_id='14'	0.00014805793762207
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00016212463378906
150	SELECT title FROM _country WHERE country_id='175'	0.00014901161193848
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00018501281738281
152	SELECT title FROM _country WHERE country_id='228'	0.00018787384033203
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00021982192993164
154	SELECT title FROM _country WHERE country_id='42'	0.00022315979003906
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00017786026000977
156	SELECT title FROM _country WHERE country_id='134'	0.00018095970153809
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.0002131462097168
158	SELECT title FROM _country WHERE country_id='77'	0.0002140998840332
159	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.00087714195251465
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019288063049316
161	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.00083494186401367
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
163	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.00084304809570312
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020003318786621
165	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.00081300735473633
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018787384033203
167	SELECT * FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00080013275146484
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
169	SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00084781646728516
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922

Blog listing by tag Cat Ba Homestays Reviews

The Best Homestays In Cat Ba, Viet Nam

WHAT DO CUSTOMERS SAY ABOUT US?

Dream Trip In Vietnam

Fantastic Indochina

Vietnam Heritage Trail

Exotic Vietnam & Cambodia

Vietnam Holiday 15 Days

The Best Of Vietnam

Vietnam Family Vacation

Vietnam In Capture

The Essence Of Vietnam

Information

Travel Styles

Other

Follow Us

Payment Channel