VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

ELECTROLUX - Frižideri

Zatvori
BOJA UREĐAJA
KOMBINOVANI
KOMORA
Način ugradnje
NO FROST
ŠIRINA UREĐAJA
UKUPNA ZAPREMINA
VISINA
VRSTA HLAĐENJA
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 (-1001115) 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 (-1001115) 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 (-1001115) 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 (-1001115) 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 frižider ERD6DE18S1
Super ponuda
Šifra: 923581340

Electrolux frižider ERD6DE18S1

  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 310l |
  • Bela
101.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 frižider LXB2AE82S
Super ponuda
Frižideri - E
Šifra: 933028028

Electrolux frižider LXB2AE82S

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

Electrolux frižider ENG7TE75S

  • 189cm |
  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 70cm |
  • 371l
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 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
58.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
53.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
60.990,00 RSD
Electrolux frižider ENT6NE18S
Super ponuda
Frižideri - E
Šifra: 925505302

Electrolux frižider ENT6NE18S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 253l |
  • 178cm
91.990,00 RSD
AEG frižider TSC8M191CS
Izdvajamo
Šifra: 925956002

AEG frižider TSC8M191CS

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 269l |
  • 188cm
203.990,00 RSD
Electrolux frižider ENT6MD19S3
Izdvajamo
Šifra: 925954020

Electrolux frižider ENT6MD19S3

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 269l |
  • 188cm
139.990,00 RSD
Electrolux frižider ENC8MC18S
Izdvajamo
Šifra: 925556002

Electrolux frižider ENC8MC18S

  • 178cm |
  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 248l
184.990,00 RSD
Electrolux frižider ENT6MD18S3
Izdvajamo
Šifra: 925555020

Electrolux frižider ENT6MD18S3

  • 178cm |
  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 248l
127.990,00 RSD
AEG frižider TC6MS18FDF
Izdvajamo
Šifra: 925552000

AEG frižider TC6MS18FDF

  • 178cm |
  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 244l
131.990,00 RSD
AEG frižider TK6DS181EC
Izdvajamo
Frižideri - E
Šifra: 923584341

AEG frižider TK6DS181EC

  • Bela |
  • Samo frižider |
  • Bez komore |
  • Ugradni |
  • Ne |
  • 55cm |
  • 310l |
  • 178cm
120.990,00 RSD
Electrolux vinska vitrinaKBW6X
Izdvajamo
Frižider - F
Šifra: 923421440

Electrolux vinska vitrinaKBW6X

228.990,00 RSD
AEG vinska vitrina NKW8P21KAT
Izdvajamo
Šifra: 923421438

AEG vinska vitrina NKW8P21KAT

249.990,00 RSD
Electrolux frižider ENC8MC19S
Izdvajamo
Šifra: 925956015

Electrolux frižider ENC8MC19S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 189cm
190.990,00 RSD
Electrolux frižider KNP7TE75S
Izdvajamo
Šifra: 925975013

Electrolux frižider KNP7TE75S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 70cm |
  • 371l |
  • 189cm
207.990,00 RSD
AEG frižider NSC7P751ES
Izdvajamo
Šifra: 925975002

AEG frižider NSC7P751ES

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 70cm |
  • 376l |
  • 189cm
203.990,00 RSD
AEG frižider OSC6N181ES
Izdvajamo
Šifra: 925505321

AEG frižider OSC6N181ES

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 253l |
  • 178cm
108.990,00 RSD
Electrolux frižider LNT7ME36K2
Izdvajamo
Šifra: 925993550

Electrolux frižider LNT7ME36K2

  • Crna |
  • Kombinovani |
  • Bez komore |
  • Samostojeći |
  • 60cm |
  • 367l |
  • 201cm |
  • No Frost
124.990,00 RSD
Electrolux frižider LNT5ME32U1
Izdvajamo
Šifra: 925993526

Electrolux frižider LNT5ME32U1

  • Siva |
  • Kombinovani |
  • Bez komore |
  • Samostojeći |
  • 60cm |
  • 324l |
  • 186cm |
  • No Frost
89.990,00 RSD
Electrolux frižider LNT5ME36U1
Izdvajamo
Šifra: 925993524

Electrolux frižider LNT5ME36U1

  • Siva |
  • Kombinovani |
  • Bez komore |
  • Samostojeći |
  • 60cm |
  • 367l |
  • 201cm |
  • No Frost
92.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava