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_stanze LIKE '%,9,%' OR a.t_stanze LIKE '%9,%') 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_id DESC LIMIT 0,11
Tappeti pregiati da Collezione, | Morandi Tappeti
0 0
KAZAK LORI PAMPAK
Morandi Tappeti In stock
KAZAK LORI PAMPAK
cod. 9944
cm 144 x 246

2.500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9942
cm 118 x 210

1.500

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

2.200

KARAMAN
Morandi Tappeti In stock
KARAMAN
cod. 9929
cm 139 x 211

3.500

FERAHAN
Morandi Tappeti In stock
FERAHAN
cod. 9927
cm 135 x 200

2.500

ARMENIA
Morandi Tappeti In stock
ARMENIA
cod. 9919
cm 141 x 213

1.500

MAGMA
Morandi Tappeti In stock
MAGMA
cod. 9902
cm 197 x 292

5.000

KIRMAN RAVER
Morandi Tappeti In stock
KIRMAN RAVER
cod. 9926
cm 132 x 194

2.500

AGRA VECCHIO
Morandi Tappeti In stock
AGRA VECCHIO
cod. 9924
cm 125 x 208

500

KAZAK LORI PAMPAK
Morandi Tappeti In stock
KAZAK LORI PAMPAK
cod. 9923
cm 128 x 202

8.500

SHIRVAN
Morandi Tappeti In stock
SHIRVAN
cod. 9922
cm 112 x 183

1.000

BALIKESIR
Morandi Tappeti In stock
BALIKESIR
cod. 9220
cm 142 x 265

1.500