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 300 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


Lanseta, Telescopica, Trabucco, Solaris, XT, Hyper, Boat, 2.00m,, 150g,, 3seg, 168-21-320, Lansete Universale, Lansete Universale Trabucco, Lansete Pescuit din Barca, Lansete Pescuit din Barca Trabucco, Trabucco
Lanseta Trabucco Achab Pro Boat 2.70m, 150g, 2seg

Lanseta Trabucco Achab Pro Boat 2.70m, 150g, 2seg

161-11-330
Livrare imediată!

179,00Lei

Lanseta Trabucco Danubius Carp Pro 2.40m, 150g, 2seg

Lanseta Trabucco Danubius Carp Pro 2.40m, 150g, 2seg

161-12-310
Livrare imediată!

199,00Lei

BRAT MODULAR PRESTON OFFBOX 36 UNIVERSAL ARM
Exclusiv online!

BRAT MODULAR PRESTON OFFBOX 36 UNIVERSAL ARM

p0110082
Livrare 7-14 zile

107,96Lei

Lanseta Telescopica Sunset Medusa ZXR, 2.40m, 100-200g, 5seg

Lanseta Telescopica Sunset Medusa ZXR, 2.40m, 100-200g, 5seg

20311stsrj8137240-5
Livrare imediată!

118,18Lei

Lanseta Trabucco Achab Pro Boat 2.70m, 250g, 2seg

Lanseta Trabucco Achab Pro Boat 2.70m, 250g, 2seg

161-11-530
Livrare imediată!

210,00Lei

Lanseta Trabucco Searider Tekno Squid 1.80m, 120g, 1+1seg
Exclusiv online!

Lanseta Trabucco Searider Tekno Squid 1.80m, 120g, 1+1seg

160-88-040
Livrare 48-72 ore

195,01Lei

Cap, Suport, Filfishing, Feeder, Multi, Adjustabil, cu, Filet, Universal, fil9441, Capete Suport Feeder, Capete Suport Feeder Filfishing, Capete Filfishing, Suport Filfishing, Feeder Filfishing, Filfishing
Carlige Legate Mikado Carp Universal Rig, 23cm, 15Lbs, Nr. 8, 2buc/plic
Exclusiv online!

Carlige Legate Mikado Carp Universal Rig, 23cm, 15Lbs, Nr. 8, 2buc/plic

amc-pur2-8
Livrare 48-72 ore

12,00Lei

Geanta Preston Hardcase Tackle Safe Standard
Exclusiv online!

Geanta Preston Hardcase Tackle Safe Standard

p0130104
Livrare 48-72 ore

405,00Lei

Geanta Trakker NXG Camera Tech Bag, 36x28x15cm
Exclusiv online!

Geanta Trakker NXG Camera Tech Bag, 36x28x15cm

204932
Livrare 7-14 zile

374,95Lei

Geanta Umar Fox Rage Street Fighter
Exclusiv online!

Geanta Umar Fox Rage Street Fighter

nlu121
Livrare 7-14 zile

269,96Lei

Suport Sonar RAM Mounts Universal Marine Electronic Mount - D Size Short

Suport Sonar RAM Mounts Universal Marine Electronic Mount - D Size Short

ram-d-115-c
Livrare imediată!

982,80Lei

Geanta, EVA, Avid, Carp, Stormshield, 47x31x27cm, a0430085, Genti Universale, Genti Universale Avid Carp, Avid Carp
Exclusiv online!

Geanta, EVA, Avid, Carp, Stormshield, 47x31x27cm, a0430085, Genti Universale, Genti Universale Avid Carp, Avid Carp

a0430085
Livrare 7-14 zile

215,96Lei

Geanta Nash Carryall Medium, 33x70x35cm

Geanta Nash Carryall Medium, 33x70x35cm

t3547
Livrare imediată!

297,00Lei

Geanta, NGT, Carryall, Green,, 68x35x34cm, ngt-fla - carryall - 093, Genti Universale, Genti Universale NGT, NGT

Geanta, NGT, Carryall, Green,, 68x35x34cm, ngt-fla - carryall - 093, Genti Universale, Genti Universale NGT, NGT

ngt-fla - carryall - 093
Livrare imediată!

189,00Lei

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

Lanseta Sunset Dorada SW20, 2.10m, 250g, 3+1seg
Exclusiv online!

Lanseta Sunset Dorada SW20, 2.10m, 250g, 3+1seg

20111stsrj8313210-3+1
Livrare 48-72 ore

288,91Lei

Lanseta Telescopica Trabucco Scuba Xtreme Teknic Boat 2.10m, 120g, 3seg

Lanseta Telescopica Trabucco Scuba Xtreme Teknic Boat 2.10m, 120g, 3seg

162-69-010
Livrare imediată!

180,00Lei

Cutit Pliabil Spro Universal, 20.3cm

Cutit Pliabil Spro Universal, 20.3cm

004702-00092-00000
Livrare imediată!

75,01Lei

Afişare 481 - 500 din 729 (37 pagini)
Queries: 8, Total time: 200.400 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = 'b620c2e6109c52617a6b7a111a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.137)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (194.288)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%universal%") 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:698
5 (5.448)
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 480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.079)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.097)
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