24/7 Support number info@banjavrujci.org.rs

Грешка Вордпресове базе података: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
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 wp_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2023-01-30',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 '2023-01-30' and '2027-03-30' 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 = 227 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 wp_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2023-01-30',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 '2023-01-30' and '2027-03-30' 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 = 227 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

APARTMANI – SOBE NIKOLIC nalaze se u Banji Vrujci preko puta doma VODA VODA, u neposrednoj bizini PRVE NOVE BANJE.

Posedujemo pet apartmana za izdavanje. Dva apartmana su trokrevetnog tipa crveni I zeleni , dva apartmana su cetvorokrevetnog tipa zuti I pink, a apartman broj 5 I najveci poseduje tri sobe, kuhinju, wc (posebno) , kupatilo (posebno), dve terase. Pogodan je za dve porodice ili vece drustvo, a moze se izdavati I kao pojedinacne sobe( po dogovoru ).

Svaki apartman poseduje zasebnu kuhinju, kupatilo, KATV, klima uredjaj, I terasu. Kuhinja je opremljena friziderom, sporetom I svim neophodnim inventarom. Terase su sa pogledom na banju I prelepo uredjeno dvoriste. Za svakog gosta obezbedjen je I parking prostor. Pored gradskog vodovoda posedujemo I sopstvenu vodu. U samoj blizini su setaliste, skola, posta I prelepo zdanje crkve.

ZA SVE GOSTE OBEZBEĐEN JE BESPLATAN WiFi INTERNET U SVIM APARTMANIMA

APARTMANI NIKOLIĆ PRIMAJU VAUČERE MINISTARSTVA TURIZMA 

APARTMAN  1. Trokrevetni – crveni – prizemlje

APARTMAN  2. Četvorokrevetni – zuti – prizemlje

APARTMAN  3. Trokrevetni – zeleni – sprat

APARTMAN  4. Cetvorokrevetni – pink – sprat

APARTMAN  5. Veliki apartman – poseduje tri sobe, pogodan za dve porodice ili vece drustvo, a moze se izdavati I kao pojedinacno sobe – sprat

Грешка Вордпресове базе података: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT IFNULL(MIN(price_per_day), 0) 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 wp_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2023-01-30',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 '2023-01-30' and '2025-01-30' 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 = 227 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 wp_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2023-01-30',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 '2023-01-30' and '2025-01-30' 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 = 227 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr