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

FLAUTA TRAVESERA
FLAUTAS
FLAUTAS PICCOLO
FLAUTAS TRAVESERAS
ALTUS
AMADEUS
ARMSTRONG
AZUMI
CONSOLAT DE MAR
J.MICHAEL
JUPITER
MIYAZAWA
MOECK
MURAMATSU
NUVO
OQAN
PEARL
ROY BENSON
SANKYO
SMLPARIS
SULLIVAN
SUZUKI
YAMAHA
FLAUTA MURAMATSU EX-RC-III
2.780,00€
FLAUTA MURAMATSU EX-RC-EO III
3.213,00€
FLAUTA MURAMATSU EX-RB-EO-III
3.577,00€
FLAUTA MURAMATSU GX-RC III
4.850,00€
FLAUTA MURAMATSU GX-RC-EO-III
5.329,00€
FLAUTA MURAMATSU GX-RB-EO-III
5.900,00€
FLAUTA MURAMATSU DS-RB-EO
8.190,00€
FLAUTA MURAMATSU DS-RB-EO-H HEAVY
8.510,00€
FLAUTA "SUZUKI" 200
3,00€
FLAUTA MURAMATSU SR-RB-EO
12.299,00€
FLAUTA MURAMATSU PT/P RB-EO
15.250,00€
FLAUTA MOECK SOPRANINO ROTTENBURGH 4101 ARCE
208,25€
FLAUTA MURAMATSU 9K G-S-RB-EO HEAVY
22.275,00€
FLAUTA ALTO SOL JUPITER JAF1000XE
1.732,80€
FLAUTA BAJO JUPITER JBF1100E VERTICAL
3.644,00€
FLAUTA OFL-650 OQAN CLASICO
255,19€
FLAUTA OFL-600 OQAN CLASICO
210,32€
FLAUTA TRAVESERA FL805N AMADEUS NIQUELADA
118,15€
FLAUTA TRAVESERA FL805SO AMADEUS PLATEADA
165,75€
CABEZA FLAUTA TRAVESERA CURVADA SULLIVAN UCH
26,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES