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
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
OQAN CLASICO
ORTOLA
PALATINO
SIELAM
STENTOR
YAMAHA
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€
VIOLIN OUTFIT 1/2 G0047 STANDARD ORTOLA
67,16€
VIOLÍN AMADEUS VA-101 1/8
75,00€
VIOLIN OUTFIT 1/4 G0048 STANDARD ORTOLA
67,16€
VIOLÍN AMADEUS VA-101 3/4
75,00€
VIOLIN OUTFIT 1/8 1421-1 STANDARD ORTOLA
67,16€
VIOLÍN AMADEUS VA-101 4/4
75,00€
VIOLIN OUTFIT 3/4 STANDARD ORTOLA
67,16€
VIOLIN OUTFIT 4/4 STANDARD ORTOLA
67,16€
VIOLIN YAMAHA V3SKA44 V3SKA44
296,00€
VIOLIN ELECTRICO YAMAHA SV-250 BROWN
1.759,20€
VIOLIN ELECTRICO YAMAHA SV-255 BROWN
1.827,20€
VIOLIN YAMAHA V10G
743,20€
VIOLIN YAMAHA V10SG
1.160,00€
VIOLIN YAMAHA V20G
1.472,00€
VIOLIN YAMAHA V3SKA12
296,00€
VIOLIN YAMAHA V3SKA34
296,00€
VIOLIN YAMAHA V5 SA 1/2
376,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES