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 = 80 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
ARMONICAS
ADMIRA
CLARKE
DUNLOP
HOHNER
HONSUY
SUZUKI
VOX
ARMONICA BIG RIVER HARP HOHNER 590/20 (G)
PVP: 30,00€
26,40€
ARMONICA CHROMETTA 14 HOHNER 257/56 (C)
PVP: 124,00€
109,12€
ARMONICA GOLDEN MELODY HOHNER 542/20 (A)
PVP: 40,99€
36,07€
ARMONICA CROMATICA I HOHNER 260/40 (C)
PVP: 140,00€
123,20€
ARMONICA GOLDEN MELODY HOHNER 542/20 (Bb)
PVP: 40,99€
36,07€
ARMONICA CROMATICA II HOHNER 270/48 (C)
PVP: 169,00€
148,72€
ARMONICA GOLDEN MELODY HOHNER 542/20 (B)
PVP: 40,99€
36,07€
ARMONICA CROMATICA III HOHNER 280/64 (C)
PVP: 219,00€
192,72€
ARMONICA GOLDEN MELODY HOHNER 542/20 (C)
PVP: 40,99€
36,07€
ARMONICA CX-12 BLACK HOHNER 7545/48 (C)
PVP: 175,99€
154,87€
ARMONICA GOLDEN MELODY HOHNER 542/20 (D)
PVP: 40,99€
36,07€
ARMONICA CROMATICA II DORADA LUXE HOHNER 270/48 (C)
PVP: 428,00€
376,64€
ARMONICA GOLDEN MELODY HOHNER 542/20 (E)
PVP: 40,99€
36,07€
ARMONICA CROMATICA II HOHNER 270/48 (A)
PVP: 169,00€
148,72€
ARMONICA GOLDEN MELODY HOHNER 542/20 (F)
PVP: 40,99€
36,07€
ARMONICA CROMATICA II HOHNER 270/48 (B)
PVP: 169,00€
148,72€
ARMONICA GOLDEN MELODY HOHNER 542/20 (G)
PVP: 40,99€
36,07€
ARMONICA CROMATICA II HOHNER 270/48 (Bb)
PVP: 169,00€
148,72€
ARMONICA MARINEBAND THUNDERBIRD HOHNER 2011/20 (A LOW)
PVP: 99,99€
87,99€
ARMONICA CROMATICA II HOHNER 270/48 (D)
PVP: 169,00€
148,72€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES