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 KORG PIANO DIGITAL B2 BK
419,00€
PIANO RINGWAY TG8810
425,00€
PIANO "RINGWAY" TG8876WH
895,00€
PIANO "RINGWAY" TG8876
750,00€
PIANO DIGITAL VOX CONTINENTAL 61 KIT STAND
1.451,03€
PIANO DIGITAL VOX CONTINENTAL 73 KIT STAND
1.547,83€
PIANO DIGITAL KORG PIANO DIGITAL B2 WH
419,00€
PIANO DIGITAL KORG PIANO DIGITAL B2N
369,00€
PIANO DIGITAL KORG PIANO DIGITAL B2SP BK
579,83€
PIANO DIGITAL KORG PIANO DIGITAL B2SP WH
579,83€
PIANO DE COLA DIGITAL "ARTESIA" AG30
1.890,00€
PIANO DIGITAL CASIO PRIVIA PX-360 BK NEGRO
999,00€
PIANO DIGITAL CASIO AP-470 BN KIT
1.165,00€
PIANO DIGITAL CASIO PIANO DIG CELV AP-470 WE KIT
1.165,00€
PIANO DIGITAL KORG C1 AIR WA
967,03€
PIANO DIGITAL ROLAND RP-102-BK
749,00€
PIANO DIGITAL ORLA PIANO DIG GRAND 500 NEGRO
3.075,60€
PIANO DIGITAL ORLA PIANO DIG GRAND 500 BLANCO
3.075,60€
PIANO DIGITAL MEDELI DP420K/BKA
837,00€
PIANO DIGITAL MEDELI DP460K/BKA
921,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES