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
IBANEZ
IBANEZ
JACKSON
LAKLAND
LTD
MARCUS MILLER SIRE
ORANGE
PRODIPE
PRS GUITARS
ROCIO
SCHECTER
SQUIER BAJOS
TOKAI
YAMAHA
BAJO ELECTRICO CORT ACTION HH4 BRM BLOOD RED METALLIC
PVP: 458,59€
357,70€
BAJO ELECTRICO CORT ACTION HH4 TLB TASMAN LIGHT BLUE
PVP: 458,59€
357,70€
BAJO ELECTRICO CORT ACTION JUNIOR OPB
PVP: 228,69€
178,38€
BAJO ELECTRICO CORT GB74 GIG LPB LAKE PLACID BLUE
PVP: 724,79€
565,34€
BAJO ELECTRICO FENDER VINTERA '60S MUSTANG BASS, PAU FERRO FINGERBOARD, FIESTA RED 0149653340
PVP: 919,00€
744,39€
BAJO ELECTRICO FENDER VINTERA '60S MUSTANG BASS, PAU FERRO FINGERBOARD, SEAFOAM GREEN 0149653373
PVP: 919,00€
744,39€
BAJO ELECTRICO FENDER VINTERA '60S MUSTANG BASS, PAU FERRO FINGERBOARD, 3-COLOR SUNBURST 0149653300
PVP: 919,00€
744,39€
BAJO ELECTRICO FENDER PLAYER JAGUAR BASS, MAPLE FINGERBOARD, TIDEPOOL 0149302513 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '70S JAZZ BASS, PAU FERRO FINGERBOARD, AGED NATURAL 0149643328
PVP: 1.099,00€
890,19€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, 3-COLOR SUNBURST 0149802500 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '70S JAZZ BASS, PAU FERRO FINGERBOARD, INCA SILVER 0149643324
PVP: 1.069,00€
865,89€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, BLACK 0149802506 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '70S JAZZ BASS, PAU FERRO FINGERBOARD, 3-COLOR SUNBURST 0149643300
PVP: 1.069,00€
865,89€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, TIDEPOOL 0149802513 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '60S JAZZ BASS, PAU FERRO FINGERBOARD, FIREMIST GOLD 0149633353
PVP: 999,00€
809,19€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, POLAR WHITE 0149802515 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '60S JAZZ BASS, PAU FERRO FINGERBOARD, DAPHNE BLUE 0149633304
PVP: 999,00€
809,19€
BAJO ELECTRICO ORANGE O-BASS ORANGE
PVP: 424,99€
335,74€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, BUTTERCREAM 0149802534 "NOVEDAD"
PVP: 769,00€
622,89€
BAJO ELECTRICO FENDER VINTERA '60S JAZZ BASS, PAU FERRO FINGERBOARD, 3-COLOR SUNBURST 0149633300
PVP: 999,00€
809,19€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES