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 MONOFILAMENT CARPZOOM BULL-DOG FEEDER 300m 0.22mm 6.4kg Brown

FIR MONOFILAMENT CARPZOOM BULL-DOG FEEDER 300m 0.22mm 6.4kg Brown

cz6444
Stoc epuizat

18,50Lei

MOMITOR SENSAS METHOD FEEDER M 35G

MOMITOR SENSAS METHOD FEEDER M 35G

a.s62678
Stoc epuizat

13,74Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRF 1.0oz Tip Carbon 2.8mm

Varf de Rezerva pentru Lansete Matrix Ethos XRF 1.0oz Tip Carbon 2.8mm

grd204
Stoc epuizat

107,96Lei

Carlige legate FUDO BREAM - BN NR 6 0.14 mm/ 85 cm -20%

Carlige legate FUDO BREAM - BN NR 6 0.14 mm/ 85 cm

fdsh-004-6
Stoc epuizat

10,00Lei(-20%) 8,00Lei

Carlige legate FUDO CRUCIAN CARP - BN NR 10 0.14 mm/ 70 cm -20%

Carlige legate FUDO CRUCIAN CARP - BN NR 10 0.14 mm/ 70 cm

fdsh-006-10
Stoc epuizat

10,00Lei(-20%) 8,00Lei

Monturi GURU CARLIG QM1 STANDARD HAIR 0.17MM NR.16 8BUC/PLIC

Monturi GURU CARLIG QM1 STANDARD HAIR 0.17MM NR.16 8BUC/PLIC

a.gu.grr108
Stoc epuizat

27,00Lei

VARF LANSETA TRABUCCO TRINIS FX FEEDER Solid Tip 5

VARF LANSETA TRABUCCO TRINIS FX FEEDER Solid Tip 5

150-71-005
Stoc epuizat

59,00Lei

Carlige legate FUDO SWEET CORN - GD NR 6 0.16 mm/ 70 cm -20%

Carlige legate FUDO SWEET CORN - GD NR 6 0.16 mm/ 70 cm

fdsh-003-6
Stoc epuizat

10,00Lei(-20%) 8,00Lei

CON PROTECTIE GURU SPARE INLINE TUBE TAIL RUBBER 10BUC/PLIC

CON PROTECTIE GURU SPARE INLINE TUBE TAIL RUBBER 10BUC/PLIC

a.gu.gti
Stoc epuizat

15,78Lei

Carlige legate FUDO MAGGOT - BN NR 8 0.12 mm/ 50 cm -20%

Carlige legate FUDO MAGGOT - BN NR 8 0.12 mm/ 50 cm

fdsh-005-8
Stoc epuizat

10,00Lei(-20%) 8,00Lei

LANSETA MAVER REALITY EVO FEEDER 3.60M 50G 3+2SEG

LANSETA MAVER REALITY EVO FEEDER 3.60M 50G 3+2SEG

a3185
Stoc epuizat

518,99Lei

Carlige Fudo Feeder-1 BN Nr.16 9buc/plic

Carlige Fudo Feeder-1 BN Nr.16 9buc/plic

8301-16
Stoc epuizat

10,00Lei

Lanseta SPORTEX Rapid Feeder Medium XS 2.70m, 80-150g, 2+3seg

Lanseta SPORTEX Rapid Feeder Medium XS 2.70m, 80-150g, 2+3seg

mf2731
Stoc epuizat

850,01Lei

ADITIV CARP ZOOM METHOD CRUSH FEEDER COMPETITION 120G

ADITIV CARP ZOOM METHOD CRUSH FEEDER COMPETITION 120G

cz5356
Stoc epuizat

11,00Lei

Varf Cormoran Feeder Tip Yellow S 1.5oz

Varf Cormoran Feeder Tip Yellow S 1.5oz

c.25.2120y
Stoc epuizat

22,79Lei

Carlige legate FUDO MAGGOT - BN NR 10 0.10 mm/ 50 cm -20%

Carlige legate FUDO MAGGOT - BN NR 10 0.10 mm/ 50 cm

fdsh-005-10
Stoc epuizat

10,00Lei(-20%) 8,00Lei

MOMITOR SENSAS METHOD FEEDER S 35G

MOMITOR SENSAS METHOD FEEDER S 35G

a.s62676
Stoc epuizat

13,74Lei

Lanseta feeder Maver IT POWERLITE F FEEDER 9FT 2.7M 2SEC 40GR

Lanseta feeder Maver IT POWERLITE F FEEDER 9FT 2.7M 2SEC 40GR

5765002
Stoc epuizat

470,00Lei

Lanseta SPORTEX Rapid Feeder Heavy XS 2.70m, 120-210g, 2+3seg

Lanseta SPORTEX Rapid Feeder Heavy XS 2.70m, 120-210g, 2+3seg

hf2719
Stoc epuizat

910,00Lei

Juvelnic Garbolino Super Rocket Carp 3.50m

Juvelnic Garbolino Super Rocket Carp 3.50m

50530gomae0180350
Stoc epuizat

244,09Lei

Afişare 12141 - 12160 din 12499 (625 pagini)
Queries: 10, Total time: 289.981 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '8a0999475cec3cf35bc1fa8a2d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (288.918)
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('+feeder' 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.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.124)
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