VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

BOSCH

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 (10023,-1002344,-1002339,-1002338,-1002337,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 rerna HBA171BS3
Super ponuda
Ugradna rerna - A
Šifra: HBA171BS3

BOSCH rerna HBA171BS3

  • Inox |
  • Pirolitičko |
  • Na dodir |
  • Multifunkcionalna |
  • 71l
72.990,00 RSD
BOSCH mašina za pranje i sušenje WNA144V0BY
Super ponuda
Sudomašine - E
Šifra: WNA144V0BY

BOSCH mašina za pranje i sušenje WNA144V0BY

  • 1400 |
  • 9/5kg |
  • Grejačem
126.990,00 RSD
BOSCH sudomašina SMV2ITX09E
Super ponuda
Sudomašine - E
Šifra: SMV2ITX09E

BOSCH sudomašina SMV2ITX09E

  • 2 korpe |
  • Svetlosni snop |
  • 46dB |
  • 13 kompleta |
  • Ugradna |
  • 60cm
61.990,00 RSD
BOSCH sudomašina SMV25EX02E
Super ponuda
Sudomašine - E
Šifra: SMV25EX02E

BOSCH sudomašina SMV25EX02E

  • 3 korpe |
  • Svetlosni snop |
  • 48dB |
  • 13 kompleta |
  • Ugradna |
  • 60cm
64.990,00 RSD
BOSCH frižider KIN96NSE0
Super ponuda
Frižideri - E
Šifra: KIN96NSE0

BOSCH frižider KIN96NSE0

  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 290l
116.990,00 RSD
BOSCH frižider KBN96VFE0
Super ponuda
Frižideri - E
Šifra: KBN96VFE0

BOSCH frižider KBN96VFE0

  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 383l
170.990,00 RSD
BOSCH rerna HQA574BB3
Super ponuda
Ugradna rerna - A+
Šifra: HQA574BB3

BOSCH rerna HQA574BB3

  • Crna sa inox detaljima |
  • Pirolitičko |
  • Potapajući dugmići |
  • Multifunkcionalna |
  • 71l
89.990,00 RSD
BOSCH aspirator DLN56AC60
Super ponuda
Aspiratori - B
Šifra: DLN56AC60

BOSCH aspirator DLN56AC60

  • Crna |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Ugradni |
  • Tasteri
47.990,00 RSD
BOSCH aspiratori DLN56AC50
Super ponuda
Aspiratori - B
Šifra: DLN56AC50

BOSCH aspiratori DLN56AC50

  • Inox |
  • 60cm |
  • Ne |
  • 645m3/h |
  • Ugradni |
  • Tasteri
46.990,00 RSD
BOSCH mikrotalasna BFL523MS0
Super ponuda
Šifra: BFL523MS0

BOSCH mikrotalasna BFL523MS0

  • Ne |
  • 800W |
  • Ugradna |
  • Mehaničko |
  • 20l
41.990,00 RSD
BOSCH mašina za sušenje veša WTH85293BY
Super ponuda
Sušare - A++
Šifra: WTH85293BY

BOSCH mašina za sušenje veša WTH85293BY

94.990,00 RSD
BOSCH mašina za pranje veša WAN24293BY
Super ponuda
Veš mašina - A
Šifra: WAN24293BY

BOSCH mašina za pranje veša WAN24293BY

76.990,00 RSD
BOSCH sudomašina SMV4HTX00E
Super ponuda
Šifra: SMV4HTX00E

BOSCH sudomašina SMV4HTX00E

67.990,00 RSD
BOSCH rerna HBA514BB3
Super ponuda
Ugradna rerna - A+
Šifra: HBA514BB3

BOSCH rerna HBA514BB3

59.990,00 RSD
BOSCH rerna HBA234EB3
Super ponuda
Ugradna rerna - A+
Šifra: HBA234EB3

BOSCH rerna HBA234EB3

64.990,00 RSD
BOSCH rerna HBG278BB3
Super ponuda
Ugradna rerna - A+
Šifra: HBG278BB3

BOSCH rerna HBG278BB3

89.990,00 RSD
BSH sudomašina SMV4HVX02E
Super ponuda
Sudomašine - D
Šifra: SMV4HVX02E

BSH sudomašina SMV4HVX02E

72.990,00 RSD
BOSCH frižider KIL82VFE0
Super ponuda
Frižideri - E
Šifra: KIL82VFE0

BOSCH frižider KIL82VFE0

108.990,00 RSD
BOSCH frižider KMC85LBEA
Super ponuda
Frižideri - E
Šifra: KMC85LBEA

BOSCH frižider KMC85LBEA

237.990,00 RSD
BSH ploča PXE801DC1E
Super ponuda
Šifra: PXE801DC1E

BSH ploča PXE801DC1E

  • Crna |
  • 80cm |
  • Senzorsko |
  • Da |
  • Indukcija
115.990,00 RSD
BOSCH ploča PVS611B16E
Super ponuda
Šifra: PVS611B16E

BOSCH ploča PVS611B16E

  • Crna |
  • 60cm |
  • Senzorsko |
  • Ne |
  • Indukcija
160.990,00 RSD
BOSCH sudomašina SPV4EMX10E
Super ponuda
Sudomašine - C
Šifra: SPV4EMX10E

BOSCH sudomašina SPV4EMX10E

  • 3 korpe |
  • Svetlosni snop |
  • 44dB |
  • 10 kompleta |
  • Ugradna |
  • 45cm
71.990,00 RSD
BOSCH sudomašina SPV2IKX10E
Super ponuda
Sudomašine - F
Šifra: SPV2IKX10E

BOSCH sudomašina SPV2IKX10E

  • 2 korpe |
  • Svetlosni snop |
  • 48dB |
  • 9 kompleta |
  • Ugradna |
  • 45cm
60.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
55.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava