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 96,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
GABBEH
Morandi Tappeti In stock
GABBEH
cod. 9558
cm 163 x 224

1.000

BERKANA
Morandi Tappeti In stock
BERKANA
cod. 9557
cm 200 x 245

1.000

FERAHAN
Morandi Tappeti In stock
FERAHAN
cod. 9553
cm 122 x 190

4.800

CI CI
Morandi Tappeti In stock
CI CI
cod. 9552
cm 139 x 205

8.500

STAR KAZAK
Morandi Tappeti In stock
STAR KAZAK
cod. 9551
cm 153 x 210

2.200

TIBET SMERALDO
Morandi Tappeti In stock
TIBET SMERALDO
cod. 9550
cm 81 x 141

1.000

DAGHESTAN
Morandi Tappeti In stock
DAGHESTAN
cod. 9545
cm 107 x 180

350

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9539
cm 125 x 185

1.200

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 9548
cm 143 x 336

6.500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9536
cm 145 x 213

1.500

HYDERABAD
ora in outlet
Morandi Tappeti In stock
HYDERABAD
cod. 9518
cm 249 x 301

€ 3.500 1.750

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9704
cm 154 x 209

290