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
GLIGA
KREUTZER
OQAN CLASICO
PALATINO
PLANETWAVES
STENTOR
YAMAHA
CELLO YAMAHA VC20G TALLA 4/4
A CONSULTAR
CELLO YAMAHA VC5S TALLA 4/4
1.135,20€
CELLO YAMAHA VC5S TALLA 1/2
1.135,20€
CELLO AMADEUS TAPA MACIZA CP201 1/4
420,00€
CELLO AMADEUS TAPA MACIZA CP201 1/2
420,00€
CELLO AMADEUS TAPA MACIZA CP201 3/4 CP20134
420,00€
CELLO AMADEUS TAPA MACIZA CP201 1/8 CP20118
420,00€
CELLO AMADEUS TAPA MACIZA CP201 4/4 CP20144
420,00€
BOLSA P.WAVES TAPONES OIDOS EP1 PLANETWAVES
1,89€
VIOLONCHELO GLIGA GENIAL II 1/2
709,20€
VIOLONCHELO GLIGA GENIAL II 3/4
802,80€
VIOLONCHELO GLIGA GENIAL II 4/4
989,10€
VIOLONCHELO KREUTZER SCHOOL I 1/2
347,77€
VIOLONCHELO KREUTZER SCHOOL I 1/4
347,77€
VIOLONCHELO KREUTZER SCHOOL I 3/4
387,90€
VIOLONCHELO KREUTZER SCHOOL I 4/4
387,90€
VIOLONCHELO STENTOR CONSEVATOIRE 1/2
1.224,90€
VIOLONCHELO STENTOR CONSEVATOIRE 3/4
1.224,90€
VIOLONCHELO STENTOR CONSEVATOIRE 4/4
1.224,90€
VIOLONCHELO STENTOR STUDENT I 1/2
421,20€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES