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 ELECTRICOS
ELECTRICOS
GUITARRAS ELECTRICAS
ARIA
AUSTIN
CORT
DANELECTRO
DAYTONA
FENDER BAJOS
FENDER ELECTRICAS
GODIN
GRETSCH
HÖFNER
HOHNER
IBANEZ
IBANEZ
JACKSON
LAKLAND
LTD
MARCUS MILLER SIRE
ORANGE
PRODIPE
PRS GUITARS
ROCIO
SCHECTER
SQUIER BAJOS
TOKAI
VOX
YAMAHA
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, TIDEPOOL 0149802513 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, POLAR WHITE 0149802515 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, MAPLE FINGERBOARD, BUTTERCREAM 0149802534 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, PAU FERRO FINGERBOARD, 3-COLOR SUNBURST 0149803500 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V3-4 (2ND GEN) TS TOBACCO SUNBURST
PVP: 389,00€
315,09€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, PAU FERRO FINGERBOARD, BLACK 0149803506 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V3-4 (2ND GEN) BLK BLACK
PVP: 389,00€
315,09€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS, PAU FERRO FINGERBOARD, POLAR WHITE 0149803515 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V3-4 (2ND GEN) AWH ANTIQUE WHITE
PVP: 389,00€
315,09€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS LEFT-HANDED, MAPLE FINGERBOARD, BLACK 0149822506 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO PARA ZURDOS MARCUS MILLER SIRE V3-4 LEFTHAND (2ND GEN) BLK BLACK
PVP: 459,00€
371,79€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS LEFT-HANDED, MAPLE FINGERBOARD, TIDEPOOL 0149822513 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V7 ALDER-4 (2ND GEN) TS TOBACCO SUNBURST*
PVP: 585,00€
473,85€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS LEFT-HANDED, PAU FERRO FINGERBOARD, 3-COLOR SUNBURST 0149823500 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V7 ALDER-4 (2ND GEN) BLK BLACK*
PVP: 585,00€
425,00€
BAJO ELECTRICO FENDER PLAYER PRECISION BASS LEFT-HANDED, PAU FERRO FINGERBOARD, POLAR WHITE 0149823515 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO ELECTRICO MARCUS MILLER SIRE V7 ALDER-4 (2ND GEN) AWH ANTIQUE WHITE
PVP: 585,00€
473,85€
BAJO ELECTRICO IBANEZ SR300E AZUL
A CONSULTAR
BAJO ELECTRICO FENDER PLAYER JAZZ BASS, MAPLE FINGERBOARD, 3-COLOR SUNBURST 0149902500 "NOVEDAD"
PVP: 799,00€
679,15€
BAJO PARA ZURDOS MARCUS MILLER SIRE V7 ALDER-4 LEFTHAND (2ND GEN) TS TOBACCO SUNBURST
PVP: 669,00€
541,89€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES