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
ARM
ARMONICAS
ADMIRA
CLARKE
DUNLOP
HOHNER
HONSUY
SUZUKI
VOX
ARMONICA SPECIAL 20 HOHNER 560/20 (E)
29,92€
ARMONICA SILVER STAR HOHNER 504/20 (F)
13,64€
ARMONICA SPECIAL 20 HOHNER 560/20 (F)
29,92€
ARMONICA SILVER STAR HOHNER 504/20 (G)
13,64€
ARMONICA SPECIAL 20 HOHNER 560/20 (G)
29,92€
ARMONICA BLUES BAND HOHNER 559/20 (C)
11,44€
ARMONICA MEISTERKLASSE HOHNER 580/20 (A)
87,99€
KIT ARMONICAS HAPPY HOHNER 91600
154,00€
ARMONICA MEISTERKLASSE HOHNER 580/20 (B)
87,99€
ARMONICA SEDUCTORA HOHNER 6892/32 (F)
50,16€
ARMONICA MEISTERKLASSE HOHNER 580/20 (Bb)
87,99€
ARMONICA BLUES BAND HOHNER 559/20 (A)
11,44€
ARMONICA MEISTERKLASSE HOHNER 580/20 (C)
87,99€
ARMONICA BLUES BAND HOHNER 559/20 (G)
11,44€
ARMONICA MEISTERKLASSE HOHNER 580/20 (D)
87,99€
ARMONICA SEDUCTORA HOHNER 6892/32 (G)
50,16€
ARMÓNICA HOHNER TREMOLO SOLO 64V M-5864
80,08€
ARMONICA MEISTERKLASSE HOHNER 580/20 (E)
87,99€
ARMONICA ECHO CURVADA HOHNER 1493/32 (G)
55,44€
ARMÓNICA HOHNER MARINEBAND NATURAL MINOR 1896/20 (B)
38,72€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES