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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


LANSETA PROLOGIC COMMANDER COMPACT 3.00M, 3.25LBS, 40MM, AR, 2SEG -20%
Exclusiv online!

LANSETA PROLOGIC COMMANDER COMPACT 3.00M, 3.25LBS, 40MM, AR, 2SEG

o.pro.72776
Livrare 24-48 ore

340,59Lei(-20%) 272,47Lei

VOBLER STRIKE PRO CRANKY X-DEEP 630V 6CM 16G
Exclusiv online!

VOBLER STRIKE PRO CRANKY X-DEEP 630V 6CM 16G

sp.eg168l.630v
Livrare 24-48 ore

39,13Lei

VOBLER STRIKE PRO THE FLEA SUSPENDING A010-EP 3CM 1.3G
Exclusiv online!

VOBLER STRIKE PRO THE FLEA SUSPENDING A010-EP 3CM 1.3G

sp.eg196.a010.ep
Livrare 24-48 ore

33,38Lei

VOBLER STRIKE PRO HOOLIGAN SHALLOW SUSPENDING GC01S 12CM 20.1G
Exclusiv online!

VOBLER STRIKE PRO HOOLIGAN SHALLOW SUSPENDING GC01S 12CM 20.1G

sp.eg220.gc01s
Livrare 24-48 ore

45,77Lei

VOBLER STRIKE PRO SKINNY MINI SINKING GC01S 5CM 4.5G
Exclusiv online!

VOBLER STRIKE PRO SKINNY MINI SINKING GC01S 5CM 4.5G

sp.eg222a.gc01s
Livrare 24-48 ore

38,40Lei

VOBLER STRIKE PRO THE FLEA SUSPENDING GC01S 3CM 1.3G
Exclusiv online!

VOBLER STRIKE PRO THE FLEA SUSPENDING GC01S 3CM 1.3G

sp.eg196.gc01s
Livrare 24-48 ore

33,38Lei

GEACA NORFIN VERITY PRO GRI XL
Exclusiv online!

GEACA NORFIN VERITY PRO GRI XL

737004-xl
Livrare 48-72ore

985,00Lei

SHAD LUCKY JOHN TIOGA PRO SERIES Osaka Pumpkin 6.1CM 9BUC/PLIC
Exclusiv online!

SHAD LUCKY JOHN TIOGA PRO SERIES Osaka Pumpkin 6.1CM 9BUC/PLIC

140119-pa19
Livrare 48-72ore

20,00Lei

SHAD LUCKY JOHN TIOGA PRO SERIES Pione 6.1CM 9BUC/PLIC
Exclusiv online!

SHAD LUCKY JOHN TIOGA PRO SERIES Pione 6.1CM 9BUC/PLIC

140119-f08
Livrare 48-72ore

20,00Lei

VOBLER STRIKE PRO THE FLEA SUSPENDING A70-713 3CM 1.3G
Exclusiv online!

VOBLER STRIKE PRO THE FLEA SUSPENDING A70-713 3CM 1.3G

sp.eg196.a70.713
Livrare 24-48 ore

33,38Lei

Buzz Bar Prologic Quick Release 2 Posturi 15-25cm -5%

Buzz Bar Prologic Quick Release 2 Posturi 15-25cm

a6.pro.72688
Livrare imediată!

95,81Lei(-5%) 91,30Lei

LANSETA PROLOGIC COMMANDER COMPACT 2.40M 2.25LBS 40MM AR 2SEG
Exclusiv online!

LANSETA PROLOGIC COMMANDER COMPACT 2.40M 2.25LBS 40MM AR 2SEG

o.pro.72774
Livrare 24-48 ore

277,48Lei

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC
Exclusiv online!

SHAD STRIKE PRO PIGLET C026 10CM 6BUC/PLIC

sp.sp172e.c026
Livrare 24-48 ore

53,17Lei

VOBLER STRIKE PRO POPPER SWING 096SA 8.5CM 9.8G

VOBLER STRIKE PRO POPPER SWING 096SA 8.5CM 9.8G

sp.eg030vl.096sa
Livrare imediată!

39,42Lei

Ancora Deriva Abu Garcia Beast Pro Drogue 120x120cm

Ancora Deriva Abu Garcia Beast Pro Drogue 120x120cm

1528365
Livrare imediată!

224,96Lei

CORT PROLOGIC AVENGER BIVVY/CONDENSER WARP 1PERS

CORT PROLOGIC AVENGER BIVVY/CONDENSER WARP 1PERS

a8.pro.64155
Livrare imediată!

1.529,50Lei

VOBLER STRIKE PRO SPRAT STICK SINKING A010-EP 5.5CM 7.3G

VOBLER STRIKE PRO SPRAT STICK SINKING A010-EP 5.5CM 7.3G

sp.eg141b.a010.ep
Livrare imediată!

36,63Lei

Creatura Libra Lures Pro Nymph 1.8cm 008 Cheese
Exclusiv online!

Creatura Libra Lures Pro Nymph 1.8cm 008 Cheese

nymph18-008
Livrare 48-72ore

29,50Lei

FIR TEXTIL TRABUCCO DYNA-TEX PRO SLK X8 LIME GREEN 150M 0.08mm 4.99kg -30%

FIR TEXTIL TRABUCCO DYNA-TEX PRO SLK X8 LIME GREEN 150M 0.08mm 4.99kg

055-00-080
Livrare imediată!

125,00Lei(-30%) 88,00Lei

VOBLER STRIKE PRO POPPER SWING 630V 8.5CM 9.8G
Exclusiv online!

VOBLER STRIKE PRO POPPER SWING 630V 8.5CM 9.8G

sp.eg030vl.630v
Livrare 24-48 ore

39,42Lei

Afişare 2081 - 2100 din 3891 (195 pagini)
Queries: 10, Total time: 105.373 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = '765dc6ac6bc0a5986f7987d33b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (88.726)
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('+pro' 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
5 (15.597)
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 2080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.153)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.114)
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