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


Mulineta Baracuda Yumoshi BK2000

Mulineta Baracuda Yumoshi BK2000

yumbk2000
Stoc epuizat

56,08Lei

Swimbait Fox Rage REPLICANT WOBBLE 14cm 55g Red Wake UV

Swimbait Fox Rage REPLICANT WOBBLE 14cm 55g Red Wake UV

nre205
Stoc epuizat

49,46Lei

FIR MAVER LAKE MONSTER SILURO STURIONE 1000m 0.50mm 19kg

FIR MAVER LAKE MONSTER SILURO STURIONE 1000m 0.50mm 19kg

932050
Stoc epuizat

99,00Lei

Set Carp Expert Smart Feeder 3.90m cu Rod Pod Kamasaki

Set Carp Expert Smart Feeder 3.90m cu Rod Pod Kamasaki

12046018
Stoc epuizat

599,00Lei

Swimbait Fox Rage REPLICANT WOBBLE 7.5cm 10g Red Wake UV

Swimbait Fox Rage REPLICANT WOBBLE 7.5cm 10g Red Wake UV

nre202
Stoc epuizat

29,21Lei

Banda Solubila PVA Select Baits PVA Tape, 17mm, 20m

Banda Solubila PVA Select Baits PVA Tape, 17mm, 20m

sel-061249
Stoc epuizat

13,49Lei

Boilies Carlig MG Special Carp Dipuit Attract Plus (15-20mm) 200gr -42%

Boilies Carlig MG Special Carp Dipuit Attract Plus (15-20mm) 200gr

mg4046
Stoc epuizat

29,00Lei(-42%) 16,70Lei

Lanseta Daiwa Ninja X Feeder 3.60m, 220g, 3+3seg

Lanseta Daiwa Ninja X Feeder 3.60m, 220g, 3+3seg

d.11607.365
Stoc epuizat

419,00Lei

Swimbait Fox Rage REPLICANT WOBBLE 7.5cm 10g Pike UV

Swimbait Fox Rage REPLICANT WOBBLE 7.5cm 10g Pike UV

nre201
Stoc epuizat

29,21Lei

Boilies CPK, Tigernuts, 20mm, 3kg

Boilies CPK, Tigernuts, 20mm, 3kg

1000959
Stoc epuizat

90,00Lei

COSTUM IMPERMEABIL PRESTON DFX SUIT XL

COSTUM IMPERMEABIL PRESTON DFX SUIT XL

p0200313
Stoc epuizat

1.394,97Lei

Mulineta Ngt Angling Pursuits Star20

Mulineta Ngt Angling Pursuits Star20

ngt-ap-frl-star20
Stoc epuizat

40,00Lei

VIERMI ARTIFICIALI FLOTANTI ENTERPRISE TACKLE IMITATION MAGGOTS Galben 20BUC/PLIC
Vobler Salmo Rattlin' Slider Sinking - Bleeding Blue, 8cm, 20g -30%

Vobler Salmo Rattlin' Slider Sinking - Bleeding Blue, 8cm, 20g

qrn020
Stoc epuizat

69,31Lei(-30%) 48,50Lei

Plior EnergoTeam Plastic 20cm

Plior EnergoTeam Plastic 20cm

80312120
Stoc epuizat

1,50Lei

Pluta Madcat Propellor Subfloat 20g

Pluta Madcat Propellor Subfloat 20g

a.mad.52056
Stoc epuizat

19,22Lei

Select Easy Shad 8.9cm 206

Select Easy Shad 8.9cm 206

18702431
Stoc epuizat

12,99Lei

Conector Preston Big Float Waggler Adaptors, 5buc/plic

Conector Preston Big Float Waggler Adaptors, 5buc/plic

p0220115
Stoc epuizat

22,10Lei

Hamac Ticket to the Moon King Size Dark Green & Army Green, 320x230cm

Hamac Ticket to the Moon King Size Dark Green & Army Green, 320x230cm

tmk0524
Stoc epuizat

369,00Lei

Lanseta Sportex Rapid Spin 270 20g

Lanseta Sportex Rapid Spin 270 20g

rp2701
Stoc epuizat

650,00Lei

Afişare 18321 - 18340 din 19324 (967 pagini)
Queries: 8, Total time: 879.400 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '8c0db8fa31d1c97ae0ab0a7f05'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.120)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (793.017)
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 (pd.tag LIKE "%20%") 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 (85.578)
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 18320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.165)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.091)
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.089)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.202)
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