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
SORDINAS
OBOES
VARIOS ACCESORIOS VIENTO
BUFFET CRAMPON
BULGHERONI
CONSOLAT DE MAR
J.MICHAEL
SANKYO
STOMVI
YAMAHA
OBOE J.MICHAEL EBANO OB 2200
2.495,00€
OBOE J.MICHAEL OB 1500
1.525,00€
OBOE BUFFET CRAMPON BC4121-2N-0 ESTUDIO
A CONSULTAR
OBOE BULGHERONI FB-090
PVP: 2.657,00€
2.178,74€
OBOE YAMAHA YOB-241B30
PVP: 2.443,00€
1.758,96€
OBOE YAMAHA YOB-431B
PVP: 4.395,00€
3.164,40€
OBOE YAMAHA YOB-432F
PVP: 4.844,00€
3.487,68€
OBOE YAMAHA YOB-832
PVP: 9.696,00€
6.981,12€
OBOE YAMAHA YOB-832L
PVP: 10.328,00€
7.436,16€
OBOE BUFFET CRAMPON BC4062-2-0 PRODIGE
A CONSULTAR
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
A CONSULTAR
OBOE BUFFET CRAMPON BC4011-2N-0 ESTUDIO
A CONSULTAR
OBOE GREEN LINE BUFFET CRAMPON BC3613G-2-0
A CONSULTAR
OBOE GREEN LINE BUFFET CRAMPON BC3663G-2-0 ORFEO
A CONSULTAR
OBOE BUFFET CRAMPON BC4030-2-0 PRODIGE
A CONSULTAR
OBOE BUFFET PRODIGE ESTUDIO 4161-2-0
A CONSULTAR
OBOE YAMAHA YOB-831L YOB-831L 02
9.613,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES