Query: LEFT JOIN `jos_{vm}_product_price` ON `jos_{vm}_product`.`product_id` = `jos_{vm}_product_price`.`product_id`
 LEFT JOIN `jos_vm_product_discount`
ON (`jos_vm_product`.`product_discount_id` = `jos_vm_product_discount`.`discount_id` OR `jos_vm_product`.`product_discount_id` = '0')  WHERE `jos_{vm}_product_category_xref`.`product_id`=`jos_{vm}_product`.`product_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=`jos_{vm}_category`.`category_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=43
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987,12988) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987,12988) 
 AND ((`jos_{vm}_product`.`product_id`=`jos_{vm}_product_price`.`product_id` AND `jos_{vm}_shopper_group`.`shopper_group_id`=`jos_{vm}_product_price`.`shopper_group_id`) OR `jos_{vm}_product_price`.`product_id` IS NULL) 
 AND `jos_{vm}_shopper_group`.`default` = 1
 AND ((`product_parent_id`='0') OR (`product_parent_id`='')) 
 AND (`product_publish`='Y')  
 AND `product_publish`='Y' 
 AND `category_publish`='Y' 
 GROUP BY `jos_{vm}_product`.`product_sku` 
 ORDER BY RAND() ASC

XENON 118-120-20%
XENON 118-120
100% Polyester
Dimensiuni - Preț
160cm x 235cm - 165.00 € 132.00 €
RAINBOW TRIANGLE KELIM 7722-01
RAINBOW TRIANGLE KELIM 7722-01
100% Cotton, Handwoven
Dimensiuni - Preț
130cm x 190cm - 389.00 €
160cm x 230cm - 589.00 €
ROYAL LUSSO 514 13-10%
ROYAL LUSSO 514 13
Chenille,Heatset PP, Machine Knotted
Dimensiuni - Preț
Set dormitor - 144.00 € 129.60 €
FARASHE 383-2740-15%
FARASHE 383-2740
100% Viscose.
Dimensiuni - Preț
67cm x 140cm - 58.00 € 49.30 €
67cm x 210cm - 82.35 €
140cm x 200cm - 164.71 €
160cm x 230cm - 216.47 €
FARASHE 348-3490-15%
FARASHE 348-3490
100% Viscose.
Dimensiuni - Preț
140cm x 200cm - 164.71 € 140.00 €
160cm x 230cm - 216.47 € 184.00 €
COASTAL LIFE ROPES NAVY-20%
COASTAL LIFE ROPES NAVY
100% PP, Machine Woven.
Dimensiuni - Preț
133cm x 190cm - 131.25 € 105.00 €
160cm x 230cm - 173.75 € 139.00 €
COASTAL LIFE WAVES L.BLUE-20%
COASTAL LIFE WAVES L.BLUE
100% PP, Machine Woven.
Dimensiuni - Preț
133cm x 190cm - 131.25 € 105.00 €
160cm x 230cm - 173.75 € 139.00 €
SUMMER SOHO 1414 87-20%
SUMMER SOHO 1414 87
chenille & viscose
Dimensiuni - Preț
200cm x 250cm - 157.50 € 126.00 €
ARTISAN 920N BEIGE-20%
ARTISAN 920N BEIGE
100% PP, Machine Made Sisal.
Dimensiuni - Preț
133cm x 190cm - 68.75 € 55.00 €
160cm x 230cm - 98.75 € 79.00 €
ARTISAN 920Χ GREY-20%
ARTISAN 920Χ GREY
100% PP, Machine Made Sisal.
Dimensiuni - Preț
133cm x 190cm - 68.75 € 55.00 €
160cm x 230cm - 98.75 € 79.00 €
TIFFANY ICE 939 BLUE-20%
TIFFANY ICE 939 BLUE
Viscose,Chenille
Dimensiuni - Preț
140cm x 200cm - 216.25 € 173.00 €
160cm x 230cm - 285.00 € 228.00 €
200cm x 250cm - 387.50 € 310.00 €
Set dormitor - 260.00 € 208.00 €
SUNSET 14720-077-20%
SUNSET 14720-077
Chenille,Heatset
Dimensiuni - Preț
133cm x 190cm - 122.50 € 98.00 €
ART3 517-102-50%
ART3 517-102
Chenille,Cotton,Polyester
Dimensiuni - Preț
150cm x 220cm - 150.00 € 75.00 €
Set dormitor - 175.00 € 87.50 €
SONIA 551-301440-15%
SONIA 551-301440
100% Viscose.
Dimensiuni - Preț
140cm x 200cm - 75.00 € 63.75 €
160cm x 230cm - 111.00 € 94.35 €
200cm x 300cm - 159.00 € 135.15 €
Set dormitor - 89.00 € 75.65 €
SAND 3188 E-20%
SAND 3188 E
100% Polypropelene,Machine Knotted
Dimensiuni - Preț
133cm x 190cm - 53.75 € 43.00 €
160cm x 230cm - 80.00 € 64.00 €
200cm x 285cm - 121.25 € 97.00 €
BERLIN 20743
BERLIN 20743
Machine Made Sisal
Dimensiuni - Preț
80cm x 150cm - 27.00 €
133cm x 190cm - 57.00 €
160cm x 230cm - 82.00 €
ALANIS ALLOVER 469 NATURAL
ALANIS ALLOVER 469 NATURAL
100% Acrylic Chenille Machine Made.
Dimensiuni - Preț
120cm x 180cm - 165.00 €
170cm x 240cm - 279.00 €
200cm x 300cm - 395.00 €
250cm x 350cm - 549.00 €
TARTUFO 2516 LIGHT BROWN-40%
TARTUFO 2516 LIGHT BROWN
100% Cotton,Handmade
Dimensiuni - Preț
160cm x 230cm - 173.00 € 103.80 €
ΜASTER FLORAL-20%
ΜASTER FLORAL
Machine made Straw Mat.
Dimensiuni - Preț
133cm x 190cm - 60.00 € 48.00 €
200cm x 250cm - 106.25 € 85.00 €
RAINBOW 2612-20%
RAINBOW 2612
Synthetic Sisal,Machine Made.
Dimensiuni - Preț
200cm x 290cm - 157.00 € 125.60 €
CARLUCCI VERTIC ANTHRACITE-20%
CARLUCCI VERTIC ANTHRACITE
100% Chenille, Machine Knotted
Dimensiuni - Preț
140cm x 200cm - 215.00 € 172.00 €
200cm x 250cm - 383.75 € 307.00 €
BATIK 229-102-20%
BATIK 229-102
100% Rattan sintetic
Dimensiuni - Preț
160cm x 230cm - 87.50 € 70.00 €
FARASHE 510-3440-15%
FARASHE 510-3440
100% Viscose.
Dimensiuni - Preț
140cm x 200cm - 164.71 € 140.00 €
160cm x 230cm - 216.47 € 184.00 €
HERIZ 013 CAMEL-20%
HERIZ 013 CAMEL
100% Viscose
Dimensiuni - Preț
160cm x 230cm - 102.50 € 82.00 €
DECO DROPS IN MOTION
DECO DROPS IN MOTION
Cotton, Acrylic.
Dimensiuni - Preț
200cm x 285cm - 389.00 €
MALIZIA FLORAL MULTI
MALIZIA FLORAL MULTI
100% Viscose.
Dimensiuni - Preț
200cm x 290cm - 525.00 €
240cm x 340cm - 719.00 €
PRESTIGE 332-330-20%
PRESTIGE 332-330
100% Viscose
Dimensiuni - Preț
140cm x 200cm - 92.50 € 74.00 €
160cm x 230cm - 121.25 € 97.00 €
ESSENTIAL CHROME PINK-20%
ESSENTIAL CHROME PINK
100% PP, Machine Woven.
Dimensiuni - Preț
133cm x 190cm - 123.75 € 99.00 €
160cm x 230cm - 156.25 € 125.00 €
200cm x 285cm - 223.75 € 179.00 €
RAINBOW KELIM 7708-13
RAINBOW KELIM 7708-13
100% Cotton, Handwoven
Dimensiuni - Preț
130cm x 190cm - 289.00 €
160cm x 230cm - 399.00 €
SUVA 4090-2312 CHAMP TAUPE-20%
SUVA 4090-2312 CHAMP TAUPE
100% PP, Machine Made Sisal.
Dimensiuni - Preț
135cm x 190cm - 62.50 € 50.00 €
200cm x 290cm - 143.75 € 115.00 €
Set dormitor - 81.25 € 65.00 €
RAINBOW 6500-20%
RAINBOW 6500
Synthetic Sisal,Machine Made.
Dimensiuni - Preț
80cm x 150cm - 33.00 € 26.40 €
135cm x 190cm - 69.00 € 55.20 €
160cm x 230cm - 99.00 € 79.20 €
200cm x 290cm - 157.00 € 125.60 €
MY TORINO FLAGS TOR 422 US
MY TORINO FLAGS TOR 422 US
Chenille,Visoce Jacquard Woven.
Dimensiuni - Preț
120cm x 170cm - 89.00 €
160cm x 230cm - 135.00 €
SUVA 4516-712 NATURAL COFFEE-20%
SUVA 4516-712 NATURAL COFFEE
100% PP, Machine Made Sisal.
Dimensiuni - Preț
135cm x 190cm - 62.50 € 50.00 €
200cm x 290cm - 143.75 € 115.00 €
Set dormitor - 81.25 € 65.00 €
SAND 3188 I-20%
SAND 3188 I
100% Polypropelene,Machine Knotted
Dimensiuni - Preț
133cm x 190cm - 53.75 € 43.00 €
160cm x 230cm - 80.00 € 64.00 €
MY GENT GEN 751 MULTI
MY GENT GEN 751 MULTI
Cotton,Polyester,Vintage Look.
Dimensiuni - Preț
120cm x 170cm - 155.00 €
155cm x 230cm - 255.00 €
200cm x 290cm - 395.00 €
FARASHE 45-1330-R-15%
FARASHE 45-1330-R
100% Viscose.
Dimensiuni - Preț
160cm (round) - 150.59 € 128.00 €
RUBINE 469 RED-20%
RUBINE 469 RED
100% Viscose
Dimensiuni - Preț
Set Dormitor - 111.25 € 89.00 €
TARTUFO 2516 BEIGE-20%
TARTUFO 2516 BEIGE
100% Cotton,Handmade
Dimensiuni - Preț
70cm x 140cm - 47.00 € 37.60 €
140cm x 200cm - 132.00 € 105.60 €
PRISMA 47005 059-20%
PRISMA 47005 059
100% Polypropelene, Machine Knotted
Dimensiuni - Preț
140cm x 200cm - 88.00 € 70.40 €
GRACE 6769-519-20%
GRACE 6769-519
Polypropelene Utah,Machine Made.
Dimensiuni - Preț
80cm x 150cm - 46.00 € 36.80 €
135cm x 190cm - 96.00 € 76.80 €
160cm x 230cm - 138.00 € 110.40 €
200cm x 290cm - 217.00 € 173.60 €
STYLISH GREEN FIORE-20%
STYLISH GREEN FIORE
100% PP, Machine Woven.
Dimensiuni - Preț
133cm x 190cm - 131.25 € 105.00 €
160cm x 230cm - 173.75 € 139.00 €
ART3 90-119-50%
ART3 90-119
Chenille,Cotton,Polyester
Dimensiuni - Preț
150cm x 220cm - 150.00 € 75.00 €
GENT 6792-49-20%
GENT 6792-49
100% P.P
Dimensiuni - Preț
135cm x 190cm - 96.25 € 77.00 €
160cm x 230cm - 137.50 € 110.00 €
DECO MULTI CHAIN
DECO MULTI CHAIN
Cotton, Acrylic.
Dimensiuni - Preț
160cm x 235cm - 255.00 €
200cm x 285cm - 389.00 €
VETUS 12007A BLACK BEIGE-30%
VETUS 12007A BLACK BEIGE
Chenille with PP,Machine Knotted
Dimensiuni - Preț
Set dormitor - 98.57 € 69.00 €
YEMENA CLASSIC SAH BLUE
YEMENA CLASSIC SAH BLUE
100% Acrylic
Dimensiuni - Preț
120cm x 170cm - 179.00 €
200cm x 290cm - 505.00 €
SUNSHINE 15837-695-20%
SUNSHINE 15837-695
Chenille Heatset
Dimensiuni - Preț
133cm x 190cm - 125.00 € 100.00 €
166cm x 236cm - 193.75 € 155.00 €
200cm x 250cm - 247.50 € 198.00 €
Set dormitor - 175.00 € 140.00 €
HERIZ 042 CAMEL-20%
HERIZ 042 CAMEL
100% Viscose
Dimensiuni - Preț
115cm x 180cm - 62.50 € 50.00 €

ro-RO

Toate materialele de pe acest site sunt proprietatea intelectuală a xalia.com