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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Boilies Bucovina Baits Competition X Tare, 24mm, 1kg

Boilies Bucovina Baits Competition X Tare, 24mm, 1kg

5940000004514
Livrare imediată!

54,50Lei

Boilies Bucovina Baits Monster Trap Tare, 24mm, 1kg

Boilies Bucovina Baits Monster Trap Tare, 24mm, 1kg

5940000004538
Livrare imediată!

54,50Lei

Boilies CPK Tare XXL + Sweetcorn, 20mm, 3kg

Boilies CPK Tare XXL + Sweetcorn, 20mm, 3kg

1000901
Livrare imediată!

110,00Lei

Boilies Dynamite Baits CarpTec Garlic & Cheese, 15mm, 1,8kg
Exclusiv online!

Boilies Dynamite Baits CarpTec Garlic & Cheese, 15mm, 1,8kg

dy1770
Livrare 48-72ore

69,00Lei

BOILIES MG SPECIAL CARP Semi Solubile Squid&Octopus Pruna 24mm 1KG

BOILIES MG SPECIAL CARP Semi Solubile Squid&Octopus Pruna 24mm 1KG

mg0384
Livrare imediată!

58,00Lei

Boilies Senzor Dipuit pentru Carlig, Scopex & Krill, 16-18mm, 200g

Boilies Senzor Dipuit pentru Carlig, Scopex & Krill, 16-18mm, 200g

6425968543248
Livrare imediată!

26,00Lei

Briceag Multifunctional Victorinox Angler, Red, 9.10cm

Briceag Multifunctional Victorinox Angler, Red, 9.10cm

1.3653.72
Livrare imediată!

264,91Lei

Briceag Multifunctional Victorinox Classic Alox, Argintiu, 5.80cm

Briceag Multifunctional Victorinox Classic Alox, Argintiu, 5.80cm

0.6221.26
Livrare imediată!

178,30Lei

Briceag Multifunctional Victorinox Classic, Camo, 5.80cm

Briceag Multifunctional Victorinox Classic, Camo, 5.80cm

0.6223.94
Livrare imediată!

134,95Lei

Briceag Multifunctional Victorinox Spartan, Camo, 9.10cm

Briceag Multifunctional Victorinox Spartan, Camo, 9.10cm

1.3603.94
Livrare imediată!

156,60Lei

Briceag True Utility Skeletonknife, 4.50cm

Briceag True Utility Skeletonknife, 4.50cm

tu571k
Livrare imediată!

49,98Lei

Conector pentru Pluta Match Nevis 5buc/pac
Exclusiv online!

Conector pentru Pluta Match Nevis 5buc/pac

8100-307
Livrare 48-72 ore

6,60Lei

CUTIE MICA VERDE PRO FL PENTRU ACCESORII

CUTIE MICA VERDE PRO FL PENTRU ACCESORII

4105234029370
Livrare imediată!

4,90Lei

Cutie pentru Momeala Cresta Baitbox Holed, 0.25l -25%

Cutie pentru Momeala Cresta Baitbox Holed, 0.25l

006403-00301-00000
Livrare imediată!

11,80Lei(-25%) 8,90Lei

Extensie pentru rulota Coleman Journeymaster Pro XL Blackout
Exclusiv online!

Extensie pentru rulota Coleman Journeymaster Pro XL Blackout

2000038460
Livrare 24-48 ore

6.900,00Lei

Fir Monofilament Conic pentru Crap Nevis Castmaster 0.20-0.57mm, 5x15m/75m
Exclusiv online!

Fir Monofilament Conic pentru Crap Nevis Castmaster 0.20-0.57mm, 5x15m/75m

3247-020
Livrare 48-72 ore

42,99Lei

Fir Monofilament Conic pentru Crap Nevis Castmaster 0.28-0.57mm, 5x15m/75m
Exclusiv online!

Fir Monofilament Conic pentru Crap Nevis Castmaster 0.28-0.57mm, 5x15m/75m

3247-028
Livrare 48-72 ore

42,99Lei

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.218mm 8lb
Exclusiv online!

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.218mm 8lb

v45603017
Livrare 48-72 ore

79,00Lei

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.260mm 12lb
Exclusiv online!

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.260mm 12lb

v45603025
Livrare 48-72 ore

79,00Lei

Fir Monofilament Varivas Sea Bass Shock Leader Fluorocarbon 30m 0.405mm 22lb
Exclusiv online!

Fir Monofilament Varivas Sea Bass Shock Leader Fluorocarbon 30m 0.405mm 22lb

v8203022
Livrare 48-72 ore

88,00Lei

Afişare 2801 - 2820 din 5143 (258 pagini)
Queries: 7, Total time: 167.791 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '972ab1b52eec1c2f12a3064627'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.115)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (144.750)
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('+pentru' 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
5 (22.382)
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 2800, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.202)
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.142)
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