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
VIOLINES ELECTRICOS
AMADEUS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
OQAN
ORTOLA
Rapsody
SIELAM
STAGG
Stentor
VALLEST
YAMAHA
VIOLIN CARLO GIORDANO VS15 1/2
PVP: 215,00€
182,75€
VIOLIN CARLO GIORDANO VS15 1/4
PVP: 215,00€
182,75€
VIOLIN SIELAM ESPRESSIVO 1/32
PVP: 241,40€
217,26€
VIOLIN CARLO GIORDANO VS15 3/4
PVP: 215,00€
182,75€
VIOLIN SIELAM ESPRESSIVO 4/4
PVP: 241,40€
217,26€
VIOLIN CARLO GIORDANO VS15 4/4
PVP: 215,00€
182,75€
VIOLIN CARLO GIORDANO VS2 1/2
PVP: 435,00€
369,75€
VIOLIN CARLO GIORDANO VS2 3/4
PVP: 435,00€
369,75€
VIOLIN CARLO GIORDANO VS2 4/4
PVP: 460,00€
391,00€
VIOLIN CARLO GIORDANO VS3 4/4
PVP: 555,00€
471,75€
VIOLIN CARLO GIORDANO VS4 4/4
PVP: 775,00€
658,75€
VIOLIN ELECTRIFICADO CARLO GIORDANO 4/4
PVP: 295,00€
250,75€
VIOLIN ELECTRIFICADO CARLO GIORDANO EV202 4/4 NEGRO
PVP: 295,00€
250,75€
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 ELÉCTRICO HÖFNER 4/4
PVP: 490,00€
416,50€
VIOLIN HÖFNER H115-AS-V 4/4
PVP: 1.500,00€
1.275,00€
VIOLIN HÖFNER H115-GG-V 4/4
PVP: 1.625,00€
1.381,25€
VIOLÍN STENTOR HARLEQUIN 1/4 BLANCO
PVP: 168,58€
146,66€
VIOLIN HÖFNER H5DV 3/4
PVP: 525,00€
446,25€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES