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


Cort Coleman Meadowood 4 Long
Exclusiv online!

Cort Coleman Meadowood 4 Long

2000037068
Livrare 24-48 ore

4.950,00Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.25mm, 8.85kg, 300m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.25mm, 8.85kg, 300m

31722025
Livrare 24-48 ore

31,44Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.28mm, 10.35kg, 600m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.28mm, 10.35kg, 600m

31722128
Livrare 24-48 ore

48,00Lei

Penar monturi Preston Absolute Long Hooklength Box

Penar monturi Preston Absolute Long Hooklength Box

p0220123
Livrare imediată!

80,96Lei

Brat Trabucco GNT X-Connect Ripple Cross Long Arm
Exclusiv online!

Brat Trabucco GNT X-Connect Ripple Cross Long Arm

116-26-020
Livrare 48-72 ore

120,00Lei

Cutie Arma Plano Pro-Max Long Gun Case

Cutie Arma Plano Pro-Max Long Gun Case

pmc151101
Livrare imediată!

292,45Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 1200m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 1200m

31722422
Livrare 24-48 ore

82,32Lei

Plumbi Advance Helicopter Long Distance 110g

Plumbi Advance Helicopter Long Distance 110g

3155234295351
Livrare imediată!

7,00Lei

Bluza Jackall Long Sleeve, Gray, Marime L
Exclusiv online!

Bluza Jackall Long Sleeve, Gray, Marime L

ja.807239782
Livrare 24-48 ore

353,47Lei

Carlige Solar Stronghold Long Shank Hook, Nr.10, 10buc/plic -34%

Carlige Solar Stronghold Long Shank Hook, Nr.10, 10buc/plic

lsc10
Livrare imediată!

37,49Lei(-34%) 24,89Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.20mm, 5.45kg, 300m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.20mm, 5.45kg, 300m

31722020
Livrare 24-48 ore

27,36Lei

Geanta Nash Long Session Carryall XL

Geanta Nash Long Session Carryall XL

t3549
Livrare imediată!

639,99Lei

Lanseta Zeck Pro-Cat Sensi-Long, 3.20m, 350g, 2seg
Exclusiv online!

Lanseta Zeck Pro-Cat Sensi-Long, 3.20m, 350g, 2seg

20305100320
Livrare 48-72 ore

1.118,49Lei

Plumbi Advance Helicopter Long Distance 125g

Plumbi Advance Helicopter Long Distance 125g

2155234088695
Livrare imediată!

8,00Lei

Plumbi Advance Helicopter Long Distance 130g

Plumbi Advance Helicopter Long Distance 130g

6155235290871
Livrare imediată!

8,00Lei

Bluza Jackall Long Sleeve, Black, Marime 2XL
Exclusiv online!

Bluza Jackall Long Sleeve, Black, Marime 2XL

ja.807260625
Livrare 24-48 ore

353,47Lei

Bluza Jackall Long Sleeve, Black, Marime L
Exclusiv online!

Bluza Jackall Long Sleeve, Black, Marime L

ja.807239744
Livrare 24-48 ore

353,47Lei

Carlige Mikado Territory Teflon Coating Long Shank, Nr.4, 10buc/plic
Exclusiv online!

Carlige Mikado Territory Teflon Coating Long Shank, Nr.4, 10buc/plic

hct0000-4
Livrare 48-72 ore

20,00Lei

Carlige Solar Stronghold Long Shank Hook, Nr.1, 10buc/plic -10%

Carlige Solar Stronghold Long Shank Hook, Nr.1, 10buc/plic

lsc1
Livrare imediată!

41,65Lei(-10%) 37,49Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.28mm, 10.35kg, 300m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.28mm, 10.35kg, 300m

31722028
Livrare 24-48 ore

31,44Lei

Afişare 421 - 440 din 621 (32 pagini)
Queries: 6, Total time: 17.504 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = 'f4497c892e26b15264d672171f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.132)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (14.324)
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('+long' 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 (2.618)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.134)
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