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 = 23 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20

PIANO DIGITAL
PIANOS DIGITALES
ALESIS
ARTESIA
CASIO
KORG
MEDELI
ORLA
RINGWAY
ROLAND
VOX
YAMAHA
PIANO DIGITAL ARTESIA AP-100
995,00€
PIANO DIGITAL YAMAHA DGX-660B BLACK
PVP: 975,00€
750,00€
PIANO DIGITAL ARTESIA DP-3
720,00€
PIANO DIGITAL YAMAHA DGX-660WH WHITE
PVP: 975,00€
750,00€
PIANO DIGITAL ARTESIA DP-7
780,00€
PIANO DIGITAL CASIO CELVIANO AP-700 BK NEGRO
PVP: 1.779,00€
1.423,20€
PIANO DIGITAL KORG D1
PVP: 761,09€
608,87€
PIANO ESCENARIO "RINGWAY" RP20-RP25
420,00€
PIANO ESCENARIO "RINGWAY" RP30-RP35
495,00€
PIANO DIGITAL MEDELI DP420K/BKA
A CONSULTAR
PIANO DIGITAL MEDELI DP460K/BKA
A CONSULTAR
PIANO DIGITAL MEDELI DP260/WH
A CONSULTAR
PIANO DIGITAL ROLAND F-140R-CB
PVP: 1.159,00€
960,00€
PIANO DIGITAL MEDELI DP330/WS
A CONSULTAR
PIANO DIGITAL ROLAND F-140R-WH
PVP: 1.159,00€
995,00€
PIANO DIGITAL YAMAHA YDP-144B
PVP: 1.017,00€
699,00€
PIANO DIGITAL YAMAHA YDP-S54B
PVP: 1.319,00€
989,25€
PIANO DIGITAL YAMAHA YDP-164WH
PVP: 1.319,00€
959,00€
PIANO DIGITAL MEDELI DP280K/WH
A CONSULTAR
PIANO DIGITAL YAMAHA YDP-S54WH
PVP: 1.319,00€
989,25€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES