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


Valigeta Energo Team Fishing Box Tip373 -20%

Valigeta Energo Team Fishing Box Tip373

75084373
Stoc epuizat

13,99Lei(-20%) 11,20Lei

SHAD FIIISH BL MINOW 12CM COLOR BOX FLASHY BM641

SHAD FIIISH BL MINOW 12CM COLOR BOX FLASHY BM641

3700696806418
Stoc epuizat

39,90Lei

JIG GAMAKATSU NR2/0 4G 10BUC/BOX

JIG GAMAKATSU NR2/0 4G 10BUC/BOX

f2.jigk02n.4
Stoc epuizat

46,30Lei

JIG GAMAKATSU NR3/0 17G 10BUC/BOX

JIG GAMAKATSU NR3/0 17G 10BUC/BOX

f2.jigk03n.17
Stoc epuizat

44,49Lei

Geanta Colmic Orange Bait Box Holder

Geanta Colmic Orange Bait Box Holder

boxeva312
Stoc epuizat

110,00Lei

JIG CARLIG GAMAKATSU NR1,5G 10BUC/BOX

JIG CARLIG GAMAKATSU NR1,5G 10BUC/BOX

f2.jigk1n.5
Stoc epuizat

35,56Lei

Penar Baracuda Carp box 005

Penar Baracuda Carp box 005

penar carp box 005
Stoc epuizat

38,15Lei

Set Borsete DAM Detek Accesory Box System 6L 17.5x22x16cm

Set Borsete DAM Detek Accesory Box System 6L 17.5x22x16cm

9040966293
Stoc epuizat

254,62Lei

Cutie Baracuda Carp Box 001 verde 365x300x55mm

Cutie Baracuda Carp Box 001 verde 365x300x55mm

carp box 001
Stoc epuizat

105,90Lei

SET LINII SENSAS PESCUIT BIG FISH 7M 5BUC/BOX

SET LINII SENSAS PESCUIT BIG FISH 7M 5BUC/BOX

a.s05058
Stoc epuizat

124,20Lei

Geanta DAM Detek Accessory Box 1L 10x16x7cm

Geanta DAM Detek Accessory Box 1L 10x16x7cm

9040966291
Stoc epuizat

61,27Lei

Cutie Baracuda Carp Box 006 verde 340x160x60mm

Cutie Baracuda Carp Box 006 verde 340x160x60mm

cutie carp box 006
Stoc epuizat

36,74Lei

SET LINII SENSAS PESCUIT CARP 7M 5BUC/BOX

SET LINII SENSAS PESCUIT CARP 7M 5BUC/BOX

a.s05231
Stoc epuizat

124,15Lei

CUTIE PLANO FILLER LINE SPOOL BOX W LABEL 108401

CUTIE PLANO FILLER LINE SPOOL BOX W LABEL 108401

pmc108401
Stoc epuizat

69,50Lei

CUTIE ACCESORII PLANO CUSTOM DIVIDER STOWAWAY LURE BOX 3600 27.9X18.4X4.4CM

CUTIE ACCESORII PLANO CUSTOM DIVIDER STOWAWAY LURE BOX 3600 27.9X18.4X4.4CM

pmc367000
Stoc epuizat

69,50Lei

Cutie Momeala Cresta Maggot Box Square 1.2L

Cutie Momeala Cresta Maggot Box Square 1.2L

006403-00320-00000
Stoc epuizat

13,30Lei

PICIOR TELESCOPIC PRESTON ABSOLUTE SEAT BOX TELE LEGS 45CM

PICIOR TELESCOPIC PRESTON ABSOLUTE SEAT BOX TELE LEGS 45CM

abst/24
Stoc epuizat

125,96Lei

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 13cm Yellow 20buc/set

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 13cm Yellow 20buc/set

p0020027
Stoc epuizat

76,46Lei

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs GREENCH, 10.5cm, 30buc/pac

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs GREENCH, 10.5cm, 30buc/pac

101003915
Stoc epuizat

114,00Lei

PICIOR TELESCOPIC PRESTON ABSOLUTE SEAT BOX 36 TELE LEGS 47CM

PICIOR TELESCOPIC PRESTON ABSOLUTE SEAT BOX 36 TELE LEGS 47CM

abst/51
Stoc epuizat

112,46Lei

Afişare 521 - 540 din 576 (29 pagini)
Queries: 8, Total time: 14.844 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = '799966d0fef4ea1fe0d9d617a4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (11.831)
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('+box' 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 (2.282)
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 520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.115)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.126)
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