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 = 4 AND Cod_Subsubfamilia = 5 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
ELECTRICAS
BAJOS
BAJOS ELECTRICOS
ELECTRICOS
GUITARRAS ELECTRICAS
ARIA
AUSTIN
CORT
DAYTONA
FENDER BAJOS
FENDER ELECTRICAS
GODIN
GRETSCH
HÖFNER
HOHNER
IBANEZ
IBANEZ
JACKSON
LAKLAND
LTD
MARCUS MILLER
MARCUS MILLER SIRE
ORANGE
PRODIPE
PRS GUITARS
ROCIO
SCHECTER
SQUIER BAJOS
TOKAI
VOX
YAMAHA
BAJO ELECTRICO FENDER MIJ TRADITIONAL '60S PRECISION BASS LEFT-HANDED, ARCTIC WHITE 5356100380
PVP: 1.139,00€
968,15€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3, LAUREL FINGERBOARD, SILVERBURST 2919904521
PVP: 350,00€
283,50€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3, LAUREL FINGERBOARD, GLOSS BLACK 2919904503
PVP: 350,00€
283,50€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3, LAUREL FINGERBOARD, METALLIC RED 2919904573
PVP: 350,00€
283,50€
BAJO ELECTRICO VOX STARSTREAM VSBA-1H ARTIST BLACK
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES KELLY BIRD JS3Q, AMARANTH FINGERBOARD, TRANSPARENT RED BURST 2919093591
PVP: 460,00€
372,60€
BAJO ELECTRICO VOX STARSTREAM VSBA-1H ARTIST RED
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3Q, AMARANTH FINGERBOARD, TRANSPARENT BLACK BURST 2919026585
PVP: 470,00€
380,70€
BAJO ELECTRICO VOX STARSTREAM VSBA-1H ARTIST WHITE
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3VQ, AMARANTH FINGERBOARD, TRANSPARENT BLACK BURST 2919023585
PVP: 519,00€
420,39€
BAJO ELECTRICO IBANEZ SR300E AZUL
A CONSULTAR
BAJO ELECTRICO VOX STARSTREAM VSBA-2S ARTIST BLACK
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3, AMARANTH FINGERBOARD, SATIN BLACK 2919016568
PVP: 445,00€
360,45€
BAJO ACUSTICO IBANEZ AEB8E-BK
A CONSULTAR
BAJO ELECTRICO VOX STARSTREAM VSBA-2S ARTIST RED
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS2, AMARANTH FINGERBOARD, SNOW WHITE 2919011576
PVP: 300,00€
243,00€
BAJO ELECTRICO VOX STARSTREAM VSBA-2S ARTIST WHITE
A CONSULTAR
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS2, AMARANTH FINGERBOARD, SATIN BLACK 2919011568
PVP: 300,00€
243,00€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3V, LAUREL FINGERBOARD, WALNUT STAIN 2919005557
PVP: 410,00€
332,10€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3V, LAUREL FINGERBOARD, SILVERBURST 2919005521
PVP: 410,00€
332,10€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES