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


Fir Carbotex Monofilament Trolling&Sea Fishing 0.46mm/15kg/250m

Fir Carbotex Monofilament Trolling&Sea Fishing 0.46mm/15kg/250m

e.5300.046
Livrare imediată!

22,43Lei

Rhino 16g 115mm Trolling Spoons MAG lollipop -46%

Rhino 16g 115mm Trolling Spoons MAG lollipop

3395041
Livrare imediată!

31,29Lei(-46%) 16,90Lei

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG gold green dolphin -28%

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG gold green dolphin

3395106
Livrare imediată!

40,28Lei(-28%) 28,91Lei

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG furuncle -53%

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG furuncle

3395120
Livrare imediată!

40,28Lei(-53%) 18,90Lei

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG beluga -51%

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG beluga

3395104
Livrare imediată!

40,28Lei(-51%) 19,90Lei

Pilker Rhino 16g 115mm Trolling Spoons MAG -52%

Pilker Rhino 16g 115mm Trolling Spoons MAG

3395006
Livrare imediată!

31,29Lei(-52%) 14,90Lei

Pilker Rhino 16g 115mm Trolling Spoons MAG beluga -36%

Pilker Rhino 16g 115mm Trolling Spoons MAG beluga

3395004
Livrare imediată!

31,29Lei(-36%) 19,90Lei

Pilker Rhino 16g 115mm Trolling Spoons MAG furuncle -52%

Pilker Rhino 16g 115mm Trolling Spoons MAG furuncle

3395020
Livrare imediată!

31,29Lei(-52%) 14,90Lei

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG old witch -53%

Pilker Rhino 27g 150mm Trolling Spoons Xtra MAG old witch

3395129
Livrare imediată!

40,28Lei(-53%) 18,90Lei

Pilker Rhino 16g 115mm Trolling Spoons MAG old witch -52%

Pilker Rhino 16g 115mm Trolling Spoons MAG old witch

3395029
Livrare imediată!

31,29Lei(-52%) 14,90Lei

Pilker Rhino 16g 115mm Trolling Spoons MAG rainbow trout -46%

Pilker Rhino 16g 115mm Trolling Spoons MAG rainbow trout

3395008
Livrare imediată!

31,29Lei(-46%) 16,90Lei

Lanseta Abu Garcia Seven Trolling 2.10m 15lb 2buc -23%

Lanseta Abu Garcia Seven Trolling 2.10m 15lb 2buc

1111023
Livrare imediată!

148,70Lei(-23%) 114,89Lei

Rhino 16g 115mm Trolling Spoons MAG gold swedish flag 1 / buc -47%

Rhino 16g 115mm Trolling Spoons MAG gold swedish flag 1 / buc

3395034
Livrare imediată!

28,16Lei(-47%) 14,90Lei

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling m 2.10m, 12-25lbs, 2seg

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling m 2.10m, 12-25lbs, 2seg

dam.64861
Livrare imediată!

130,75Lei

Lanseta Abu Garcia Altum Trolling Rod 3.04m, 15-30lbs -31%

Lanseta Abu Garcia Altum Trolling Rod 3.04m, 15-30lbs

1516848
Livrare imediată!

357,95Lei(-31%) 246,90Lei

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling M 2.40m, 12-25lbs, 2seg

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling M 2.40m, 12-25lbs, 2seg

dam.64862
Livrare imediată!

135,96Lei

Pilker Rhino Trolling Spoons Xtra MAG Gold Swedish Flag 15cm, 27g -53%

Pilker Rhino Trolling Spoons Xtra MAG Gold Swedish Flag 15cm, 27g

3395134
Livrare imediată!

40,28Lei(-53%) 18,90Lei

Clema cu Stift Rhino Trolling Clip 3buc/pac -51%

Clema cu Stift Rhino Trolling Clip 3buc/pac

6234001
Livrare imediată!

40,28Lei(-51%) 19,90Lei

Pilker Rhino Trolling Spoons Xtra MAG Lollipop 15cm, 27g -46%

Pilker Rhino Trolling Spoons Xtra MAG Lollipop 15cm, 27g

3395141
Livrare imediată!

40,28Lei(-46%) 21,90Lei

Pluta Rapitori Quantum Mr. Pike Trolling Float, 30g, 125mm -41%

Pluta Rapitori Quantum Mr. Pike Trolling Float, 30g, 125mm

5244001
Livrare imediată!

26,78Lei(-41%) 15,90Lei

Afişare 1 - 20 din 51 (3 pagini)
Queries: 5, Total time: 2.905 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'a41249678edd1dc99609a92f44'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.151)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.076)
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('+trolling' 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.408)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.121)
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