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-03-26',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-03-26' and '2027-05-26' 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 = 274 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-03-26',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-03-26' and '2027-05-26' 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 = 274 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

PETRA RESORT SE SASTOJI IZ DVA OBJEKTA:

  1. VILA PETRA
  2. BRVNARA PETRA

Vila Petra se nalazi u najstrožijem centru Banje Vrujci. Pozicionirana je između privatnog spa centra “Prva Nova Banja” i kompleksa državnih bazena hotela “Vrujci”.

U neposrednoj blizini vile Petre se nalazi dom zdravlja sa specijalizovanim ordinacijama za masažu i fizikalnu terapiju uz lekovito blato.

U okruženju se nalazi i nekoliko privatnih ordinacija. U krugu od 300 metara postoji više restorana nacionalne kuhinje sa izuzetno pristupačnim cenama i pansionskim uslugama. Vila je okružena zelenilom. Svi sadržaji u vili su namenjeni isključivo gostima vile Petre kako bi gosti mogli da uživaju u miru i privatnosti.

Vila PETRA Poseduje:

3 bazena sa lekovitom, toplom vodom.
Spa program: sauna i masaže.
Igraonicu
Kafe bar
Parking
Smestajne jedinice:
Sobe – jednokrevetne
          – dvokrevetne
          – trokrevetne
          – četvorokrevetne
Studio
Panorama apartman

 

Brvnara PETRA poseduje:

Jedan bazen sa lekovitom,  toplom vodom.
Letnjikovac za ručavanje u bašti.
Roštilje
Smeštajne jedinice:
3 standardna apartmana / 4 osobe /
1 veliki apartman / 6 osoba /
Postoji mogućnost najma celokupne brvnare. Kapacitet 18 osoba!

Грешка Вордпресове базе података: [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-03-26',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-03-26' and '2025-03-26' 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 = 274 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-03-26',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-03-26' and '2025-03-26' 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 = 274 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr