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,-1001140,-1001139,-1001134,-1001125,-1001123,-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,-1001140,-1001139,-1001134,-1001125,-1001123,-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,-1001140,-1001139,-1001134,-1001125,-1001123,-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,-1001140,-1001139,-1001134,-1001125,-1001123,-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 COF6P76BX
Super ponuda
Šifra: 944068348

Electrolux rerna COF6P76BX

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

Electrolux aspirator LFV626K

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

Electrolux vezni element E1WYHSK2

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

Electrolux dugačka kanalica M2CKCF05U

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

Electrolux set kanalica M2CKCF01C

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

Electrolux strugač E6HUE103

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

Electrolux pregrada M3DKH100

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

Electrolux loptice za mašinu za sušenje EDBALL

1.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
42.990,00 RSD
Electrolux frižider ERD6DE18S1
Super ponuda
Šifra: 923581340

Electrolux frižider ERD6DE18S1

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 310l
101.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

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

Electrolux ploča EIS62453IZ

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

Electrolux ploča KIS62453I

  • Crna |
  • 60cm |
  • Senzorsko |
  • Da |
  • Indukcija
58.990,00 RSD
Electrolux frižider ENT6ME18S
Super ponuda
Šifra: 925555002

Electrolux frižider ENT6ME18S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 253l |
  • 178cm
119.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
66.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
71.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
71.990,00 RSD
Electrolux aspirator LFP326FB
Super ponuda
Šifra: 942022683

Electrolux aspirator LFP326FB

  • Crna |
  • 60cm |
  • Ne |
  • 410m3/h |
  • Teleskopski |
  • Tasteri
20.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
48.990,00 RSD
Electrolux frižider ENG7TE75S
Super ponuda
Frižideri - E
Šifra: 925975015

Electrolux frižider ENG7TE75S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 70cm |
  • 371l |
  • 189cm
164.990,00 RSD
Electrolux frižider LNS5LE18S
Super ponuda
Frižideri - E
Šifra: 925503339

Electrolux frižider LNS5LE18S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 55cm |
  • 267l |
  • 178cm
79.990,00 RSD
Electrolux sudomašina KEAF7200L
Super ponuda
Sudomašine - E
Šifra: 911539276

Electrolux sudomašina KEAF7200L

  • 2 korpe |
  • 49dB |
  • 13 kompleta |
  • Ugradna |
  • 60cm
52.990,00 RSD
Electrolux sudomašina EEC87400W
Super ponuda
Sudomašine - C
Šifra: 911438464

Electrolux sudomašina EEC87400W

  • 3 korpe |
  • Projekcija vremena |
  • 42dB |
  • 14 kompleta |
  • Ugradna |
  • 60cm
130.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava