Hotels in Halong Bay

Visiting Halong Bay, tourists not only have a great chance to visit and explore a lot of stunning and beautiful landscapes and spots but also take an opportunity to stay in luxurious and modern cruises. Just come and enjoy your trip here.

View Detail

From:

280 USD

Ha Long Plaza Hotel

08 Ha Long Road, Bai Chay Ward, Ha Long, Quang Ninh, Vietnam

A-Z Hotels of Other Destinations

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='hotel'	0.0011680126190186
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00052690505981445
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.0062718391418457
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.010843992233276
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.029111862182617
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00061511993408203
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.0087358951568604
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.011976957321167
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.0095310211181641
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.012447834014893
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.0076661109924316
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.011031150817871
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.0037481784820557
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.036695003509521
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.024178028106689
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.0048248767852783
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.0035660266876221
18	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00057101249694824
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.025249004364014
20	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and slug = 'halong-bay' limit 0,1	0.0035829544067383
21	SELECT title,slug,intro,content,intro_hotel,image_hotel FROM default_city WHERE city_id='417'	0.00039291381835938
22	SELECT distinct country_id FROM default_city where city_id=417 LIMIT 0,1	0.0081491470336914
23	SELECT country_id FROM default_city WHERE city_id='417'	0.029014110565186
24	SELECT slug FROM default_city WHERE city_id='417'	0.0003509521484375
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.011325120925903
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.0076949596405029
27	SELECT hotel_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and city_id='417'	0.0095648765563965
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='417' order by order_no ASC LIMIT 0,12	0.027803182601929
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='417')	0.037783145904541
30	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.011350870132446
31	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.063853979110718
32	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.013471841812134
33	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.015317916870117
34	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.0063779354095459
35	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.011621952056885
36	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.038664102554321
37	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.035290002822876
38	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.047341108322144
39	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.0099642276763916
40	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.018465995788574
41	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.0075030326843262
42	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.029008150100708
43	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.01682186126709
44	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.023092031478882
45	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.023107051849365
46	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.064039945602417
47	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.095877885818481
48	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.011451959609985
49	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.018976926803589
50	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.017176866531372
51	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.037132978439331
52	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.017935037612915
53	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.073261976242065
54	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.016538858413696
55	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'417' 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.039444923400879
56	SELECT intro FROM default_city WHERE city_id='417'	0.0010349750518799
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.003817081451416
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/halong-bay' or config_link='/en/hotels/vietnam/halong-bay') limit 1	0.020936965942383
59	SELECT slug FROM default_country WHERE country_id='7'	0.0039830207824707
60	SELECT slug FROM default_country WHERE country_id='1'	0.00081396102905273
61	SELECT slug FROM default_country WHERE country_id='37'	0.00074005126953125
62	SELECT slug FROM default_country WHERE country_id='52'	0.00068998336791992
63	SELECT slug FROM default_country WHERE country_id='3'	0.00071597099304199
64	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00072216987609863
65	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.0002892017364502
66	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00074100494384766
67	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00063896179199219
68	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.00075507164001465
69	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00020980834960938
70	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00080299377441406
71	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.0029470920562744
72	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00021696090698242
73	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00099396705627441
74	SELECT title FROM default_tour_category WHERE tourcat_id='402'	0.00085306167602539
75	SELECT slug FROM default_tour_category WHERE tourcat_id='402'	0.00094389915466309
76	SELECT title FROM default_tour_category WHERE tourcat_id='3'	0.0003199577331543
77	SELECT slug FROM default_tour_category WHERE tourcat_id='3'	0.00099921226501465
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.019932985305786
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.016860008239746
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.0079100131988525
81	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='47'	0.00034594535827637
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.0096359252929688
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.0082671642303467
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.013283014297485
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.016691923141479
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.015582799911499
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.0084998607635498
88	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='365' and price >0 order by price ASC	0.030638933181763
89	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00053906440734863
90	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '23'	0.0076658725738525
91	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '15'	0.01534104347229
92	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '13'	0.019023895263672
93	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '1'	0.0079669952392578
94	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '16'	0.014695167541504
95	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '9'	0.053823947906494
96	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '2'	0.035048007965088
97	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '12'	0.020169973373413
98	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '417' and cat_id = '14'	0.0044949054718018

Hotels in Halong Bay

Ha Long Plaza Hotel

A-Z Hotels of Other Destinations

VietISO Company

About isoCMS

Travel Styles

Other

Follow Us

Payment Channel