VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

BOSCH - Frižideri

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

  • Da |
  • 383l |
  • Kombinovani |
  • Bez komore |
  • Ugradni
170.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
BOSCH frižider KUR21VFE0
Super ponuda
Frižideri - E
Šifra: KUR21VFE0

BOSCH frižider KUR21VFE0

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 60cm |
  • 134l |
  • 82cm
75.990,00 RSD
BOSCH frižider KUL22VFD0
Super ponuda
Frižider - D
Šifra: KUL22VFD0

BOSCH frižider KUL22VFD0

  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 54cm |
  • 267l |
  • 178cm |
  • Bela
79.990,00 RSD
BOSCH frižider KIV86NSE0
Super ponuda
Frižideri - E
Šifra: KIV86NSE0

BOSCH frižider KIV86NSE0

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

BOSCH frižider KIR81VFE0

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 56cm |
  • 310l |
  • 178cm
105.990,00 RSD
BOSCH frižider KIN86NSE0
Super ponuda
Frižideri - E
Šifra: KIN86NSE0

BOSCH frižider KIN86NSE0

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 54cm |
  • 260l |
  • 178cm
107.990,00 RSD
BOSCH frižider KGV36VBEAS
Super ponuda
Frižideri - E
Šifra: KGV36VBEAS

BOSCH frižider KGV36VBEAS

  • Crna |
  • Kombinovani |
  • Bez komore |
  • Samostojeći |
  • Ne |
  • 60cm |
  • 308l |
  • 186cm
82.990,00 RSD
BOSCH vinska vitrina KWK36ABGA
Šifra: KWK36ABGA

BOSCH vinska vitrina KWK36ABGA

  • Crna |
  • Samo frižider |
  • Bez komore |
  • Samostojeći |
  • Ne |
  • 370l
294.990,00 RSD
BOSCH frižider KUW21AHG0
Šifra: KUW21AHG0

BOSCH frižider KUW21AHG0

  • Crna |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 110l
174.990,00 RSD
BOSCH vinska vitrina KUW20VHF0
Šifra: KUW20VHF0

BOSCH vinska vitrina KUW20VHF0

  • Crna |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 85l
111.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava