VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

BSH KUĆNI APARATI - Sudomašine

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 (-1002313) 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 (-1002313) 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 (-1002313) 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 (-1002313) 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
BOSCH sudomašina SMV25EX02E
Super ponuda
Sudomašine - E
Šifra: SMV25EX02E

BOSCH sudomašina SMV25EX02E

  • 3 korpe |
  • Svetlosni snop |
  • 48dB |
  • 13 kompleta |
  • Ugradna |
  • 60cm
69.990,00 RSD
BOSCH sudomašina SPV2IKX10E
Super ponuda
Sudomašine - F
Šifra: SPV2IKX10E

BOSCH sudomašina SPV2IKX10E

  • Svetlosni snop |
  • 48dB |
  • 9 kompleta |
  • Ugradna |
  • 45cm |
  • 2 korpe
55.990,00 RSD
BOSCH sudomašina SMV24AX04E
Super ponuda
Sudomašine - E
Šifra: SMV24AX04E

BOSCH sudomašina SMV24AX04E

  • 2 korpe |
  • Svetlosni snop |
  • 48dB |
  • 12 kompleta |
  • Ugradna |
  • 60cm
52.990,00 RSD
BOSCH sudomašina SPV2HMX02E
Sudomašine - D
Šifra: SPV2HMX02E

BOSCH sudomašina SPV2HMX02E

57.990,00 RSD
BOSCH sudomašina SMV6ECX23E
Sudomašine - D
Šifra: SMV6ECX23E

BOSCH sudomašina SMV6ECX23E

107.990,00 RSD
BOSCH sudomašina SMV4EVX11E
Sudomašine - B
Šifra: SMV4EVX11E

BOSCH sudomašina SMV4EVX11E

74.990,00 RSD
BOSCH sudomašina SMH4HVX14E
Sudomašine - C
Šifra: SMH4HVX14E

BOSCH sudomašina SMH4HVX14E

69.990,00 RSD
BOSCH sudomašina SMV25EX06F
Sudomašine - E
Šifra: SMV25EX06F

BOSCH sudomašina SMV25EX06F

58.990,00 RSD
BOSCH sudomašina SMV4HTX00E EOL
Šifra: SMV4HTX00E

BOSCH sudomašina SMV4HTX00E EOL

67.990,00 RSD
SPV4EMX10E
Sudomašine - C
Šifra: SPV4EMX10E

SPV4EMX10E

  • 3 korpe |
  • Svetlosni snop |
  • 44dB |
  • 10 kompleta |
  • Ugradna |
  • 45cm
67.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava