VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

ELECTROLUX

Zatvori
BOJA UREĐAJA
BROJ KORPI
ELEMENT
GRILL GREJAČ
HOB2HOOD
INDIKATOR RADA
JAČINA
JAČINA ZVUKA
KAPACITET PUNJENJA
KOMBINOVANI
KOMORA
MAKSIMALNA JAČINA
NAČIN ČIŠĆENJA
Način ugradnje
NO FROST
ŠIRINA UREĐAJA
UKUPNA ZAPREMINA
UPRAVLJANJE
URANJANJE U MERMER
VISINA
VRSTA HLAĐENJA
VRSTA PLOČE
VRSTA RERNE
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 (10011,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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 (10011,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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 (10011,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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 (10011,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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 rerna KOEBP39H
Super ponuda
Šifra: 949288421

Electrolux rerna KOEBP39H

  • Multifunkcionalna |
  • 71l |
  • Crna sa inox detaljima |
  • Pirolitičko |
  • Na dodir
73.990,00 RSD
Electrolux rerna KOBAS3XH
Super ponuda
Šifra: 944032175

Electrolux rerna KOBAS3XH

  • Crna sa inox detaljima |
  • Aqua clean |
  • Na dodir |
  • Parna |
  • 71l
126.990,00 RSD
Electrolux rerna COF6P76BX
Super ponuda
Šifra: 944068348

Electrolux rerna COF6P76BX

52.990,00 RSD
Electrolux aspirator LFV626K
Super ponuda
Šifra: 942051493

Electrolux aspirator LFV626K

  • Crna |
  • 60cm |
  • Da |
  • 710m3/h |
  • Dekorativni |
  • Na dodir
56.990,00 RSD
Electrolux vezni element E1WYHSK2
Super ponuda
Šifra: 902986629

Electrolux vezni element E1WYHSK2

9.990,00 RSD
Electrolux kanalica M2CKCF05U
Super ponuda
Šifra: 902986615

Electrolux kanalica M2CKCF05U

5.990,00 RSD
Electrolux kanalica M2CKCF01C
Super ponuda
Šifra: 902986614

Electrolux kanalica M2CKCF01C

19.990,00 RSD
Electrolux strugač E6HUE103
Super ponuda
Šifra: 902986532

Electrolux strugač E6HUE103

790,00 RSD
Electrolux pregrada M3DKH100
Super ponuda
Šifra: 902980338

Electrolux pregrada M3DKH100

6.690,00 RSD
Electrolux loptice za mašinu za sušenje EDBALL
Super ponuda
Šifra: 902979186

Electrolux loptice za mašinu za sušenje EDBALL

990,00 RSD
Electrolux rerna KOD5H70BX
Super ponuda
Šifra: 944068057

Electrolux rerna KOD5H70BX

  • Crna sa inox detaljima |
  • Aqua clean |
  • Potapajući dugmići |
  • Multifunkcionalna |
  • 65l
45.990,00 RSD
Electrolux frižider ERD6DE18S1
Super ponuda
Šifra: 923581340

Electrolux frižider ERD6DE18S1

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 310l
109.990,00 RSD
Electrolux mašina za pranje veša EW6F2491E
Super ponuda
Veš mašina - A
Šifra: 914932023

Electrolux mašina za pranje veša EW6F2491E

  • A |
  • 9kg |
  • Frontalno |
  • Ne |
  • 1400
66.990,00 RSD
Electrolux ploča EIS62453IZ
Super ponuda
Šifra: 949599335

Electrolux ploča EIS62453IZ

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Indukcija
86.990,00 RSD
Electrolux ploča KIS62453I
Super ponuda
Šifra: 949599321

Electrolux ploča KIS62453I

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Indukcija
65.990,00 RSD
Electrolux mašina za pranje veša EW7F2481UE
Super ponuda
Veš mašina - A
Šifra: 914933900

Electrolux mašina za pranje veša EW7F2481UE

  • 1400 |
  • A |
  • 8kg |
  • Frontalno |
  • Ne
74.990,00 RSD
Electrolux rerna KODDP77WX
Super ponuda
Šifra: 949499864

Electrolux rerna KODDP77WX

  • Crna sa inox detaljima |
  • Pirolitičko |
  • Potapajući dugmići |
  • Multifunkcionalna |
  • 71l
80.990,00 RSD
Electrolux grejna ploča EHF6240IOK
Super ponuda
Šifra: 949492250

Electrolux grejna ploča EHF6240IOK

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Staklokeramika
24.990,00 RSD
Electrolux rerna KODDP77H
Super ponuda
Šifra: 949499871

Electrolux rerna KODDP77H

  • Crna sa inox detaljima |
  • Pirolitičko |
  • Potapajući dugmići |
  • Multifunkcionalna |
  • 71l
64.990,00 RSD
Electrolux aspirator LFP326FB
Super ponuda
Šifra: 942022683

Electrolux aspirator LFP326FB

  • Crna |
  • 60cm |
  • Ne |
  • 410m3/h |
  • Teleskopski |
  • Tasteri
22.990,00 RSD
Electrolux frižider LXB2AE82S
Super ponuda
Frižideri - E
Šifra: 933028028

Electrolux frižider LXB2AE82S

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 60cm |
  • 127l |
  • 82cm
49.990,00 RSD
Electrolux frižider LFB3AE12S
Super ponuda
Frižideri - E
Šifra: 933033177

Electrolux frižider LFB3AE12S

  • Bela |
  • Samo frižider |
  • Sa komorom |
  • Ugradni |
  • Ne |
  • 55cm |
  • 187l |
  • 122cm
63.990,00 RSD
Electrolux frižider LRB3AE12S
Super ponuda
Frižideri - E
Šifra: 933033055

Electrolux frižider LRB3AE12S

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 55cm |
  • 207l |
  • 122cm
56.990,00 RSD
Electrolux frižider LFB3AE82R
Super ponuda
Frižideri - E
Šifra: 933025098

Electrolux frižider LFB3AE82R

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 60cm |
  • 109l |
  • 82cm
63.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava