VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

CATA

Zatvori
SELECT t1.id, t1.primaran, t1.naziv, t1.mpcena, t1.ascase,t1.AdditionalProperty_1,t1.AdditionalProperty_2 FROM (SELECT a.id,a.primaran,a.naziv,a.mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM `artikli` a LEFT JOIN artikli a2 on a2.parent_id = a.id WHERE a.`id`!='0' AND a.parent_id IS NULL AND a.`category_id` IN (10024,-1002448,-1002440,-1002426,-1002425,-1002420,-1002415,-1002414,-1002413,-1002412,-1002411) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' OR (a.`id`!='0' AND a2.`category_id` IN (10024,-1002448,-1002440,-1002426,-1002425,-1002420,-1002415,-1002414,-1002413,-1002412,-1002411) AND a2.`novo`!='on' AND a2.`aktivan`='on' AND a2.`mpcena`!='0.00' AND a2.`prikaz_b2c`='on') UNION SELECT a.id,a.primaran,a.naziv,a.mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM `artikli` a WHERE a.`id`!='0' AND a.parent_id IS NULL AND a.`category_id` IN (10024,-1002448,-1002440,-1002426,-1002425,-1002420,-1002415,-1002414,-1002413,-1002412,-1002411) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' UNION SELECT a.id,a.primaran,a.naziv,MIN(a.mpcena) as mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM artikli a INNER JOIN artikli a2 ON a2.id = a.parent_id WHERE a.`id`!='0' AND a.parent_id IS NOT NULL AND a.`category_id` IN (10024,-1002448,-1002440,-1002426,-1002425,-1002420,-1002415,-1002414,-1002413,-1002412,-1002411) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' GROUP BY a.parent_id ) t1 ORDER BY CASE WHEN t1.AdditionalProperty_1 = 4 THEN 0 WHEN t1.AdditionalProperty_1 = 1 THEN 1 WHEN t1.AdditionalProperty_1 = 2 THEN 2 WHEN t1.AdditionalProperty_1 = 5 THEN 3 ELSE 4 END ASC, `id` DESC
CATA ploča TT 6004
Super ponuda
Šifra: 8063215

CATA ploča TT 6004

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Staklokeramika
25.990,00 RSD
CATA ploča IB 6303 E2 BK
Super ponuda
Šifra: 8063120

CATA ploča IB 6303 E2 BK

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Indukcija
27.990,00 RSD
CATA ploča IAS 6024
Super ponuda
Šifra: 8000206

CATA ploča IAS 6024

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Indukcija
114.990,00 RSD
CATA ploča IAS 7024
Super ponuda
Šifra: 8000200

CATA ploča IAS 7024

  • Crna |
  • 80cm |
  • Senzorsko |
  • Ne |
  • Indukcija
126.990,00 RSD
CATA mikrotalasna MC 20M BK
Super ponuda
Šifra: 7510313

CATA mikrotalasna MC 20M BK

  • Da |
  • 700W |
  • Ugradni |
  • Mehaničko |
  • 20l
26.990,00 RSD
CATA mikrotalasna MC 20D BK
Super ponuda
Šifra: 7510312

CATA mikrotalasna MC 20D BK

  • Da |
  • 700W |
  • Ugradni |
  • Mehaničko |
  • 20l
26.990,00 RSD
CATA rerna MDS 8007 FB
Super ponuda
Šifra: 7034606

CATA rerna MDS 8007 FB

  • Crna |
  • Aqua clean |
  • Mehaničko |
  • Multifunkcionalna |
  • 80l
41.990,00 RSD
CATA rerna MDS 8008 X AIR FRYER
Super ponuda
Šifra: 7001509

CATA rerna MDS 8008 X AIR FRYER

  • Inox |
  • Aqua clean |
  • Potapajući dugmići |
  • Multifunkcionalna |
  • 80l
45.990,00 RSD
CATA aspirator ARONA 60 BK
Super ponuda
Aspiratori - A
Šifra: 2186411

CATA aspirator ARONA 60 BK

  • Crna |
  • 60cm |
  • Da |
  • Ugradni |
  • Tasteri
37.990,00 RSD
CATA aspirator ARONA 60 X
Super ponuda
Aspiratori - A
Šifra: 2186311

CATA aspirator ARONA 60 X

  • Inox |
  • 60cm |
  • Da |
  • Ugradni |
  • Tasteri
37.990,00 RSD
CATA aspirator THALASSA EVO 900 GBK
Super ponuda
Šifra: 2139408

CATA aspirator THALASSA EVO 900 GBK

  • Crna |
  • 90cm |
  • Da |
  • Dekorativni |
  • Na dodir
60.990,00 RSD
CATA aspirator THALASSA PRO 900 GBK
Super ponuda
Šifra: 2139407

CATA aspirator THALASSA PRO 900 GBK

  • 842m3/h |
  • Dekorativni |
  • Na dodir |
  • Crna |
  • 90cm |
  • Da
54.990,00 RSD
CATA aspirator THALASSA EVO 600 GBK
Super ponuda
Šifra: 2136408

CATA aspirator THALASSA EVO 600 GBK

  • Crna |
  • 60cm |
  • Da |
  • Dekorativni |
  • Na dodir
56.990,00 RSD
CATA aspirator Isla Vega X
Super ponuda
Šifra: 2119311

CATA aspirator Isla Vega X

  • Inox |
  • 60cm |
  • Ne |
  • 850m3/h |
  • Ostrvski |
  • Tasteri
91.990,00 RSD
CATA aspirator ISLA FARO X
Super ponuda
Šifra: 2119101

CATA aspirator ISLA FARO X

  • Inox |
  • 40cm |
  • Ne |
  • Ostrvski |
  • Tasteri
75.990,00 RSD
CATA aspirator S PRO 6000 BK
Super ponuda
Aspiratori - A
Šifra: 2075415

CATA aspirator S PRO 6000 BK

33.990,00 RSD
CATA aspirator S PRO 6000 X
Super ponuda
Aspiratori - A
Šifra: 2075412

CATA aspirator S PRO 6000 X

  • Inox |
  • 60cm |
  • Ne |
  • Dekorativni |
  • Tasteri
33.990,00 RSD
CATA aspirator S PRO 9000 X
Super ponuda
Šifra: 2075410

CATA aspirator S PRO 9000 X

  • Inox |
  • 90cm |
  • Ne |
  • Dekorativni |
  • Tasteri
37.990,00 RSD
CATA aspirator SYGMA 6010 BK
Super ponuda
Aspiratori - A
Šifra: 2060400

CATA aspirator SYGMA 6010 BK

  • Crna |
  • 60cm |
  • Ne |
  • 802m3/h |
  • Dekorativni |
  • Tasteri
36.990,00 RSD
CATA aspirator GL 75 X
Super ponuda
Šifra: 2031302

CATA aspirator GL 75 X

  • Inox |
  • 90cm |
  • Ne |
  • 850m3/h |
  • Ugradni |
  • Na dodir
25.990,00 RSD
CATA aspirator GL 45 X
Super ponuda
Šifra: 2030305

CATA aspirator GL 45 X

  • Inox |
  • 60cm |
  • Ne |
  • 850m3/h |
  • Ugradni |
  • Na dodir
24.990,00 RSD
CATA aspirator THALASSA 900 GBK
Super ponuda
Šifra: 2139406

CATA aspirator THALASSA 900 GBK

  • Crna |
  • 90cm |
  • Ne |
  • 811m3/h |
  • Dekorativni |
  • Tasteri
48.990,00 RSD
CATA aspirator ISLA LEGEND 900 XGBK
Super ponuda
Šifra: 2097202

CATA aspirator ISLA LEGEND 900 XGBK

  • Inox |
  • 90cm |
  • Ne |
  • 820m3/h |
  • Ostrvski |
  • Na dodir
77.990,00 RSD
CATA aspirator TFB 5160 BK
Super ponuda
Šifra: 2034408

CATA aspirator TFB 5160 BK

11.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava