INGRESAR0

Nuestros productos

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

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

CODIGO: AC0117/2C

(PROMO 30%) PATO ROOT (C) 0.40
Ampliar!

CODIGO: AC0117/1C

(PROMO 30%) PATO ROOT (C) 0.30
Ampliar!

CODIGO: AC0116/3B

(PROMO 30%) PATO ROOT (B) 0.50
Ampliar!

CODIGO: AC0116/2B

(PROMO 30%) PATO ROOT (B) 0.40
Ampliar!

CODIGO: AC0115/3A

(PROMO 30%) PATO ROOT (A) 0.50
Ampliar!

CODIGO: AC0115/2A

(PROMO 30%) PATO ROOT (A) 0.40