SELECT a.t_id, a.t_codice, a.t_nome, a.t_outlet, a.t_sconto_outlet, a.t_larghezza, a.t_lunghezza, a.t_prezzo, a.t_prezzodef, a.t_url, c.nomeITA AS nomecategoria FROM tappeti AS a, categoria AS b, categoria AS c, tappeti_categorie AS d, provenienze AS e WHERE d.tappeto = a.t_id AND d.categoria = b.id AND b.parent = c.id AND a.t_provenienza = e.p_id AND (a.t_colore LIKE '%,29,%') AND t_stato!=2 AND t_stato!=5 AND t_stato!=3 AND (t_status=1) AND ( (d.categoria != 41) AND (d.categoria != 42) AND (d.categoria != 45) AND (d.categoria != 56) ) ORDER BY (t_larghezza * t_lunghezza) DESC LIMIT 96,11
Tappeti Rossi Annodati a Mano | Morandi Tappeti
0 0
BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9355
cm 120 x 185

1.200

MISHAN MALAYER
Morandi Tappeti In stock
MISHAN MALAYER
cod. 9934
cm 129 x 170

2.200

MARASALI
ora in outlet
Morandi Tappeti In stock
MARASALI
cod. 8351
cm 138 x 158

€ 7.200 5.040

ANTALYA
Morandi Tappeti In stock
ANTALYA
cod. 9006
cm 116 x 172

500

DAGHESTAN
Morandi Tappeti In stock
DAGHESTAN
cod. 9545
cm 107 x 180

350

URGUP
Morandi Tappeti In stock
URGUP
cod. 0536
cm 110 x 170

2.100

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 3187
cm 116 x 146

1.500

FERAHAN
Morandi Tappeti In stock
FERAHAN
cod. 9874
cm 106 x 156

3.850

KUM SETA
Morandi Tappeti In stock
KUM SETA
cod. 9858
cm 107 x 152

1.200

KASKULI
Morandi Tappeti In stock
KASKULI
cod. 3350
cm 82 x 195

960

BELUCI
Morandi Tappeti In stock
BELUCI
cod. 9822
cm 96 x 163

100

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9702
cm 151 x 200

250