select codigo from products where codigo > '841020000' and marca = 'VINTAGE' and catalogid = '5' and subcatalogid = '25' and codtitulo = '346' and estado = 0 and publica = 1 order by codigo asc LIMIT 1

codigo: 841.020.000
SKU: V300VSB
origen: CHINA
peso bruto: 3.000Kg
volumen bruto: 0.077146m3


V300 Acustica FOLK Tapa SOLIDA

Productos Guitarras Acusticas Vintage



  • Comprar