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
ROLAND
YAMAHA
PIANO DIGITAL MEDELI DP650K
1.045,20€
PIANO DIGITAL MEDELI GRAND510
2.465,47€
PIANO DIGITAL CASIO PRIVIA PX-870 BN
1.235,00€
PIANO DIGITAL ORLA STAGE STARTER BLACK
360,80€
PIANO DIGITAL ORLA CDP-101 ROSEWOOD
638,00€
PIANO DIGITAL ORLA CDP-101 POLISH BLACK
805,20€
PIANO DIGITAL ORLA CDP-101 POLISH WHITE
805,20€
PIANO DIGITAL ORLA CDP-1 RW
541,19€
PIANO DIGITAL ROLAND RP-102-BK
650,00€
PIANO DIGITAL CASIO PRIVIA PX-360 BK NEGRO
1.095,00€
PIANO DIGITAL CASIO CDP-S100BK
529,00€
PIANO DIGITAL CASIO CDP-S350BK
749,00€
PIANO DIGITAL CASIO PRIVIA PX-360 KIT NEGRO
1.165,00€
PIANO DIGITAL CASIO AP-470 BK KIT
1.399,00€
PIANO DIGITAL CASIO AP-470 BN KIT
1.399,00€
PIANO DIGITAL CASIO PIANO DIG CELV AP-470 WE KIT
1.399,00€
PIANO DIGITAL KORG D1
676,63€
PIANO DIGITAL CASIO PRIVIA PRO PX-5S
1.225,00€
PIANO DIGITAL CASIO PRIVIA PX-560
1.029,00€
PIANO DIGITAL ROLAND RP-501R-CB
950,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES