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 '%,6,%' OR a.t_stanze LIKE '%6,%') 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 24,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9895
cm 173 x 244

2.500

MARASALI
Morandi Tappeti In stock
MARASALI
cod. 9876
cm 120 x 141

5.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9894
cm 171 x 247

2.500

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

3.850

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9893
cm 171 x 243

2.500

GOOM
Morandi Tappeti In stock
GOOM
cod. 9875
cm 142 x 213

2.400

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9891
cm 171 x 241

2.500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9890
cm 200 x 302

3.000

SEIKHUR
Morandi Tappeti In stock
SEIKHUR
cod. 9915
cm 128 x 230

1.500

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 9914
cm 142 x 208

2.500

GOOM
Morandi Tappeti In stock
GOOM
cod. 9913
cm 130 x 202

500

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9765
cm 106 x 150

150