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 KNA7TE75S
Super ponuda
Šifra: 925974005

Electrolux frižider KNA7TE75S

128.990,00 RSD
Electrolux frižider ENA7CE19S
Super ponuda
Šifra: 925954033

Electrolux frižider ENA7CE19S

109.990,00 RSD
Electrolux frižider LNA7NE18S
Super ponuda
Šifra: 925505367

Electrolux frižider LNA7NE18S

89.990,00 RSD
Electrolux frižider LNA6LE18S
Super ponuda
Šifra: 925503408

Electrolux frižider LNA6LE18S

69.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 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
AEG frižider TSC8M191CS
Izdvajamo
Šifra: 925956002

AEG frižider TSC8M191CS

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

AEG frižider TC6MS18FDF

  • 55cm |
  • 244l |
  • 178cm |
  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da
131.990,00 RSD
Electrolux vinska vitrinaKBW6X
Izdvajamo
Frižider - F
Šifra: 923421440

Electrolux vinska vitrinaKBW6X

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

AEG vinska vitrina NKW8P21KAT

249.990,00 RSD
Electrolux frižider LFB2AE88S1
Izdvajamo
Šifra: 933031106

Electrolux frižider LFB2AE88S1

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

Electrolux frižider ENC8MC19S

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 189cm
218.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
Electrolux frižider LRB2AE88S
Izdvajamo
Šifra: 933035205

Electrolux frižider LRB2AE88S

46.990,00 RSD
Electrolux frižider ENT6ME19S (EOL)
Outlet
Šifra: 925954001

Electrolux frižider ENT6ME19S (EOL)

  • Bela |
  • Kombinovani |
  • Bez komore |
  • Ugradni |
  • Da |
  • 55cm |
  • 268l |
  • 189cm
126.990,00 RSD
Electrolux frižider EAT6ME53U0
Frižideri - E
Šifra: 925995018

Electrolux frižider EAT6ME53U0

122.990,00 RSD
Electrolux frižider EAT6ME53K0
Frižideri - E
Šifra: 925995019

Electrolux frižider EAT6ME53K0

132.990,00 RSD
Electrolux frižider EAT6ME53E0
Frižideri - E
Šifra: 925995016

Electrolux frižider EAT6ME53E0

136.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava