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
ADAMS
DIXON
HONSUY
JINBAO
LUDWIG
MAPEX
MEINL
OQAN
ORTOLA
ROCIO
SANTAFE DRUMS
SONOR
TAMA
VIC FIRTH
YAMAHA
CAJA LUDWIG LS654XXU2 CLUB DATE SNARE 14
PVP: 719,00€
647,10€
BOMBO YAMAHA LHB1814
1.451,00€
CAJA DE BATERIA SONOR VT 14X5,75 SDW CAB
760,00€
BOMBO YAMAHA LHB2016
1.503,00€
BOMBO YAMAHA LHB2216
1.555,00€
TOM YAMAHA LHF1413
829,00€
TOM YAMAHA LHF1615
881,00€
TOM YAMAHA LHF1816
933,00€
BOMBO DE BATERIA SONOR PROLITE 2016 BD (SIN PERF) EDT
1.437,00€
BOMBO DE BATERIA SONOR PROLITE 2216 BD (SIN PERF) EDT
1.570,00€
TOM YAMAHA LHT0807
539,00€
BOMBO DE BATERIA SONOR PROLITE 2414 BD (SIN PERF) EDT
1.672,00€
TOM YAMAHA LHT1007
560,00€
BOMBO DE BATERIA SONOR PROLITE 1814 BD (BOMBO PERF.) EDT
1.305,00€
TOM YAMAHA LHT1208
591,00€
BOMBO DE BATERIA SONOR PROLITE 2016 BD (BOMBO PERF.) EDT
1.468,00€
TOM YAMAHA LHT1208
591,00€
BOMBO DE BATERIA SONOR PROLITE 2216 BD (BOMBO PERF.) EDT
1.590,00€
TOM YAMAHA LHT1309
653,00€
TOM YAMAHA LHT1411
725,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES