articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


CICADA JAXON MAGIC FISH 10CM 38GR F
Exclusiv online!

CICADA JAXON MAGIC FISH 10CM 38GR F

tx-e10f
Livrare 48-72 ore

64,00Lei

CICADA JAXON VIBRO HOLO REFLEX 2A 9GR

CICADA JAXON VIBRO HOLO REFLEX 2A 9GR

bw-hjk02a
Livrare imediată!

11,50Lei

CICADA JAXON MAGIC FISH 10CM 38GR K
Exclusiv online!

CICADA JAXON MAGIC FISH 10CM 38GR K

tx-e10k
Livrare 48-72 ore

64,00Lei

CICADA STRIKE PRO 4.5CM/9.1G CYBER VIBE

CICADA STRIKE PRO 4.5CM/9.1G CYBER VIBE

sp.jg005c.788e
Livrare imediată!

30,71Lei

Cicada DAM Salt-X Pilk-Blade 100gr Cod
Exclusiv online!

Cicada DAM Salt-X Pilk-Blade 100gr Cod

13060966084
Livrare 48-72 ore

55,03Lei

Cicada Strike PRO 7.5cm, 26.3g, JU007E Astro Vibe
Exclusiv online!

Cicada Strike PRO 7.5cm, 26.3g, JU007E Astro Vibe

sp.pjg005c.ju007e
Livrare 24-48 ore

34,00Lei

CICADA JAXON MAGIC FISH 8CM 16GR C

CICADA JAXON MAGIC FISH 8CM 16GR C

tx-h08c
Livrare imediată!

79,00Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Metal Silver
Exclusiv online!

Cicada Sakura Micro Soukouss Blade 35mm 7g Metal Silver

130634saplg501435-ms
Livrare 48-72 ore

31,34Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Bronze Perch
Exclusiv online!

Cicada Sakura Micro Soukouss Blade 35mm 7g Bronze Perch

130634saplg501435-016
Livrare 48-72 ore

31,34Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

130634saplg501435-m14
Livrare imediată!

31,34Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Pearl White
Exclusiv online!

Cicada Sakura Micro Soukouss Blade 35mm 7g Pearl White

130634saplg501435-p06
Livrare 48-72 ore

31,34Lei

Cicada DAM Salt-X Pilk-Blade 100gr Fluo Pink UV
Exclusiv online!

Cicada DAM Salt-X Pilk-Blade 100gr Fluo Pink UV

13060966085
Livrare 48-72 ore

55,03Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G BLUE PINK STRIPES -23%

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G BLUE PINK STRIPES

sg.71443
Livrare imediată!

35,25Lei(-23%) 27,12Lei

CICADA JAXON MAGIC FISH 8CM 19GR F
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 19GR F

tx-e08f
Livrare 48-72 ore

70,00Lei

CICADA JAXON MAGIC FISH 8CM 16GR E
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 16GR E

tx-h08e
Livrare 48-72 ore

79,00Lei

CICADA JAXON MAGIC FISH 8CM 19GR B
Exclusiv online!

CICADA JAXON MAGIC FISH 8CM 19GR B

tx-e08b
Livrare 48-72 ore

70,00Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G GREEN SILVER AYU

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G GREEN SILVER AYU

sg.71441
Livrare imediată!

35,25Lei

CICADA JAXON MAGIC FISH 6CM 7GR E
Exclusiv online!

CICADA JAXON MAGIC FISH 6CM 7GR E

tx-e06e
Livrare 48-72 ore

78,00Lei

CICADA JAXON VIBRO HOLO REFLEX 1A 7GR

CICADA JAXON VIBRO HOLO REFLEX 1A 7GR

bw-hjk01a
Livrare imediată!

11,00Lei

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G BLUE PINK SMOLT
Exclusiv online!

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G BLUE PINK SMOLT

sg.63748
Livrare 24-48 ore

34,34Lei

Afişare 361 - 380 din 837 (42 pagini)
Queries: 5, Total time: 21.545 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'd61543ac37845887a5ebadb351'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.959)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+cicade' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (3.220)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38