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


Extensie cort Coleman Classic Awning
Exclusiv online!

Extensie cort Coleman Classic Awning

205081
Livrare 24-48 ore

450,00Lei

Mulineta Cormoran Cormaxx BR 3500 0.30mm/250m

Mulineta Cormoran Cormaxx BR 3500 0.30mm/250m

c.19.81350
Livrare imediată!

162,46Lei

Pufarin Mini Cukk Capsuni
Exclusiv online!

Pufarin Mini Cukk Capsuni

92000281
Livrare 48-72ore

10,00Lei

Fir Monofilament Sunset Amnesia Clear, 12lb/5.4kg, 100m

Fir Monofilament Sunset Amnesia Clear, 12lb/5.4kg, 100m

895181001
Livrare imediată!

40,00Lei

Carlig Owner Cp 51481 Negru Rotund Nr 5 - 16buc/plic

Carlig Owner Cp 51481 Negru Rotund Nr 5 - 16buc/plic

5148108
Livrare imediată!

12,88Lei

Carlig Owner Cp 51481 Negru Rotund Nr 3 - 14buc/plic

Carlig Owner Cp 51481 Negru Rotund Nr 3 - 14buc/plic

5148106
Livrare imediată!

12,88Lei

ROD POD EXTRA CARP ROYAL 3 POSTURI

ROD POD EXTRA CARP ROYAL 3 POSTURI

ec1781
Livrare imediată!

330,00Lei

ADITIV BENZAR MIX TURBO CONCENTRAT MIERE 100ML
Exclusiv online!

ADITIV BENZAR MIX TURBO CONCENTRAT MIERE 100ML

94008103
Livrare 24-48 ore

12,00Lei

Inel EnergoTeam Varf Match SIC UMHSIT 4x1.0mm
Exclusiv online!

Inel EnergoTeam Varf Match SIC UMHSIT 4x1.0mm

81504010
Livrare 24-48 ore

7,50Lei

Vobler Biwaa Seven Section 10cm/17g culoare Blue Gill -21%

Vobler Biwaa Seven Section 10cm/17g culoare Blue Gill

b000781
Livrare imediată!

99,00Lei(-21%) 77,90Lei

INEL CARP EXPERT UKWLSG 50 Long Leg

INEL CARP EXPERT UKWLSG 50 Long Leg

81040050
Livrare imediată!

49,19Lei

Double Suport Nash Spod Station -25%

Double Suport Nash Spod Station

t2081
Livrare imediată!

225,99Lei(-25%) 168,90Lei

Shad Mann s Q-Paddler 7g 10cm Camouflage

Shad Mann s Q-Paddler 7g 10cm Camouflage

801283281019
Livrare imediată!

3,00Lei

Carlig Owner Cp 51481 Negru Rotund Nr 1 - 12buc/plic -23%

Carlig Owner Cp 51481 Negru Rotund Nr 1 - 12buc/plic

5148104
Livrare imediată!

12,88Lei(-23%) 9,90Lei

Penseta Nevis 18cm Curbata

Penseta Nevis 18cm Curbata

8100-004
Livrare imediată!

26,10Lei

Burete Plutitor Carp Academy 4bucati/plic

Burete Plutitor Carp Academy 4bucati/plic

8100-043
Livrare imediată!

11,00Lei

Bride Sunset ST Double Brass Tube ST-S-6020 1.5-3.2

Bride Sunset ST Double Brass Tube ST-S-6020 1.5-3.2

411stsab10581.5x3.210
Livrare imediată!

9,48Lei

Bride Sunset ST Double Brass Tube ST-S-6020 1.8-3.2 -27%

Bride Sunset ST Double Brass Tube ST-S-6020 1.8-3.2

411stsab10581.8x3.810
Livrare imediată!

9,48Lei(-27%) 6,90Lei

Fir textil CPK Heavy Hooklink Green/Black 15lb/15m

Fir textil CPK Heavy Hooklink Green/Black 15lb/15m

999881
Livrare imediată!

29,00Lei

ADITIV BENZAR MIX TURBO CONCENTRAT LUCERNA 100ML
Exclusiv online!

ADITIV BENZAR MIX TURBO CONCENTRAT LUCERNA 100ML

94008159
Livrare 24-48 ore

12,00Lei

Afişare 821 - 840 din 3336 (167 pagini)
Queries: 6, Total time: 549.105 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'cebb39c8f7e887b9d7327d6999'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (534.124)
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 "%81%%") 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 (14.436)
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 820, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.163)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"YU HAI YANG IMPEX"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.143)
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