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 = 40 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
VIOLONCELLOS
AMADEUS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KREUTZER
OQAN
Rapsody
Stentor
YAMAHA
CELLO AMADEUS CA-101 1/8
270,00€
CELLO STENTOR STUDENT II SH 1/2 SET
PVP: 697,54€
606,86€
CELLO ELECTRICO YAMAHA SVC110
A CONSULTAR
CELLO STENTOR STUDENT II SH 3/4 SET
PVP: 730,83€
635,82€
CELLO STENTOR STUDENT II SH 4/4 SET
PVP: 730,83€
635,82€
CELLO ELECTRICO YAMAHA SVC210
A CONSULTAR
CELLO ELECTRICO YAMAHA SVC50
PVP: 2.436,00€
1.948,80€
VIOLONCHELO OQAN OC300 4/4
PVP: 394,99€
347,59€
VIOLONCHELO OQAN OC300 3/4
PVP: 394,99€
347,59€
VIOLONCHELO OQAN OC300 1/2
PVP: 394,99€
347,59€
VIOLONCHELO OQAN OC300 1/4
PVP: 394,99€
347,59€
CELLO CARLO GIORDANO SC100 1/2
785,00€
CELLO CARLO GIORDANO SC100 3/4
785,00€
CELLO CARLO GIORDANO SC100 4/4
785,00€
CELLO CARLO GIORDANO SC200 3/4
1.195,00€
CELLO CARLO GIORDANO SC200 4/4
1.195,00€
CELLO CARLO GIORDANO SC90 1/2
545,00€
CELLO CARLO GIORDANO SC90 1/4
545,00€
CELLO CARLO GIORDANO SC90 3/4
545,00€
CELLO YAMAHA VC20G TALLA 4/4
A CONSULTAR
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES