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


KWIK FOX CHANGE POP-UP WEIGHTS ADDITIONS nr 4

KWIK FOX CHANGE POP-UP WEIGHTS ADDITIONS nr 4

cac762
Livrare imediată!

32,59Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - CCA

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - CCA

bscom09 cca
Livrare imediată!

31,00Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - SG
Exclusiv online!

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - SG

bscom09 sg
Livrare 48-72ore

31,00Lei

BANDANA FOX RAGE LIGHTWEIGHT SNOOD

BANDANA FOX RAGE LIGHTWEIGHT SNOOD

npr322
Livrare imediată!

40,20Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - MU
Exclusiv online!

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - MU

bscom09 mu
Livrare 48-72ore

31,00Lei

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - FT

SWIMBAIT STORM 360GT COSTAL BISCAY COAST MINNOW WEIGHTED SWIMBAIT HOOK (2 naluci armate) - FT

bscom09 ft
Livrare imediată!

31,00Lei

KWIK FOX CHANGE POP-UP WEIGHTS ADDITIONS nr 1

KWIK FOX CHANGE POP-UP WEIGHTS ADDITIONS nr 1

cac761
Livrare imediată!

32,59Lei

PANTALONI, FOX, LIGHTWEIGHT, SHORTS, S, npr323, Pantaloni Indispensabili, Pantaloni Indispensabili Fox Rage, Fox Rage -30%
Exclusiv online!

PANTALONI, FOX, LIGHTWEIGHT, SHORTS, S, npr323, Pantaloni Indispensabili, Pantaloni Indispensabili Fox Rage, Fox Rage

npr323
Livrare 7-14 zile

157,50Lei(-30%) 110,00Lei

PANTALONI, FOX, LIGHTWEIGHT, SHORTS, L, npr325, Pantaloni Indispensabili, Pantaloni Indispensabili Fox Rage, Fox Rage
Carlige VMC 7315SL Weighted Finesse Swimbait Nr.2/0 2.5g 3buc/plic
Exclusiv online!

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.2/0 2.5g 3buc/plic

7315 sl2/0 x 3
Livrare 48-72ore

62,00Lei

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.3/0 3g 3buc/plic
Exclusiv online!

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.3/0 3g 3buc/plic

7315 sl3/0 x 3
Livrare 48-72ore

62,00Lei

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.1/0 2g 4buc/plic
Exclusiv online!

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.1/0 2g 4buc/plic

7315 sl1/0 x 4
Livrare 48-72ore

62,00Lei

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.2 1g 4buc/plic
Exclusiv online!

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.2 1g 4buc/plic

7315 sl2 x 4
Livrare 48-72ore

62,00Lei

Kit Spro Freestyle Twitch Weights 1.00g 3buc/plic
Exclusiv online!

Kit Spro Freestyle Twitch Weights 1.00g 3buc/plic

004589-00602-00000
Livrare 48-72 ore

15,70Lei

FOX LIGHTWEIGHT CAMO WADERS 41
Exclusiv online!

FOX LIGHTWEIGHT CAMO WADERS 41

cfw110
Livrare 7-14 zile

449,96Lei

Kit Spro Freestyle Twitch Weights 0.50g 3buc/plic -24%

Kit Spro Freestyle Twitch Weights 0.50g 3buc/plic

004589-00601-00000
Livrare imediată!

15,70Lei(-24%) 11,90Lei

Pantaloni RidgeMonkey Dropback Lightweight Hydrophobic Green S -34%

Pantaloni RidgeMonkey Dropback Lightweight Hydrophobic Green S

rm205
Livrare imediată!

220,45Lei(-34%) 146,57Lei

Kit Spro Freestyle Twitch Weights 1.50g 3buc/plic -24%

Kit Spro Freestyle Twitch Weights 1.50g 3buc/plic

004589-00603-00000
Livrare imediată!

15,70Lei(-24%) 11,90Lei

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.1 1.5g
Exclusiv online!

Carlige VMC 7315SL Weighted Finesse Swimbait Nr.1 1.5g

7315 sl1 x 4
Livrare 48-72ore

62,00Lei

PANTALONI FOX COLLECTION ORANGE BLACK LIGHTWEIGHT JOGGERS XXXL -20%

PANTALONI FOX COLLECTION ORANGE BLACK LIGHTWEIGHT JOGGERS XXXL

ccl042
Livrare imediată!

125,20Lei(-20%) 100,16Lei

Afişare 1 - 20 din 216 (11 pagini)
Queries: 16, Total time: 164.220 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '244a0b0fb9ea93a3bf4e931dbd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.157)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.111)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.107)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.087)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (160.622)
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 = '0' AND (pd.tag LIKE "%weight%") 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:697
12 (0.186)
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:1066
13 (1.908)
SELECT COUNT(*) 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:911
14 (0.149)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
16 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38