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


STRUNA DAIWA PROREX TITANIUM 30CM/12KG

STRUNA DAIWA PROREX TITANIUM 30CM/12KG

a7.17925.812
Livrare imediată!

20,69Lei

VOBLER SPRO IRIS SLOW SINKING PERCH 9.5 CM 37 GR
Exclusiv online!

VOBLER SPRO IRIS SLOW SINKING PERCH 9.5 CM 37 GR

004867-01204-00000
Livrare 48-72 ore

69,00Lei

Shad Biwaa DEUS 2" 5.1cm 303 Pro Blue 14/plic

Shad Biwaa DEUS 2" 5.1cm 303 Pro Blue 14/plic

b001500
Livrare imediată!

26,00Lei

Pat Prologic Commander Classic 6 Picioare 200x70cm -15%

Pat Prologic Commander Classic 6 Picioare 200x70cm

a8.pro.54332
Livrare imediată!

823,30Lei(-15%) 699,90Lei

Rucsac ProLogic Scaun Camuflaj Max5 34X32X51cm
Exclusiv online!

Rucsac ProLogic Scaun Camuflaj Max5 34X32X51cm

a8.pro.49080
Livrare 24-48 ore

534,08Lei

STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC
Exclusiv online!

STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC

617b15
Livrare 48-72 ore

64,00Lei

LANSETA SPRO CRX BAITCASTING TWITCH 2.00 M 20-50 GR 2 BUC
Exclusiv online!

LANSETA SPRO CRX BAITCASTING TWITCH 2.00 M 20-50 GR 2 BUC

002410-00200-00000
Livrare 48-72 ore

340,99Lei

STRUNE SPRO FINE LEADER 1X19W 20CM 13.7KG
Exclusiv online!

STRUNE SPRO FINE LEADER 1X19W 20CM 13.7KG

004623-02600-00302
Livrare 48-72 ore

10,00Lei

PLUTA JOKER PROFESSIONAL MATCH1 4G

PLUTA JOKER PROFESSIONAL MATCH1 4G

60733104
Livrare imediată!

20,00Lei

Twistere Spro Booby Trap Shad 9 Cm GOLDEN GOBY 4BUC
Exclusiv online!

Twistere Spro Booby Trap Shad 9 Cm GOLDEN GOBY 4BUC

004662-01001-00004
Livrare 48-72 ore

15,60Lei

Lanseta Spro C-TEC Governor Carp Spod New 3.90m 5lb 2seg

Lanseta Spro C-TEC Governor Carp Spod New 3.90m 5lb 2seg

002968-00391-00000
Livrare imediată!

315,00Lei

VOBLER RAPTURE PRO HELLION S LMY 50MM 3G

VOBLER RAPTURE PRO HELLION S LMY 50MM 3G

180-11-768
Livrare imediată!

23,00Lei

VOBLER STRIKE PRO CRANKY, A010, 4CM, 4.2G

VOBLER STRIKE PRO CRANKY, A010, 4CM, 4.2G

sp.eg164.a010
Livrare imediată!

31,02Lei

Lanseta Fox EOS Pro Spod Marker 3.60m 5lb 2seg -17%

Lanseta Fox EOS Pro Spod Marker 3.60m 5lb 2seg

crd334
Livrare imediată!

359,96Lei(-17%) 299,90Lei

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X5000 -20%
Exclusiv online!

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X5000

a.11.80111
Livrare 24-48 ore

101,54Lei(-20%) 81,22Lei

VOBLER DAIWA PROREX MICRO MINNOW, LIVE MINNOW, 3CM, 1.5G
Exclusiv online!

VOBLER DAIWA PROREX MICRO MINNOW, LIVE MINNOW, 3CM, 1.5G

f3.d15217.004
Livrare 24-48 ore

45,97Lei

SHAD STRIKE PRO PIG JR 15CM
Exclusiv online!

SHAD STRIKE PRO PIG JR 15CM

sp.sp172d.c018
Livrare 24-48 ore

53,17Lei

VOBLER DAIWA PROREX MICRO MINNOW, FIRE TIGER, 3CM, 1.5G
Exclusiv online!

VOBLER DAIWA PROREX MICRO MINNOW, FIRE TIGER, 3CM, 1.5G

f3.d15217.000
Livrare 24-48 ore

42,00Lei

VOBLER STRIKE PRO MONTERO 9CM/8,6G CUloareGC01S
Exclusiv online!

VOBLER STRIKE PRO MONTERO 9CM/8,6G CUloareGC01S

sp.eg190a.gc01s
Livrare 24-48 ore

44,01Lei

LINGURITA OSCILANTA MISU NICHELATA PROFI 11G

LINGURITA OSCILANTA MISU NICHELATA PROFI 11G

f3.osc.n.pr11
Livrare imediată!

14,54Lei

Afişare 3621 - 3640 din 7186 (360 pagini)
Queries: 5, Total time: 699.771 ms [By time] [By id] [By file]
1 (0.205)
SELECT data
FROM `oc_session`
WHERE session_id = '3a31d6cc8ec1e8ee3806791ae8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (669.727)
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 = '2' AND (pd.tag LIKE "%pro%") 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 (29.504)
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 3620, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.206)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38