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

VENUS 17521-695-25%
VENUS 17521-695
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 265.00 € 198.75 €
200cm x 290cm - 415.00 € 311.25 €
KASHAN BEIGE BLUE
KASHAN BEIGE BLUE
100% Heatset.
Dimensions - PRICE
160cm x 230cm - 204.00 €
JAMAL BEIGE RED
JAMAL BEIGE RED
100% New Zealand Wool.
Dimensions - PRICE
133cm x 190cm - 329.00 €
ORIENT MIXED 902-103-1.57-70%
ORIENT MIXED 902-103-1.57
100% Wool, Handknotted.
Dimensions - PRICE
104cm x 151cm - 1,225.00 € 367.50 €
TUNISIAN CLASSIC MONAS
TUNISIAN CLASSIC MONAS
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 334.00 €
ORIENT MIXED 902-103-1.10-70%
ORIENT MIXED 902-103-1.10
100% Wool, Handknotted.
Dimensions - PRICE
85cm x 130cm - 862.00 € 258.60 €
ORIENT MIXED 902-103-3.31-70%
ORIENT MIXED 902-103-3.31
100% Wool, Handknotted.
Dimensions - PRICE
155cm x 214cm - 2,587.00 € 776.10 €
ORIENT MIXED 902-103-3.10-70%
ORIENT MIXED 902-103-3.10
100% Wool, Handknotted.
Dimensions - PRICE
148cm x 210cm - 2,424.00 € 727.20 €
ELIF 1364 CR-50%
ELIF 1364 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 €
ORIENT MIXED 902-103-4.86-70%
ORIENT MIXED 902-103-4.86
100% Wool, Handknotted.
Dimensions - PRICE
180cm x 270cm - 3,790.00 € 1,137.00 €
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 €
KARGAI 904-345-2.85-70%
KARGAI 904-345-2.85
100% Wool, Handknotted.
Dimensions - PRICE
156cm x 183cm - 2,332.00 € 699.60 €
TUNISIAN CLASSIC MONAS RED
TUNISIAN CLASSIC MONAS RED
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 334.00 €
SAROUK INDIA 15-41092-70%
SAROUK INDIA 15-41092
100% Wool Handknotted
Dimensions - PRICE
200cm x 248cm - 4,030.00 € 1,209.00 €
CHOBI CB09
CHOBI CB09
100% Wool,Machine Woven.
Dimensions - PRICE
130cm x 190cm - 450.00 €
164cm x 230cm - 680.00 €
DAVINCI 57062-6424
DAVINCI 57062-6424
100% Acrylic
Dimensions - PRICE
133cm x 195cm - 220.00 €
200cm x 290cm - 495.00 €
ORIENT MIXED 902-103-3.06-70%
ORIENT MIXED 902-103-3.06
100% Wool, Handknotted.
Dimensions - PRICE
143cm x 214cm - 2,387.00 € 716.10 €
MILLION 961 BLACK BEIGE-50%
MILLION 961 BLACK BEIGE
100% Heatset
Dimensions - PRICE
160cm x 230cm - 335.00 € 167.50 €
200cm x 290cm - 520.00 € 260.00 €
KLASSIK 2273A RED
KLASSIK 2273A RED
100% Acrylic Heatset.
Dimensions - PRICE
80cm x 150cm - 54.00 €
133cm x 190cm - 92.00 €
160cm x 230cm - 130.00 €
200cm x 290cm - 195.00 €
Bedroom Set - 117.00 €
WINDSOR WIN01
WINDSOR WIN01
100% Acrylic, Machine Made.
Dimensions - PRICE
80cm x 150cm - 95.00 €
120cm x 170cm - 135.00 €
200cm x 300cm - 329.00 €
240cm x 340cm - 439.00 €
WINDSOR WIN02
WINDSOR WIN02
100% Acrylic, Machine Made.
Dimensions - PRICE
120cm x 170cm - 135.00 €
160cm x 230cm - 214.00 €
ORIENT MIXED 902-103-2.67-70%
ORIENT MIXED 902-103-2.67
100% Wool, Handknotted.
Dimensions - PRICE
136cm x 197cm - 2,089.00 € 626.70 €
ELITE 16954-953
ELITE 16954-953
Acrylic, Polyester.
Dimensions - PRICE
160cm x 230cm - 210.00 € 168.00 €
Bedroom set - 200.00 € 160.00 €
KHAL MOHAMMADI 904-344-2.88-70%
KHAL MOHAMMADI 904-344-2.88
100% Wool, Handknotted.
Dimensions - PRICE
150cm x 192cm - 1,920.00 € 576.00 €
ORIENT MIXED 902-103-2.27-70%
ORIENT MIXED 902-103-2.27
100% Wool, Handknotted.
Dimensions - PRICE
112cm x 203cm - 1,773.00 € 531.90 €
PUCCINI 60037-1010
PUCCINI 60037-1010
100% New Zealand Wool
Dimensions - PRICE
160cm x 230cm - 775.00 €
200cm x 250cm - 1,050.00 €
200cm x 300cm - 1,260.00 €
ZIEGLER 904-347-5.03-70%
ZIEGLER 904-347-5.03
100% Wool, Handknotted.
Dimensions - PRICE
187cm x 269cm - 4,195.00 € 1,258.50 €
KHAL MOHAMMADI 904-344-2.52-70%
KHAL MOHAMMADI 904-344-2.52
100% Wool, Handknotted.
Dimensions - PRICE
128cm x 197cm - 1,681.00 € 504.30 €
ORIENT MIXED 902-103-3.94-70%
ORIENT MIXED 902-103-3.94
100% Wool, Handknotted.
Dimensions - PRICE
170cm x 232cm - 3,076.00 € 922.80 €
SARAY 067 PINK-70%
SARAY 067 PINK
100% Acrylic
Dimensions - PRICE
200cm x 300cm - 800.00 € 240.00 €
ELIF 1644 CR-50%
ELIF 1644 CR
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
200cm x 300cm - 650.00 € 325.00 €
250cm x 300cm - 800.00 € 400.00 €
JAMAL BLUE
JAMAL BLUE
100% New Zealand Wool.
Dimensions - PRICE
160cm x 235cm - 480.00 €
JORD CLASSIC SAH RED
JORD CLASSIC SAH RED
100% Modacrylic
Dimensions - PRICE
160cm x 230cm - 1,420.00 €
200cm x 300cm - 2,225.00 €
ORIENT MIXED 902-103-1.60-70%
ORIENT MIXED 902-103-1.60
100% Wool, Handknotted.
Dimensions - PRICE
104cm x 154cm - 1,249.00 € 374.70 €
ZIEGLER 904-347-2.74-70%
ZIEGLER 904-347-2.74
100% Wool, Handknotted.
Dimensions - PRICE
146cm x 188cm - 2,289.00 € 686.70 €
MING 501-200 RED
MING 501-200 RED
100% Acrylic Handtufted
Dimensions - PRICE
120cm x 180cm - 255.00 €
190cm x 290cm - 550.00 €
JAMILA 10683-090
JAMILA 10683-090
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 280.00 €
ORIENT MIXED 902-103-1.37-70%
ORIENT MIXED 902-103-1.37
100% Wool, Handknotted.
Dimensions - PRICE
95cm x 145cm - 1,074.00 € 322.20 €
WINDSOR WIN09
WINDSOR WIN09
100% Acrylic, Machine Made.
Dimensions - PRICE
80cm x 150cm - 95.00 €
160cm x 230cm - 215.00 €
200cm x 300cm - 329.00 €
240cm x 330cm - 439.00 €
ORIENT MIXED 902-103-3.32-70%
ORIENT MIXED 902-103-3.32
100% Wool, Handknotted.
Dimensions - PRICE
154cm x 216cm - 2,674.00 € 802.20 €
LYDIA 2128A ROUND BURGUNDY
LYDIA 2128A ROUND BURGUNDY
100% Heatset.
Dimensions - PRICE
Ø200cm (Round) - 124.00 €
Ø250cm (Round) - 183.00 €
Ø300cm (Round) - 264.00 €
ORIENT MIXED 902-103-0.91-70%
ORIENT MIXED 902-103-0.91
100% Wool, Handknotted.
Dimensions - PRICE
80cm x 114cm - 711.00 € 213.30 €
DAVINCI 57904-6737
DAVINCI 57904-6737
100% Acrylic
Dimensions - PRICE
160cm x 230cm - 315.00 €
200cm x 290cm - 495.00 €
PUCCINI 60032-3030
PUCCINI 60032-3030
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 €
ESTIA CLASSIC 8235 RED
ESTIA CLASSIC 8235 RED
100% Heatset.
Dimensions - PRICE
160cm x 230cm - 89.00 €
ORIENT MIXED 902-103-2.80-70%
ORIENT MIXED 902-103-2.80
100% Wool, Handknotted.
Dimensions - PRICE
138cm x 203cm - 2,185.00 € 655.50 €
OLYMPOS 15893-670
OLYMPOS 15893-670
Acrylic, Polyester.
Dimensions - PRICE
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
REGALIA NAVY
REGALIA NAVY
100% Acrylic.
Dimensions - PRICE
120cm x 170cm - 205.00 €
160cm x 220cm - 285.00 €
180cm x 270cm - 395.00 €

en-GB

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