INGRESAR0

Nuestros productos

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

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

CODIGO: SC033

POT CEMENTO ANANA (23CM)
Ampliar!

CODIGO: SC032

POT CEMENTO CONO (18CM)
Ampliar!

CODIGO: SC029

BUHO CEMENTO (25.5CM)
Ampliar!

CODIGO: SC028

ARDILLA CEMENTO (17CM)
Ampliar!

CODIGO: SC027

BUHO CEMENTO (9.5CM)
Ampliar!

CODIGO: SC026

BUHO CEMENTO (10CM)
Ampliar!

CODIGO: SC025

BUHO CEMENTO (13.5CM)
Ampliar!

CODIGO: SC024

PAJARO CEMENTO (13CM)
Ampliar!

CODIGO: SC020

PINO CONO CEMENTO (12CM)
Ampliar!

CODIGO: SC019

PINO CONO CEMENTO (9CM)
Ampliar!

CODIGO: SC018

POT CEMENTO OVAL (12CM)