#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select hotel.id_tara from hotel
						join hotel_preturi on hotel_preturi.id_hotel = hotel.id
						inner join tara t ON t.id = hotel.id_tara
						where hotel.activ = 1
						and hotel_preturi.activ = 1
						and hotel_preturi.data_sfarsit > now()
						and hotel.public = 1
						and t.public =1 and t.activ = 1
						group by hotel.id_tara
						) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select hotel.id_tara from hotel
						join hotel_preturi on hotel_preturi.id_hotel = hotel.id
						inner join tara t ON t.id = hotel.id_tara
						where hotel.activ = 1
						and hotel_preturi.activ = 1
						and hotel_preturi.data_sfarsit > now()
						and hotel.public = 1
						and t.public =1 and t.activ = 1
						group by hotel.id_tara
						) called at [/home/pradu/public_html/beta/core/main.php:130]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select * from tara where id in () order by nume asc) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select * from tara where id in () order by nume asc) called at [/home/pradu/public_html/beta/core/main.php:138]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '15349' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '15349' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:47]
#3  lista::getElement(hotel, 15349) called at [/home/pradu/public_html/beta/core/functii/hotel.php:16]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(SELECT * FROM `imagini` WHERE `cale`!='' AND `activ`=1 AND `public`=1 AND `tabela`='hotel' AND `id_extern`='15349' GROUP BY cale ORDER BY id ASC) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(SELECT * FROM `imagini` WHERE `cale`!='' AND `activ`=1 AND `public`=1 AND `tabela`='hotel' AND `id_extern`='15349' GROUP BY cale ORDER BY id ASC) called at [/home/pradu/public_html/beta/core/clase/class/hotel.php:23]
#3  hotel->moreInfo() called at [/home/pradu/public_html/beta/core/functii/hotel.php:19]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(SELECT * FROM `hotel_preturi` WHERE `activ`=1 AND `id_hotel`='15349' ORDER BY `id`) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(SELECT * FROM `hotel_preturi` WHERE `activ`=1 AND `id_hotel`='15349' ORDER BY `id`) called at [/home/pradu/public_html/beta/core/clase/class/hotel.php:33]
#3  hotel->moreInfo() called at [/home/pradu/public_html/beta/core/functii/hotel.php:19]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'statiune' and id_extern = '1888' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'statiune' and id_extern = '1888' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:47]
#3  lista::getElement(statiune, 1888) called at [/home/pradu/public_html/beta/core/functii/hotel.php:25]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'regiune' and id_extern = '184' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'regiune' and id_extern = '184' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:47]
#3  lista::getElement(regiune, 184) called at [/home/pradu/public_html/beta/core/functii/hotel.php:29]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'tara' and id_extern = '7' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'tara' and id_extern = '7' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:47]
#3  lista::getElement(tara, 7) called at [/home/pradu/public_html/beta/core/functii/hotel.php:31]
#4  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#5  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '15196' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '15196' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:28]
#3  lista::getElemente(hotel, 18833,15196, 1) called at [/home/pradu/public_html/beta/core/clase/class/recomandari.class.php:23]
#4  recomandari::recomandari_hoteluri(1888, 15349, 184) called at [/home/pradu/public_html/beta/core/functii/hotel.php:33]
#5  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#6  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
#0  db_rez->__construct() called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:106]
#1  db::query(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '18833' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/db.php:161]
#2  db::obj_array(select cale from imagini where public = 1 and activ = 1 and tabela = 'hotel' and id_extern = '18833' GROUP BY cale ORDER BY id) called at [/home/pradu/public_html/beta/core/clase/abstract/lista.class.php:28]
#3  lista::getElemente(hotel, 18833,15196, 1) called at [/home/pradu/public_html/beta/core/clase/class/recomandari.class.php:23]
#4  recomandari::recomandari_hoteluri(1888, 15349, 184) called at [/home/pradu/public_html/beta/core/functii/hotel.php:33]
#5  hotel(15349) called at [/home/pradu/public_html/beta/core/main.php(222) : eval()'d code:1]
#6  eval() called at [/home/pradu/public_html/beta/core/main.php:222]
Hotel Katerina 3*, Olympic Beach, Riviera Olimpului (pieria), Grecia - Across.ro
  Home home page  Contact us contact us  
Tel: 0232 263373, 0332 401008
Adresa: Sf Teodor, 16
IASI, 700115, ROMANIA
promotii, early booking, last minute
NEWSLETTER: selectia noastra de oferte
 
bilete avion ymessenger
bilete avion ymessenger
turism ymessenger

Cauta sejur

Data
Numar nopti
Adulti:
Copii:
  


descarcare oferte

  • Early Booking


H15349



Informatii hotel

Hotelul este situat in centrul statiunii Olympic Beach la 80 m de plaja. Toate camerele sunt dotate cu 2 si 3 paturi, grup sanitar propriu cu dus, frigider, TV, instalatie de aer conditionat (optional – 5 euro/camera/zi). Hotelul dispune de salon restaurant, terasa. Hotelul dispune si de 7 apartamente cu 2 camere de cate 2 paturi.


Termeni: Riviera Olimpului (pieria) - Grecia, Olympic Beach - Hotel Katerina 3*




Recomandari

  • Pantheon
  • Pantheon
    Este situat la 5 m distanta de plaja.
    Hotelul dispune de : 16 camere...
  • Vila Irida
  • Vila Irida

    Situat la 4 minute de plaja, vila a fost construita in anul 2009 si...