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 '%,4,%' OR a.t_stanze LIKE '%4,%') 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 0,11
Tappeti da Cucina in Design Contemporaneo | Morandi Tappeti
0 0
PANDERMA
Morandi Tappeti In stock
PANDERMA
cod. 10084
cm 125 x 180

250

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10126
cm 193 x 286

250

ERIVAN
Morandi Tappeti In stock
ERIVAN
cod. 10123
cm 198 x 194

450

AZERBAIDJAN
Morandi Tappeti In stock
AZERBAIDJAN
cod. 10119
cm 78 x 119

250

GURE
Morandi Tappeti In stock
GURE
cod. 10077
cm 61 x 203

200

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10118
cm 173 x 239

230

CANAKKALE
Morandi Tappeti In stock
CANAKKALE
cod. 10082
cm 130 x 195

500

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10117
cm 200 x 234

240

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10116
cm 200 x 202

200

KAISERI
Morandi Tappeti In stock
KAISERI
cod. 10066
cm 200 x 304

1.300

KELARDASHT
Morandi Tappeti In stock
KELARDASHT
cod. 10050
cm 207 x 285

1.450

KILIM KASKAI
Morandi Tappeti In stock
KILIM KASKAI
cod. 9918
cm 140 x 235

500