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 = '193' order by pd.products_name
Afiseaza de la 1 la 5 (din 5 produse) Pagini de rezultate:  1 
Barcelo Maya Beach & Caribe Beach 5*
BARCELO MAYA BEACH &...
Localizare: hotelul este situat in prima linie a plajei de 2 km, la 95...
Pret : 0.00EUR
Catalonia Royal Tulum 5*
CATALONIA ROYAL TULU...
Localizare: Resortul de 5* all inclusive destinat numai adultilor (nu ...
Pret : 0.00EUR

Grand Palladium Resort & Spa 5*
GRAND PALLADIUM RESO...
Localizare: Acest complex ecologic de lux este construit pe un teren d...
Pret : 0.00EUR
Grand Riviera Princess 5*
GRAND RIVIERA PRINCE...
Localizare: Acest hotel este situat in paradisiaca Riviera Maya, la do...
Pret : 0.00EUR

Hotel Occidental Allegro Playacar 4*
HOTEL OCCIDENTAL ALL...
Localizare: complex hotelier construit în stil polinez, alactuit...
Pret : 0.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