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


Maner Minciog Trabucco Dream Team Net Edge Carp, 3.20m, 3seg
Exclusiv online!

Maner Minciog Trabucco Dream Team Net Edge Carp, 3.20m, 3seg

081-06-510
Livrare 48-72 ore

295,00Lei

Cutit Carne Victorinox, Maner Fibrox, Wavy Edge, Lama 20.00cm
Exclusiv online!

Cutit Carne Victorinox, Maner Fibrox, Wavy Edge, Lama 20.00cm

5.2063.20
Livrare 48-72ore

175,00Lei

Razatoare Legume Victorinox Kitchen Grater Fine Edge, Verde
Exclusiv online!

Razatoare Legume Victorinox Kitchen Grater Fine Edge, Verde

7.6082.4
Livrare 48-72ore

45,01Lei

Razatoare Legume Victorinox Kitchen Grater Ribbon Edge, Portocaliu
Exclusiv online!

Razatoare Legume Victorinox Kitchen Grater Ribbon Edge, Portocaliu

7.6084.9
Livrare 48-72ore

45,01Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz5 STD 3BUC

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz5 STD 3BUC

ccr156
Livrare imediată!

35,96Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz5 SHORT 3BUC
Exclusiv online!

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz5 SHORT 3BUC

ccr163
Livrare 7-14 zile

35,96Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb NR 6 STD 3BUC

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb NR 6 STD 3BUC

ccr157
Livrare imediată!

35,96Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz6 SHORT 3BUC
Exclusiv online!

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz6 SHORT 3BUC

ccr164
Livrare 7-14 zile

35,96Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz7 SHORT 3BUC -20%

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz7 SHORT 3BUC

ccr165
Livrare imediată!

35,74Lei(-20%) 28,60Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 STD 3BUC -34%

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 STD 3BUC

ccr155
Livrare imediată!

35,96Lei(-34%) 23,90Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 SHORT 3BUC
Exclusiv online!

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 SHORT 3BUC

ccr162
Livrare 7-14 zile

35,96Lei

OCHELARI POLARIZATI GAMAKATSU EDGE GRI
Exclusiv online!

OCHELARI POLARIZATI GAMAKATSU EDGE GRI

a8.gk7128.81
Livrare 24-48 ore

148,48Lei

OCHELARI POLARIZATI GAMAKATSU EDGE AMBER
Exclusiv online!

OCHELARI POLARIZATI GAMAKATSU EDGE AMBER

a8.gk7128.83
Livrare 24-48 ore

147,56Lei

Lanseta Rapture Edge Master 2.13m 2-10g
Exclusiv online!

Lanseta Rapture Edge Master 2.13m 2-10g

126-53-200
Livrare 48-72 ore

850,01Lei

Lanseta Rapture Edge Master 2.28m 2-10g
Exclusiv online!

Lanseta Rapture Edge Master 2.28m 2-10g

126-53-400
Livrare 48-72 ore

780,00Lei

Lanseta Rapture Edge Master 1.95m 1-7gG
Exclusiv online!

Lanseta Rapture Edge Master 1.95m 1-7gG

126-53-100
Livrare 48-72 ore

780,00Lei

OCHELARI GAMAKATSU POLARIZATI EDGE GALBENI -1%
Exclusiv online!

OCHELARI GAMAKATSU POLARIZATI EDGE GALBENI

a8.gk7128.82
Livrare 24-48 ore

148,48Lei(-1%) 147,56Lei

Lanseta Rapture Edge Master 2.13m 0.5-6g
Exclusiv online!

Lanseta Rapture Edge Master 2.13m 0.5-6g

126-53-300
Livrare 48-72 ore

750,00Lei

MULINETA ENERGOTEAM WIZARD EDGE 5000
Exclusiv online!

MULINETA ENERGOTEAM WIZARD EDGE 5000

20618500
Livrare 24-48 ore

290,00Lei

MULINETA ENERGOTEAM WIZARD EDGE 4000
Exclusiv online!

MULINETA ENERGOTEAM WIZARD EDGE 4000

20618400
Livrare 24-48 ore

275,00Lei

Afişare 1 - 20 din 76 (4 pagini)
Queries: 7, Total time: 2.639 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = '83778b98546f97fda433c5b406'
/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 (2.117)
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('+edge' 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.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.074)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.073)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.105)
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