ika turism.::.agentie turism, excursii, vacanta, vacante in strainatate, litoral, munte, oferte la mare, circuite, oferte cazare , cazare
 
PRIMA PAGINA
INFO VIZE
LUNA DE MIERE
GUEST BOOK
GALERIE FOTO
CONTACT
 
 
 
 
 
select m.manufacturers_name, p.products_image, pd.products_name, p.products_id, p.manufacturers_id,pd.products_description, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd INNER JOIN products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p2c.categories_id = '173' order by pd.products_name
Afiseaza de la 1 la 6 (din 6 produse) Pagini de rezultate:  1 
Aruba
ARUBA
Din 01 octombrie 2006, cetatenii romani nu au nevoie de viza turistica...
Pret : 0.00EUR
Bali
BALI
Cetatenii romani care calatoresc in Indonezia, Bali, au nevoie de viza...
Pret : 0.00EUR

Cuba
CUBA
Cetatenii romani care calatoresc in scop turistic in Cuba au nevoie de...
Pret : 0.00EUR
Mauritius
MAURITIUS
Cetatenii romani pot calatori fara viza in Mauritius, pentru o perioad...
Pret : 0.00EUR

Mexic
MEXIC
Incepand cu data de 11 martie 2007, cetatenii romani detinatori de pas...
Pret : 0.00EUR
Rep. Dominicana
REP. DOMINICANA
Incepand cu 1 ianuarie 2008, cetatenii romani nu mai au nevoie de viza...
Pret : 0.00EUR


Afiseaza de la 1 la 6 (din 6 produse) Pagini de rezultate:  1 



© 2009-2013 IkaTurism.
Toate drepturile rezervate

Web design: Dezibel Media
Web Hosting: Web Hotel

IKA TURISM

Str. Dionisie Lupu nr. 61, parter, ap.1, Bucuresti, sector 1
Tel/ fax: 021 317 72 10
Mobil: 0755 276 124
E-mail: info@ikaturism.ro, ikatravel@yahoo.com


 
 PROPUNERILE NOASTRE
 
Luna de miere Singapore si Bali
LUNA DE MIERE SINGAPORE SI BALI
+detalii
Luna de miere Dubai & Seychelles
LUNA DE MIERE DUBAI & SEYCHELLES
+detalii
Oferta luna de miere in Krabi
OFERTA LUNA DE MIERE IN KRABI
+detalii
Luna de miere in Varadero
LUNA DE MIERE IN VARADERO
+detalii
Luna de miere in Krabi
LUNA DE MIERE IN KRABI
+detalii
Oferta Phuket si Phi Phi Island
OFERTA PHUKET SI PHI PHI ISLAND
+detalii
Luna de miere in Bangkok & Phuket
LUNA DE MIERE IN BANGKOK & PHUKET
+detalii
Last minute luna de miere Republica Dominicana
LAST MINUTE LUNA DE MIERE REPUBLICA DOMINICANA
+detalii
Oferta luna de miere in Bali
OFERTA LUNA DE MIERE IN BALI
+detalii
Last minute luna de miere in Mexic
LAST MINUTE LUNA DE MIERE IN MEXIC
+detalii
 
Protectia consumatorilor