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.0010230541229248
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00026607513427734
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.0019412040710449
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.0024518966674805
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.0019040107727051
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.0021960735321045
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.0019807815551758
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.0019781589508057
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00023221969604492
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.00088715553283691
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020885467529297
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.00094699859619141
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001978874206543
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.0018899440765381
15	SELECT title,newscat_id,reg_date,last_update,author,intro,content,slug,image FROM default_news WHERE news_id='48'	0.00017094612121582
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.0020458698272705
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.0027561187744141
18	SELECT image FROM default_meta WHERE meta_id='515'	0.00015091896057129
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.00088906288146973
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021982192993164
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.00085306167602539
22	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
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.0019528865814209
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.0020871162414551
25	SELECT slug FROM default_country WHERE country_id='1'	0.00021886825561523
26	SELECT slug FROM default_country WHERE country_id='64'	0.00024986267089844
27	SELECT slug FROM default_country WHERE country_id='3'	0.00017404556274414
28	SELECT slug FROM default_country WHERE country_id='7'	0.00020098686218262
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.00095200538635254
30	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
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.0018510818481445
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.0018510818481445
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.0017549991607666
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.0018160343170166
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.0018479824066162
36	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00015997886657715
37	SELECT slug FROM default_country WHERE country_id='1'	0.00016403198242188
38	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00015401840209961
39	SELECT slug FROM default_country WHERE country_id='1'	0.00014495849609375
40	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00013303756713867
41	SELECT slug FROM default_country WHERE country_id='1'	0.00022411346435547
42	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00021696090698242
43	SELECT slug FROM default_country WHERE country_id='1'	0.00021004676818848
44	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00021100044250488
45	SELECT slug FROM default_country WHERE country_id='1'	0.00024986267089844
46	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00014305114746094
47	SELECT slug FROM default_country WHERE country_id='1'	0.00014185905456543
48	SELECT image_menu FROM default_country WHERE country_id='1'	0.00013589859008789
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.0017659664154053
50	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00020408630371094
51	SELECT slug FROM default_country WHERE country_id='64'	0.00022506713867188
52	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00024604797363281
53	SELECT slug FROM default_country WHERE country_id='64'	0.00017499923706055
54	SELECT image_menu FROM default_country WHERE country_id='64'	0.00016999244689941
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.0018448829650879
56	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00014805793762207
57	SELECT slug FROM default_country WHERE country_id='3'	0.00014305114746094
58	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00013089179992676
59	SELECT slug FROM default_country WHERE country_id='3'	0.00022101402282715
60	SELECT image_menu FROM default_country WHERE country_id='3'	0.00021910667419434
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.0018858909606934
62	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021600723266602
63	SELECT slug FROM default_country WHERE country_id='7'	0.00026106834411621
64	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00020313262939453
65	SELECT slug FROM default_country WHERE country_id='7'	0.00024294853210449
66	SELECT image_menu FROM default_country WHERE country_id='7'	0.00017881393432617
67	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00022411346435547
68	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00022602081298828
69	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00023198127746582
70	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00023102760314941
71	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00024294853210449
72	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00014805793762207
73	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00015592575073242
74	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00015401840209961
75	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00015997886657715
76	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00016498565673828
77	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00021004676818848
78	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.0002140998840332
79	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00022196769714355
80	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00021910667419434
81	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00021004676818848
82	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00019502639770508
83	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.0001838207244873
84	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.0001680850982666
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.00090599060058594
86	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023198127746582
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.0018918514251709
88	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00021886825561523
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.00187087059021
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.0018310546875
91	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022792816162109
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.0018308162689209
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.0018360614776611
94	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00022196769714355
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.0017950534820557
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.0018198490142822
97	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00024104118347168
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.0018539428710938
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.0018470287322998
100	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.0001671314239502
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.0018069744110107
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.0019078254699707
103	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00022697448730469
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.002079963684082
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.0018868446350098
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.0009150505065918
107	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022411346435547
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.0019190311431885
109	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00023698806762695
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.0019059181213379
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.0019440650939941
112	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00017189979553223
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.0018379688262939
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.0019879341125488
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.00093913078308105
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023508071899414
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.0019180774688721
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.0009760856628418
119	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022196769714355
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.0019059181213379
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.00098204612731934
122	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020813941955566
123	SELECT title,slug FROM default_newscat WHERE newscat_id='5'	0.0002288818359375
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.001878023147583
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.0019969940185547
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.00083708763122559
127	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019311904907227
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.00084495544433594
129	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022482872009277
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.0019209384918213
131	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00021696090698242
132	SELECT title FROM _country WHERE country_id='193'	0.00022602081298828
133	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00018715858459473
134	SELECT title FROM _country WHERE country_id='103'	0.00020599365234375
135	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00024509429931641
136	SELECT title FROM _country WHERE country_id='229'	0.0001370906829834
137	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00016498565673828
138	SELECT title FROM _country WHERE country_id='14'	0.00015592575073242
139	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00016903877258301
140	SELECT title FROM _country WHERE country_id='175'	0.00016307830810547
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00019598007202148
142	SELECT title FROM _country WHERE country_id='228'	0.00019979476928711
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00025200843811035
144	SELECT title FROM _country WHERE country_id='42'	0.00017285346984863
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00018882751464844
146	SELECT title FROM _country WHERE country_id='134'	0.00018906593322754
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00020909309387207
148	SELECT title FROM _country WHERE country_id='77'	0.00020813941955566
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.00091791152954102
150	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001978874206543
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.00084304809570312
152	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019097328186035
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.00088095664978027
154	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001981258392334
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.00086617469787598
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020217895507812
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.00090694427490234
158	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019502639770508
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.0009150505065918
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025296211242676

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

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

Explore Phnom Penh City Tour By Reviewing With Mrs. Nancy

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

Explore Phnom Penh City Tour By Reviewing With Miss Linda

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