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
CELLOS
VIOLONCELLOS
AMADEUS
Antonio Wang
GLIGA
KREUTZER
OQAN
Rapsody
Stentor
VALLEST
YAMAHA
CELLO YAMAHA VC20G TALLA 4/4
A CONSULTAR
CELLO YAMAHA VC5S TALLA 4/4
PVP: 1.419,00€
1.135,20€
CELLO YAMAHA VC5S TALLA 1/2
PVP: 1.419,00€
1.135,20€
CELLO STENTOR STUDENT II SH 1/2 SET
PVP: 697,54€
606,86€
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€
VIOLONCHELO GLIGA GENIAL II 1/2
PVP: 788,00€
709,20€
VIOLONCHELO GLIGA GENIAL II 3/4
PVP: 892,00€
802,80€
VIOLONCHELO GLIGA GENIAL II 4/4
PVP: 1.099,00€
989,10€
VIOLONCHELO KREUTZER SCHOOL I 1/2
PVP: 386,41€
347,77€
VIOLONCHELO KREUTZER SCHOOL I 1/4
PVP: 386,41€
347,77€
VIOLONCHELO KREUTZER SCHOOL I 3/4
PVP: 431,00€
387,90€
VIOLONCHELO KREUTZER SCHOOL I 4/4
PVP: 431,00€
387,90€
CELLO ANTONIO WANG MODELO BRANDENBURG. COPIA ANTONIO STRADIVARI 1710
PVP: 4.668,92€
3.968,58€
CELLO ANTONIO WANG MODELO VIENA, STRADIVARI 1710
PVP: 7.374,22€
6.268,09€
CELLO BARROCO RAPSODY 450K-A. SIN PUENTE NI CUERDAS
PVP: 2.310,88€
2.079,79€
CELLO AMADEUS TAPA MACIZA CP201 1/4
PVP: 420,00€
357,00€
CELLO AMADEUS TAPA MACIZA CP201 1/2
PVP: 420,00€
357,00€
CELLO AMADEUS TAPA MACIZA CP201 3/4 CP20134
PVP: 420,00€
357,00€
CELLO AMADEUS TAPA MACIZA CP201 1/8 CP20118
PVP: 420,00€
357,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES