Little Riverside Hoi An . A Luxury Hotel & Spa

09 Phan Boi Chau, Cam Chau, Hoi An, Vietnam

Price from: USD 365

Need help? Call us at

+84 243 829 3838

or call your favorite travel agent

Overview

Hotel booking policy

Due to Coronavirus (COVID-19), please ensure that you are only booking this property following the local government guidelines of the destination, including but not limited to the purpose of travel, and maximum allowed group size.
In accordance with government guidelines to minimise transmission of the Coronavirus (COVID-19), this property can only accept bookings from essential workers/permitted travellers, during dates where such guidelines exist. Reasonable evidence must be provided on arrival. If it isn't provided, your booking will be cancelled on arrival.
In accordance with government guidelines to minimise transmission of the Coronavirus (COVID-19), this property currently isn't accepting guests from certain countries, during dates where such guidelines exist.
In accordance with government guidelines to minimise transmission of the Coronavirus (COVID-19), this property may request additional documentation from guests to validate identity, travel itinerary and other relevant information, during dates where such guidelines exist.
In response to Coronavirus (COVID-19), additional safety and sanitation measures are in effect at this property.
Food & beverage services at this property may be limited or unavailable due to Coronavirus (COVID-19).
Due to Coronavirus (COVID-19), this property is taking steps to help protect the safety of guests and staff. Certain services and amenities may be reduced or unavailable as a result.
Due to Coronavirus (COVID-19), this property has reduced reception and service operating hours.
Due to Coronavirus (COVID-19), this property adheres to strict physical distancing measures.
Guests are required to show a photo identification and credit card upon check-in. Please note that all Special Requests are subject to availability and additional charges may apply.
Pet are not allowed.

Hotel Facilities
- Car park
- Luggage storage
- Laundry service
- Restaurant(s)
- Massage(s)
- Wi-Fi in public areas
- Free Wi-Fi in all rooms
- Elevator
- Karaoke
- Spa / Massage
- 24-hour front desk
- Tours/ticket assistance
- Safe-deposit box at front desk
- Fitness facilities
- Free newspapers in lobby
- Sauna
- Concierge services
- Multilingual staff 12

