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_colore LIKE '%,29,%') 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_prezzodef DESC LIMIT 12,11
Tappeti Rossi Annodati a Mano | Morandi Tappeti
0 0
BERGAMA
Morandi Tappeti In stock
BERGAMA
cod. 9868
cm 180 x 191

7.850

TIBET
Morandi Tappeti In stock
TIBET
cod. 8675
cm 242 x 307

7.300

SEIKHUR
Morandi Tappeti In stock
SEIKHUR
cod. 8366
cm 124 x 310

7.200

LUSSURIA
Morandi Tappeti In stock
LUSSURIA
cod. 7651
cm 255 x 306

7.200

TORMENTO
Morandi Tappeti In stock
TORMENTO
cod. 9241
cm 247 x 306

6.800

TIBET SMERALDO
Morandi Tappeti In stock
TIBET SMERALDO
cod. 9240
cm 241 x 304

6.500

KAZAK BORDJALOU
Morandi Tappeti In stock
KAZAK BORDJALOU
cod. 4098
cm 140 x 246

6.400

TIBET
Morandi Tappeti In stock
TIBET
cod. 8975
cm 242 x 304

6.100

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8701
cm 273 x 374

5.800

MARASALI
ora in outlet
Morandi Tappeti In stock
MARASALI
cod. 8351
cm 138 x 158

€ 7.200 5.040

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9834
cm 260 x 340

5.000

KUBA KILIM
Morandi Tappeti In stock
KUBA KILIM
cod. 8179
cm 120 x 415

1.500