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: 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: JC029

FLORERO WASH 23CM
Ampliar!

CODIGO: JC021

PORTAMACETA GARDEN 19CM
Ampliar!

CODIGO: JC019

PORTAMACETA GARDEN 16CM
Ampliar!

CODIGO: JC017

PORTAMACETA GARDEN 22CM
Ampliar!

CODIGO: JC016

PORTAMACETA GARDEN 21CM
Ampliar!

CODIGO: JC015

FLORERO GARDEN 26CM
Ampliar!

CODIGO: JC014

FLORERO GARDEN 23CM
Ampliar!

CODIGO: JC013

FLORERO GARDEN 38.5CM