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 ARMONIA 60 BK
Izdvajamo
Aspiratori - C
Šifra: 2186409

CATA aspirator ARMONIA 60 BK

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

CATA aspirator ARMONIA 60 X

  • Inox |
  • 60cm |
  • Ne |
  • 850m3/h |
  • Ugradni |
  • Tasteri
27.990,00 RSD
CATA aspirator CORONA 60 X
Izdvajamo
Aspiratori - A
Šifra: 2186308

CATA aspirator CORONA 60 X

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

CATA aspirator THALASSA 600 GBK

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

CATA aspirator SYGMA 6010 X

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

CATA aspirator TFB 5160 X

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

CATA aspirator GT-PLUS 45 X

  • Inox |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Ugradni |
  • Tasteri
15.990,00 RSD
CATA aspirator GCX 53 SD
Izdvajamo
Aspiratori - A
Šifra: 2030308

CATA aspirator GCX 53 SD

  • Inox |
  • 60cm |
  • Ne |
  • 750m3/h |
  • Ugradni |
  • Na dodir
28.990,00 RSD
CATA aspirator TF-2003 600 GBK
Izdvajamo
Aspiratori - C
Šifra: 2017203

CATA aspirator TF-2003 600 GBK

  • Crna |
  • 60cm |
  • Ne |
  • 390m3/h |
  • Teleskopski |
  • Tasteri
12.990,00 RSD
CATA aspirator TFH 6830 X
Izdvajamo
Aspiratori - A+++
Šifra: 2010601

CATA aspirator TFH 6830 X

  • Inox |
  • 60cm |
  • Ne |
  • 795m3/h |
  • Teleskopski |
  • Na dodir
27.990,00 RSD
CATA aspirator TFH 6630 BK
Izdvajamo
Aspiratori - A+
Šifra: 2010302

CATA aspirator TFH 6630 BK

  • Crna |
  • 60cm |
  • Ne |
  • Teleskopski |
  • Na dodir
21.990,00 RSD
CATA aspirator OMEGA 600 BK
Izdvajamo
Aspiratori - C
Šifra: 2002410

CATA aspirator OMEGA 600 BK

  • Crna |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Dekorativni |
  • Tasteri
15.990,00 RSD
CATA aspirator OMEGA 600 X
Izdvajamo
Aspiratori - C
Šifra: 2002310

CATA aspirator OMEGA 600 X

  • Inox |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Dekorativni |
  • Tasteri
15.990,00 RSD
CATA aspirator CORONA 60 BK
Izdvajamo
Aspiratori - A
Šifra: 2186400

CATA aspirator CORONA 60 BK

  • Crna |
  • 60cm |
  • Ne |
  • 850m3/h |
  • Ugradni |
  • Tasteri
46.990,00 RSD
CATA aspirator GC DUAL 45 BK
Izdvajamo
Aspiratori - A
Šifra: 2130208

CATA aspirator GC DUAL 45 BK

  • Crna |
  • 60cm |
  • Ne |
  • 820m3/h |
  • Ugradni |
  • Na dodir
36.990,00 RSD
CATA aspirator LENA 600 XGBK
Izdvajamo
Aspiratori - A
Šifra: 2032205

CATA aspirator LENA 600 XGBK

17.990,00 RSD
CATA aspirator GT-PLUS 45 BK
Izdvajamo
Aspiratori - C
Šifra: 2030408

CATA aspirator GT-PLUS 45 BK

  • Crna |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Ugradni |
  • Tasteri
15.990,00 RSD
CATA aspirator TF-2003 DURALUM 600
Izdvajamo
Aspiratori - C
Šifra: 2017305

CATA aspirator TF-2003 DURALUM 600

  • 390m3/h |
  • Teleskopski |
  • Tasteri |
  • Inox |
  • 60cm |
  • Ne
12.990,00 RSD
CATA aspirator TFH 6630 X
Izdvajamo
Aspiratori - A+
Šifra: 2010300

CATA aspirator TFH 6630 X

  • Inox |
  • 60cm |
  • Ne |
  • 605m3/h |
  • Teleskopski |
  • Na dodir
21.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava