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 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
OBOES
VARIOS ACCESORIOS VIENTO
BUFFET CRAMPON
BULGHERONI
CONSOLAT DE MAR
J.MICHAEL
SANKYO
YAMAHA
CABEZA FLAUTA SANKYO HJ925-ST2
945,00€
CABEZA FLAUTA SANKYO HJ925-RT2
945,00€
CABEZA FLAUTA SANKYO HJ925-FT
945,00€
OBOE BUFFET ESTUDIO 4151-2N-0
1.870,42€
OBOE BUFFET CRAMPON BC4121-2N-0 ESTUDIO
1.416,14€
OBOE BUFFET CRAMPON BC4062-2-0 PRODIGE
2.927,40€
OBOE STANDARD BULGHERONI 091/3
A CONSULTAR
OBOE CONSERVATORY BULGHERONI 101/3
A CONSULTAR
OBOE STANDARD BULGHERONI 091/3-ART-TF
A CONSULTAR
OBOE BUFFET CRAMPON BC4057-2N-0 ESTUDIO
3.175,04€
OBOE BUFFET CRAMPON BC4011-2N-0 ESTUDIO
1.578,50€
OBOE GREEN LINE BUFFET CRAMPON BC3613G-2-0
7.265,20€
OBOE GREEN LINE BUFFET CRAMPON BC3663G-2-0 ORFEO
7.265,20€
OBOE BUFFET CRAMPON BC4030-2-0 PRODIGE
1.785,96€
OBOE YAMAHA YOB-241B30
1.758,96€
OBOE YAMAHA YOB-431B
3.164,40€
OBOE YAMAHA YOB-432F
3.487,68€
OBOE YAMAHA YOB-832
6.981,12€
OBOE YAMAHA YOB-832L
7.436,16€
OBOE BUFFET PRODIGE ESTUDIO 4161-2-0
2.062,30€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES