VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

ELECTROLUX - Mikrotalasne

Zatvori
GRILL GREJAČ
JAČINA
Način ugradnje
UPRAVLJANJE
ZAPREMINA
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 (-1001120) 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 (-1001120) 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 (-1001120) 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 (-1001120) 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
Electrolux mikrotalasnaLMS2203EMK
Super ponuda
Šifra: 947608769

Electrolux mikrotalasnaLMS2203EMK

  • 20l |
  • Ne |
  • 700W |
  • Mehaničko
44.990,00 RSD
Electrolux mikrotalasna LMS4253TMX
Super ponuda
Šifra: 947608763

Electrolux mikrotalasna LMS4253TMX

  • Da |
  • 900W |
  • Ugradna |
  • Na dodir |
  • 25l
59.990,00 RSD
Electrolux mikrotalasna LMS2203EMX
Super ponuda
Šifra: 947608762

Electrolux mikrotalasna LMS2203EMX

  • Ne |
  • 700W |
  • Ugradna |
  • Mehaničko |
  • 20l
44.990,00 RSD
Electrolux mikrotalasna EMZ725MMTI
Izdvajamo
Šifra: 947607505

Electrolux mikrotalasna EMZ725MMTI

30.990,00 RSD
AEG mikrotalasna NMB6G261UB
Izdvajamo
Šifra: 947608863

AEG mikrotalasna NMB6G261UB

  • Da |
  • 900W |
  • Ugradna |
  • Na dodir |
  • 26l
91.990,00 RSD
AEG mikrotalasna NMB6G261TB
Izdvajamo
Šifra: 947608861

AEG mikrotalasna NMB6G261TB

  • Da |
  • 900W |
  • Ugradna |
  • Na dodir |
  • 26l
92.990,00 RSD
AEG mikrotalasna OS5MG20EB
Izdvajamo
Šifra: 947607522

AEG mikrotalasna OS5MG20EB

44.990,00 RSD
AEG mikrotalasna OS5GM251EB
Izdvajamo
Šifra: 947607520

AEG mikrotalasna OS5GM251EB

  • Da |
  • 900W |
  • Ugradna |
  • Na dodir |
  • 23l
58.990,00 RSD
Electrolux mikrotalasna EMZ421MMK
Izdvajamo
Šifra: 947607501

Electrolux mikrotalasna EMZ421MMK

  • Da |
  • 800W |
  • Samostojeća |
  • Mehaničko |
  • 20l
24.990,00 RSD
Electrolux mikrotalasna EMZ725MMK
Izdvajamo
Šifra: 947607504

Electrolux mikrotalasna EMZ725MMK

  • Da |
  • 900W |
  • Samostojeća |
  • Mehaničko |
  • 24l
29.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava