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 = 7845 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 = 7845 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

Apartmani Alfa Banja Vrujci rade izdavanje apartmana u Banji Vrujci. Kontaktirajte nas za cene smeštaja u apartmanima.
Banja Vrujci apartmani Alfa za iznajmljivanje u pondi smeštaja imaju četvorokrevetne apartmane. Svi apartmani su novi i prostrani i moderno opremljeni.

Sačinjavaju ih dve sobe, kuhinja, trpezarija, kupatilo i terasa. Kuhinja je potpuno opremljena sa neophodnim elementima. Apartmani imaju televiziju sa kablovskim signalom i wi-fi internet.

Ukoliko koristite vaučere za smeštaj u Banji Vrujci, primamo ih i kod nas možete koristiti VAUČERE Ministarstva Srbije za turizam.

Apartmani imaju grejanje tako da se izdaju i tokom zime. Svi apartmani se nalaze u prizemlju.

Parking je obezbeđen, svaki apartman ima interfon. Vode ima stalno.

Udaljeni su šesto metara od doma zdravlja i česme. Nalazimo se u ravnom delu banje Vrujci pogodnom za šetnje.

  • 063 77 55 900, 063 203 484, 065 97 55 900
  • E-mail: ljilja.krajcinovic@gmail.com

Apartman 1

Apartman 2

Apartman 3

Apartman 4

 

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