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


PAT PESCUIT FOX DURALITE BED 6 PICIOARE 202X78CM -15%

PAT PESCUIT FOX DURALITE BED 6 PICIOARE 202X78CM

cbc076
Stoc epuizat

1.574,97Lei(-15%) 1.338,71Lei

Fir Textil cu Camasa FOX Coretex Tungsten 20m 35lbs 15.9kg -30%

Fir Textil cu Camasa FOX Coretex Tungsten 20m 35lbs 15.9kg

cac697
Stoc epuizat

99,95Lei(-30%) 69,97Lei

Pat Fox Eos 3 -15%

Pat Fox Eos 3

cbc090
Stoc epuizat

1.079,96Lei(-15%) 917,95Lei

Minciog Fox Rage Warrior Rubber Mesh 2.40M -20%

Minciog Fox Rage Warrior Rubber Mesh 2.40M

nln011
Stoc epuizat

160,97Lei(-20%) 128,78Lei

Fox Cookware Coffee Maker 450ml 9cups

Fox Cookware Coffee Maker 450ml 9cups

ccw015
Stoc epuizat

103,46Lei

Husa Lanesta Fox R-Series Single Sleeve 192x24cm

Husa Lanesta Fox R-Series Single Sleeve 192x24cm

clu357
Stoc epuizat

139,46Lei

PAT PESCUIT FOX FLATLINER 5 SEASON SLEEP SYSTEM 6 PICIOARE 215X84CM -27%

PAT PESCUIT FOX FLATLINER 5 SEASON SLEEP SYSTEM 6 PICIOARE 215X84CM

cbc096
Stoc epuizat

2.789,96Lei(-27%) 2.049,91Lei

CARLIGE FOX ARMAPOINT WIDE GAPE BEAKED NR 7 10BUC

CARLIGE FOX ARMAPOINT WIDE GAPE BEAKED NR 7 10BUC

chk186
Stoc epuizat

26,79Lei

CARLIGE FOX ARMAPOINT WIDE GAPE STRAIGHT NR 7 10BUC -44%

CARLIGE FOX ARMAPOINT WIDE GAPE STRAIGHT NR 7 10BUC

chk178
Stoc epuizat

26,79Lei(-44%) 14,88Lei

Jacheta FOX RAGE matlasata Rip Stop Quilted CAMO/GREY MARIME L

Jacheta FOX RAGE matlasata Rip Stop Quilted CAMO/GREY MARIME L

npr341
Stoc epuizat

404,96Lei

HUSA FOX CAMOLITE BROLLY CARRYALL 178CM

HUSA FOX CAMOLITE BROLLY CARRYALL 178CM

clu289
Stoc epuizat

382,45Lei

Lanseta Fox EOS Pro Spod Marker 3.90m 5lb 2seg

Lanseta Fox EOS Pro Spod Marker 3.90m 5lb 2seg

crd348
Stoc epuizat

429,40Lei

Husa rigida lansete Fox Rage Rod Shield 198cm – 230cm

Husa rigida lansete Fox Rage Rod Shield 198cm – 230cm

nlu077
Stoc epuizat

49,46Lei

Pichet Telescopic Fox Black Label Power Point, 45cm

Pichet Telescopic Fox Black Label Power Point, 45cm

cbs048
Stoc epuizat

139,15Lei

SHAD FOX RAGE SPIKEY 9CM HOT TIGER -45%

SHAD FOX RAGE SPIKEY 9CM HOT TIGER

nsl807
Stoc epuizat

5,38Lei(-45%) 2,94Lei

STRUNA FOX TITAN 40CM 14KG 2BUC

STRUNA FOX TITAN 40CM 14KG 2BUC

nwl043
Stoc epuizat

37,31Lei

STRUNA FOX SUREFIT 30CM 8KG 2BUC

STRUNA FOX SUREFIT 30CM 8KG 2BUC

nwl046
Stoc epuizat

18,86Lei

FIR LEADCORE FOX CAMO WOVEN LEADER 7M 50LB

FIR LEADCORE FOX CAMO WOVEN LEADER 7M 50LB

cac747
Stoc epuizat

35,70Lei

Combo Pat Pescuit Plus Sac de Dormit Fox Duralite 5 Season System 202x78cm -14%

Combo Pat Pescuit Plus Sac de Dormit Fox Duralite 5 Season System 202x78cm

cbc099
Stoc epuizat

2.384,96Lei(-14%) 2.049,75Lei

KIT MONTURA FOX EDGES ZIG LEAD CLIP KIT 5X5BUC/BLISTER -30%

KIT MONTURA FOX EDGES ZIG LEAD CLIP KIT 5X5BUC/BLISTER

cac722
Stoc epuizat

31,27Lei(-30%) 22,00Lei

Afişare 2021 - 2040 din 2721 (137 pagini)
Queries: 5, Total time: 58.084 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '330b56859e9522342f7d10e81d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (57.642)
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('+fox' 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.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.081)
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