VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

BSH KUĆNI APARATI - Ugradne ploče

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 (-1002311) 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 (-1002311) 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 (-1002311) 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 (-1002311) 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 grejana ploča PKF611BB2E
Super ponuda
Šifra: PKF611BB2E

Bosch grejana ploča PKF611BB2E

31.990,00 RSD
BOSCH ploča PUG611AA5D
Super ponuda
Šifra: PUG611AA5D

BOSCH ploča PUG611AA5D

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Indukcija
39.990,00 RSD
BOSCH ploča PUE64KBB5E
Izdvajamo
Šifra: PUE64KBB5E

BOSCH ploča PUE64KBB5E

45.990,00 RSD
BSH ploča PXE801DC1E
Izdvajamo
Šifra: PXE801DC1E

BSH ploča PXE801DC1E

  • Crna |
  • 80cm |
  • Senzorsko |
  • Da |
  • Indukcija
104.990,00 RSD
BOSCH ploča PVS611B16E
Izdvajamo
Šifra: PVS611B16E

BOSCH ploča PVS611B16E

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Indukcija
164.990,00 RSD
BOSCH ploča PVS631HB1E
Izdvajamo
Šifra: PVS631HB1E

BOSCH ploča PVS631HB1E

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Indukcija
67.990,00 RSD
BOSCH ploča PKN645BA2E
Izdvajamo
Šifra: PKN645BA2E

BOSCH ploča PKN645BA2E

  • Inox |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Staklokeramika
36.990,00 RSD
BOSCH ploča PKF375FP2E
Izdvajamo
Šifra: PKF375FP2E

BOSCH ploča PKF375FP2E

  • Inox |
  • 30cm |
  • Senzorsko |
  • Ne |
  • Staklokeramika
37.990,00 RSD
BOSCH ploča PXE675DC1E
Šifra: PXE675DC1E

BOSCH ploča PXE675DC1E

103.990,00 RSD
BOSCH ploča PUE61RBB6E
Šifra: PUE61RBB6E

BOSCH ploča PUE61RBB6E

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Indukcija
47.990,00 RSD
BOSCH ploča PKE61RAA2E
Šifra: PKE61RAA2E

BOSCH ploča PKE61RAA2E

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Staklokeramika
31.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava