INGRESAR0

Nuestros productos

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

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

CODIGO: RS1235

CHANCHITO TARJETERO 8 CM
Ampliar!

CODIGO: RS1234

TORTUGA MIX COLORES 10 CM
Ampliar!

CODIGO: EBP123/2

KRISHNA RESINA 25CM BLANCO
Ampliar!

CODIGO: EB0838/2

CEBRA MULTICOLOR 25 CM
Ampliar!

CODIGO: EB0835/2

ELEFANTE MULTICOLOR 25 CM
Ampliar!

CODIGO: EB0835/1

ELEFANTE MULTICOLOR 20 CM
Ampliar!

CODIGO: EB0755/8

SET (3) BUHOS NEW (B)
Ampliar!

CODIGO: EB0755/2

SET X 3 BUHOS
Ampliar!

CODIGO: EB0755/1

SET (3) BUHOS 0.12 (A)
Ampliar!

CODIGO: EB0750

BUHO X1 0,40