24/7 Support number +91 9368 776 756

WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_accommodation_vacancies' doesn't exist]
SELECT IFNULL(MIN(the_date), 0) min_date FROM ( SELECT DISTINCT (avc.number_of_available_rooms - IFNULL(bc.number_of_booked_rooms, 0)) available_rooms, avc.the_date, IFNULL(avc.price_per_day, 0) price_per_day FROM ( SELECT SUM(room_count) number_of_available_rooms, possible_dates.the_date, MIN(price_per_day) price_per_day FROM wp3t_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2024-04-17',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-04-17' and '2028-06-17' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date > DATE(availabilities.start_date) AND possible_dates.the_date <= DATE(availabilities.end_date) WHERE availabilities.accommodation_id = 2036 GROUP BY possible_dates.the_date ) as avc LEFT JOIN ( SELECT SUM(bookings.room_count) number_of_booked_rooms, possible_dates.the_date booking_date FROM wp3t_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2024-04-17',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-04-17' and '2028-06-17' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date <= DATE(bookings.date_to) WHERE bookings.accommodation_id = 2036 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

  • 3 Star hotels in Rishikesh

3 Star hotels in Rishikesh

Welcome to Hotel Aqua Vibes (3 Star hotels in Rishikesh), where luxury meets tranquility in the heart of Rishikesh. As one of the best 3 star hotels in this enchanting city, we pride ourselves on providing an unforgettable experience for our guests.

At Hotel Aqua Vibes, we understand that every traveler seeks a unique and memorable stay. Our commitment to excellence is reflected in our impeccable service and attention to detail. From the moment you step into our elegant lobby, you will be greeted with warm hospitality and a sense of serenity that sets us apart.

Situated amidst the breathtaking landscapes of Rishikesh, our hotel offers a perfect blend of comfort and convenience. Whether you are here for business or leisure, we have thoughtfully designed rooms and suites that cater to your every need. Each room is tastefully furnished with modern amenities to ensure a comfortable stay.

Beyond the walls of our hotel lies a world waiting to be explored. Rishikesh is renowned for its spiritual significance and natural beauty, making it an ideal destination for sightseeing enthusiasts. From the iconic Laxman Jhula bridge to the sacred Triveni Ghat, there are countless attractions just moments away from Hotel Aqua Vibes.

Our knowledgeable staff is always ready to assist you in planning your sightseeing adventures. Whether it’s visiting ancient temples or embarking on thrilling outdoor activities like white water rafting or trekking, we will ensure that your time spent exploring Rishikesh is truly remarkable.

After a day of sightseeing or adventure, retreat back to Hotel Aqua Vibes where you can relax and rejuvenate at our spa facilities or take a refreshing dip in our swimming pool overlooking the majestic mountains.

Experience the magic of Rishikesh at Hotel Aqua Vibes – where comfort meets nature’s beauty. Book your stay with us today and let us create memories that will last a lifetime.

WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_accommodation_vacancies' doesn't exist]
SELECT price_per_day min_price FROM ( SELECT DISTINCT (avc.number_of_available_rooms - IFNULL(bc.number_of_booked_rooms, 0)) available_rooms, avc.the_date, IFNULL(avc.price_per_day, 0) price_per_day FROM ( SELECT SUM(room_count) number_of_available_rooms, possible_dates.the_date, MIN(price_per_day) price_per_day FROM wp3t_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2024-04-17',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-04-17' and '2026-04-17' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date > DATE(availabilities.start_date) AND possible_dates.the_date <= DATE(availabilities.end_date) WHERE availabilities.accommodation_id = 2036 GROUP BY possible_dates.the_date ) as avc LEFT JOIN ( SELECT SUM(bookings.room_count) number_of_booked_rooms, possible_dates.the_date booking_date FROM wp3t_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2024-04-17',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-04-17' and '2026-04-17' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date <= DATE(bookings.date_to) WHERE bookings.accommodation_id = 2036 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr