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`=34
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987) 
 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

PAK. SILK TOUCH 906-204-1.46-70%
PAK. SILK TOUCH 906-204-1.46
100% Wool,Silk Handknotted.
Dimensions - PRICE
93cm x 157cm - 1,287.00 € 386.10 €
EXCLUSIVE K23 NAVY-50%
EXCLUSIVE K23 NAVY
100% New Zealand Wool T5
Dimensions - PRICE
200cm x 250cm - 550.00 € 275.00 €
ORIENT MIXED 902-103-3.60-70%
ORIENT MIXED 902-103-3.60
100% Wool, Handknotted.
Dimensions - PRICE
158cm x 228cm - 2,809.00 € 842.70 €
SARAY 067 BLUE-70%
SARAY 067 BLUE
100% Acrylic
Dimensions - PRICE
200cm x 300cm - 800.00 € 240.00 €
PUCCINI 60046-6010
PUCCINI 60046-6010
100% New Zealand Wool
Dimensions - PRICE
100cm x 180cm - 378.00 €
133cm x 195cm - 545.00 €
160cm x 230cm - 775.00 €
200cm x 300cm - 1,260.00 €
BOKHARA RUSSIAN 906-319-4.05-70%
BOKHARA RUSSIAN 906-319-4.05
100% Wool, Handknotted.
Dimensions - PRICE
163cm x 249cm - 6,319.00 € 1,895.70 €
ORIENT MIXED 902-103-6.64-70%
ORIENT MIXED 902-103-6.64
100% Wool, Handknotted.
Dimensions - PRICE
220cm x 302cm - 5,247.00 € 1,574.10 €
ELIF 1645 CREAM 5-50%
ELIF 1645 CREAM 5
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
170cm x 240cm - 458.00 € 229.00 €
250cm x 300cm - 800.00 € 400.00 €
VEGAS CLASSIC 1266 CHERRY
VEGAS CLASSIC 1266 CHERRY
100% Heatset
Dimensions - PRICE
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
DAVINCI 57368-3323
DAVINCI 57368-3323
100% Acrylic
Dimensions - PRICE
160cm x 230cm - 315.00 €
200cm x 290cm - 495.00 €
PUCCINI 60044-1010
PUCCINI 60044-1010
100% New Zealand Wool
Dimensions - PRICE
70cm x 140cm - 206.00 €
70cm x 240cm - 353.00 €
200cm x 300cm - 1,260.00 €
EXCLUSIVE 74706 NAVY-50%
EXCLUSIVE 74706 NAVY
100% New Zealand Wool T5
Dimensions - PRICE
200cm x 300cm - 650.00 € 325.00 €
MILLION 903 RED-50%
MILLION 903 RED
100% Heatset
Dimensions - PRICE
160cm x 230cm - 335.00 € 167.50 €
200cm x 290cm - 520.00 € 260.00 €
MOHAMADI 21527-010
MOHAMADI 21527-010
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 190.00 €
KLASSIK 6057A CHERRY
KLASSIK 6057A CHERRY
100% Heatset.
Dimensions - PRICE
80cm x 150cm - 54.00 €
160cm x 230cm - 130.00 €
200cm x 290cm - 195.00 €
DAVINCI 57204-6414
DAVINCI 57204-6414
100% Acrylic
Dimensions - PRICE
200cm x 290cm - 495.00 €
ZIEGLER 1260 RED IVORY
ZIEGLER 1260 RED IVORY
100% Heatset Frise.
Dimensions - PRICE
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
JAMAL BLUE
JAMAL BLUE
100% New Zealand Wool.
Dimensions - PRICE
160cm x 235cm - 480.00 €
ORIENT MIXED 902-103-3.77-70%
ORIENT MIXED 902-103-3.77
100% Wool, Handknotted.
Dimensions - PRICE
171cm x 221cm - 2,947.00 € 884.10 €
CHOBI CB02
CHOBI CB02
100% Wool,Machine Woven.
Dimensions - PRICE
80cm x 290cm - 429.00 €
130cm x 190cm - 450.00 €
164cm x 230cm - 680.00 €
SOFIA 559 87
SOFIA 559 87
100% Acrylic Frise.
Dimensions - PRICE
160cm x 230cm - 165.00 €
ORIENT MIXED 902-103-3.26-70%
ORIENT MIXED 902-103-3.26
100% Wool, Handknotted.
Dimensions - PRICE
145cm x 225cm - 2,545.00 € 763.50 €
ORIENT MIXED 902-103-2.72-70%
ORIENT MIXED 902-103-2.72
100% Wool, Handknotted.
Dimensions - PRICE
131cm x 208cm - 2,125.00 € 637.50 €
ORIENT MIXED 902-103-1.81-70%
ORIENT MIXED 902-103-1.81
100% Wool, Handknotted.
Dimensions - PRICE
107cm x 170cm - 1,418.00 € 425.40 €
ELIF 1490 CR-50%
ELIF 1490 CR
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
170cm x 240cm - 458.00 € 229.00 €
200cm x 250cm - 550.00 € 275.00 €
200cm x 300cm - 650.00 € 325.00 €
250cm x 300cm - 800.00 € 400.00 €
PUCCINI 60032-6010
PUCCINI 60032-6010
100% New Zealand Wool
Dimensions - PRICE
70cm x 140cm - 206.00 €
70cm x 240cm - 353.00 €
80cm x 160cm - 269.00 €
80cm x 240cm - 405.00 €
100cm x 180cm - 378.00 €
133cm x 195cm - 545.00 €
200cm x 300cm - 1,260.00 €
240cm x 300cm - 1,512.00 €
PUCCINI 60032-1010
PUCCINI 60032-1010
100% New Zealand Wool
Dimensions - PRICE
70cm x 140cm - 206.00 €
70cm x 240cm - 353.00 €
80cm x 160cm - 269.00 €
80cm x 240cm - 405.00 €
100cm x 180cm - 378.00 €
133cm x 195cm - 545.00 €
160cm x 230cm - 775.00 €
200cm x 250cm - 1,050.00 €
200cm x 300cm - 1,260.00 €
240cm x 300cm - 1,512.00 €
OLYMPIA 5238D CREAM
OLYMPIA 5238D CREAM
100% Acrylic.
Dimensions - PRICE
140cm x 200cm - 75.00 €
160cm x 230cm - 99.00 €
200cm x 250cm - 135.00 €
200cm x 300cm - 162.00 €
KHAL MOHAMMADI 904-344-2.49-70%
KHAL MOHAMMADI 904-344-2.49
100% Wool, Handknotted.
Dimensions - PRICE
130cm x 192cm - 1,664.00 € 499.20 €
WINDSOR WIN04
WINDSOR WIN04
100% Acrylic, Machine Made.
Dimensions - PRICE
80cm x 150cm - 95.00 €
67cm x 230cm - 109.00 €
200cm x 300cm - 329.00 €
240cm x 340cm - 439.00 €
KHAL MOHAMMADI 904-344-3.98-70%
KHAL MOHAMMADI 904-344-3.98
100% Wool, Handknotted.
Dimensions - PRICE
160cm x 249cm - 2,657.00 € 797.10 €
JAMAL RED BEIGE
JAMAL RED BEIGE
100% New Zealand Wool.
Dimensions - PRICE
160cm x 235cm - 480.00 €
200cm x 285cm - 715.00 €
DAVINCI 57904-6717
DAVINCI 57904-6717
100% Acrylic
Dimensions - PRICE
200cm x 290cm - 495.00 €
240cm x 300cm - 612.00 €
KHAL MOHAMMADI 904-344-2.69-70%
KHAL MOHAMMADI 904-344-2.69
100% Wool, Handknotted.
Dimensions - PRICE
141cm x 191cm - 1,796.00 € 538.80 €
MOHAMADI 21115-010
MOHAMADI 21115-010
100% Acrylic.
Dimensions - PRICE
200cm x 290cm - 290.00 €
ZIEGLER 1267 RED IVORY
ZIEGLER 1267 RED IVORY
100% Heatset Frise.
Dimensions - PRICE
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
HERMITAGE STAR BLUE
HERMITAGE STAR BLUE
100% Acrylic,Wool Look, Embossed.
Dimensions - PRICE
120cm x 170cm - 189.00 €
Ø150cm (Round) - 205.00 €
160cm x 230cm - 269.00 €
200cm x 290cm - 405.00 €
280cm x 380cm - 654.00 €
OLYMPOS 15891-630
OLYMPOS 15891-630
Acrylic, Polyester.
Dimensions - PRICE
160cm x 230cm - 185.00 €
ORIENT MIXED 902-103-1.00-70%
ORIENT MIXED 902-103-1.00
100% Wool, Handknotted.
Dimensions - PRICE
80cm x 125cm - 780.00 € 234.00 €
JAMILA 13112-060
JAMILA 13112-060
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 225.00 €
200cm x 250cm - 300.00 €
ZIEGLER 904-347-4.23-70%
ZIEGLER 904-347-4.23
100% Wool, Handknotted.
Dimensions - PRICE
170cm x 249cm - 3,530.00 € 1,059.00 €
HERMITAGE STAR GREEN
HERMITAGE STAR GREEN
100% Acrylic,Wool Look, Embossed.
Dimensions - PRICE
120cm x 170cm - 189.00 €
Ø150cm (Round) - 205.00 €
160cm x 230cm - 269.00 €
JULIAN 559 RED
JULIAN 559 RED
100% Heatset.
Dimensions - PRICE
133cm x 190cm - 89.00 €
165cm x 225cm - 119.00 €
200cm x 290cm - 180.00 €
235cm x 300cm - 219.00 €
Bedroom Set - 110.00 €
PAK. SILK TOUCH 906-204-3.99-70%
PAK. SILK TOUCH 906-204-3.99
100% Wool,Silk Handknotted.
Dimensions - PRICE
170cm x 235cm - 3,397.00 € 1,019.10 €
SHERAZAD 8302 IVORY
SHERAZAD 8302 IVORY
100% Acrylic
Dimensions - PRICE
140cm x 190cm - 184.00 €
160cm x 230cm - 251.00 €
200cm x 250cm - 337.00 €
200cm x 290cm - 386.00 €
PAK. SILK TOUCH 906-204-5.05-70%
PAK. SILK TOUCH 906-204-5.05
100% Wool,Silk Handknotted.
Dimensions - PRICE
183cm x 276cm - 4,281.00 € 1,284.30 €
AVENUE 360R
AVENUE 360R
100% Heatset.
Dimensions - PRICE
133cm x 190cm - 180.00 €
160cm x 235cm - 265.00 €
200cm x 285cm - 395.00 €
HESPER CLASSIC NAVY
HESPER CLASSIC NAVY
100% Acrylic
Dimensions - PRICE
160cm x 230cm - 524.00 €

en-GB

All material, in any form, on this website is copyrighted by xalia.com