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


Lanterna cap Energoteam Outdoor Vesta, 60 lumeni

Lanterna cap Energoteam Outdoor Vesta, 60 lumeni

74991515
Livrare imediată!

29,00Lei

Suport Delphin feeder EVA Vario

Suport Delphin feeder EVA Vario

101001470
Livrare imediată!

84,00Lei

Atractant Senzor DIP Neon Spray Capsuna 30ml

Atractant Senzor DIP Neon Spray Capsuna 30ml

snz99615
Livrare imediată!

14,00Lei

Wafter, 220Baits, Supreme, Fluo, 10, mm, portocaliu, Miere, &, Capsuna, 8242219761576, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters 220Baits, 220Baits
Capac Momitor Feeder Guru Particle Cap -20%

Capac Momitor Feeder Guru Particle Cap

a.gu.gad26
Livrare imediată!

18,54Lei(-20%) 14,90Lei

Aditiv Feeder Bait Method Booster Capsuni 100ml
Exclusiv online!

Aditiv Feeder Bait Method Booster Capsuni 100ml

fb18-2
Livrare 48-72 ore

22,00Lei

POP-UP CPK HA SQUID & CAPSUNA 16MM

POP-UP CPK HA SQUID & CAPSUNA 16MM

1000155
Livrare imediată!

22,00Lei

Cap suport Matrix Flexi Rod Butt Grip

Cap suport Matrix Flexi Rod Butt Grip

gba055
Livrare imediată!

34,11Lei

Cap Minciog Trabucco Cauciucat XDS Power 50x40cm
Exclusiv online!

Cap Minciog Trabucco Cauciucat XDS Power 50x40cm

083-69-830
Livrare 48-72 ore

95,00Lei

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 38X45X30

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 38X45X30

083-69-110
Livrare imediată!

68,00Lei

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 40X50X30

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 40X50X30

083-69-120
Livrare imediată!

72,00Lei

Wafter, 220Baits, Supreme, Fluo, 10, mm, visiniu, Capsuni, &, N-Butyric, 3242216885355, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters 220Baits, 220Baits
SUPORT MOSTIRO NN REGLABIL ALU + CAP PLASTIC 80-135CM

SUPORT MOSTIRO NN REGLABIL ALU + CAP PLASTIC 80-135CM

nn-6658
Livrare imediată!

24,89Lei

Cap Minciog Trabucco Cauciucat XDS Power 45x35cm
Exclusiv online!

Cap Minciog Trabucco Cauciucat XDS Power 45x35cm

083-69-820
Livrare 48-72 ore

95,00Lei

CAP SUPORT FEEDER TF BY DOME DIN EVA 30CM

CAP SUPORT FEEDER TF BY DOME DIN EVA 30CM

7325-012
Livrare imediată!

64,00Lei

CUREA PIELE ARROW INTERNATIONAL 29MM CAPTUSITA CU NEOPREN PENTRU ARMA
Exclusiv online!

CUREA PIELE ARROW INTERNATIONAL 29MM CAPTUSITA CU NEOPREN PENTRU ARMA

ve.14.02.6
Livrare 24-48 ore

83,47Lei

Wafter, 220Baits, Supreme, Fluo, 6, mm, portocaliu, Miere, &, Capsuna, 5242215413762, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters 220Baits, 220Baits
Cap Minciog Trabucco Cauciucat XDS Micro 50x40x40
Exclusiv online!

Cap Minciog Trabucco Cauciucat XDS Micro 50x40x40

083-69-630
Livrare 48-72 ore

90,00Lei

LANTERNA CAP CARP ACADEMY 60 lumeni
Exclusiv online!

LANTERNA CAP CARP ACADEMY 60 lumeni

4817-002
Livrare 48-72 ore

67,00Lei

SUPORT MOSTIRO NN REGLABIL ALU + CAP PLASTIC 65-105CM

SUPORT MOSTIRO NN REGLABIL ALU + CAP PLASTIC 65-105CM

nn-6659
Livrare imediată!

19,90Lei

Afişare 141 - 160 din 2384 (120 pagini)
Queries: 5, Total time: 245.953 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'd7e78219e1034b540362f9b8ed'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (236.179)
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 "%cap%") 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
4 (9.459)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.099)
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