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
DAYTONA
EK AUDIO
FENDER ACUSTICAS
FENDER UKELELES
FLIGHT
GRETSCH
IBANEZ
KALA
KOHALA
KORALA
LANIKAI
LEHO
OCTOPUS
ON STAGE
OQAN
ORTEGA
ORTOLA
PRODIPE
PYRAMID
STRONGBAG
TANGLEWOOD
UKELELE KALA TENOR DE VIAJE
225,25€
UKELELE SOPRANO FLIGHT TUS-35RD TRAVEL ROJO
49,00€
UKELELE KALA TENOR EQ
186,15€
UKELELE SOPRANO FLIGHT TUS-35OR TRAVEL NARANJA
49,00€
UKELELE SOPR QUK-10S CON FUNDA OQAN GUITARRAS
57,20€
UKELELE KALA TENOR EQ MAKALA
102,00€
UKELELE SOPRANO FLIGHT TUS-35NA TRAVEL NATURAL
49,00€
UKELELE SOPRANO QUK-15SZ OQAN GUITARRAS
66,00€
UKELELE KALA TENOR EXOTIC
126,65€
UKELELE SOPRANO FLIGHT TUS-35YW TRAVEL AMARILLO
49,00€
UKELELE CONCIERTO QUK-20C OQAN GUITARRAS
58,09€
UKELELE KALA TENOR KA-T
112,20€
UKELELE SOPRANO FLIGHT TUS-35LB TRAVEL AZUL CIELO
49,00€
UKELELE TENOR QUK-30T OQAN GUITARRAS
87,12€
UKELELE ORTEGA RGL-25TH
302,44€
UKELELES SOPRANO KORALA UKS-510 PERFORMER SERIES
119,00€
UKELELE KALA TENOR KATG
126,65€
UKELELE CONCERT FLIGHT VICTORIA ELECTRIFICADO KOA
319,00€
UKELELE TENOR FLIGHT MUSTANG ELECTRIFICADO
460,01€
UKELELE SOPR ELECTR QUK-25SE OQAN GUITARRAS
101,20€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES