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
VIOLINES
AMADEUS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
OQAN
ORTOLA
Rapsody
SIELAM
STAGG
Stentor
YAMAHA
VIOLIN OUTFIT 4/4 STANDARD ORTOLA
PVP: 74,60€
67,14€
VIOLÍN AMADEUS VA-101 1/16
75,00€
VIOLÍN AMADEUS VA-101 1/2
75,00€
VIOLÍN AMADEUS VA-101 1/4
75,00€
VIOLÍN AMADEUS VA-101 1/8
75,00€
VIOLÍN AMADEUS VA-101 3/4
75,00€
VIOLÍN AMADEUS VA-101 4/4
75,00€
VIOLIN ELECTRICO YAMAHA SV-250 BROWN
PVP: 2.287,00€
1.829,60€
VIOLIN ELECTRICO YAMAHA SV-255 BROWN
PVP: 2.376,00€
1.900,80€
VIOLIN YAMAHA V10G
PVP: 966,00€
772,80€
VIOLIN YAMAHA V10SG
PVP: 1.508,00€
1.206,40€
VIOLIN YAMAHA V20G
PVP: 1.914,00€
1.531,20€
VIOLIN ELECTRICO STAGG EVN 4/4
PVP: 244,00€
187,00€
VIOLIN YAMAHA V3SKA12
PVP: 385,00€
308,00€
VIOLIN YAMAHA V3SKA34
PVP: 385,00€
308,00€
VIOLIN YAMAHA V5 SA 1/2
PVP: 489,00€
391,20€
VIOLIN ANTONIO WANG VERONA 4/4 EN BLANC
PVP: 1.853,44€
1.575,42€
VIOLIN YAMAHA V5 SA 3/4
PVP: 489,00€
391,20€
VIOLIN STENTOR HARLEQUIN 4/4 AZUL
PVP: 168,58€
146,66€
VIOLIN YAMAHA V5 SA 4/4
PVP: 489,00€
391,20€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES