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-10-27',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-10-27' and '2028-12-27' 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 = 2463 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-10-27',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-10-27' and '2028-12-27' 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 = 2463 AND IFNULL(bookings.woo_status, '') IN ('completed') GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

Nestled amidst the scenic beauty of Mussoorie, AB's Abode offers a perfect blend of modern comfort and rustic charm. This boutique hotel promises an intimate and cozy stay with thoughtfully designed rooms, each with breathtaking views of the lush valley or misty mountains. Guests are welcomed with warm hospitality and can enjoy curated experiences such as outdoor dining, scenic trails, and personalized service that truly captures the essence of Mussoorie. Whether for a weekend getaway or a peaceful retreat, AB's Abode ensures a memorable stay in the heart of the Himalayas.

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-10-27',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-10-27' and '2026-10-27' 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 = 2463 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-10-27',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-10-27' and '2026-10-27' 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 = 2463 AND IFNULL(bookings.woo_status, '') IN ('completed') GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr