SELECT a.* from ARTICULOS a, MARCAS m WHERE m.Codigo=a.Cod_Marca and m.Activo <> 'N' and a.Cod_Familia <> 0 and a.Borrado <> 'S' AND Cod_Subfamilia = 39 LIMIT 0, 20
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
STENTOR
YAMAHA
VIOLA CARLO GIORDANO VL1 12"
197,20€
VIOLA CARLO GIORDANO VL1 13"
197,20€
VIOLA CARLO GIORDANO VL1 14"
197,20€
VIOLA CARLO GIORDANO VL1 15"
197,20€
VIOLA CARLO GIORDANO VL1 16"
197,20€
VIOLA CARLO GIORDANO VL2 16"
505,75€
VIOLA HÖFNER-ALFRED S.160 13"
264,35€
VIOLA HÖFNER-ALFRED S.160 15"
397,80€
VIOLA HÖFNER-ALFRED S.160 16"
397,80€
VIOLA HÖFNER-ALFRED S.60 13"
242,25€
VIOLA HÖFNER-ALFRED S.60 14"
242,25€
VIOLA HÖFNER-ALFRED S.60 15"
260,10€
VIOLA HÖFNER-ALFRED S.60 16"
260,10€
VIOLA ESTUDIO 14\" KARPATHI 1433-A
138,00€
VIOLA ESTUDIO 15\" KARPATHI 1433-A
153,00€
VIOLA ESTUDIO 15½\" KARPATHI 1433-A
153,00€
VIOLA GLIGA GENIAL I 13
281,70€
VIOLA GLIGA GENIAL I 14
281,70€
VIOLA GLIGA GENIAL I 15
310,50€
VIOLA GLIGA GENIAL I 15,5
310,50€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES