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`=71
 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 `jos_{vm}_product_category_xref`.`product_list` ASC

COSY GLAMOUR ESP-0400-85-R
COSY GLAMOUR ESP-0400-85-R
100% Heatset Frise.
Dimensiuni - Preț
Ø120cm (Round) - 89.00 €
Ø200cm (Round) - 219.00 €
RAINBOW KELIM ESP-7708-07
RAINBOW KELIM ESP-7708-07
100% Cotton, Handwoven
Dimensiuni - Preț
160cm x 230cm - 399.00 €
GRAPHIC JUNGLE ESP-4002-03
GRAPHIC JUNGLE ESP-4002-03
100% Acrylic Handtufted.
Dimensiuni - Preț
120cm x 180cm - 339.00 €
140cm x 200cm - 439.00 €
170cm x 240cm - 639.00 €
SPA 0054-900
SPA 0054-900
100% Acrylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 139.00 €
133cm x 200cm - 179.00 €
160cm x 225cm - 249.00 €
200cm x 200cm - 279.00 €
200cm x 290cm - 379.00 €
240cm x 340cm - 569.00 €
GOBI ESP-7112-01
GOBI ESP-7112-01
Wool & Jute, Handwoven.
Dimensiuni - Preț
160cm x 230cm - 379.00 €
CROCO WH-0721-08
CROCO WH-0721-08
100% Polyester Microfibre.
Dimensiuni - Preț
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
RELIEF ESP-3243-952
RELIEF ESP-3243-952
Arcylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
200cm x 290cm - 429.00 €
RELAXX ESP-4150-02
RELAXX ESP-4150-02
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
RELAXX ESP-4150-21
RELAXX ESP-4150-21
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
SPA 0054-060
SPA 0054-060
100% Acrylic, Machine Woven
Dimensiuni - Preț
Ø200cm (Round) - 279.00 €
SOCIETY CIRCLE YELLOW
SOCIETY CIRCLE YELLOW
100% Acrylic, Machinewoven.
Dimensiuni - Preț
160cm x 230cm - 269.00 €
COOL GLAMOUR ESP-9001-16
COOL GLAMOUR ESP-9001-16
100% Artsilk Shaggy, Machine Tufted.
Dimensiuni - Preț
120cm x 180cm - 229.00 €
140cm x 200cm - 275.00 €
170cm x 240cm - 415.00 €
200cm x 200cm - 415.00 €
200cm x 300cm - 635.00 €
WOODLAND GREY TURQUOISE
WOODLAND GREY TURQUOISE
Heatset Frise,Polyester Shrink Yarn.
Dimensiuni - Preț
80cm x 150cm - 109.00 €
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 289.00 €
CHIMERA ESP-3387-953
CHIMERA ESP-3387-953
Acrylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 290cm - 429.00 €
RELAXX ESP-4150-17
RELAXX ESP-4150-17
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
200cm x 290cm - 479.00 €
COSY GLAMOUR ESP-0400-70-R
COSY GLAMOUR ESP-0400-70-R
100% Heatset Frise.
Dimensiuni - Preț
Ø200cm (Round) - 219.00 €
RAINBOW KELIM ESP-7708-03
RAINBOW KELIM ESP-7708-03
100% Cotton, Handwoven
Dimensiuni - Preț
130cm x 190cm - 289.00 €
160cm x 230cm - 399.00 €
NEW GLAMOUR ESP-3303-17
NEW GLAMOUR ESP-3303-17
100% Artsilk Handtufted.
Dimensiuni - Preț
170cm x 240cm - 495.00 €
200cm x 200cm - 495.00 €
200cm x 300cm - 749.00 €
COOL GLAMOUR ESP-9001-05
COOL GLAMOUR ESP-9001-05
100% Artsilk Shaggy, Machine Tufted.
Dimensiuni - Preț
120cm x 180cm - 229.00 €
140cm x 200cm - 275.00 €
170cm x 240cm - 415.00 €
200cm x 300cm - 635.00 €
WILD OAK BROWN
WILD OAK BROWN
Heatset Frise,Polyester Shrink Yarn.
Dimensiuni - Preț
80cm x 150cm - 109.00 €
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 289.00 €
200cm x 290cm - 459.00 €
VELVET GRID 3385-095
VELVET GRID 3385-095
Acrylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 290cm - 429.00 €
RELAXX ESP-4150-14
RELAXX ESP-4150-14
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
COSY GLAMOUR ESP-0400-60
COSY GLAMOUR ESP-0400-60
100% Heatset Frise.
Dimensiuni - Preț
120cm x 170cm - 115.00 €
133cm x 200cm - 149.00 €
160cm x 225cm - 195.00 €
200cm x 290cm - 319.00 €
240cm x 340cm - 449.00 €
FIESTA ESP-7707-04
FIESTA ESP-7707-04
Wool Cotton, Handwoven
Dimensiuni - Preț
130cm x 190cm - 439.00 €
160cm x 230cm - 659.00 €
NEW GLAMOUR ESP-3303-04
NEW GLAMOUR ESP-3303-04
100% Artsilk Handtufted.
Dimensiuni - Preț
120cm x 180cm - 275.00 €
EDDY ESP-3249-690
EDDY ESP-3249-690
100% Acrylic, Machine Woven
Dimensiuni - Preț
Ø150cm (Round) - 129.00 €
Ø200cm (Round) - 229.00 €
Ø250cm (Round) - 349.00 €
FLORIA ESP-4017-02
FLORIA ESP-4017-02
100% Acrylic Handtufted.
Dimensiuni - Preț
170cm x 240cm - 749.00 €
VELVET SPOTS 3352-070
VELVET SPOTS 3352-070
Arcylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 290cm - 429.00 €
RELAXX ESP-4150-10
RELAXX ESP-4150-10
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
NEW GLAMOUR ESP-3303-10
NEW GLAMOUR ESP-3303-10
100% Artsilk Handtufted.
Dimensiuni - Preț
120cm x 180cm - 275.00 €
140cm x 200cm - 345.00 €
170cm x 240cm - 495.00 €
200cm x 200cm - 495.00 €
200cm x 300cm - 749.00 €
LAMELLA ESP-4206-03
LAMELLA ESP-4206-03
100% New Zealand Wool, Handtufted
Dimensiuni - Preț
170cm x 240cm - 979.00 €
CARVING ART SAND
CARVING ART SAND
100% Acrylic Handtufted.
Dimensiuni - Preț
120cm x 180cm - 505.00 €
RAINBOW KELIM ESP-7708-15
RAINBOW KELIM ESP-7708-15
100% Cotton, Handwoven
Dimensiuni - Preț
160cm x 230cm - 399.00 €
ARTISAN POP ESP-4011-04
ARTISAN POP ESP-4011-04
100% New Zealand Wool Handtufted.
Dimensiuni - Preț
120cm x 180cm - 649.00 €
170cm x 240cm - 1,229.00 €
SNUGS GREEN YELLOW
SNUGS GREEN YELLOW
Heatset Frise
Dimensiuni - Preț
80cm x 150cm - 95.00 €
133cm x 200cm - 179.00 €
ZEBRA BLUE WHITE
ZEBRA BLUE WHITE
100% Polyester Microfibre.
Dimensiuni - Preț
120cm x 170cm - 189.00 €
133cm x 200cm - 239.00 €
160cm x 225cm - 319.00 €
RELAXX ESP-4150-07
RELAXX ESP-4150-07
Acrylic Microfiber, Machine Tufted
Dimensiuni - Preț
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
CASINO ESP-4200-01
CASINO ESP-4200-01
100% New Zealand Wool, Handtufted
Dimensiuni - Preț
140cm x 200cm - 669.00 €
170cm x 240cm - 979.00 €
OCEAN VIEW YELLOW BLUE
OCEAN VIEW YELLOW BLUE
100% Heatset Frise
Dimensiuni - Preț
120cm x 170cm - 159.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 290cm - 399.00 €
RAINBOW KELIM ESP-7708-12
RAINBOW KELIM ESP-7708-12
100% Cotton, Handwoven
Dimensiuni - Preț
160cm x 230cm - 399.00 €
TARA BLUE
TARA BLUE
100% Acrylic Handtufted.
Dimensiuni - Preț
140cm x 200cm - 499.00 €
170cm x 240cm - 719.00 €
ZIG-ZAG 0003-03
ZIG-ZAG 0003-03
Hemp, Pure Wool, Handwoven
Dimensiuni - Preț
130cm x 190cm - 399.00 €
160cm x 230cm - 599.00 €
CHILL GLAMOUR ESP-8250-30
CHILL GLAMOUR ESP-8250-30
100% Polyester.
Dimensiuni - Preț
120cm x 170cm - 139.00 €
133cm x 200cm - 179.00 €
160cm x 225cm - 239.00 €
200cm x 290cm - 379.00 €
PHYTON WH-0727-03
PHYTON WH-0727-03
100% Polyester Microfibre.
Dimensiuni - Preț
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
DREAMING 3247-730
DREAMING 3247-730
100% Acrylic, Machine Woven
Dimensiuni - Preț
120cm x 170cm - 109.00 €
133cm x 200cm - 149.00 €
160cm x 225cm - 199.00 €
200cm x 290cm - 319.00 €
COSY GLAMOUR ESP-0400-92
COSY GLAMOUR ESP-0400-92
100% Heatset Frise.
Dimensiuni - Preț
120cm x 170cm - 115.00 €
133cm x 200cm - 149.00 €
160cm x 225cm - 195.00 €
200cm x 290cm - 319.00 €
240cm x 340cm - 449.00 €
RAINBOW KELIM ESP-7708-08
RAINBOW KELIM ESP-7708-08
100% Cotton, Handwoven
Dimensiuni - Preț
160cm x 230cm - 399.00 €
GRAPHIC JUNGLE ESP-4002-04
GRAPHIC JUNGLE ESP-4002-04
100% Acrylic Handtufted.
Dimensiuni - Preț
140cm x 200cm - 439.00 €
170cm x 240cm - 639.00 €

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