select codigo from products where codigo > '153010000' and marca = 'BLACKSTAR Carry-On' and catalogid = '15' and subcatalogid = '370' and codtitulo = '1425' and estado = 0 and publica = 1 order by codigo asc LIMIT 1

codigo: 153.010.000
SKU: BA203012-Z
origen: CHINA
peso bruto: 1.000Kg
volumen bruto: 0.010768m3


CARRY-ON-FP49 Piano PLEGABLE 49teclas, 128sonid,Parlant,USB,MIDI

Productos Pianos Digitales Blackstar Carry-on



  • Comprar