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 72,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9834
cm 260 x 340

5.000

PECHINO
Morandi Tappeti In stock
PECHINO
cod. 9836
cm 150 x 155

4.850

GHIORDES
Morandi Tappeti In stock
GHIORDES
cod. 9830
cm 130 x 175

12.800

KASHAN MOHTASHEM
Morandi Tappeti In stock
KASHAN MOHTASHEM
cod. 9835
cm 230 x 300

27.000

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9821
cm 119 x 182

3.800

KIRMAN LAVER
Morandi Tappeti In stock
KIRMAN LAVER
cod. 9590
cm 197 x 300

1.250

BIBIKABAD
Morandi Tappeti In stock
BIBIKABAD
cod. 9589
cm 128 x 203

2.500

GHAZNI
Morandi Tappeti In stock
GHAZNI
cod. 9711
cm 173 x 239

2.500

GHAZNI
Morandi Tappeti In stock
GHAZNI
cod. 9697
cm 170 x 252

2.500

GHAZNI
Morandi Tappeti In stock
GHAZNI
cod. 9741
cm 200 x 315

3.000

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9795
cm 141 x 219

3.200

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9706
cm 145 x 192

250