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


Fir Dreamline Carp (Camo) - 0.35Mm 12.04Kg 600M
Exclusiv online!

Fir Dreamline Carp (Camo) - 0.35Mm 12.04Kg 600M

zdl110-600-035
Livrare 48-72 ore

99,00Lei

Fir Monofilament Berkley Nautil, Turquoise, 4kg, 0.22mm, 600m

Fir Monofilament Berkley Nautil, Turquoise, 4kg, 0.22mm, 600m

1560529
Livrare imediată!

76,46Lei

Fir Monofilament Berkley Nautil, Turquoise, 5.7kg, 0.28mm, 600m

Fir Monofilament Berkley Nautil, Turquoise, 5.7kg, 0.28mm, 600m

1560531
Livrare imediată!

84,95Lei

Fir Monofilament Berkley Trilene Big Game Verde Fluo 20.0kg 0.55mm 600m
Exclusiv online!

Fir Monofilament Berkley Trilene Big Game Verde Fluo 20.0kg 0.55mm 600m

1342719
Livrare 7-14 zile

110,46Lei

Fir Monofilament Carp Spirit CELT-2X, Verde Fluo, 0.26mm, 5.37kg, 1600m

Fir Monofilament Carp Spirit CELT-2X, Verde Fluo, 0.26mm, 5.37kg, 1600m

acs470016
Livrare imediată!

119,00Lei

Fir Sensual N.G. Carp 0.28Mm/14.5Kg/600M - Transparent
Exclusiv online!

Fir Sensual N.G. Carp 0.28Mm/14.5Kg/600M - Transparent

zsn100-600-028
Livrare 48-72 ore

31,20Lei

Fir Sensual N.G. Carp 0.28Mm/14.5Kg/600M - Yellow
Exclusiv online!

Fir Sensual N.G. Carp 0.28Mm/14.5Kg/600M - Yellow

zsn110-600-028
Livrare 48-72 ore

39,00Lei

Fir Sensual N.G. Carp 0.30Mm/17.5Kg/600M - Yellow
Exclusiv online!

Fir Sensual N.G. Carp 0.30Mm/17.5Kg/600M - Yellow

zsn110-600-030
Livrare 48-72 ore

39,00Lei

Fir Sensual N.G. Carp 0.38Mm/25Kg/600M - Transparent
Exclusiv online!

Fir Sensual N.G. Carp 0.38Mm/25Kg/600M - Transparent

zsn100-600-038
Livrare 48-72 ore

35,20Lei

Fir Sensual N.G. Carp 0.40Mm/26.5Kg/600M - Yellow
Exclusiv online!

Fir Sensual N.G. Carp 0.40Mm/26.5Kg/600M - Yellow

zsn110-600-040
Livrare 48-72 ore

35,20Lei

Fir Textil Nytro Sublime X8 Sinking Feeder 0.08mm, 3.6kg, 150m
Exclusiv online!

Fir Textil Nytro Sublime X8 Sinking Feeder 0.08mm, 3.6kg, 150m

20600001
Livrare 48-72 ore

149,98Lei

Fir Textil Spiderwire Stealth Smooth 8 Verde 300m, 0.29mm, 26.4kg
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 8 Verde 300m, 0.29mm, 26.4kg

1515600
Livrare 7-14 zile

154,47Lei

Geanta Semirigida pentru Accesorii Zeck Window Bag, Size M, 21x18.5x6cm
Exclusiv online!

Geanta Semirigida pentru Accesorii Zeck Window Bag, Size M, 21x18.5x6cm

90405260063
Livrare 48-72 ore

55,57Lei

Geanta Zeck Rig Bag+ Tackle Box WP M 29x19x18cm
Exclusiv online!

Geanta Zeck Rig Bag+ Tackle Box WP M 29x19x18cm

90405160032
Livrare 48-72 ore

255,92Lei

Lanseta DAM Yagi Spin F, 2.40m, 12-42g, 2seg
Exclusiv online!

Lanseta DAM Yagi Spin F, 2.40m, 12-42g, 2seg

dam.60037
Livrare 24-48 ore

257,79Lei

Lanseta Zebco Magic Trout Tec X-Trem Light G1, 0.5-5g, 1.78m, 2seg

Lanseta Zebco Magic Trout Tec X-Trem Light G1, 0.5-5g, 1.78m, 2seg

15600178
Livrare imediată!

279,00Lei

Lanseta Zebco Magic Trout Tec X-Trem Light G1, 0.5-9g, 1.95m, 2seg

Lanseta Zebco Magic Trout Tec X-Trem Light G1, 0.5-9g, 1.95m, 2seg

15600195
Livrare imediată!

287,00Lei

Lanterna TED cu Acumulator Litiu L18650x1 Metal Led Zoom XPH50 1600 lm + Power Display + Cablu Incarcare Micro USB
Montura Somn DAM Madcat Screaming River DeadBait Marime M, 100mm, 2/0-8/0, 180cm, 40g
Exclusiv online!

Montura Somn DAM Madcat Screaming River DeadBait Marime M, 100mm, 2/0-8/0, 180cm, 40g

a.mad.56002
Livrare 24-48 ore

85,16Lei

Mulineta Golden Catch Airone 6000FD
Exclusiv online!

Mulineta Golden Catch Airone 6000FD

gcz-1039010
Livrare 48-72 ore

269,00Lei

Afişare 301 - 320 din 2036 (102 pagini)
Queries: 5, Total time: 605.440 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '5d0cb434f2815f4f1d49d1c550'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (596.730)
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 "%600%") 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 (8.388)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.146)
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