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 48,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
MAHAJERAN
Morandi Tappeti In stock
MAHAJERAN
cod. 9870
cm 257 x 310

9.500

TIBET
Morandi Tappeti In stock
TIBET
cod. 9879
cm 205 x 305

4.200

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9878
cm 173 x 238

2.500

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9871
cm 167 x 244

8.200

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9877
cm 200 x 301

3.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9880
cm 206 x 256

3.000

KASHAN MOHTASHEM
Morandi Tappeti In stock
KASHAN MOHTASHEM
cod. 9869
cm 143 x 208

11.300

BERGAMA
Morandi Tappeti In stock
BERGAMA
cod. 9868
cm 180 x 191

7.850

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 9867
cm 275 x 387

2.500

TABRIZ HAJI JALILI
Morandi Tappeti In stock
TABRIZ HAJI JALILI
cod. 9862
cm 275 x 383

15.500

SHIRVAN
Morandi Tappeti In stock
SHIRVAN
cod. 9861
cm 105 x 202

4.800

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9709
cm 156 x 197

280