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

Se nalaze u mirnom delu Banje Vrujci, u  blizini Prve nove banje odnosno kompleksa novih bazena.

Od apartmana do ovog kompleksa I centra banje se dolazi lepo uredjenom pešačkom stazom uz reku Toplicu. U neposrednoj blizini se nalazi posta, crkva I prodavnice za snabdevanje.

Do  prelepog i moderno opremljenog kompleksa Premijer bazena ima oko cetristo metara, odnosno 8 minuta laganog hoda, a do centra banje oko 700 metara. Apartmani su napravljeni I opremljeni u modernom stilu strogo vodeći računa o potrebama gostiju. Svi apartmani su klimatizovani, opremljeni komarnicima I svaki apartman poseduje parking mesto u okviru dvorišta koje je uređeno I ukrašeno travnjakom I cvetnim alpinetumima. Objekat poseduje i novoizgrađeni letnjikovac sa roštiljem i svom pratećom opremom za sladokusce dobre hrane i gurmane a u dvorištu je i prelepa fontana koja je pozicionirana tako da se na nju pruža pogled sa svih apartmanskih terasa

APARTMANI KOMAZEC PRIMAJU VAUČERE MINISTARTSVA TURIZMA REPUBLIKE SRBIJE

Apartmani su kategorisani sa tri i četiri zvezdice i boravišna taksa se plaća po cenovniku turističke organizacije Mionica.

Apartman 1 je veliki porodični app kategorisan sa 4 zvezdice, opremljen u modernom stilu sa dve odvojene sobe. U jednoj spavaćoj sobi se nalazi veliki bračni ležaj, a u drugoj sobi dva odvojena ležaja koja se mogu i sastaviti po potrebi.U prostoru trpezarijsko-dnevnog boravka se takođe nalazi trosed sa mogućnošću razvlacenja, TV sa kablovskim signalom, trpezarijski sto i stolice i kompletno opremljena kuhinja.

Apartman poseduje i potpuno novo kupatilo sa kadom i veliku, natkrivenu, komfornu terasu sa pogledom na lepo uredjeno dvoriste, sa baštenskim stolicama i stolom koji moze poslužiti i za ručavanje. Klimatizovan je i poseduje parking mesto u sklopu dvorista.

Apartman 2 je trokrevetni I sastoji se iz dva dela koji su vizuelno odvojeni jedan od drugog.  U trpezarijsko dnevnom boravku se nalazi jedan ležaj i potpuno opremljena kuhinja. Kupatilo u sredini apartmana, vizuelno potpuno odvaja prostor u kome se nalazi veliki bracni lezaj sa velikim garderobnim delom i TV sa kablovskim signalom.Apartman je klimatizovan, poseduje parking mesto i veliku, prostranu, natkrivenu terasu, sa pogledom na lepo uredjeno dvoriste. Terasa je opremljena sa baštenskim stolicama i stolom pogodnim i za rucavanje.

Apartman 3 je smesten u prizemlju objekta I sastoji se iz dve prostorije. U prvom delu se nalazi veliki bracni lezaj sa garderobnim ormarom a u drugom delu koji je potpuno odvojen nalazi se trpezarijsko-kuhinjski prostor i krevet za jednu osobu. Apartman je klimatizovan sa potpuno opremljenom kuhinjom, kupatilom, kablovskom i terasom sa pogledom na uredjeno dvorište.

Apartman 4 je četvorokrevetni apartman studijskog tipa – renoviran, kompletno opremljena kuhinja sa trpezariskim stolom za sedenje, kupatilo. U sklopu apartmana su trosed na razvlačenje i još jedan ležaj za jednu osobu, a u trpezariskom delu je dvosed na razvlačenje. Apartman ima nadkrivenu terasu sa baštenskom garniturom za sedenje i pogledom na baštu sa puno cveća. Apartman ima TV sa kablovskim signalom.

Apartman 5 je studijskog tipa. Nalazi se u prizemnom delu objekta. Poseduje veliki bračni ležaj, sopstveno kupatilo i potpuno opremljenu kuhinju, trpezarijski sto i stolice. Apartman je klimatizovan, ima kablovski TV signal, opremljen je modernom rasvetom koja mu daje posebnu draž,  poseduje parking mesto i natkrivenu terasu sa bastenskim stolicama i stolom. Terasa je u nivou sa lepo uredjenim dvoristem sa puno cveća tako da se svaki gost oseća, zaista prijatno i opušteno.

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