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 = 42 AND Cod_Subsubfamilia = 67 LIMIT 0, 20
AUBERT
CARLO GIORDANO
DADDARIO ORCHESTRAL
DICK
Hercules
HIDERSINE
HÖFNER
JARGAR
KARPATHI
KONIG & MEYER
KREUTZER
NEO
ORTOLA
PALATINO
PIRASTRO
PRODIPE
PYRAMID
ROTOSOUND
THOMASTIK
WITTNER
WOLF
XEROS
YAMAHA
ESTUCHE CELLO FIBRA CARBONO CFC-3 CARLO GIORDANO
552,50€
ESTUCHE DE FIBRA DE VIDRIO CARLO GIORDANO CELLO 4/4 ROJO
323,00€
ESTUCHE DE FIBRA DE VIDRIO CARLO GIORDANO CELLO 4/4 VERDE
323,00€
ARCO CELLO HÖFNER AS23 1/2
53,55€
ARCO CELLO HÖFNER AS23 1/4
53,55€
ARCO CELLO HÖFNER AS23 1/8
53,55€
ARCO CELLO HÖFNER AS23 3/4
53,55€
ARCO CELLO HÖFNER AS23 4/4
53,55€
ARCO FIBRA DE CARBONO CELLO HÖFNER AS34 1/2
114,75€
ARCO FIBRA DE CARBONO CELLO HÖFNER AS34 3/4
114,75€
ARCO FIBRA DE CARBONO CELLO HÖFNER AS34 4/4
114,75€
FUNDA CELLO HÖFNER 1/2
99,00€
FUNDA CELLO HÖFNER 1/4
99,00€
FUNDA CELLO HÖFNER 1/8
99,00€
FUNDA CELLO HÖFNER 3/4
99,00€
FUNDA CELLO HÖFNER 4/4
99,00€
ARCO CELLO PALATINO 1/2
35,00€
ARCO CELLO PALATINO 1/4
35,00€
ARCO CELLO PALATINO 3/4
35,00€
ARCO CELLO PALATINO 4/4
35,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES