VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

CATA - Aspiratori

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 (-1002414) 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 (-1002414) 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 (-1002414) 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 (-1002414) 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 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

  • Crna |
  • 90cm |
  • Da |
  • 842m3/h |
  • Dekorativni |
  • Na dodir
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
CATA aspirator JUNO+ 6000 GBK
Super ponuda
Šifra: 2027701

CATA aspirator JUNO+ 6000 GBK

  • Crna |
  • 60cm |
  • Ne |
  • Dekorativni |
  • Na dodir
31.990,00 RSD
CATA aspirator EXTENDER 600
Super ponuda
Aspiratori - C
Šifra: 2017606

CATA aspirator EXTENDER 600

14.990,00 RSD
CATA aspirator ARMONIA 60 BK
Super ponuda
Aspiratori - C
Šifra: 2186409

CATA aspirator ARMONIA 60 BK

  • Crna |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Ugradni |
  • Tasteri
31.990,00 RSD
CATA aspirator ARMONIA 60 X
Super ponuda
Aspiratori - C
Šifra: 2186309

CATA aspirator ARMONIA 60 X

  • Inox |
  • 60cm |
  • Ne |
  • 850m3/h |
  • Ugradni |
  • Tasteri
31.990,00 RSD
CATA aspirator THALASSA 600 GBK
Super ponuda
Aspiratori - A+
Šifra: 2136406

CATA aspirator THALASSA 600 GBK

  • Crna |
  • 60cm |
  • Ne |
  • 811m3/h |
  • Dekorativni |
  • Na dodir
45.990,00 RSD
CATA aspirator SYGMA 6010 X
Super ponuda
Aspiratori - A
Šifra: 2060310

CATA aspirator SYGMA 6010 X

  • Inox |
  • 60cm |
  • Ne |
  • Dekorativni |
  • Tasteri
36.990,00 RSD
CATA aspirator TFB 5160 X
Super ponuda
Aspiratori - B
Šifra: 2034606

CATA aspirator TFB 5160 X

  • Inox |
  • 60cm |
  • Ne |
  • 300m3/h |
  • Teleskopski |
  • Tasteri
11.990,00 RSD
CATA aspirator GT-PLUS 45 X
Super ponuda
Aspiratori - C
Šifra: 2030309

CATA aspirator GT-PLUS 45 X

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