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 = 11 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
FLAUTAS
FLAUTAS TRAVESERAS
ALTUS
AMADEUS
ARMSTRONG
AZUMI
CONSOLAT DE MAR
J.MICHAEL
JUPITER
NUVO
OQAN CLASICO
PEARL
ROY BENSON
SANKYO
SMLPARIS
SULLIVAN
SUZUKI
YAMAHA
FLAUTA SANKYO ETUDE CF-201BE -RT2
3.075,00€
FLAUTA SANKYO SILVERSONIC CF-301-RT2
4.225,00€
FLAUTA SANKYO SILVERSONIC CF-301E-RT2
4.525,00€
FLAUTA SANKYO SILVERSONIC CF-301BE-RT2
4.925,00€
FLAUTA SANKYO ARTIST CF-401BE-RT2
6.400,00€
FLAUTA SANKYO CF-501BEH-RT2 HEAVY
7.585,00€
FLAUTA SANKYO CF-601BE-RT2
9.325,00€
FLAUTA SANKYO CF-701BE-RT2
8.415,00€
FLAUTA SANKYO CF-801BE-RT2
10.725,00€
FLAUTA SANKYO SR PURE CF-901BE-RT2
13.510,00€
FLAUTA SANKYO 10K-2DT-BE-RT2
19.120,00€
FLAUTA SANKYO CF-850BE-RT2 50º ANIVERSARIO
15.000,00€
FLAUTA SANKYO WF-BE GRANADILLO
13.380,00€
FLAUTA ALTO SANKYO AF-101S
6.940,00€
FLAUTA ALTO SANKYO AF-201C
9.050,00€
FLAUTA ALTO SANKYO AF-201S
8.500,00€
FLAUTA YAMAHA YFL-212U
663,12€
FLAUTA TRAVESSERA (MECANISMO DE MI- SOL NO ALINEADO) FL400RE SMLPARIS PRIME VSMFL400RE
283,10€
FLAUTA YAMAHA YFL-382GL
1.101,60€
FLAUTA YAMAHA YFL-472 HGL
2.253,60€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES