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
Excursii optionale
Hoteluri
Oferte
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 = '191' order by pd.products_name
Afiseaza de la 1 la 8 (din 16 produse) Pagini de rezultate:  1  2  [Inainte >>] 
BARCELO PUNTA CANA 4*
BARCELO PUNTA CANA 4...
Localizare:pe plaja, in frumoasa zona Playa Arena Gorda Hotelul: 6 res...
Pret : 0.00EUR
BAVARO PRINCESS ALL SUITES RESORT SPA&CASINO 5*
BAVARO PRINCESS ALL ...
 Descriere:este  situat  la 25 minute de aeroport  ...
Pret : 0.00EUR

Catalonia Bavaro Beach, Golf & Spa 5*
CATALONIA BAVARO BEA...
Descriere hotel: Resortul Catalonia este situat langa ocean pe faimoas...
Pret : 0.00EUR
Catalonia Royal Bavaro 5*
CATALONIA ROYAL BAVA...
Localizare: resortul all inclusive destinat exclusiv adultilor (nu per...
Pret : 1,150.00EUR

EXCELLENCE PUNTA CANA 5*
EXCELLENCE PUNTA CAN...
Localizare: pe coasta de est a Republicii Dominicane, la Uverto Alto...
Pret : 0.00EUR
Gran Bahia Principe Ambar Don Pablo Collection 5*
GRAN BAHIA PRINCIPE ...
Localizare: resortul premium al renumitului lant hotelier Bahia Princi...
Pret : 0.00EUR

GRAND BAHIA PRINCIPE BAVARO/ PUNTA CANA 5*
GRAND BAHIA PRINCIPE...
Localizare: Atragatorul resort al lantului hotelier Bahia Principe est...
Pret : 0.00EUR
Grand Palladium Palace Resort Spa & Casino 5*
GRAND PALLADIUM PALA...
Localizare: hotelul ce face parte din binecunoscutul grup Fiesta este ...
Pret : 0.00EUR


Afiseaza de la 1 la 8 (din 16 produse) Pagini de rezultate:  1  2  [Inainte >>] 



© 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