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 = 38 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
VIOLIN
VIOLINES
AMADEUS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
OQAN
ORTOLA
PALATINO
Rapsody
SIELAM
Stentor
VALLEST
YAMAHA
VIOLIN SIELAM ESPRESSIVO 1/32
217,26€
VIOLIN SIELAM ESPRESSIVO 4/4
217,26€
VIOLIN YAMAHA V3SKA44 V3SKA44
296,00€
VIOLIN ANTONIO WANG VERONA 4/4 EN BLANC
1.853,44€
VIOLIN STENTOR HARLEQUIN 4/4 AZUL
146,66€
VIOLIN ELECTRICO YAMAHA SV-250 BROWN
1.759,20€
VIOLIN STENTOR HARLEQUIN 4/4 LILA
146,66€
VIOLINB STENTOR HARLEQUIN 1/4 ROSA FRAMBUESA
146,66€
VIOLIN ELECTRICO YAMAHA SV-255 BROWN
1.827,20€
VIOLIN MR. DANIO WU, MASTER SIGNATURE
4.700,38€
VIOLIN ANTONIO WANG ATELIER 4/4
1.002,64€
VIOLIN ANTONIO WANG ATELIER 4/4
1.002,64€
VIOLIN ANTONIO WANG SIRACUSA 3/4 EN BLANCO
1.091,76€
VIOLIN ANTONIO WANG SIRACUSA 4/4 EN BLANCO
1.091,76€
VIOLIN HOFNER H11EV 4/4
840,00€
VIOLIN ANTONIO WANG SIRACUSA ANTIQUED 1/2
1.262,75€
VIOLIN ANTONIO WANG SIRACUSA ANTIQUED 3/4
1.345,86€
VIOLIN ANTONIO WANG SIRACUSA ANTIQUED 4/4
1.345,86€
VIOLIN ANTONIO WANG SIRACUSA ANTIQUED ART MODEL 4/4
3.572,52€
VIOLIN ANTONIO WANG SIRACUSA ANTIQUED BARROCO
1.531,86€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES