SELECT a.* from ARTICULOS a, MARCAS m, PROVEEDORES p WHERE m.Codigo=a.Cod_Marca and a.Proveedor=p.Codigo and m.Activo <> 'N' and a.Cod_Familia <> 0 and a.Borrado <> 'S' and p.Activo <> 'N' AND Cod_Subfamilia = 39 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
VIOLAS
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
SIELAM
STENTOR
YAMAHA
VIOLA GLIGA GENIAL III 14
229,99€
VIOLA GLIGA GENIAL III 15
257,40€
VIOLA GLIGA GENIAL III 15,5
257,40€
VIOLA GLIGA GENIAL III 16
257,40€
VIOLA KREUTZER SCHOOL 12
137,65€
VIOLA KREUTZER SCHOOL 13
137,65€
VIOLA KREUTZER SCHOOL 14
140,86€
VIOLA KREUTZER SCHOOL 15
140,86€
VIOLA STENTOR CONSERVATOIRE 14
337,50€
VIOLA STENTOR CONSERVATOIRE 15
337,50€
VIOLA STENTOR CONSERVATOIRE 15,5
337,50€
VIOLA STENTOR CONSERVATOIRE 16
337,50€
VIOLA STENTOR MESSINA 15"
515,70€
VIOLA STENTOR MESSINA 15,5"
515,70€
VIOLA STENTOR MESSINA 16"
515,70€
VIOLA STENTOR STUDENT I 12
173,70€
VIOLA STENTOR STUDENT I 13
173,70€
VIOLA STENTOR STUDENT I 14
173,70€
VIOLA STENTOR STUDENT I 15
173,70€
VIOLA STENTOR STUDENT II 14
203,40€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES