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


Ancora Deriva Abu Garcia Beast Pro Drogue 80x80cm -32%

Ancora Deriva Abu Garcia Beast Pro Drogue 80x80cm

1537278
Livrare imediată!

158,87Lei(-32%) 107,90Lei

VOBLER STRIKE PRO SKINNY MINI SINKING A142-264 5CM 4.5G
Exclusiv online!

VOBLER STRIKE PRO SKINNY MINI SINKING A142-264 5CM 4.5G

sp.eg222a.a142.264
Livrare 24-48 ore

38,40Lei

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

Creatura Libra Lures Pro Nymph 1.8cm 011 Cheese

nymph18-011
Livrare 48-72ore

29,50Lei

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

Creatura Libra Lures Pro Nymph 1.8cm 018 Cheese

nymph18-018
Livrare 48-72ore

29,50Lei

GEACA NORFIN VERITY PRO GRI L
Exclusiv online!

GEACA NORFIN VERITY PRO GRI L

737003-l
Livrare 48-72ore

985,00Lei

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

FIR TEXTIL TRABUCCO DYNA-TEX PRO SLK X8 LIME GREEN 150M 0.10mm 6.21kg

055-00-100
Livrare imediată!

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

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

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

140119-t52
Livrare 48-72ore

20,00Lei

CAP MINCIOG TRABUCCO TR PRO NET TX-3D 2MESH 55X60

CAP MINCIOG TRABUCCO TR PRO NET TX-3D 2MESH 55X60

083-66-040
Livrare imediată!

62,00Lei

Spinnertail Spro ASP Spinner UV 14g Firetiger
Exclusiv online!

Spinnertail Spro ASP Spinner UV 14g Firetiger

004341-02020-00000
Livrare 48-72 ore

45,01Lei

Cutie Plano Deep Waterproof StowAway 3700 35.6x22.3x7.6cm -26%
Exclusiv online!

Cutie Plano Deep Waterproof StowAway 3700 35.6x22.3x7.6cm

pmc374310
Livrare 7-14 zile

99,00Lei(-26%) 72,99Lei

Fir Inaintas Conic Exocet Pro Double Tapered Mainline 0.33mm-0.50mm, 300m

Fir Inaintas Conic Exocet Pro Double Tapered Mainline 0.33mm-0.50mm, 300m

cml193
Livrare imediată!

71,96Lei

SHAD SPRO SCENT SERIES INSTA 9CM SNOWFLAKE 5BUC

SHAD SPRO SCENT SERIES INSTA 9CM SNOWFLAKE 5BUC

004689-00507-00000
Livrare imediată!

25,00Lei

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

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

140119-t61
Livrare 48-72ore

20,00Lei

Trepied Cantarire Prowess 185cm

Trepied Cantarire Prowess 185cm

60133prcad1003
Livrare imediată!

256,59Lei

VOBLER STRIKE PRO POPPER SWING 938 8.5CM 9.8G

VOBLER STRIKE PRO POPPER SWING 938 8.5CM 9.8G

sp.eg030vl.938
Livrare imediată!

39,42Lei

VOBLER STRIKE PRO SKINNY MINI SINKING SIN057-713 5CM 4.5G
Exclusiv online!

VOBLER STRIKE PRO SKINNY MINI SINKING SIN057-713 5CM 4.5G

sp.eg222a.sin057.713
Livrare 24-48 ore

38,40Lei

Cutie Plano 360710 ProLatch 3600 Size Open Compartments Stowaway Boxes Clear 27.3x18.4x4.44cm -10%

Cutie Plano 360710 ProLatch 3600 Size Open Compartments Stowaway Boxes Clear 27.3x18.4x4.44cm

pmc360710
Livrare imediată!

54,50Lei(-10%) 49,05Lei

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

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

140119-t46
Livrare 48-72ore

20,00Lei

VOBLER STRIKE PRO SPRAT STICK SINKING A53 5.5CM 7.3G
Exclusiv online!

VOBLER STRIKE PRO SPRAT STICK SINKING A53 5.5CM 7.3G

sp.eg141b.a53
Livrare 24-48 ore

36,63Lei

Ochelari Protectie Browning ProShooter Clear
Exclusiv online!

Ochelari Protectie Browning ProShooter Clear

bo.127177
Livrare 24-48 ore

202,51Lei

Afişare 4281 - 4300 din 7177 (359 pagini)
Queries: 13, Total time: 818.540 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'ae4cddb765df5af63c785043cc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (722.068)
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 (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 (31.353)
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 4280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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
6 (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
7 (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
8 (0.119)
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.119)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=145169'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
10 (0.118)
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
11 (0.121)
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
12 (63.923)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
13 (0.131)
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