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_prezzodef DESC LIMIT 60,11
Tappeti Rossi Annodati a Mano | Morandi Tappeti
0 0
BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8706
cm 164 x 242

2.300

YOMUT MAFRASH
Morandi Tappeti In stock
YOMUT MAFRASH
cod. 8748
cm 39 x 75

2.200

STAR KAZAK
Morandi Tappeti In stock
STAR KAZAK
cod. 9551
cm 153 x 210

2.200

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

2.200

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 3186
cm 125 x 190

2.200

GHAZNI
Morandi Tappeti In stock
GHAZNI
cod. 9828
cm 196 x 304

2.200

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

2.100

RELOADED-ZEKI MUREN
Morandi Tappeti In stock
RELOADED-ZEKI MUREN
cod. 6195
cm 136 x 265

2.000

LORI GABBEH
Morandi Tappeti In stock
LORI GABBEH
cod. 3913
cm 174 x 238

2.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9187
cm 197 x 200

1.900

AGRA
Morandi Tappeti In stock
AGRA
cod. 4181
cm 125 x 316

1.800

DENIZILI KILIM
Morandi Tappeti In stock
DENIZILI KILIM
cod. 8338
cm 94 x 237

500