Nuestros productos

select count(articulos.codigo) from articulos where articulos.idrubro =37 and Visible<>1 and (articulos.habilitado=1) and articulos.Agotado != 1 order by codigo DESC, descripcion desc

select * from articulos where articulos.idrubro = 37 and Visible<>1 and articulos.habilitado=1 and articulos.Agotado != 1 order by codigo DESC, descripcion desc LIMIT 0,50
Ampliar!

CODIGO: LMT030BL

CHANCHO CERAMICA BLANCO 40CM
Ampliar!

CODIGO: LJS040BL

NI袿 CERAMICA 30CM BLANCO
Ampliar!

CODIGO: LJS040AM

NI袿 CERAMICA 30CM AMARILLO
Ampliar!

CODIGO: EBP123/1

KRISHNA RESINA 25CM DORADO
Ampliar!

CODIGO: EBP108

CABEZA BUDHA PIEDRA 0.40
Ampliar!

CODIGO: EBP105

MUJER BUSTO PIEDRA 0.60