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


Wafters BENZAR MIX Concourse Twister Mini, 5.5mm, Mulberry

Wafters BENZAR MIX Concourse Twister Mini, 5.5mm, Mulberry

98091999
Stoc epuizat

25,00Lei

Wafters Feeder Bait Mikron Halloween 6mm

Wafters Feeder Bait Mikron Halloween 6mm

fb-special
Stoc epuizat

21,30Lei

Wafters Fish Pro Solubile Fluo, Somon Branza, 8mm, 40g

Wafters Fish Pro Solubile Fluo, Somon Branza, 8mm, 40g

FHP-WSFSB8-40
Stoc epuizat

29,00Lei

Wafters THE ONE Hook Bait Solubile, 20mm, Gold - Tigernut & Scopex

Wafters THE ONE Hook Bait Solubile, 20mm, Gold - Tigernut & Scopex

98031201
Stoc epuizat

34,00Lei

Wafters THE ONE Hook Bait Solubile, 20mm, Red - Cajun

Wafters THE ONE Hook Bait Solubile, 20mm, Red - Cajun

98031202
Stoc epuizat

34,00Lei

Wafters THE ONE Hook Bait Solubile, 24mm, Purple - Garlic

Wafters THE ONE Hook Bait Solubile, 24mm, Purple - Garlic

98031243
Stoc epuizat

34,00Lei

Wafters WLC Duo Balls, SPP, 11mm, 30g

Wafters WLC Duo Balls, SPP, 11mm, 30g

w14019
Stoc epuizat

20,00Lei

Wafters Feeder-X Method Feeder Mini Dumbell 7mm, Usturoi

Wafters Feeder-X Method Feeder Mini Dumbell 7mm, Usturoi

plf043
Stoc epuizat

15,90Lei

Wafters CPK Critic Echilibrate Feeder Capsuna, 8mm, 30g -38%

Wafters CPK Critic Echilibrate Feeder Capsuna, 8mm, 30g

999851
Stoc epuizat

20,00Lei(-38%) 12,38Lei

WAFTERS FC CARP ZOOM METHOD FEEDER NBC 9mm 13gr Fluo Orange -32%

WAFTERS FC CARP ZOOM METHOD FEEDER NBC 9mm 13gr Fluo Orange

cz8746
Stoc epuizat

14,50Lei(-32%) 9,90Lei

Boilies Mainline High Impact Balanced Wafters Banoffee 18mm

Boilies Mainline High Impact Balanced Wafters Banoffee 18mm

a0.m.m23050
Stoc epuizat

51,74Lei

Wafters Feeder-X Method Feeder Mini Dumbell 7mm, Sweet Corn

Wafters Feeder-X Method Feeder Mini Dumbell 7mm, Sweet Corn

plf042
Stoc epuizat

15,90Lei

Wafters Dynamite Baits Speedys Washter Hookbaits, Maro Pastel, 5mm

Wafters Dynamite Baits Speedys Washter Hookbaits, Maro Pastel, 5mm

dy1454
Stoc epuizat

28,00Lei

Wafters Dynamite Baits Hit N' Run Red, 14mm

Wafters Dynamite Baits Hit N' Run Red, 14mm

dy1276
Stoc epuizat

31,00Lei

POP-UP MAINLINE WAFTER BARRELS CRANBERRY ORANGE 12X15MM

POP-UP MAINLINE WAFTER BARRELS CRANBERRY ORANGE 12X15MM

a0.m.m35001
Stoc epuizat

42,08Lei

Wafters Feeder Bait Mikron Wafters Fish 50ml 4mm

Wafters Feeder Bait Mikron Wafters Fish 50ml 4mm

fb27-1
Stoc epuizat

23,00Lei

Wafters Feeder Bait Czinkers Lime 60ml

Wafters Feeder Bait Czinkers Lime 60ml

fb19-9
Stoc epuizat

17,20Lei

Wafters Crafty Catcher Fast Food Scopex And Squid 150 ml -20%

Wafters Crafty Catcher Fast Food Scopex And Squid 150 ml

v00406
Stoc epuizat

23,50Lei(-20%) 18,80Lei

WAFTERS Bucovina ANANAS-BANANA 14MM 20G

WAFTERS Bucovina ANANAS-BANANA 14MM 20G

5940000005078b
Stoc epuizat

16,50Lei

WAFTERS Bucovina ANANAS-BANANA 8-11MM 20G

WAFTERS Bucovina ANANAS-BANANA 8-11MM 20G

5940000005047b
Stoc epuizat

16,50Lei

Afişare 1021 - 1040 din 1080 (54 pagini)
Queries: 13, Total time: 1,711.339 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = '0d3d5dd4a3a1373254c9b2477a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,709.695)
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 = '2' AND (pd.tag LIKE "%wafters%") 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:725
4 (0.148)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"WILD LIFE CONCEPT SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.128)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PESCUITLAFEEDER S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.137)
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
7 (0.129)
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
8 (0.133)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PESCUITLAFEEDER S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.142)
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.131)
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 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"BUCOVINA BAITS SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.111)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"BUCOVINA BAITS SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.192)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38