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 50,50
Ampliar!

CODIGO: AC0508/5

SET (5) MINI BUHOS 0.06 (5)
Ampliar!

CODIGO: AC0508/4

SET (5) MINI BUHOS 0.06 (4)
Ampliar!

CODIGO: AC0505/6

SET (3) BUHOS C/PIE 0.17 (6)
Ampliar!

CODIGO: AC0505/5

SET (3) BUHOS C/PIE 0.17 (5)
Ampliar!

CODIGO: AC0505/2

SET (3) BUHOS C/PIE 0.17 (2)
Ampliar!

CODIGO: AC0505/1

SET (3) BUHOS C/PIE 0.17 (1)
Ampliar!

CODIGO: AC0490/3

SET (5) BUHO MULTICOLOR 10CM
Ampliar!

CODIGO: AC0490/2

SET (5) BUHO MULTICOLOR 6CM
Ampliar!

CODIGO: AC0487/3B

SET (3) BUHO DIBUJO 10CM (B)

CODIGO: AC0487/3A

SET (3) BUHO DIBUJO 10CM (A)
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: AC0481

PAJARO FULL GLASS 0.60 X1
Ampliar!

CODIGO: AC0471

SET (3) GATOS FLUO S/M/L
Ampliar!

CODIGO: AC0470

SET (3) CONEJOS FLUO
Ampliar!

CODIGO: AC0467

SET (3) PECES FLUO XS
Ampliar!

CODIGO: AC0466

SET (5) ELEFANTES FLUO
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/4

TUCAN MOSAICO 0.60
Ampliar!

CODIGO: AC0463/3

TUCAN MOSAICO 0.50
Ampliar!

CODIGO: AC0463

SET (5) GATO FLUO
Ampliar!

CODIGO: AC0462/1NA

TORTUGA MOSAICO X1 0.20 NARANJA