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


Baliza Luminoasa Fox Halo Illuminated Marker Pole Remote 1 Pole Kit Plus Telecomanda

Baliza Luminoasa Fox Halo Illuminated Marker Pole Remote 1 Pole Kit Plus Telecomanda

cei180
Livrare imediată!

944,96Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - CCA

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - CCA

bscom09 cca
Livrare imediată!

31,00Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - SG
Exclusiv online!

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - SG

bscom09 sg
Livrare 48-72ore

31,00Lei

K-Karp Drake Stiff Hanger Illuminated Verde
Exclusiv online!

K-Karp Drake Stiff Hanger Illuminated Verde

190-40-430
Livrare 48-72 ore

39,00Lei

Acumulator Agm Vrla 12V 102A Gel Deep Cycle 328mm x 172mm x h 214mm

Acumulator Agm Vrla 12V 102A Gel Deep Cycle 328mm x 172mm x h 214mm

m8ted
Livrare imediată!

1.318,98Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - MU
Exclusiv online!

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - MU

bscom09 mu
Livrare 48-72ore

31,00Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 5/0 5buc/plic

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 5/0 5buc/plic

vc97hmm5/0
Livrare imediată!

20,00Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 2/0 8buc/plic

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 2/0 8buc/plic

vc97hmh2/0
Livrare imediată!

17,01Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 1/0 8buc/plic
Exclusiv online!

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 1/0 8buc/plic

vc97hmh1/0
Livrare 48-72 ore

17,01Lei

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura XXL -49%

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura XXL

000104-0002-2xl
Livrare imediată!

976,00Lei(-49%) 499,90Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 3/0 7buc/plic
Exclusiv online!

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 3/0 7buc/plic

vc97hmh3/0
Livrare 48-72 ore

17,01Lei

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura L -49%

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura L

000104-0002-ll
Livrare imediată!

976,00Lei(-49%) 499,90Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - FT

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - FT

bscom09 ft
Livrare imediată!

31,00Lei

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura XL -49%

Salopeta Impermeabila FHM BIB Overalls Guard Insulated Black Masura XL

000104-0002-xl
Livrare imediată!

976,00Lei(-49%) 499,90Lei

Momitor DAM Detek Pellet Feeder Elasticated 25g -30%

Momitor DAM Detek Pellet Feeder Elasticated 25g

a.dam.66029
Livrare imediată!

13,61Lei(-30%) 9,52Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION LIGHT CLASS NR 3 5buc/plic
Exclusiv online!

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION LIGHT CLASS NR 3 5buc/plic

vc97hml003
Livrare 48-72 ore

17,01Lei

Cap Baliza Luminoasa Fox Halo Illuminated Marker Pole Capsule
Exclusiv online!

Cap Baliza Luminoasa Fox Halo Illuminated Marker Pole Capsule

cei185
Livrare 7-14 zile

170,96Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 3/0 6buc/plic

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION MONSTER CLASS NR 3/0 6buc/plic

vc97hmm3/0
Livrare imediată!

17,01Lei

Momitor DAM Detek Pellet Feeder Elasticated 15g -30%
Exclusiv online!

Momitor DAM Detek Pellet Feeder Elasticated 15g

a.dam.66028
Livrare 24-48 ore

12,83Lei(-30%) 8,98Lei

Acumulator Agm Vrla 12V 77A Gel Deep Cycle 260mm x 167mm x 210mm

Acumulator Agm Vrla 12V 77A Gel Deep Cycle 260mm x 167mm x 210mm

m6ted
Livrare imediată!

950,00Lei

Afişare 1 - 20 din 1135 (57 pagini)
Queries: 11, Total time: 797.156 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'b137129c135bd6bd364acc3352'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (420.853)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%ted%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (375.167)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%ted%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
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
6 (0.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.142)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.161)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%ted%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014
9 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (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