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

PUCCINI 60046-6030
PUCCINI 60046-6030
100% New Zealand Wool
Dimensiones - Precio
100cm x 180cm - 378.00 €
133cm x 195cm - 545.00 €
160cm x 230cm - 775.00 €
200cm x 300cm - 1,260.00 €
ORIENT MIXED 902-103-1.15-70%
ORIENT MIXED 902-103-1.15
100% Wool, Handknotted.
Dimensiones - Precio
105cm x 110cm - 900.00 € 270.00 €
LYDIA 2128A BURGUNDY
LYDIA 2128A BURGUNDY
100% Heatset.
Dimensiones - Precio
100cm x 130cm - 34.00 €
200cm x 300cm - 156.00 €
300cm x 400cm - 312.00 €
BOKHARA RUSSIAN 906-319-4.05-70%
BOKHARA RUSSIAN 906-319-4.05
100% Wool, Handknotted.
Dimensiones - Precio
163cm x 249cm - 6,319.00 € 1,895.70 €
ELIF K18 NAVY-50%
ELIF K18 NAVY
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
170cm x 240cm - 408.00 € 204.00 €
200cm x 300cm - 600.00 € 300.00 €
JORD CLASSIC AM RED
JORD CLASSIC AM RED
100% Modacrylic
Dimensiones - Precio
200cm x 300cm - 2,195.00 €
VISCOUNT V52 1144
VISCOUNT V52 1144
100% Acrylic, Machine Made.
Dimensiones - Precio
67cm x 330cm - 200.00 €
PAK. SILK TOUCH 906-204-1.49-70%
PAK. SILK TOUCH 906-204-1.49
100% Wool,Silk Handknotted.
Dimensiones - Precio
94cm x 159cm - 1,312.00 € 393.60 €
ORIENT MIXED 902-103-1.04-70%
ORIENT MIXED 902-103-1.04
100% Wool, Handknotted.
Dimensiones - Precio
80cm x 130cm - 880.00 € 264.00 €
MOHAMADI 21530-110-20%
MOHAMADI 21530-110
100% Acrylic Heatset Frise.
Dimensiones - Precio
200cm x 290cm - 265.00 € 212.00 €
ELIF 1492 CR-50%
ELIF 1492 CR
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
170cm x 240cm - 458.00 € 229.00 €
200cm x 300cm - 650.00 € 325.00 €
250cm x 300cm - 800.00 € 400.00 €
ORIENT MIXED 902-103-2.27-70%
ORIENT MIXED 902-103-2.27
100% Wool, Handknotted.
Dimensiones - Precio
112cm x 203cm - 1,773.00 € 531.90 €
KLASSIK 1533A CHERRY
KLASSIK 1533A CHERRY
100% Heatset.
Dimensiones - Precio
80cm x 150cm - 34.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Σετ Κρεβατ/μαρας - 92.00 €
ELIF 1643 CREAM-50%
ELIF 1643 CREAM
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
200cm x 300cm - 600.00 € 300.00 €
250cm x 300cm - 750.00 € 375.00 €
PUCCINI 60044-1010
PUCCINI 60044-1010
100% New Zealand Wool
Dimensiones - Precio
70cm x 140cm - 206.00 €
70cm x 240cm - 353.00 €
200cm x 300cm - 1,260.00 €
ELIF 1945 CREAM 2-50%
ELIF 1945 CREAM 2
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
170cm x 240cm - 408.00 € 204.00 €
250cm x 300cm - 750.00 € 375.00 €
WINDSOR WIN02 1212
WINDSOR WIN02 1212
100% Acrylic, Machine Made.
Dimensiones - Precio
120cm x 170cm - 124.00 €
160cm x 230cm - 194.00 €
ZIEGLER 904-347-4.97-70%
ZIEGLER 904-347-4.97
100% Wool, Handknotted.
Dimensiones - Precio
183cm x 272cm - 4,151.00 € 1,245.30 €
JORD CLASSIC AM IVORY
JORD CLASSIC AM IVORY
100% Modacrylic
Dimensiones - Precio
160cm x 230cm - 1,395.00 €
200cm x 300cm - 2,195.00 €
VISCOUNT V56 1148
VISCOUNT V56 1148
100% Acrylic, Machine Made.
Dimensiones - Precio
160cm x 230cm - 310.00 €
PAK. SILK TOUCH 906-204-2.15-70%
PAK. SILK TOUCH 906-204-2.15
100% Wool,Silk Handknotted.
Dimensiones - Precio
122cm x 177cm - 1,863.00 € 558.90 €
ATHOS 1525 CREAM-50%
ATHOS 1525 CREAM
Acrylic, Wool Touch.
Dimensiones - Precio
250cm x 300cm - 470.00 € 235.00 €
ELIF 1268 CR-50%
ELIF 1268 CR
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
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 €
ZIEGLER 904-347-4.23-70%
ZIEGLER 904-347-4.23
100% Wool, Handknotted.
Dimensiones - Precio
170cm x 249cm - 3,530.00 € 1,059.00 €
PAK. SILK TOUCH 906-204-1.46-70%
PAK. SILK TOUCH 906-204-1.46
100% Wool,Silk Handknotted.
Dimensiones - Precio
93cm x 157cm - 1,287.00 € 386.10 €
ZIEGLER 904-347-4.80-70%
ZIEGLER 904-347-4.80
100% Wool, Handknotted.
Dimensiones - Precio
182cm x 264cm - 4,007.00 € 1,202.10 €
DAVINCI 57011-6424
DAVINCI 57011-6424
100% Acrylic
Dimensiones - Precio
200cm x 290cm - 495.00 €
CHOBI CB09 5658
CHOBI CB09 5658
100% Wool,Machine Woven.
Dimensiones - Precio
130cm x 190cm - 444.00 €
164cm x 230cm - 654.00 €
ZIEGLER 904-347-5.70-70%
ZIEGLER 904-347-5.70
100% Wool, Handknotted.
Dimensiones - Precio
200cm x 285cm - 4,754.00 € 1,426.20 €
SAROUK INDIA 15-41092-70%
SAROUK INDIA 15-41092
100% Wool Handknotted
Dimensiones - Precio
200cm x 248cm - 3,690.00 € 1,107.00 €
TUNISIAN CLASSIC MONAS RED
TUNISIAN CLASSIC MONAS RED
100% Acrylic.
Dimensiones - Precio
160cm x 230cm - 409.00 €
200cm x 290cm - 649.00 €
LYDIA A487D CHERRY
LYDIA A487D CHERRY
100% Heatset.
Dimensiones - Precio
200cm x 300cm - 156.00 €
300cm x 400cm - 312.00 €
ORIENT MIXED 902-103-2.51-70%
ORIENT MIXED 902-103-2.51
100% Wool, Handknotted.
Dimensiones - Precio
125cm x 201cm - 1,960.00 € 588.00 €
ORIENT MIXED 902-103-4.01-70%
ORIENT MIXED 902-103-4.01
100% Wool, Handknotted.
Dimensiones - Precio
170cm x 236cm - 3,129.00 € 938.70 €
ORIENT MIXED 902-103-2.04-70%
ORIENT MIXED 902-103-2.04
100% Wool, Handknotted.
Dimensiones - Precio
120cm x 170cm - 1,591.00 € 477.30 €
VENUS 17520-695-25%
VENUS 17520-695
100% Acrylic.
Dimensiones - Precio
200cm x 290cm - 415.00 € 311.25 €
ZIEGLER 1594 IVORY RED
ZIEGLER 1594 IVORY RED
100% Heatset Frise.
Dimensiones - Precio
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ORIENT MIXED 902-103-2.98-70%
ORIENT MIXED 902-103-2.98
100% Wool, Handknotted.
Dimensiones - Precio
140cm x 213cm - 2,326.00 € 697.80 €
ARTEMIS 1266 RED
ARTEMIS 1266 RED
100% Heatset
Dimensiones - Precio
160cm x 230cm - 125.00 €
200cm x 290cm - 199.00 €
SAROUK INDIA 15-41123-70%
SAROUK INDIA 15-41123
100% Wool Handknotted
Dimensiones - Precio
195cm x 292cm - 4,235.00 € 1,270.50 €
ORIENT MIXED 902-103-3.64-70%
ORIENT MIXED 902-103-3.64
100% Wool, Handknotted.
Dimensiones - Precio
162cm x 225cm - 2,843.00 € 852.90 €
ORIENT MIXED 902-103-6.70-70%
ORIENT MIXED 902-103-6.70
100% Wool, Handknotted.
Dimensiones - Precio
213cm x 315cm - 5,233.00 € 1,569.90 €
TASHKENT 613-616 580 CREAM
TASHKENT 613-616 580 CREAM
100% Acrylic Machine Woven
Dimensiones - Precio
200cm x 285cm - 400.00 €
FEDORA GREY D.GREEN
FEDORA GREY D.GREEN
100% Heatset.
Dimensiones - Precio
133cm x 195cm - 189.00 €
FERAHAN 824/1040-80%
FERAHAN 824/1040
100% Wool.
Dimensiones - Precio
250cm x 300cm - 2,350.00 € 470.00 €
DAVINCI 57060-1464
DAVINCI 57060-1464
100% Acrylic
Dimensiones - Precio
200cm x 290cm - 495.00 €
ELIF 1263 CREAM 1-50%
ELIF 1263 CREAM 1
60% New Zealand wool,40% Acrylic.
Dimensiones - Precio
200cm x 250cm - 500.00 € 250.00 €
200cm x 300cm - 600.00 € 300.00 €
250cm x 300cm - 750.00 € 375.00 €
ARTEMIS 1267 RED
ARTEMIS 1267 RED
100% Heatset
Dimensiones - Precio
160cm x 230cm - 125.00 €
200cm x 290cm - 199.00 €

es-ES

Todo el material, en cualquier forma, en este sitio está protegido por copyright y por el griego y el derecho internacional. El material de este sitio puede ser utilizado sólo para uso personal. Nada en este sitio, especialmente las fotos y los vídeos de nuestros productos no pueden ser copiados, modificados, publicados o distribuidos de ninguna manera sin permiso previo de Doup.gr.