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 84,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
FETYE
Morandi Tappeti In stock
FETYE
cod. 9593
cm 146 x 225

1.500

INCONTRI
Morandi Tappeti In stock
INCONTRI
cod. 9572
cm 179 x 252

3.600

NAIN
Morandi Tappeti In stock
NAIN
cod. 9585
cm 171 x 250

3.800

BLOOD
Morandi Tappeti In stock
BLOOD
cod. 9569
cm 243 x 310

9.000

MARA
Morandi Tappeti In stock
MARA
cod. 9571
cm 160 x 253

5.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9582
cm 242 x 310

3.700

DJOSAN
Morandi Tappeti In stock
DJOSAN
cod. 9580
cm 138 x 215

1.500

INCONTRI
Morandi Tappeti In stock
INCONTRI
cod. 9568
cm 254 x 308

5.000

BESHIR
Morandi Tappeti In stock
BESHIR
cod. 9578
cm 158 x 382

8.500

SUMAK
Morandi Tappeti In stock
SUMAK
cod. 9577
cm 165 x 201

4.350

ILLUSION
Morandi Tappeti In stock
ILLUSION
cod. 9567
cm 276 x 380

15.000

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9705
cm 153 x 197

270