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`=31
 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

ABACUS SPOTTY PRIMA-60%
ABACUS SPOTTY PRIMA
100% Pure New Wool, Handtufted.
Dimensions - PRICE
90cm x 140cm - 330.00 € 132.00 €
ELIF K06 NAVY-50%
ELIF K06 NAVY
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
200cm x 250cm - 550.00 € 275.00 €
200cm x 300cm - 650.00 € 325.00 €
PATCH KILIM S4 BEIGE-50%
PATCH KILIM S4 BEIGE
Wool,Cotton,Handmade
Dimensions - PRICE
80cm x 150cm - 240.00 € 120.00 €
200cm x 250cm - 848.00 € 424.00 €
200cm x 300cm - 1,006.00 € 503.00 €
COSI STELLA 78004 D.BROWN IVORY-20%
COSI STELLA 78004 D.BROWN IVORY
Heatset Frisee
Dimensions - PRICE
120cm x 170cm - 143.75 € 115.00 €
160cm x 220cm - 173.75 € 139.00 €
AL-PJ 009-20%
AL-PJ 009
Handmade Pvc
Dimensions - PRICE
140cm x 200cm - 157.00 € 125.60 €
200cm x 250cm - 269.00 € 215.20 €
LORIBAFF INDIA L03 RED BEIGE-70%
LORIBAFF INDIA L03 RED BEIGE
100% Wool.Handmade.
Dimensions - PRICE
171cm x 238cm - 1,347.00 € 404.10 €
200cm x 250cm - 1,640.00 € 492.00 €
200cm x 300cm - 1,950.00 € 585.00 €
LILIUM 4718 BLACK CREAM-20%
LILIUM 4718 BLACK CREAM
Chenille & Exclusive Acrylic.
Dimensions - PRICE
133cm x 190cm - 134.00 € 107.20 €
160cm x 230cm - 189.00 € 151.20 €
GANTI 199 CHOCO-60%
GANTI 199 CHOCO
Natural Cowskin,Indian Handmade
Dimensions - PRICE
170cm x 240cm - 1,295.00 € 518.00 €
DUFFY DUCK 21080-30%
DUFFY DUCK 21080
Smooth Piled Carpet
Dimensions - PRICE
140cm x 200cm - 109.00 € 76.30 €
SHAGGY LEATHER KORBA BROWN-50%
SHAGGY LEATHER KORBA BROWN
Handmade Leather Shaggy
Dimensions - PRICE
140cm x 200cm - 278.00 € 139.00 €
160cm x 230cm - 343.00 € 171.50 €
200cm x 300cm - 488.00 € 244.00 €
IVOIRE 311 NATURAL-20%
IVOIRE 311 NATURAL
100% Wool,Handknotted
Dimensions - PRICE
170cm x 240cm - 709.00 € 567.20 €
JADE SAND 6000-40%
JADE SAND 6000
Artificial Silk & Suede Leather & Wool.
Dimensions - PRICE
160cm x 230cm - 615.00 € 369.00 €
LIVING 20791-110-20%
LIVING 20791-110
100% Acrylic Frise.
Dimensions - PRICE
133cm x 190cm - 133.00 € 106.40 €
160cm x 230cm - 188.00 € 150.40 €
FORLI 2204 BLACK-50%
FORLI 2204 BLACK
ArtSilk, Cotton, Handmade
Dimensions - PRICE
70cm x 200cm - 100.00 € 50.00 €
160cm x 230cm - 212.00 € 106.00 €
ELIF 1961 CR-50%
ELIF 1961 CR
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
170cm x 240cm - 458.00 € 229.00 €
SONIA 560-301220-15%
SONIA 560-301220
100% Viscose.
Dimensions - PRICE
160cm x 230cm - 136.00 € 115.60 €
200cm x 300cm - 189.00 € 160.65 €
Bedroom Set - 112.00 € 95.20 €
FARFALA 2182 GREY-10%
FARFALA 2182 GREY
100% Butterfly,Indian handmade
Dimensions - PRICE
60cm x 90cm - 42.00 € 37.80 €
70cm x 140cm - 35.00 € 31.50 €
70cm x 200cm - 50.00 € 45.00 €
140cm x 200cm - 123.00 € 110.70 €
160cm x 230cm - 160.00 € 144.00 €
SHAGGY-50 1086 VIOLET-30%
SHAGGY-50 1086 VIOLET
100% Heatset Shaggy
Dimensions - PRICE
160cm x 230cm - 200.00 € 140.00 €
INFINITY 3614-50%
INFINITY 3614
100% New Zealand Wool.1.000.000 Knots.
Dimensions - PRICE
160cm x 230cm - 360.00 € 180.00 €
PRESTIGE 8784-84-20%
PRESTIGE 8784-84
100% Heatset
Dimensions - PRICE
137cm x 195cm - 124.00 € 99.20 €
170cm x 230cm - 164.00 € 131.20 €
ANZARO 7141 IVORY-40%
ANZARO 7141 IVORY
100% Art Silk
Dimensions - PRICE
160cm x 230cm - 270.00 € 162.00 €
WORLD 10 MTC-50%
WORLD 10 MTC
100% Acrylic
Dimensions - PRICE
165cm x 235cm - 465.00 € 232.50 €
200cm x 300cm - 720.00 € 360.00 €
M.T BLACK TIE 108 BRICK-50%
M.T BLACK TIE 108 BRICK
100% wool -Handtufted Indian
Dimensions - PRICE
140cm x 200cm - 440.00 € 220.00 €
160cm x 230cm - 560.00 € 280.00 €
ALEGRO-UTKU-NAVY-60%
ALEGRO-UTKU-NAVY
100% Wool T5 Pennie
Dimensions - PRICE
170cm x 240cm - 468.00 € 187.20 €
200cm x 250cm - 560.00 € 224.00 €
KENYA SKIN 1030-40%
KENYA SKIN 1030
Artificial Silk & Suede Leather & Wool.
Dimensions - PRICE
160cm x 230cm - 615.00 € 369.00 €
WALL-E 502-20%
WALL-E 502
100% Acrylic Handmade
Dimensions - PRICE
140cm x 200cm - 135.00 € 108.00 €
160cm x 230cm - 165.00 € 132.00 €
TAZ BEIGE 9727-30%
TAZ BEIGE 9727
Loop Carpet
Dimensions - PRICE
140cm x 200cm - 95.00 € 66.50 €
DISNEY 10005-10%
DISNEY 10005
100% Acrylic, Handtufted
Dimensions - PRICE
140cm x 200cm - 135.00 € 121.50 €
J.GABBEH GH607 TERRA-50%
J.GABBEH GH607 TERRA
100% Wool/ Indian Handmade.
Dimensions - PRICE
HANDTUFT 326111-50%
HANDTUFT 326111
100% NewZealand Wool
Dimensions - PRICE
190cm x 280cm - 520.00 € 260.00 €
METALLIC SHAGGY 005-50%
METALLIC SHAGGY 005
Synthetic Metallic Shaggy, Handmade.
Dimensions - PRICE
140cm x 200cm - 250.00 € 125.00 €
160cm x 230cm - 315.00 € 157.50 €
200cm x 250cm - 415.00 € 207.50 €
200cm x 300cm - 488.00 € 244.00 €
CARRERA 32416-2268-10%
CARRERA 32416-2268
100% Acrylic
Dimensions - PRICE
133cm x 195cm - 137.00 € 123.30 €
160cm x 230cm - 190.00 € 171.00 €
CAVALLI BLACK 1861-50%
CAVALLI BLACK 1861
Handmade Leather
Dimensions - PRICE
160cm x 230cm - 1,390.00 € 695.00 €
COSI STELLA 78003 IVORY-20%
COSI STELLA 78003 IVORY
Heatset Frisee
Dimensions - PRICE
120cm x 170cm - 143.75 € 115.00 €
160cm x 220cm - 173.75 € 139.00 €
ALEGRO-ASYA-BEIGE-60%
ALEGRO-ASYA-BEIGE
100% Wool T5 Pennie
Dimensions - PRICE
170cm x 240cm - 468.00 € 187.20 €
200cm x 250cm - 560.00 € 224.00 €
ELIF 11010 NAVY-20%
ELIF 11010 NAVY
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
170cm x 240cm - 265.00 € 212.00 €
HANDTUFT 2320 3-50%
HANDTUFT 2320 3
100% Wool Handmade
Dimensions - PRICE
160cm x 230cm - 380.00 € 190.00 €
190cm x 280cm - 530.00 € 265.00 €
IASON 830 BLACK  & SILVER-80%
IASON 830 BLACK & SILVER
100% Genuine Leather
Dimensions - PRICE
90cm x 150cm - 1,000.00 € 200.00 €
120cm x 180cm - 1,575.00 € 315.00 €
Ø160cm (Round) - 1,825.00 € 365.00 €
170cm x 240cm - 2,875.00 € 575.00 €
200cm x 300cm - 4,150.00 € 830.00 €
POP SHAGGY 002 BEIGE-30%
POP SHAGGY 002 BEIGE
70% Chenille 30% Art Silk/Indian
Dimensions - PRICE
140cm x 190cm - 180.00 € 126.00 €
GHALI 5097 BLACK-20%
GHALI 5097 BLACK
Chenille & Viscose.
Dimensions - PRICE
140cm x 200cm - 163.00 € 130.40 €
150cm x 230cm - 200.00 € 160.00 €
200cm x 300cm - 332.00 € 265.60 €
ELIF 1268 CR2-50%
ELIF 1268 CR2
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
170cm x 240cm - 458.00 € 229.00 €
200cm x 300cm - 650.00 € 325.00 €
250cm x 300cm - 800.00 € 400.00 €
PAO 10581-20%
PAO 10581
100% Acrylic, Handtufted
Dimensions - PRICE
140cm x 200cm - 145.00 € 116.00 €
SONIA 560-301550-15%
SONIA 560-301550
100% Viscose
Dimensions - PRICE
140cm x 200cm - 100.00 € 85.00 €
160cm x 230cm - 136.00 € 115.60 €
Bedroom Set - 112.00 € 95.20 €
BOLZANO 2518 LIGHT BLUE-20%
BOLZANO 2518 LIGHT BLUE
100% Cotton,Handmade
Dimensions - PRICE
70cm x 140cm - 70.00 € 56.00 €
100cm x 180cm - 108.00 € 86.40 €
140cm x 200cm - 154.00 € 123.20 €
160cm x 230cm - 202.00 € 161.60 €
REGGAE 138A L.BROWN-20%
REGGAE 138A L.BROWN
100% Heatset Frize
Dimensions - PRICE
160cm x 230cm - 200.00 € 100.00 €
WINNIE THE POOH PINK 1281-50%
WINNIE THE POOH PINK 1281
100% Acrylic Handtufted
Dimensions - PRICE
120cm x 180cm - 244.00 € 122.00 €
MILLION 907 RED-50%
MILLION 907 RED
100% Heatset
Dimensions - PRICE
160cm x 230cm - 335.00 € 167.50 €
200cm x 290cm - 520.00 € 260.00 €
AJADI 2062 DARK BLUE-50%
AJADI 2062 DARK BLUE
100% New Zealand Wool.
Dimensions - PRICE
140cm x 200cm - 328.00 € 164.00 €
200cm x 250cm - 548.00 € 274.00 €
200cm x 300cm - 648.00 € 324.00 €

en-GB

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