INGRESAR0

Nuestros productos

select count(articulos.codigo) from articulos where articulos.idrubro =24 and Visible<>1 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.habilitado=1 and articulos.Agotado != 1 order by codigo DESC, descripcion desc LIMIT 300,50
Ampliar!

CODIGO: AC0490/3

SET (5) BUHO MULTICOLOR 10CM
Ampliar!

CODIGO: AC0490/2

SET (5) BUHO MULTICOLOR 6CM
Ampliar!

CODIGO: AC0490/1

SET (5) BUHO MULTICOLOR 4CM
Ampliar!

CODIGO: AC0487/3B

SET (3) BUHO DIBUJO 10CM (B)
Ampliar!

CODIGO: AC0487/1C

SET (3) BUHO GECKO 10CM (C)
Ampliar!

CODIGO: AC0487/1B

SET (3) BUHO GECKO 10CM (B)
Ampliar!

CODIGO: AC0487/1A

SET (3) BUHO GECKO 10CM (A)
Ampliar!

CODIGO: AC0486/3B

SET (3) BUHO DIBUJO 7CM (B)
Ampliar!

CODIGO: AC0486/1B

SET (3) BUHO GECKO 7CM (B)
Ampliar!

CODIGO: AC0476

BUHO MADERA C VIDRIO 0.10
Ampliar!

CODIGO: AC0470

SET (3) CONEJOS FLUO
Ampliar!

CODIGO: AC0467

SET (3) PECES FLUO XS
Ampliar!

CODIGO: AC0465

SET (5) CONEJOS FLUO
Ampliar!

CODIGO: AC0464

SET (5) CHANCHITOS FLUO
Ampliar!

CODIGO: AC0463/5

TUCAN MOSAICO 0.80
Ampliar!

CODIGO: AC0463

SET (5) GATO FLUO
Ampliar!

CODIGO: AC0462/2VE

TORTUGA MOSAICO X1 0.25 VERDE
Ampliar!

CODIGO: AC0462/2NE

TORTUGA MOSAICO X1 0.25 NEGRA
Ampliar!

CODIGO: AC0462/1RO

TORTUGA MOSAICO X1 0.20 ROJA
Ampliar!

CODIGO: AC0461RO

BUHO MOSAICO STAND 0.35 ROJO
Ampliar!

CODIGO: AC0460/3

PESCADO (C) MOSAICO X1 0,25
Ampliar!

CODIGO: AC0460/2

PESCADO (B) MOSAICO X1 0,25
Ampliar!

CODIGO: AC0460/1

PESCADO (A) MOSAICO X1 0,25
Ampliar!

CODIGO: AC0459

RANA MOSAICO X1 0,20
Ampliar!

CODIGO: AC0458RO

BUHO MOSAICO X1 0.20 ROJO
Ampliar!

CODIGO: AC0458NE

BUHO MOSAICO X1 0.20 NEGRO
Ampliar!

CODIGO: AC0457RO

BUHO MOSAICO X1 0.15 ROJO
Ampliar!

CODIGO: AC0457NE

BUHO MOSAICO X1 0.15 NEGRO