First Time At Cafe With A Full View Of Hoan Kiem Lake Hanoi

Invited by the Auasia Travel manager, we visited a charming café on the fifth floor next to Hoan Kiem Lake.

The panoramic view was breathtaking, etching an indelible memory. The serene lake, illuminated by sunlight, captivated us. This unforgettable experience combined the inviting café ambiance with an unmatched lake view, stirring both visual and emotional sensations.

Auasia Travel has coffee with customers in Hoan Kiem lake

Auasia Travel has coffee with customers in Hoan Kiem lake

In summary, the Auasia Travel manager's thoughtful arrangement gifted us an unparalleled Hoan Kiem Lake perspective - a cherished memory of captivating vistas and evoked emotions.

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='news'	0.00094485282897949
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00031518936157227
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.0021121501922607
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.0025680065155029
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.0019938945770264
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.0022249221801758
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.0019998550415039
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.0019810199737549
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00024986267089844
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.00087809562683105
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023007392883301
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.00092601776123047
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020194053649902
14	SELECT news_id FROM default_news WHERE lang_id='' and is_trash=0 and is_online=1 and news_id='48' and slug='first-time-at-cafe-with-a-full-view-of-hoan-kiem-lake-hanoi'	0.0018980503082275
15	SELECT title,newscat_id,reg_date,last_update,author,intro,content,slug,image FROM default_news WHERE news_id='48'	0.00027108192443848
16	SELECT news_id,reg_date,title,slug,image FROM default_news WHERE lang_id='' and is_trash=0 and is_online=1 and news_id<>'48' order by rand() LIMIT 0,5	0.0020439624786377
17	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/n48-first-time-at-cafe-with-a-full-view-of-hoan-kiem-lake-hanoi.html'	0.0027902126312256
18	SELECT image FROM default_meta WHERE meta_id='515'	0.0002140998840332
19	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.00098896026611328
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002448558807373
21	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.0010089874267578
22	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023508071899414
23	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.0019681453704834
24	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/n48-first-time-at-cafe-with-a-full-view-of-hoan-kiem-lake-hanoi.html' or config_link='/n48-first-time-at-cafe-with-a-full-view-of-hoan-kiem-lake-hanoi.html') limit 1	0.0023288726806641
25	SELECT slug FROM default_country WHERE country_id='1'	0.00021600723266602
26	SELECT slug FROM default_country WHERE country_id='64'	0.00026416778564453
27	SELECT slug FROM default_country WHERE country_id='3'	0.0002138614654541
28	SELECT slug FROM default_country WHERE country_id='7'	0.00026583671569824
29	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.00096392631530762
30	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022506713867188
31	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.0020771026611328
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='64' order by order_no ASC	0.0020010471343994
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='3' order by order_no ASC	0.0020978450775146
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='7' order by order_no ASC	0.0020120143890381
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='1' order by order_no ASC	0.0020790100097656
36	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00024008750915527
37	SELECT slug FROM default_country WHERE country_id='1'	0.00019288063049316
38	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00023412704467773
39	SELECT slug FROM default_country WHERE country_id='1'	0.00018596649169922
40	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00022983551025391
41	SELECT slug FROM default_country WHERE country_id='1'	0.00027585029602051
42	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00022602081298828
43	SELECT slug FROM default_country WHERE country_id='1'	0.00026702880859375
44	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00021195411682129
45	SELECT slug FROM default_country WHERE country_id='1'	0.00025486946105957
46	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00020194053649902
47	SELECT slug FROM default_country WHERE country_id='1'	0.00024199485778809
48	SELECT image_menu FROM default_country WHERE country_id='1'	0.00019097328186035
49	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.0020411014556885
50	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00019311904907227
51	SELECT slug FROM default_country WHERE country_id='64'	0.00024509429931641
52	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00018811225891113
53	SELECT slug FROM default_country WHERE country_id='64'	0.00026607513427734
54	SELECT image_menu FROM default_country WHERE country_id='64'	0.00022602081298828
55	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.0021209716796875
56	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00027918815612793
57	SELECT slug FROM default_country WHERE country_id='3'	0.00022792816162109
58	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00018191337585449
59	SELECT slug FROM default_country WHERE country_id='3'	0.00022792816162109
60	SELECT image_menu FROM default_country WHERE country_id='3'	0.00027799606323242
61	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.0020110607147217
62	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00027084350585938
63	SELECT slug FROM default_country WHERE country_id='7'	0.00021886825561523
64	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00026392936706543
65	SELECT slug FROM default_country WHERE country_id='7'	0.00020790100097656
66	SELECT image_menu FROM default_country WHERE country_id='7'	0.00026488304138184
67	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00023007392883301
68	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00028705596923828
69	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00023698806762695
70	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00027203559875488
71	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00022721290588379
72	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00026798248291016
73	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00021481513977051
74	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00025415420532227
75	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00019598007202148
76	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00025200843811035
77	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00020098686218262
78	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00024199485778809
79	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00018811225891113
80	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00023293495178223
81	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00027894973754883
82	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.0002129077911377
83	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00026106834411621
84	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00019717216491699
85	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.00096487998962402
86	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025582313537598
87	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.0020120143890381
88	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00026202201843262
89	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.0019810199737549
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.0019750595092773
91	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022387504577637
92	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.0020451545715332
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.0019071102142334
94	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00025796890258789
95	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.0019629001617432
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.0019428730010986
97	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00019001960754395
98	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.002007007598877
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.0020139217376709
100	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00026798248291016
101	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.0019810199737549
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.0019519329071045
103	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00020384788513184
104	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.0019659996032715
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.0019891262054443
106	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.00099086761474609
107	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024604797363281
108	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.0018610954284668
109	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00017595291137695
110	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.0019211769104004
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.001943826675415
112	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00016307830810547
113	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.001878023147583
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.0018610954284668
115	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.00090217590332031
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022602081298828
117	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.00187087059021
118	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.00088000297546387
119	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021910667419434
120	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.0019822120666504
121	SELECT * FROM default_featurepackage WHERE mod_page='news' and act_page='category' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00095105171203613
122	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022196769714355
123	SELECT title,slug FROM default_newscat WHERE newscat_id='5'	0.00024604797363281
124	SELECT newscat_id,title,slug FROM default_newscat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0018649101257324
125	SELECT news_id,reg_date,title,image,slug FROM default_news WHERE lang_id='' and is_trash=0 and is_online=1 order by view_num desc LIMIT 3,5	0.0019910335540771
126	SELECT * FROM default_featurepackage WHERE mod_page='news' and act_page='category' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00095295906066895
127	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022101402282715
128	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.0027170181274414
129	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0004570484161377
130	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.0065000057220459
131	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.003896951675415
132	SELECT title FROM _country WHERE country_id='193'	0.00020194053649902
133	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00021100044250488
134	SELECT title FROM _country WHERE country_id='103'	0.00019001960754395
135	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00019598007202148
136	SELECT title FROM _country WHERE country_id='229'	0.00018215179443359
137	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.0007939338684082
138	SELECT title FROM _country WHERE country_id='14'	0.0001990795135498
139	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00014185905456543
140	SELECT title FROM _country WHERE country_id='175'	0.00014591217041016
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00019097328186035
142	SELECT title FROM _country WHERE country_id='228'	0.00019311904907227
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00023508071899414
144	SELECT title FROM _country WHERE country_id='42'	0.00023412704467773
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00018405914306641
146	SELECT title FROM _country WHERE country_id='134'	0.0001981258392334
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00013995170593262
148	SELECT title FROM _country WHERE country_id='77'	0.00014305114746094
149	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.0014278888702393
150	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021791458129883
151	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.0011930465698242
152	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848
153	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.0009770393371582
154	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020813941955566
155	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.0011799335479736
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00040698051452637
157	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.0011241436004639
158	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00030183792114258
159	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.00096702575683594
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00029182434082031

First Time At Cafe With A Full View Of Hoan Kiem Lake Hanoi

Featured news

Review 3 Days In Bangkok - Top Things To Do In Bangkok, Thailand

Explore Phnom Penh City Tour By Reviewing With Mrs. Nancy

Review Bangkok Floating Market Tour - Damnoen Saduak Floating Market

Explore Phnom Penh City Tour By Reviewing With Miss Linda

Incredible Experience Cruise And Mekong Delta Tour Vietnam

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