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


RUCSAC JAXON X-TEAM CAMOU 30x20x50CM
Exclusiv online!

RUCSAC JAXON X-TEAM CAMOU 30x20x50CM

uj-xdd02
Livrare 48-72 ore

191,99Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.18mm, 5kg, 150m
Exclusiv online!

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.18mm, 5kg, 150m

110706202150018
Livrare 48-72 ore

17,97Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.22mm, 6.7kg, 150m
Exclusiv online!

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.22mm, 6.7kg, 150m

110706202150022
Livrare 48-72 ore

21,67Lei

Fir Monofilament Team Feeder By Dome Camou Blue, 1000m, 0.20mm, 5.30kg
Exclusiv online!

Fir Monofilament Team Feeder By Dome Camou Blue, 1000m, 0.20mm, 5.30kg

3256-120
Livrare 48-72 ore

135,01Lei

Fir Monofilament Team Feeder By Dome Camou Blue, 1000m, 0.22mm, 6.20kg
Exclusiv online!

Fir Monofilament Team Feeder By Dome Camou Blue, 1000m, 0.22mm, 6.20kg

3256-122
Livrare 48-72 ore

135,01Lei

HUSA LANSETE JAXON X-TEAM CAMOU, 3 COMPARTIMENTE, 130CM
Exclusiv online!

HUSA LANSETE JAXON X-TEAM CAMOU, 3 COMPARTIMENTE, 130CM

uj-xdc130
Livrare 48-72 ore

143,00Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.25mm, 8kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.25mm, 8kg

110106229001025
Livrare 48-72 ore

36,96Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.28mm, 10kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.28mm, 10kg

110106229001028
Livrare 48-72 ore

39,51Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.30mm, 11.3kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.30mm, 11.3kg

110106229001030
Livrare 48-72 ore

40,53Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.20mm, 5.9kg, 150m
Exclusiv online!

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.20mm, 5.9kg, 150m

110706202150020
Livrare 48-72 ore

19,64Lei

GEANTA JAXON X-TEAM CAMOU, 56x30x26cm
Exclusiv online!

GEANTA JAXON X-TEAM CAMOU, 56x30x26cm

uj-xde01
Livrare 48-72 ore

251,99Lei

SALTEA PRIMIRE CRAP ACADEMY CAMOU 120X75CM
Exclusiv online!

SALTEA PRIMIRE CRAP ACADEMY CAMOU 120X75CM

5131-200
Livrare 48-72 ore

146,00Lei

Husa lansete Spro Double Camou 150x23x14cm; -23%

Husa lansete Spro Double Camou 150x23x14cm;

006204-01100-00000
Livrare imediată!

445,00Lei(-23%) 342,90Lei

Leader Radical Unloaded Dropcore Camou Olive 10m 24.9kg

Leader Radical Unloaded Dropcore Camou Olive 10m 24.9kg

2676055
Stoc epuizat

76,28Lei

Fir Radical WaryCarp Link Camou Olive 0.35mm 20m 15.8kg

Fir Radical WaryCarp Link Camou Olive 0.35mm 20m 15.8kg

2674035
Stoc epuizat

62,78Lei

Fir Radical WaryCarp Link Camou Olive Coated 0.25mm 20m 11.3kg

Fir Radical WaryCarp Link Camou Olive Coated 0.25mm 20m 11.3kg

2675025
Stoc epuizat

76,28Lei

Fir Radical WaryCarp Link Coated Camou Olive 0.35mm 20m 15.8kg

Fir Radical WaryCarp Link Coated Camou Olive 0.35mm 20m 15.8kg

2675035
Stoc epuizat

76,28Lei

Umbrela Zebco Nylon Camou Storm 2,20m

Umbrela Zebco Nylon Camou Storm 2,20m

9974253
Stoc epuizat

269,78Lei

Fir Textil Nomura GFS 8x Camou Green 150m, 0.10mm, 9.80kg

Fir Textil Nomura GFS 8x Camou Green 150m, 0.10mm, 9.80kg

nm.34000010
Stoc epuizat

137,75Lei

COSTUM PLOAIE JAXON CAMOU XXL

COSTUM PLOAIE JAXON CAMOU XXL

uj-akpxxlm
Stoc epuizat

176,00Lei

Afişare 181 - 200 din 225 (12 pagini)
Queries: 10, Total time: 10.170 ms [By time] [By id] [By file]
1 (0.166)
SELECT data
FROM `oc_session`
WHERE session_id = 'ddd4c2986dfe7adb5273ed7b87'
/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 (5.904)
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('+camou' 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.097)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (1.123)
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 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.347)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.116)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.123)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (2.069)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.111)
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