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 = 20 LIMIT 0, 20
OBOES
VARIOS ACCESORIOS VIENTO
BUFFET CRAMPON
BULGHERONI
CONSOLAT DE MAR
J.MICHAEL
SANKYO
YAMAHA
OBOE CONSOLAT DE MAR OB-582
1.275,00€
OBOE BUFFET CRAMPON BC4062-2-0 PRODIGE
3.213,00€
OBOE STANDARD BULGHERONI 091/3
2.609,24€
OBOE CONSERVATORY BULGHERONI 101/3
3.522,72€
OBOE STANDARD BULGHERONI 091/3-ART-TF
2.865,90€
OBOE BUFFET CRAMPON BC4057-2N-0 ESTUDIO
3.484,80€
OBOE BUFFET CRAMPON BC4011-2N-0 ESTUDIO
1.732,50€
OBOE GREEN LINE BUFFET CRAMPON BC3613G-2-0
7.974,00€
OBOE GREEN LINE BUFFET CRAMPON BC3663G-2-0 ORFEO
7.974,00€
OBOE BUFFET CRAMPON BC4030-2-0 PRODIGE
1.960,20€
OBOE BUFFET PRODIGE ESTUDIO 4161-2-0
2.263,50€
OBOE BUFFET CRAMPON BC4121-2N-0 ESTUDIO
1.554,30€
OBOE YAMAHA YOB 241
1.459,00€
OBOE YAMAHA YOB 431
2.845,00€
OBOE YAMAHA YOB 831
A CONSULTAR
OBOE YAMAHA YOB 831E
A CONSULTAR
OBOE YAMAHA YOB 832
A CONSULTAR
OBOE YAMAHA YOB 832 F
A CONSULTAR
OBOE YAMAHA YOB 832E
A CONSULTAR
OBOE YAMAHA YOB-241 LLAVE DE FA
1.866,30€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES