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 = 22 AND Cod_Subsubfamilia = 29 LIMIT 0, 20
SORDINAS
DENIS WICK
J.MICHAEL
ON STAGE STANDS
ORTOLA
SAETA
SML PARIS
YAMAHA
SORDINA TROMPETA ON STAGE TCM7530
22,00€
SORDINA TROMPETA ON STAGE TCM7520
22,00€
SORDINA TROMPETA SML PARIS ASMSOURTPE
35,49€
SORDINA TROMPETA SML PARIS ASMSOURTPD
44,28€
SORDINA TROMPETA SML PARIS ASMSOURTPW
48,75€
SORDINA TROMPETA PRACTICE 3X STANDARD ORTOLA
23,98€
SORDINA TROMPETA PRACTICE JX STANDARD ORTOLA
34,24€
SORDINA TROMPETA STRAIGHT 1 STANDARD ORTOLA
13,68€
SORDINA TROMBON STRAIGHT 1 STANDARD ORTOLA
41,13€
SORDINA TROMPA BOUCHE 1 STANDARD ORTOLA
68,53€
SORDINA CORNETA SAETA
15,00€
SORDINA YAMAHA PM3X PARA FRENCH HORN
149,07€
SORDINA YAMAHA PM5X PARA TROMBONE
135,52€
SORDINA YAMAHA PM6X PARA FLUGELHORN
135,52€
SORDINA YAMAHA PM7X PARA TROMPETA
88,09€
SILENT BRASS YAMAHA SB1X PARA TUBA
559,50€
SILENT BRASS YAMAHA SB2X PARA EUPHONIUM
279,75€
SILENT BRASS YAMAHA SB3X 02 PARA FRENCH HORN
204,25€
SILENT BRASS YAMAHA SB5X 02 PARA TROMBONE
198,44€
SILENT BRASS YAMAHA SB6X 02 PARA FLUTELHORN
198,44€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES