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
BAJO ELECTRICO
BAJO PARA ZURDOS
BAJOS
BAJOS EL
BAJOS ELECTRICOS
BAJOS SEMI-AC
GUITARRAS ELECTRICAS
ARIA
AUSTIN
CORT
DAYTONA
FENDER BAJOS
FENDER ELECTRICAS
GODIN
GRETSCH
HÖFNER
HOHNER
IBANEZ
IBANEZ
JACKSON
LAKLAND
LTD
MARCUS MILLER SIRE
PLANETWAVES
PRODIPE
ROCIO
SCHECTER
SQUIER BAJOS
TOKAI
YAMAHA
BAJO ELECTRICO FENDER FSR MIJ HYBRID 60S JAZZ BASS QUILT TOP, ROSEWOOD FINGERBOARD, TRANSPARENT RED 5758600332
891,00€
BAJO ELECTRICO FENDER MIJ TRADITIONAL '60S JAZZ BASS FRETLESS, ROSEWOOD FINGERBOARD, BLACK 5450600306
891,00€
BAJO ELECTRICO MARCUS MILLER M7 SWAMP ASH-4 (2ND GEN) NAT NATURAL
724,95€
BAJO ELECTRICO CORT B4 PLUS ASRM OPAB OPEN PORE AQUA BLUE
546,46€
BAJO ELECTRICO CORT B4 PLUS ASRM OPBR OPEN PORE BURGUNDY RED
546,46€
BAJO ELECTRICO FENDER FSR MIJ TRADITIONAL 60S PRECISION BASS, ROSEWOOD FINGERBOARD, MIDNIGHT 5564600306
971,19€
BAJO ELECTRICO FENDER MADE IN JAPAN TRADITIONAL '70S PRECISION BASS MAPLE OLYMPIC WHITE 5357002305
891,00€
BAJO ELECTRICO FENDER MIJ TRADITIONAL '60S PRECISION BASS LEFT-HANDED, ROSEWOOD FINGERBOARD, 3-COLOR SUNBURST 5356100300
891,00€
BAJO ELECTRICO CORT ACTION PJ OPB
187,82€
BAJO ELECTRICO FENDER MIJ TRADITIONAL '60S PRECISION BASS, ROSEWOOD FINGERBOARD, 3-COLOR SUNBURST 5356000300
891,00€
BAJO ELECTRICO FENDER MIJ TRADITIONAL '60S PRECISION BASS LEFT-HANDED, ARCTIC WHITE 5356100380
891,00€
BAJO ELECTRICO FENDER FSR AERODYNE JAZZ BASS, ROSEWOOD FINGERBOARD, 3-COLOR SUNBURST 5257400300
1.125,09€
BAJO ELECTRICO FENDER AERODYNE JAZZ BASS LEFT-HANDED, ROSEWOOD FINGERBOARD, BLACK 5250252306
1.125,09€
BAJO ELECTRICO JACKSON JS SERIES KELLY BIRD JS3Q, AMARANTH FINGERBOARD, TRANSPARENT BLUE BURST 2919093585
384,75€
BAJO ELECTRICO JACKSON JS SERIES KELLY BIRD BASS IV JS2, AMARANTH FINGERBOARD, TOBACCO BURST 2919091598
352,35€
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3Q, AMARANTH FINGERBOARD, CHERRY BURST 2919016520
392,85€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3, LAUREL FINGERBOARD, SILVERBURST 2919904521
275,40€
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3V, AMARANTH FINGERBOARD, METALLIC BLUE BURST 2919021527
420,39€
BAJO ELECTRICO JACKSON JS SERIES SPECTRA BASS JS3, LAUREL FINGERBOARD, GLOSS BLACK 2919904503
275,40€
BAJO ELECTRICO JACKSON JS SERIES CONCERT BASS JS3VQ, AMARANTH FINGERBOARD, TRANSPARENT RED BURST 2919021502
436,59€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES