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 = 39 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
VIOLAS
Antonio Wang
CARLO GIORDANO
GLIGA
HÖFNER
KARPATHI
KREUTZER
Rapsody
SIELAM
Stentor
VALLEST
YAMAHA
VIOLA GLIGA GENIAL III 15
PVP: 286,00€
257,40€
VIOLA GLIGA GENIAL III 15,5
PVP: 286,00€
257,40€
VIOLA GLIGA GENIAL III 16
PVP: 286,00€
257,40€
VIOLA KREUTZER SCHOOL 12
PVP: 152,94€
137,65€
VIOLA SIELAM ESPRESSIVO 11
PVP: 264,99€
238,49€
VIOLA KREUTZER SCHOOL 13
PVP: 152,94€
137,65€
VIOLA SIELAM ESPRESSIVO 16
PVP: 264,99€
238,49€
VIOLA KREUTZER SCHOOL 14
PVP: 156,51€
140,86€
VIOLA KREUTZER SCHOOL 15
PVP: 156,51€
140,86€
VIOLA HERITAGE BASIC HB381 15"
PVP: 545,01€
463,26€
VIOLA HERITAGE BASIC HB393 15,5"
PVP: 545,01€
463,26€
VIOLA HERITAGE BASIC HB406 16"
PVP: 545,01€
463,26€
VIOLA HERITAGE BASIC HB420 16,5"
PVP: 545,01€
463,26€
VIOLA HERITAGE EE HA393EE 15,5"
PVP: 1.035,00€
879,75€
VIOLA HERITAGE EE HA406EE 16"
PVP: 1.035,00€
879,75€
VIOLA HERITAGE EE HA420EE 16,5"
PVP: 1.035,00€
879,75€
VIOLA HERITAGE HA381 15"
PVP: 800,00€
680,00€
VIOLA HERITAGE HA393 15,5"
PVP: 800,00€
680,00€
VIOLA HERITAGE HA406 16"
PVP: 800,00€
680,00€
VIOLA HERITAGE HA420 16,5"
PVP: 800,00€
680,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES