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 Pontoon21 GAD Footsie 9cm 1108

Shad Pontoon21 GAD Footsie 9cm 1108

6901124090080
Stoc epuizat

15,51Lei

Shad Pontoon21 GAD Footsie 9cm 2216

Shad Pontoon21 GAD Footsie 9cm 2216

6901124090158
Stoc epuizat

15,51Lei

Shad Pontoon21 GAD Footsie 9cm 2217

Shad Pontoon21 GAD Footsie 9cm 2217

6901124090165
Stoc epuizat

15,51Lei

Shad Relax Kopyto Floating 5cm, F003, 5 buc/plic

Shad Relax Kopyto Floating 5cm, F003, 5 buc/plic

bls2-f003-b
Stoc epuizat

9,00Lei

Shad Relax Kopyto Standard Blister, S171, 0.7g, 3cm, 8buc/plic

Shad Relax Kopyto Standard Blister, S171, 0.7g, 3cm, 8buc/plic

bls1-s171-b
Stoc epuizat

9,00Lei

Shad Relax Ohio Standard Blister S055, 12,5cm, 14g, 3buc/plic

Shad Relax Ohio Standard Blister S055, 12,5cm, 14g, 3buc/plic

oh5-s055-b
Stoc epuizat

13,99Lei

DUO Beach Walker Haul Head AJA0199 Shocking Pink 14g

DUO Beach Walker Haul Head AJA0199 Shocking Pink 14g

4525918067007
Stoc epuizat

83,00Lei

Kit Dropshot Berkley URBN

Kit Dropshot Berkley URBN

1525664
Stoc epuizat

52,46Lei

Select Easy Shad 8.9cm 209

Select Easy Shad 8.9cm 209

18702432
Stoc epuizat

12,99Lei

Set Naluci Abu Garcia Soft Bait Kit Paddletail, Assorted, 8cm, 60buc/cutie

Set Naluci Abu Garcia Soft Bait Kit Paddletail, Assorted, 8cm, 60buc/cutie

1580032p
Stoc epuizat

295,42Lei

Shad Abu Garcia Svartzonker McPerch, Motoroil Perch, 5.8g, 9cm, 8buc/plic
Shad Abu Garcia Svartzonker McPerch, Real Perch, 5.8g, 9cm, 8buc/plic

Shad Abu Garcia Svartzonker McPerch, Real Perch, 5.8g, 9cm, 8buc/plic

1514219
Stoc epuizat

55,42Lei

Shad Abu Garcia Svartzonker McPerch, Real Roach, 5.8g, 9cm, 8buc/plic

Shad Abu Garcia Svartzonker McPerch, Real Roach, 5.8g, 9cm, 8buc/plic

1514221
Stoc epuizat

55,42Lei

Shad Abu Garcia Svartzonker McPrech, Real Roach SVZ PDQ, 3.7g, 7.5cm, 8buc/plic
Shad Abu Garcia Svartzonker McPrey Kit, Real Roach, 11.5g, 12cm, 4buc/plic
Shad Bass Assassin Elite Shiner Sungill 10cm

Shad Bass Assassin Elite Shiner Sungill 10cm

bsaes95531
Stoc epuizat

26,10Lei

Shad Bass Assassin Turbo Acid Rain 10cm -15%

Shad Bass Assassin Turbo Acid Rain 10cm

bsassa25260
Stoc epuizat

29,00Lei(-15%) 24,64Lei

Shad Berkley Sick Vamper, Wagasaki, 9cm -10%

Shad Berkley Sick Vamper, Wagasaki, 9cm

1536472-bucxxx
Stoc epuizat

6,79Lei(-10%) 6,12Lei

Shad Daiwa Prorex Slim Shady, Color Mix 1, 10.5cm, 8.0g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Color Mix 1, 10.5cm, 8.0g, 4buc/pac

d.15100.700
Stoc epuizat

27,63Lei

Shad Delalande Chabot 9cm Camel 171

Shad Delalande Chabot 9cm Camel 171

3520519878145
Stoc epuizat

7,00Lei

Afişare 8181 - 8200 din 8386 (420 pagini)
Queries: 7, Total time: 222.351 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'fd154f31f81df3685971c510a4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (221.595)
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('+shad' 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:724
4 (0.155)
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.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
6 (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
7 (0.134)
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