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 300 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


Broasca, Strike, King, Kvd, Sexy, Frog,, Tiger,, 14.5cm,, 17.7g, sfkvd-153, Broaste Artificiale, Broaste Artificiale Fox Rage, Fox Rage
Spinner Tail Savage Gear Fat Tail Firetiger 6.5cm 16g

Spinner Tail Savage Gear Fat Tail Firetiger 6.5cm 16g

sg.71765
Livrare imediată!

37,41Lei

VOBLER, JAXON, ATRACT, XXT-H, FROG, F, B, 5.5CM, 11GR, vr-th055b, Voblere Floating, Voblere Floating Jaxon, Jaxon
Vobler Smith D Compact 4.5cm 3.5g 10 S -15%

Vobler Smith D Compact 4.5cm 3.5g 10 S

comp45.10
Livrare imediată!

95,00Lei(-15%) 80,75Lei

VOBLER, JAXON, ATRACT, XXT-H, FROG, F, D, 5.5CM, 11GR, vr-th055d, Voblere Floating, Voblere Floating Jaxon, Jaxon
Exclusiv online!

VOBLER, JAXON, ATRACT, XXT-H, FROG, F, D, 5.5CM, 11GR, vr-th055d, Voblere Floating, Voblere Floating Jaxon, Jaxon

vr-th055d
Livrare 48-72 ore

27,00Lei

VOBLER, JAXON, ATRACT, XXT-H, FROG, F, C, 5.5CM, 11GR, vr-th055c, Voblere Floating, Voblere Floating Jaxon, Jaxon
Vobler, Jaxon, Atract, XXT-H, Frog, Floating,, Culoare, B,, 4.5cm,, 7g, vr-th045b, Voblere Floating, Voblere Floating Jaxon, Voblere Jaxon, Floating Jaxon, Jaxon -20%
Kryston, MONTURA, KRYSTON, FLEX, CHOD, RIG, Short, 2.5cm, 15lb, 8, krcrs3, Monturi Crap, Monturi Crap Kryston, Kryston
Shad, Fox, Rage, UV, Micro, Tiddler, Fast, 5cm, 8buc/plic, nmc012, Shad-uri, Shad-uri Fox Rage, Fox Rage
Kryston, MONTURA, KRYSTON, FLEX, CHOD, RIG, Short, 2.5cm, 15lb, 4, krcrs1, Monturi Crap, Monturi Crap Kryston, Kryston
Exclusiv online!

Kryston, MONTURA, KRYSTON, FLEX, CHOD, RIG, Short, 2.5cm, 15lb, 4, krcrs1, Monturi Crap, Monturi Crap Kryston, Kryston

krcrs1
Livrare 48-72 ore

32,00Lei

VOBLER, JAXON, ATRACT, XXT-H, FROG, F, D, 4.5CM, 7GR, vr-th045d, Voblere Floating, Voblere Floating Jaxon, Jaxon
VOBLER, JAXON, ATRACT, XXT-H, FROG, F, C, 4.5CM, 7GR, vr-th045c, Voblere Floating, Voblere Floating Jaxon, Jaxon
Shad Gambler Little EZ, Red Ear, 9.5cm, 9buc/plic

Shad Gambler Little EZ, Red Ear, 9.5cm, 9buc/plic

ez3215
Livrare imediată!

26,60Lei

Saltea Primire Prologic Avenger Pro Crap 120x75cm -50%
Exclusiv online!

Saltea Primire Prologic Avenger Pro Crap 120x75cm

a.pro.65002
Livrare 24-48 ore

295,08Lei(-50%) 147,54Lei

DAIWA GEANTA 56cm x 32cm x 15cm
Exclusiv online!

DAIWA GEANTA 56cm x 32cm x 15cm

d.ddb1
Livrare 24-48 ore

666,71Lei

Kryston, MONTURA, KRYSTON, FLEX, CHOD, RIG, Short, 2.5cm, 15lb, 6, krcrs2, Monturi Crap, Monturi Crap Kryston, Kryston
Exclusiv online!

Kryston, MONTURA, KRYSTON, FLEX, CHOD, RIG, Short, 2.5cm, 15lb, 6, krcrs2, Monturi Crap, Monturi Crap Kryston, Kryston

krcrs2
Livrare 48-72 ore

32,00Lei

SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING FIRETIGER

SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING FIRETIGER

sg.71760
Livrare imediată!

35,25Lei

SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING PERCH

SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING PERCH

sg.71766
Livrare imediată!

37,41Lei

Kryston MONTURA KRYSTON FLEX CHOD RIG Short 2.5cm 25lb 4
Exclusiv online!

Kryston MONTURA KRYSTON FLEX CHOD RIG Short 2.5cm 25lb 4

krcrs4
Livrare 48-72 ore

32,00Lei

SUPORT MOSTIRO NN ALU STORM CU INFILETARE 67-115cm

SUPORT MOSTIRO NN ALU STORM CU INFILETARE 67-115cm

nn-6656
Livrare imediată!

17,50Lei

Afişare 61 - 80 din 8245 (413 pagini)
Queries: 8, Total time: 339.963 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '4e6b41a46c4e56e78eb4cfbb49'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (307.731)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%5cm%") 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:698
5 (31.633)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.087)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38