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
Bali
Cuba
Dubai
Malaezia
Maldive
Mexic
Republica Dominicana
Seychelles
Sri Lanka
Thailanda
KRABI
PATTAYA
PHI PHI ISLAND
PHUKET
Mauritius
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 = '164' order by pd.products_name
Afiseaza de la 1 la 6 (din 6 produse) Pagini de rezultate:  1 
Luna de miere Bangkok & Phuket
LUNA DE MIERE BANGKO...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 26.05.2018. TAXE INCLUSE! ...
Pret : 945.00EUR
Luna de miere in Bangkok & Phuket
LUNA DE MIERE IN BAN...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 04.05.2018. TAXE INCLUSE! ...
Pret : 1,100.00EUR
980.00EUR

Luna de miere in Phuket si Krabi
LUNA DE MIERE IN PHU...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 05.07.2018. TAXE INCLUSE! ...
Pret : 1,030.00EUR
Oferta de Paste in Phuket
OFERTA DE PASTE IN P...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 05.04.2018. TAXE INCLUSE! ...
Pret : 1,120.00EUR
1,020.00EUR

Sejur combinat Thailanda
SEJUR COMBINAT THAIL...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 22.11.2018. TAXE INCLUSE! ...
Pret : 1,055.00EUR
Super oferta luna de miere Phuket
SUPER OFERTA LUNA DE...
SEJUR CU AVIONUL. PLECARE DIN CLUJ PE 30.04.2018. TAXE INCLUSE!  ...
Pret : 880.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