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 = 75 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
MESA DE MEZCLAS
UKELELE
UKELELE CONCIERTO
UKELELES
UKELELES CONCERT
UKELELES TENOR
ADMIRA
ALVAREZ
APC
ARIA
BONES
DAYTONA
EK AUDIO
FENDER ACUSTICAS
FENDER UKELELES
FLIGHT
GRETSCH
HOHNER
IBANEZ
KALA
KOHALA
KORALA
LANIKAI
LEHO
OCTOPUS
ON STAGE
OQAN
ORTEGA
ORTOLA
PRODIPE
PYRAMID
STRONGBAG
TANGLEWOOD
UKELELE ORTEGA RULAGOON
PVP: 90,00€
76,50€
UKELELE OQAN QUK POLYNESIA RED PREAMP
PVP: 79,00€
69,52€
PACK UKELELE SOPRANO DAYTONA PUKDS
PVP: 49,90€
42,42€
UKELELE SOPRANO FLIGHT NUS-380 TOPAZ
79,00€
UKELELE ORTEGA RULAGOON-CE
PVP: 163,35€
138,85€
UKELELE SOPRANO BONES SP600N NATURAL
29,90€
UKELELE ORTEGA RUSUN
PVP: 101,83€
86,56€
UKELELE SOPRANO BONES SP600B NEGRO
29,90€
UKELELE ORTEGA RUSUN-CE
PVP: 163,35€
138,85€
UKELELE ORTEGA RUEB-SO
PVP: 151,25€
128,56€
UKELELE ORTEGA RUEB-CC
PVP: 155,00€
131,75€
UKELELES SOPRANO KORALA UKS-510 PERFORMER SERIES
119,00€
UKELELE CONCIERTO KORALA UKC-510 PERFORMER SERIES
134,58€
UKELELES SOPRANO KORALA UKS-610 PERFORMER SERIES
119,00€
PUAS UKULELE ON STAGE UPK300 FIELTRO 3 PACK
4,00€
UKELELE SOPR QUK-10S CON FUNDA OQAN GUITARRAS
PVP: 65,00€
57,20€
UKELELE CONCIERTO KORALA UKC-610 PERFORMER SERIES
131,54€
UKELELE SOPRANO QUK-15SZ OQAN GUITARRAS
PVP: 75,00€
66,00€
UKELELES SOPRANO KORALA UKS-750 PERFORMER SERIES
208,38€
UKELELE CONCIERTO QUK-20C OQAN GUITARRAS
PVP: 66,01€
58,09€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES