INGRESAR0

Nuestros productos

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

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

CODIGO: FB3008/RO

GECKO COLOR ROSA ARENA 0.30
Ampliar!

CODIGO: FB3008/3

GECKO FLUO MULTI 0.50
Ampliar!

CODIGO: FB3008/2

GECKO FLUO MULTI 0.30
Ampliar!

CODIGO: FB3008/1

GECKO FLUO MULTI 0.15
Ampliar!

CODIGO: FB3007/VE

GECKO COLOR VERDE ARENA 0.15
Ampliar!

CODIGO: FB3007/RO

GECKO COLOR ROSA ARENA 0.15
Ampliar!

CODIGO: FB3007/CE

GECKO COLOR CELESTE ARENA 0.15
Ampliar!

CODIGO: FB3006/4

GEKO-LAGARTO NEW 0.15
Ampliar!

CODIGO: FB3005/1

GEKO-LAGARTO C/VIDRIO 0.30
Ampliar!

CODIGO: EMD60

ESPEJOS MULTICOLOR 0.60
Ampliar!

CODIGO: EMD50

ESPEJOS MULTICOLOR 0.50
Ampliar!

CODIGO: EMD30

ESPEJOS MULTICOLOR 0.30

CODIGO: CB1108

FRIZO ACERO DISCOS 80 CM
Ampliar!

CODIGO: AC0425/2

ELEFANTE MOSAICO MULTI 40CM