Book this hotel now Back to previous page

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='hotel'	0.0011119842529297
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00056600570678711
3	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.0035018920898438
4	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.0026278495788574
5	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00026297569274902
6	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.0032639503479004
7	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00025200843811035
8	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.0028021335601807
9	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00024986267089844
10	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.002781867980957
11	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.0032000541687012
12	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.0024747848510742
13	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.0025951862335205
14	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.0032529830932617
15	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00046396255493164
16	SELECT hotel_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and hotel_id='477' and slug='little-riverside-hoi-an-a-luxury-hotel-spa'	0.0038819313049316
17	SELECT * FROM default_hotel WHERE hotel_id='477'	0.00041389465332031
18	SELECT hotel_image_id,image FROM default_hotel_image WHERE is_trash=0 and table_id='477' and image <> '' order by order_no ASC	0.0012350082397461
19	SELECT hotel_room_id,room_stype_id FROM default_hotel_room WHERE is_trash=0 and hotel_id='477' order by order_no ASC	0.0013039112091064
20	SELECT hotel_id,star_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and hotel_id <> '477' order by order_no desc limit 0,10	0.0027260780334473
21	SELECT * FROM default_hotel_customfield WHERE hotel_id='477' and fieldtype='CUSTOM' order by order_no ASC	0.0011510848999023
22	SELECT title FROM default_hotel WHERE hotel_id='477'	0.00023913383483887
23	SELECT intro FROM default_hotel WHERE hotel_id='477'	0.00029802322387695
24	SELECT slug FROM default_hotel WHERE hotel_id='477'	0.0003359317779541
25	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/en/h477-little-riverside-hoi-an-a-luxury-hotel-spa.html'	0.0034260749816895
26	SELECT distinct image FROM default_hotel where hotel_id=477 LIMIT 0,1	0.0002751350402832
27	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.0025789737701416
28	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/h477-little-riverside-hoi-an-a-luxury-hotel-spa.html' or config_link='/en/h477-little-riverside-hoi-an-a-luxury-hotel-spa.html') limit 1	0.0034279823303223
29	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.0025529861450195
30	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.0023119449615479
31	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.0023488998413086
32	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='47'	0.00022006034851074
33	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.0023479461669922
34	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.0022621154785156
35	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.0023071765899658
36	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.0024011135101318
37	SELECT title FROM default_hotel WHERE hotel_id='477'	0.0002748966217041
38	SELECT intro FROM default_hotel WHERE hotel_id='477'	0.00023698806762695
39	SELECT content FROM default_hotel WHERE hotel_id='477'	0.00013494491577148
40	SELECT slug FROM default_country WHERE country_id=''	0.0002129077911377
41	SELECT image FROM default_hotel WHERE hotel_id='477'	0.00034499168395996
42	SELECT distinct wishlist_num FROM default_hotel where hotel_id=477 LIMIT 0,1	0.00026512145996094
43	SELECT address FROM default_hotel WHERE hotel_id='477'	0.00020503997802734
44	SELECT price_avg FROM default_hotel WHERE hotel_id='477'	0.00031685829162598
45	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00025081634521484
46	SELECT other_policy FROM default_hotel WHERE hotel_id='477'	0.00022697448730469
47	SELECT distinct title FROM default_property where property_id=992 LIMIT 0,1	0.00025701522827148
48	SELECT distinct title FROM default_property where property_id=985 LIMIT 0,1	0.00023698806762695
49	SELECT distinct title FROM default_property where property_id=984 LIMIT 0,1	0.0002598762512207
50	SELECT distinct title FROM default_property where property_id=982 LIMIT 0,1	0.00023603439331055
51	SELECT distinct title FROM default_property where property_id=980 LIMIT 0,1	0.00024914741516113
52	SELECT distinct title FROM default_property where property_id=978 LIMIT 0,1	0.00023794174194336
53	SELECT distinct title FROM default_property where property_id=977 LIMIT 0,1	0.00025796890258789
54	SELECT distinct title FROM default_property where property_id=849 LIMIT 0,1	0.00023794174194336
55	SELECT distinct title FROM default_property where property_id=865 LIMIT 0,1	0.00024914741516113
56	SELECT distinct title FROM default_property where property_id=929 LIMIT 0,1	0.00023603439331055
57	SELECT distinct title FROM default_property where property_id=1106 LIMIT 0,1	0.00028800964355469
58	SELECT distinct title FROM default_property where property_id=1107 LIMIT 0,1	0.00024986267089844
59	SELECT distinct title FROM default_property where property_id=1108 LIMIT 0,1	0.00023818016052246
60	SELECT distinct title FROM default_property where property_id=1111 LIMIT 0,1	0.00027680397033691
61	SELECT distinct title FROM default_property where property_id=1113 LIMIT 0,1	0.00023698806762695
62	SELECT distinct title FROM default_property where property_id=1114 LIMIT 0,1	0.00024986267089844
63	SELECT distinct title FROM default_property where property_id=1123 LIMIT 0,1	0.00023794174194336
64	SELECT distinct title FROM default_property where property_id=1126 LIMIT 0,1	0.00025701522827148
65	SELECT slug FROM default_hotel WHERE hotel_id='477'	0.00019979476928711
66	SELECT distinct country_id FROM default_hotel where hotel_id=477 LIMIT 0,1	0.0002601146697998
67	SELECT slug FROM default_country WHERE country_id='1'	0.00023794174194336
68	SELECT slug FROM default_hotel WHERE hotel_id='299'	0.00029516220092773
69	SELECT title FROM default_hotel WHERE hotel_id='299'	0.00035905838012695
70	SELECT image FROM default_hotel WHERE hotel_id='299'	0.0002901554107666
71	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='299' and price >0 order by price ASC	0.0012269020080566
72	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00025010108947754
73	SELECT address FROM default_hotel WHERE hotel_id='299'	0.00024199485778809
74	SELECT intro FROM default_hotel WHERE hotel_id='299'	0.00020694732666016
75	SELECT slug FROM default_hotel WHERE hotel_id='406'	0.00023293495178223
76	SELECT title FROM default_hotel WHERE hotel_id='406'	0.00029182434082031
77	SELECT image FROM default_hotel WHERE hotel_id='406'	0.00026297569274902
78	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='406' and price >0 order by price ASC	0.0012240409851074
79	SELECT address FROM default_hotel WHERE hotel_id='406'	0.00022602081298828
80	SELECT intro FROM default_hotel WHERE hotel_id='406'	0.00028300285339355
81	SELECT slug FROM default_hotel WHERE hotel_id='376'	0.00022792816162109
82	SELECT title FROM default_hotel WHERE hotel_id='376'	0.00029587745666504
83	SELECT image FROM default_hotel WHERE hotel_id='376'	0.00025200843811035
84	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='376' and price >0 order by price ASC	0.0010700225830078
85	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00025796890258789
86	SELECT address FROM default_hotel WHERE hotel_id='376'	0.00021100044250488
87	SELECT intro FROM default_hotel WHERE hotel_id='376'	0.00029301643371582
88	SELECT slug FROM default_hotel WHERE hotel_id='401'	0.00022196769714355
89	SELECT title FROM default_hotel WHERE hotel_id='401'	0.00027799606323242
90	SELECT image FROM default_hotel WHERE hotel_id='401'	0.00025606155395508
91	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='401' and price >0 order by price ASC	0.001072883605957
92	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00024294853210449
93	SELECT address FROM default_hotel WHERE hotel_id='401'	0.00022411346435547
94	SELECT intro FROM default_hotel WHERE hotel_id='401'	0.00027799606323242
95	SELECT slug FROM default_hotel WHERE hotel_id='316'	0.00030112266540527
96	SELECT title FROM default_hotel WHERE hotel_id='316'	0.00027990341186523
97	SELECT image FROM default_hotel WHERE hotel_id='316'	0.0002598762512207
98	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='316' and price >0 order by price ASC	0.0010600090026855
99	SELECT address FROM default_hotel WHERE hotel_id='316'	0.00023007392883301
100	SELECT intro FROM default_hotel WHERE hotel_id='316'	0.00028300285339355
101	SELECT slug FROM default_hotel WHERE hotel_id='297'	0.00020503997802734
102	SELECT title FROM default_hotel WHERE hotel_id='297'	0.00029397010803223
103	SELECT image FROM default_hotel WHERE hotel_id='297'	0.00025701522827148
104	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='297' and price >0 order by price ASC	0.0010640621185303
105	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00026607513427734
106	SELECT address FROM default_hotel WHERE hotel_id='297'	0.00029397010803223
107	SELECT intro FROM default_hotel WHERE hotel_id='297'	0.00026082992553711
108	SELECT slug FROM default_hotel WHERE hotel_id='317'	0.00030899047851562
109	SELECT title FROM default_hotel WHERE hotel_id='317'	0.00026416778564453
110	SELECT image FROM default_hotel WHERE hotel_id='317'	0.00023484230041504
111	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='317' and price >0 order by price ASC	0.0010159015655518
112	SELECT address FROM default_hotel WHERE hotel_id='317'	0.00028681755065918
113	SELECT intro FROM default_hotel WHERE hotel_id='317'	0.00025296211242676
114	SELECT slug FROM default_hotel WHERE hotel_id='347'	0.00029397010803223
115	SELECT title FROM default_hotel WHERE hotel_id='347'	0.0002589225769043
116	SELECT image FROM default_hotel WHERE hotel_id='347'	0.00023603439331055
117	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='347' and price >0 order by price ASC	0.0011041164398193
118	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00026893615722656
119	SELECT address FROM default_hotel WHERE hotel_id='347'	0.00020408630371094
120	SELECT intro FROM default_hotel WHERE hotel_id='347'	0.00027894973754883
121	SELECT slug FROM default_hotel WHERE hotel_id='298'	0.00025796890258789
122	SELECT title FROM default_hotel WHERE hotel_id='298'	0.00023603439331055
123	SELECT image FROM default_hotel WHERE hotel_id='298'	0.00020790100097656
124	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='298' and price >0 order by price ASC	0.0023407936096191
125	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00073885917663574
126	SELECT address FROM default_hotel WHERE hotel_id='298'	0.00028300285339355
127	SELECT intro FROM default_hotel WHERE hotel_id='298'	0.00028109550476074
128	SELECT slug FROM default_hotel WHERE hotel_id='363'	0.00024819374084473
129	SELECT title FROM default_hotel WHERE hotel_id='363'	0.00022792816162109
130	SELECT image FROM default_hotel WHERE hotel_id='363'	0.00028896331787109
131	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='363' and price >0 order by price ASC	0.001101016998291
132	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.00026512145996094
133	SELECT address FROM default_hotel WHERE hotel_id='363'	0.00023412704467773
134	SELECT intro FROM default_hotel WHERE hotel_id='363'	0.00030207633972168
135	SELECT testimonial_id,reg_date FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online=1 and image<>'' order by order_no asc limit 0,4	0.0026299953460693
136	SELECT title FROM default_testimonial WHERE testimonial_id='7'	0.00032186508178711
137	SELECT slug FROM default_testimonial WHERE testimonial_id='7'	0.00029206275939941
138	SELECT image FROM default_testimonial WHERE testimonial_id='7'	0.00024318695068359
139	SELECT intro FROM default_testimonial WHERE testimonial_id='7'	0.00021600723266602
140	SELECT name FROM default_testimonial WHERE testimonial_id='7'	0.00027990341186523
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00030183792114258
142	SELECT title FROM _country WHERE country_id='1'	0.00055503845214844
143	SELECT title FROM default_testimonial WHERE testimonial_id='12'	0.00022220611572266
144	SELECT slug FROM default_testimonial WHERE testimonial_id='12'	0.00027012825012207
145	SELECT image FROM default_testimonial WHERE testimonial_id='12'	0.00023698806762695
146	SELECT intro FROM default_testimonial WHERE testimonial_id='12'	0.0001990795135498
147	SELECT name FROM default_testimonial WHERE testimonial_id='12'	0.00027704238891602
148	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00022196769714355
149	SELECT title FROM _country WHERE country_id='1'	0.00025796890258789
150	SELECT title FROM default_testimonial WHERE testimonial_id='10'	0.0002131462097168
151	SELECT slug FROM default_testimonial WHERE testimonial_id='10'	0.00027298927307129
152	SELECT image FROM default_testimonial WHERE testimonial_id='10'	0.00021910667419434
153	SELECT intro FROM default_testimonial WHERE testimonial_id='10'	0.00030612945556641
154	SELECT name FROM default_testimonial WHERE testimonial_id='10'	0.00027012825012207
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00023198127746582
156	SELECT title FROM _country WHERE country_id='1'	0.00025081634521484
157	SELECT title FROM default_testimonial WHERE testimonial_id='5'	0.00022387504577637
158	SELECT slug FROM default_testimonial WHERE testimonial_id='5'	0.00026893615722656
159	SELECT image FROM default_testimonial WHERE testimonial_id='5'	0.0002291202545166
160	SELECT intro FROM default_testimonial WHERE testimonial_id='5'	0.00028395652770996
161	SELECT name FROM default_testimonial WHERE testimonial_id='5'	0.00029706954956055
162	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00024080276489258
163	SELECT title FROM _country WHERE country_id='1'	0.00017094612121582
164	SELECT why_id,title FROM default_why WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.002810001373291
165	SELECT why_id FROM default_why WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0023288726806641
166	SELECT distinct map_la FROM default_hotel where hotel_id=477 LIMIT 0,1	0.00029397010803223
167	SELECT distinct map_lo FROM default_hotel where hotel_id=477 LIMIT 0,1	0.00024795532226562

Little Riverside Hoi An . A Luxury Hotel & Spa

Need help? Call us at

Hotel booking policy

Hotel Facilities

Related hotels

VietISO Company

About isoCMS

Travel Styles

Other

Follow Us

Payment Channel