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.0010359287261963
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00032305717468262
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.0020902156829834
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.0025510787963867
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.0020358562469482
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.002187967300415
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.0020029544830322
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.0019690990447998
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00022983551025391
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.00086188316345215
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022482872009277
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.00083398818969727
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020217895507812
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.0019891262054443
15	SELECT title,newscat_id,reg_date,last_update,author,intro,content,slug,image FROM default_news WHERE news_id='48'	0.00019407272338867
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.0022780895233154
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.0027029514312744
18	SELECT image FROM default_meta WHERE meta_id='515'	0.00021696090698242
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.00084614753723145
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
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.00080108642578125
22	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
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.0020279884338379
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.0022828578948975
25	SELECT slug FROM default_country WHERE country_id='1'	0.00015902519226074
26	SELECT slug FROM default_country WHERE country_id='64'	0.00017404556274414
27	SELECT slug FROM default_country WHERE country_id='3'	0.0001838207244873
28	SELECT slug FROM default_country WHERE country_id='7'	0.00019407272338867
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.00086212158203125
30	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020718574523926
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.0019750595092773
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.0019478797912598
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.0018990039825439
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.0019841194152832
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.0020771026611328
36	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00020694732666016
37	SELECT slug FROM default_country WHERE country_id='1'	0.00022411346435547
38	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.0002288818359375
39	SELECT slug FROM default_country WHERE country_id='1'	0.00023984909057617
40	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00015401840209961
41	SELECT slug FROM default_country WHERE country_id='1'	0.00016498565673828
42	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00016498565673828
43	SELECT slug FROM default_country WHERE country_id='1'	0.00016999244689941
44	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00019216537475586
45	SELECT slug FROM default_country WHERE country_id='1'	0.00021004676818848
46	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00022006034851074
47	SELECT slug FROM default_country WHERE country_id='1'	0.00022602081298828
48	SELECT image_menu FROM default_country WHERE country_id='1'	0.00023198127746582
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.0018961429595947
50	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00020098686218262
51	SELECT slug FROM default_country WHERE country_id='64'	0.00020408630371094
52	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00020694732666016
53	SELECT slug FROM default_country WHERE country_id='64'	0.00021100044250488
54	SELECT image_menu FROM default_country WHERE country_id='64'	0.00021696090698242
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.0020170211791992
56	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00023603439331055
57	SELECT slug FROM default_country WHERE country_id='3'	0.00015497207641602
58	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00015401840209961
59	SELECT slug FROM default_country WHERE country_id='3'	0.00015902519226074
60	SELECT image_menu FROM default_country WHERE country_id='3'	0.0001671314239502
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.0019440650939941
62	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00016498565673828
63	SELECT slug FROM default_country WHERE country_id='7'	0.00017619132995605
64	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00018405914306641
65	SELECT slug FROM default_country WHERE country_id='7'	0.00018715858459473
66	SELECT image_menu FROM default_country WHERE country_id='7'	0.00019192695617676
67	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00021004676818848
68	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00020503997802734
69	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00020885467529297
70	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00020217895507812
71	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00020313262939453
72	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00020599365234375
73	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00021505355834961
74	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00021600723266602
75	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00032591819763184
76	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00028705596923828
77	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.0001990795135498
78	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00020098686218262
79	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00020909309387207
80	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00021100044250488
81	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00022292137145996
82	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.0002288818359375
83	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00023889541625977
84	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00014185905456543
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.00088715553283691
86	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021505355834961
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.0019619464874268
88	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00016593933105469
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.0019159317016602
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.0019199848175049
91	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022697448730469
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.0019490718841553
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.0018801689147949
94	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00018501281738281
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.0020780563354492
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.0019409656524658
97	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00015497207641602
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.0018939971923828
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.0018999576568604
100	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00020718574523926
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.0019619464874268
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.0018839836120605
103	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00018692016601562
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.0019400119781494
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.0018730163574219
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.00093984603881836
107	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
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.0019700527191162
109	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00018215179443359
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.0018961429595947
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.0019280910491943
112	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00023484230041504
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.0019431114196777
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.0019619464874268
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.00080704689025879
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
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.0018670558929443
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.00081682205200195
119	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020003318786621
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.0021119117736816
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.00092101097106934
122	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
123	SELECT title,slug FROM default_newscat WHERE newscat_id='5'	0.0001678466796875
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.0019290447235107
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.0021219253540039
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.0008699893951416
127	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020289421081543
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.00084209442138672
129	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020503997802734
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.0020198822021484
131	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00024199485778809
132	SELECT title FROM _country WHERE country_id='193'	0.00016307830810547
133	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00019097328186035
134	SELECT title FROM _country WHERE country_id='103'	0.00019192695617676
135	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00022506713867188
136	SELECT title FROM _country WHERE country_id='229'	0.00022387504577637
137	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.0001530647277832
138	SELECT title FROM _country WHERE country_id='14'	0.0001530647277832
139	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00019693374633789
140	SELECT title FROM _country WHERE country_id='175'	0.00019288063049316
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00022292137145996
142	SELECT title FROM _country WHERE country_id='228'	0.00022315979003906
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.0001518726348877
144	SELECT title FROM _country WHERE country_id='42'	0.0001528263092041
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00018620491027832
146	SELECT title FROM _country WHERE country_id='134'	0.00018501281738281
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00021505355834961
148	SELECT title FROM _country WHERE country_id='77'	0.0002140998840332
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.00089192390441895
150	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020909309387207
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.00081610679626465
152	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
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.00084209442138672
154	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
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.00083494186401367
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019717216491699
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.00086021423339844
158	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019693374633789
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.00096011161804199
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019717216491699

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

Incredible Experience Cruise And Mekong Delta Tour Vietnam

What To Do In Siem Reap In 3 Days? Review 3 Days In Siem Reap, Cambodia From Mr John

What To Do In Vientiane In 3 Days? Review 3 Days In Vientiane, Laos From Mrs Maria

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