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
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
Rapsody
SIELAM
Stentor
VALLEST
YAMAHA
VIOLA STENTOR STUDENT I 12" SET
174,88€
VIOLA STENTOR STUDENT I 13" SET
174,88€
VIOLA STENTOR STUDENT I 14" SET
174,88€
VIOLA STENTOR STUDENT I 15" SET
174,88€
VIOLA SIELAM ESPRESSIVO 11
238,49€
VIOLA STENTOR STUDENT II SH 12" SET
204,89€
VIOLA SIELAM ESPRESSIVO 16
238,49€
VIOLA STENTOR STUDENT II SH 13" SET
204,89€
VIOLA STENTOR STUDENT II SH 14"
204,89€
VIOLA STENTOR STUDENT II SH 15" SET
214,97€
VIOLA STENTOR STUDENT II SH 15.5" SET
214,97€
VIOLA ELECTRICA YAMAHA SVV200 BR BROWN
1.616,00€
VIOLA STENTOR STUDENT I 13" SET (B-STOCK)
174,88€
VIOLA STENTOR STUDENT II SH 16" SET
214,97€
VIOLA YAMAHA VA5S TALLA 13
453,60€
VIOLA YAMAHA VA5S TALLA 14
453,60€
VIOLA YAMAHA VA5S TALLA 15
490,40€
VIOLA YAMAHA VA5S TALLA 15 . 5
490,40€
VIOLA YAMAHA VA5S TALLA 16
510,40€
VIOLA YAMAHA VA5S TALLA 16 . 5
510,40€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES