INGRESAR0

Nuestros productos

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

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

CODIGO: AC0412/4

MOBIL CAMPANAS BUHOS (D)
Ampliar!

CODIGO: AC0412/3

MOBIL CAMPANAS BUHOS (C)
Ampliar!

CODIGO: AC0412/2

MOBIL CAMPANAS BUHOS (B)
Ampliar!

CODIGO: AC0412/1

MOBIL CAMPANAS BUHOS (A)