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 BARITONO
UKELELES CONCERT
UKELELES SOPRANO
UKELELES TENOR
ADMIRA
ALVAREZ
APC
DAYTONA
EK AUDIO
FENDER ACUSTICAS
FENDER UKELELES
FLIGHT
GRETSCH
HOHNER
IBANEZ
KALA
KOHALA
KORALA
LANIKAI
LEHO
OCTOPUS
OQAN
OQAN GUITARRAS
ORTEGA
ORTOLA
PRODIPE
PYRAMID
STRONGBAG
TANGLEWOOD
WINGO
UKULELE LEHO ALEHO CAOBA LAMINADA BAJO ELECT C/F
360,00€
UKELELE TENOR KORALA UKT-310-CE
258,66€
UKELELE CONCERT QUILT ASH-SERIES LANIKAI ULQA-CCA CTW
275,00€
UKULELE LEHO GUITARLELE
235,00€
UKELELE SOPRANO KORALA UKS-250-CE
196,36€
UKELELE CONCERT LU-SERIES LANIKAI ULU-21CEBK
219,00€
UKELELE SOPR QUK-10S CON FUNDA OQAN GUITARRAS
57,20€
UKELELE TENOR KORALA UKT-250-CE
238,98€
UKELELE SOPRANO QUK-15SZ OQAN GUITARRAS
66,00€
UKELELE SOPRANO KORALA UKS-450-CE
195,32€
UKELELE CONCERT MA-SERIES LANIKAI MA-C
120,00€
UKELELE CONCIERTO QUK-20C OQAN GUITARRAS
58,09€
UKELELE CONCIERTO KORALA UKC-450-CE
214,04€
GUITARLELE CHATEAU C08-GK6S-OT STANDARD ORTOLA
69,95€
UKELELE CONCERT FLIGHT NUC310
75,00€
UKELELE TENOR QUK-30T OQAN GUITARRAS
87,12€
UKELELE TENOR KORALA UKT-450-CE
233,30€
UKELELE CONCIERTO CHATEAU 23" C08-U23M-OT STANDARD ORTOLA
45,62€
UKELELE CONCERT NEGRO BURST OCTOPUS UK-210CEX-BKB CONCERT
62,90€
UKELELE SOPR ELECTR QUK-25SE OQAN GUITARRAS
101,20€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES