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 60,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
MAHAJERAN
Morandi Tappeti In stock
MAHAJERAN
cod. 9855
cm 130 x 200

6.800

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9844
cm 280 x 380

3.500

KIRMAN RAVER
Morandi Tappeti In stock
KIRMAN RAVER
cod. 9839
cm 130 x 198

3.800

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9856
cm 128 x 200

3.450

KASHAN MOHTASHEM
Morandi Tappeti In stock
KASHAN MOHTASHEM
cod. 9854
cm 236 x 330

50.000

MAHAJERAN
Morandi Tappeti In stock
MAHAJERAN
cod. 9852
cm 265 x 365

11.000

KASHAN MANCHESTER
Morandi Tappeti In stock
KASHAN MANCHESTER
cod. 9840
cm 175 x 275

8.700

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9845
cm 235 x 297

3.300

CI CI
Morandi Tappeti In stock
CI CI
cod. 9843
cm 122 x 198

5.000

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9833
cm 248 x 308

5.000

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9829
cm 149 x 198

2.500

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9708
cm 156 x 196

300