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


SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C012 6BUC/PLIC

SHAD STRIKE PRO PIGLET 10CM ALCATRAZ C012 6BUC/PLIC

sp.sp172e.c012
Livrare imediată!

53,17Lei

Geanta Plumbi Prologic Avanger L 20x10x12cm -20%
Exclusiv online!

Geanta Plumbi Prologic Avanger L 20x10x12cm

a8.pro.65071
Livrare 24-48 ore

71,50Lei(-20%) 57,19Lei

HANGER PROLOGIC K3 ROSU -20%
Exclusiv online!

HANGER PROLOGIC K3 ROSU

a.pro.62053
Livrare 24-48 ore

98,98Lei(-20%) 79,18Lei

Shad Owner Getnet Juster Fish 89mm 12 Pro Blue
Exclusiv online!

Shad Owner Getnet Juster Fish 89mm 12 Pro Blue

13013782919-12
Livrare 48-72 ore

33,03Lei

GEANTA CARP EXPERT PRO METHOD 57x27x29cm

GEANTA CARP EXPERT PRO METHOD 57x27x29cm

73301300
Livrare imediată!

168,00Lei

Shad Lucky John Pro Series S-Shad Tail 2.8inch 7.1cm 071 Lime Chartreuse 7 buc/plic
Exclusiv online!

Shad Lucky John Pro Series S-Shad Tail 2.8inch 7.1cm 071 Lime Chartreuse 7 buc/plic

140144-071
Livrare 48-72ore

15,51Lei

Shad Lucky John Pro Series Tioga, 7.4cm, T46 Natural Pro-Blue, 7buc/pac

Shad Lucky John Pro Series Tioga, 7.4cm, T46 Natural Pro-Blue, 7buc/pac

140103-t46
Livrare imediată!

20,00Lei

Momitor Carp Expert Method Feeder Pro Method Flat XXL 60g
Exclusiv online!

Momitor Carp Expert Method Feeder Pro Method Flat XXL 60g

58040060
Livrare 24-48 ore

11,00Lei

SAPCA PROLOGIC MEGA FISH ONE SIZE CAMO

SAPCA PROLOGIC MEGA FISH ONE SIZE CAMO

a8.pro.73765
Livrare imediată!

66,71Lei

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 301 1 buc/pac
Exclusiv online!

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 301 1 buc/pac

lj-v62-301
Livrare 48-72ore

33,00Lei

CICADA STRIKE PRO ASTRO VIBE 4.5CM/9.6G Culoare: 945
Exclusiv online!

CICADA STRIKE PRO ASTRO VIBE 4.5CM/9.6G Culoare: 945

sp.pjg005a.945
Livrare 24-48 ore

39,58Lei

Vobler Rapture Pro Hot Bean Area YMS 4cm 3.5g
Exclusiv online!

Vobler Rapture Pro Hot Bean Area YMS 4cm 3.5g

180-07-027
Livrare 48-72 ore

27,00Lei

Vobler Rapture Pro Fargo SQR F 6cm 11g BLS
Exclusiv online!

Vobler Rapture Pro Fargo SQR F 6cm 11g BLS

180-18-153
Livrare 48-72 ore

23,00Lei

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G MBG

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G MBG

180-42-109
Livrare imediată!

27,00Lei

VOBLER RAPTURE PRO RYUJIN PINK YAMAME 4.5CM 4G

VOBLER RAPTURE PRO RYUJIN PINK YAMAME 4.5CM 4G

180-17-457
Livrare imediată!

34,00Lei

Lanseta Fox EOS Pro 3.60M 3.5lb 2seg -20%

Lanseta Fox EOS Pro 3.60M 3.5lb 2seg

crd327
Livrare imediată!

335,40Lei(-20%) 269,90Lei

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G MK -19%

VOBLER RAPTURE PRO BEEATLE AREA F 28MM 2G MK

180-42-161
Livrare imediată!

22,00Lei(-19%) 17,73Lei

Carlige Prologic Swivel Hooks CS Curve Shank Nr.6 5buc/plic
Exclusiv online!

Carlige Prologic Swivel Hooks CS Curve Shank Nr.6 5buc/plic

a.pro.62081
Livrare 24-48 ore

25,75Lei

Sac Plutitor Crap Prologic C Series L 90x55cm -14%

Sac Plutitor Crap Prologic C Series L 90x55cm

a.pro.72672
Livrare imediată!

177,46Lei(-14%) 152,61Lei

SCAUN PROLOGIC INSPIRE LITE PRO -26%

SCAUN PROLOGIC INSPIRE LITE PRO

a8.pro.64161
Livrare imediată!

505,42Lei(-26%) 373,86Lei

Afişare 2141 - 2160 din 3912 (196 pagini)
Queries: 6, Total time: 90.702 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '8be2b103e03ca72bee65e075d5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (90.157)
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 (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
4 (0.165)
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
5 (0.136)
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.098)
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