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 = 38 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20

VIOLIN
VIOLINES
AMADEUS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
OQAN
ORTOLA
Rapsody
SIELAM
STAGG
Stentor
VALLEST
YAMAHA
VIOLIN YAMAHA V5 SA 1/2
PVP: 470,00€
376,00€
VIOLIN SIELAM ESPRESSIVO 1/32
PVP: 241,40€
217,26€
VIOLIN SIELAM ESPRESSIVO 4/4
PVP: 241,40€
217,26€
VIOLIN YAMAHA V5 SA 3/4
PVP: 470,00€
376,00€
VIOLIN YAMAHA V5 SA 4/4
PVP: 470,00€
376,00€
VIOLIN YAMAHA V5SA TALLA 1/4
PVP: 470,00€
376,00€
VIOLIN YAMAHA V5SA TALLA 1/8
PVP: 470,00€
376,00€
VIOLIN YAMAHA V5SC TALLA 1/2
PVP: 518,00€
414,40€
VIOLIN YAMAHA V5SC TALLA 1/4
PVP: 518,00€
414,40€
VIOLIN YAMAHA V5SC TALLA 1/8
PVP: 518,00€
414,40€
VIOLIN YAMAHA V5SC TALLA 3/4
PVP: 518,00€
414,40€
VIOLIN YAMAHA V5SC TALLA 4/4
PVP: 518,00€
414,40€
VIOLIN YAMAHA V7SG TALLA 1/8
PVP: 913,00€
730,40€
VIOLIN YAMAHA V7SG TALLA 1/4
PVP: 913,00€
730,40€
VIOLÍN STENTOR HARLEQUIN 1/4 BLANCO
PVP: 168,58€
146,66€
VIOLIN YAMAHA V7SG TALLA 1/2
PVP: 913,00€
730,40€
VIOLIN GLIGA GAMA II 4/4
PVP: 872,00€
784,80€
VIOLIN GLIGA GEMS I 4/4
PVP: 500,00€
450,00€
VIOLIN YAMAHA V7SG TALLA 3/4
PVP: 913,00€
730,40€
VIOLIN GLIGA GEMS II 4/4
PVP: 323,00€
290,70€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES