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 ELECTRICA YAMAHA SVV200 BR BROWN
1.616,00€
VIOLA GLIGA GENIAL I 13
281,70€
VIOLA GLIGA GENIAL I 14
281,70€
VIOLA GLIGA GENIAL I 15
310,50€
VIOLA GLIGA GENIAL I 15,5
310,50€
VIOLA GLIGA GENIAL I 16
310,50€
VIOLA GLIGA GENIAL I 16,5
310,50€
VIOLA GLIGA GENIAL III 13
229,99€
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 ESTUDIO 14\" KARPATHI 1433-A
138,00€
VIOLA ESTUDIO 15\" KARPATHI 1433-A
153,00€
VIOLA ESTUDIO 15½\" KARPATHI 1433-A
153,00€
VIOLA STENTOR CONSERVATOIRE 14
337,50€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES