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
YAMAHA
VIOLA HERITAGE HA420 16,5"
PVP: 814,79€
692,57€
VIOLA MESSINA 15"
PVP: 597,57€
519,89€
VIOLA MESSINA 15,5"
PVP: 597,57€
519,89€
VIOLA STENTOR CONSERVATOIRE 14" SET
PVP: 390,50€
339,73€
VIOLA STENTOR CONSERVATOIRE 15" SET
PVP: 390,50€
339,73€
VIOLA STENTOR CONSERVATOIRE 15,5" SET
PVP: 390,50€
339,73€
VIOLA STENTOR CONSERVATOIRE 16" SET
PVP: 390,50€
339,73€
VIOLA STENTOR MESSINA 15" EN BLANCO
PVP: 284,70€
247,69€
VIOLA STENTOR MESSINA 15,5" EN BLANCO
PVP: 284,70€
247,69€
VIOLA STENTOR MESSINA 16" EN BLANCO
PVP: 284,70€
247,69€
VIOLA STENTOR STUDENT I 12" SET
PVP: 201,01€
174,88€
VIOLA STENTOR STUDENT I 13" SET
PVP: 201,01€
174,88€
VIOLA STENTOR STUDENT I 14" SET
PVP: 201,01€
174,88€
VIOLA STENTOR STUDENT I 15" SET
PVP: 201,01€
174,88€
VIOLA STENTOR STUDENT II SH 12" SET
PVP: 235,50€
204,88€
VIOLA STENTOR STUDENT II SH 13" SET
PVP: 235,50€
204,88€
VIOLA STENTOR STUDENT II SH 14"
PVP: 235,50€
204,88€
VIOLA STENTOR STUDENT II SH 15" SET
PVP: 247,09€
214,97€
VIOLA ELECTRICA YAMAHA SVV200 BR BROWN
PVP: 2.101,00€
1.680,80€
VIOLA STENTOR STUDENT II SH 15.5" SET
PVP: 247,09€
214,97€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES