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
RIVIERA MAYA
Hoteluri
Oferte
Republica Dominicana
Seychelles
Sri Lanka
Thailanda
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 = '194' order by pd.products_name
Afiseaza de la 1 la 5 (din 5 produse) Pagini de rezultate:  1 
Early booking luna de miere in Mexic
EARLY BOOKING LUNA D...
SEJUR CU AVIONUL. PLECARE DIN MADRID IN MAI - OCTOMBRIE. TAXE INCLUSE!...
Pret : 1,050.00EUR
Last minute luna de miere in Mexic
LAST MINUTE LUNA DE ...
SEJUR CU AVIONUL. PLECARE DIN MADRID IN APRILIE-MAI 2018.TAXE INCLUSE!...
Pret : 990.00EUR
890.00EUR

Oferta luna de miere in Mexic
OFERTA LUNA DE MIERE...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 28.08.2018. TAXE INCLUSE. ...
Pret : 1,120.00EUR
Oferta luna de miere Mexic
OFERTA LUNA DE MIERE...
SEJUR CU AVIONUL. PLECARE DIN BUCURESTI PE 22.11.2018.TAXE INCLUSE! ...
Pret : 1,000.00EUR

Sejur Paste Mexic
SEJUR PASTE MEXIC
SEJUR CU AVIONUL IN PERIOADA DE PASTE. PLECARE DIN MADRID IN 06 APRILI...
Pret : 1,230.00EUR

Afiseaza de la 1 la 5 (din 5 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