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 = 37 AND Cod_Subsubfamilia = 63 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
BAQUETAS
BAQUETAS
GONALCA PERCUSION
HONSUY
JINBAO
MAPEX
MEINL
OQAN PERCUSION
ROLAND
SCHLAGWERK
VATER
VIC FIRTH
ZILDJIAN
PERCUSION VIC FIRTH SAAC ALEX ACUÑA "CLEAR CONQUISTADOR"
9,00€
BAQUETAS BATERIA ZILDJIAN PZAASJD
12,77€
FDT2 FRAME DRUM TIPPER MEINL
10,35€
PERCUSION VIC FIRTH SAA2 ALEX ACUÑA "EL PALO"
9,00€
SST3-S SAMBA STICK, TRIPLE, SHORT MEINL
13,05€
MPM1 PERCUSSION MALLET MEINL
17,00€
MPM2 PERCUSSION MALLET MEINL
17,00€
COW2 COWBELL BEATER WITH RIBBED GRIP MEINL
7,64€
BAQUETAS BATERIA ZILDJIAN ZM1964
268,94€
COW1BK COWBELL BEATER, BLACK MEINL
5,30€
COW3BK MEINL
8,91€
BAQUETAS BATERIA ZILDJIAN 7AWA
15,24€
ESCOBILLAS VIC FIRTH SB SPLIT BRUSH
49,00€
BAQUETAS BATERIA ZILDJIAN 5AWA
15,24€
RODS VIC FIRTH TW11 STEVE SMITH "TALA WAND" BAMBU
33,00€
PERCUSION VIC FIRTH TMB-1
7,60€
BAQUETAS BATERIA ZILDJIAN SDM2
A CONSULTAR
MAZA JINBAO BOMBO MARCHA JB4 BOLA GRANDE
35,00€
BAQUETAS "VATER" VMJRW JUNIOR NOGAL AMERICANO
9,90€
RODS VIC FIRTH RUTE 16 VARILLAS
29,90€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES