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
MIYAZAWA
MURAMATSU
NUVO
OQAN
PEARL
ROY BENSON
SANKYO
SMLPARIS
SULLIVAN
SUZUKI
YAMAHA
CABEZA CURVA NUVO N230CHBK
PVP: 25,00€
23,75€
CABEZA CURVA NUVO N230CHWT
PVP: 25,00€
23,75€
PICCOLO PEARL PFP-105E
PVP: 1.030,00€
896,10€
FLAUTA MURAMATSU EX-RC-III
PVP: 3.255,00€
2.780,00€
PICCOLO PEARL PFP-165E
PVP: 1.390,00€
1.209,30€
FLAUTA MURAMATSU EX-RC-EO III
PVP: 3.655,00€
3.213,00€
FLAUTA MURAMATSU EX-RB-EO-III
PVP: 4.160,00€
3.577,00€
FLAUTA MURAMATSU GX-RC III
PVP: 5.565,00€
4.850,00€
FLAUTA MURAMATSU GX-RC-EO-III
PVP: 5.965,00€
5.329,00€
FLAUTA MURAMATSU GX-RB-EO-III
PVP: 6.760,00€
5.900,00€
FLAUTA MURAMATSU DS-RB-EO
PVP: 9.510,00€
8.190,00€
FLAUTA ROY BENSON FL-402R2
PVP: 426,00€
340,80€
FLAUTA MURAMATSU DS-RB-EO-H HEAVY
PVP: 9.885,00€
8.510,00€
FLAUTA ROY BENSON FL-102
PVP: 283,00€
226,40€
FLAUTA MURAMATSU SR-RB-EO
PVP: 14.030,00€
12.299,00€
FLAUTA ROY BENSON FL-402E
PVP: 368,00€
294,40€
FLAUTA MURAMATSU PT/P RB-EO
PVP: 17.430,00€
15.250,00€
FLAUTA ROY BENSON FL-402E2
PVP: 426,00€
340,80€
FLAUTA MURAMATSU 9K G-S-RB-EO HEAVY
PVP: 24.750,00€
22.275,00€
FLAUTA ROY BENSON FL-402R
PVP: 368,00€
294,40€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES