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 = 32 AND Cod_Subsubfamilia = 93 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
CAJAS DE BATERIA/TOMS/BOMBOS
ACCESORIOS BATERIA
BATERIA
BOMBOS
CAJAS
PERCUSI
TOMS
DIXON
HONSUY
JINBAO
LUDWIG
MAPEX
MEINL
OQAN
ORTOLA
PREMIER
REMO
SANTAFE DRUMS
TAMA
VIC FIRTH
YAMAHA
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
233,68€
BOMBO YAMAHA LHB2216
1.555,00€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
263,59€
BOMBO YAMAHA LHB2218
1.607,00€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
257,98€
BOMBO YAMAHA LHB2416
1.658,00€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
257,98€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
261,72€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
291,63€
CAJA MASTER ABEDUL 14X5.6"(35X14CM) STF0800 ORTOLA
265,59€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
286,03€
BOMBO YAMAHA LHB1814
1.451,00€
CAJA MASTER ABEDUL 14X5.6" COVER REF.STF0806 ORTOLA
167,89€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
286,03€
BOMBO YAMAHA LHB2016
1.503,00€
CAJA MASTER MAPPLE 14X5.6"(35X14CM) STF0810 ORTOLA
302,31€
TIMBAL BASE 18"x18" (45,7x45,7cm.) HONSUY
289,76€
TOM YAMAHA LHF1413
829,00€
CAJA MASTER ABEDUL 14X4" PICCOLO STF0850 ORTOLA
233,41€
TIMBAL BASE 18"x18" (45,7x45,7cm.) HONSUY
319,68€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES