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


PANTALON BLASER MEN TAKLE RUBBER BROWN MAR. 50
Exclusiv online!

PANTALON BLASER MEN TAKLE RUBBER BROWN MAR. 50

bl.122038.152.1.50
Livrare 24-48 ore

1.402,33Lei

Shad Live Target Skip Shad Soft Jerkbait, Silver / Brown, 11cm, 4buc/pac
Exclusiv online!

Shad Live Target Skip Shad Soft Jerkbait, Silver / Brown, 11cm, 4buc/pac

f1.lt.ssd110s934
Livrare 24-48 ore

42,88Lei

Tub Termocontractabil Pole Position Weedy Brown, 1.6mm, 10buc

Tub Termocontractabil Pole Position Weedy Brown, 1.6mm, 10buc

008036-00711-00000
Livrare imediată!

19,90Lei

Camasa Blaser Louie, Brown & Orange, Marime 2XL -30%
Exclusiv online!

Camasa Blaser Louie, Brown & Orange, Marime 2XL

bl.122051.087.2xl
Livrare 24-48 ore

372,41Lei(-30%) 260,69Lei

Camasa Blaser Louie, Brown & Orange, Marime XL -30%
Exclusiv online!

Camasa Blaser Louie, Brown & Orange, Marime XL

bl.122051.087.xl
Livrare 24-48 ore

372,41Lei(-30%) 260,69Lei

Jacheta Blaser Challenger Airflake Dark Brown, Marime 2XL
Exclusiv online!

Jacheta Blaser Challenger Airflake Dark Brown, Marime 2XL

bl.232008.140.2xl
Livrare 24-48 ore

1.290,78Lei

Jacheta Blaser WP Janus Parka Dark Brown, Marime 3XL
Exclusiv online!

Jacheta Blaser WP Janus Parka Dark Brown, Marime 3XL

bl.232001.026.3xl
Livrare 24-48 ore

3.549,64Lei

Ochelari de Soare Fox Collection Wraps Black & Orange, Brown Lens

Ochelari de Soare Fox Collection Wraps Black & Orange, Brown Lens

csn049
Livrare imediată!

103,46Lei

Sapca Trakker Flexi Fit Cap, Brown

Sapca Trakker Flexi Fit Cap, Brown

207628
Livrare imediată!

89,95Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 11.5cm, 4buc/pac
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 11.5cm, 4buc/pac

f1.lt.gtm115sk934
Livrare 24-48 ore

42,88Lei

Vobler HMKL Zagger 50 B1 Half 5cm, 2.6gr, MS Brown

Vobler HMKL Zagger 50 B1 Half 5cm, 2.6gr, MS Brown

z50b1h-msb
Livrare imediată!

70,00Lei

Vobler HMKL Zagger 50 F1-R, 5cm, 1.4g, Yadoku Brown
Exclusiv online!

Vobler HMKL Zagger 50 F1-R, 5cm, 1.4g, Yadoku Brown

z50f1-r-yb
Livrare 48-72ore

70,00Lei

Vobler Jackall Chibi Panicra SR, Tackey Brown, 2.5cm, 1.4g
Exclusiv online!

Vobler Jackall Chibi Panicra SR, Tackey Brown, 2.5cm, 1.4g

ja.418085757
Livrare 24-48 ore

80,44Lei

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 6.5cm, 21g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 6.5cm, 21g

lt.fgh65t502
Livrare 24-48 ore

41,94Lei(-20%) 33,55Lei

Con Anti Tangle Mikado, Brown, 43mm, 20buc/plic
Exclusiv online!

Con Anti Tangle Mikado, Brown, 43mm, 20buc/plic

amc-11517-06
Livrare 48-72 ore

18,00Lei

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.20mm, 5.92kg, 600m

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.20mm, 5.92kg, 600m

33554020
Livrare imediată!

55,00Lei

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.28mm, 9.35kg, 600m

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.28mm, 9.35kg, 600m

33554028
Livrare imediată!

55,00Lei

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

a.dam.66638
Livrare imediată!

20,83Lei

Jacheta Blaser Challenger Airflake Dark Brown, Marime M
Exclusiv online!

Jacheta Blaser Challenger Airflake Dark Brown, Marime M

bl.232008.140.m
Livrare 24-48 ore

1.290,78Lei

Jacheta Blaser Sherpa Fleece Dark Brown, Marime XL
Exclusiv online!

Jacheta Blaser Sherpa Fleece Dark Brown, Marime XL

bl.122030.009.1.xl
Livrare 24-48 ore

1.139,39Lei

Afişare 161 - 180 din 850 (43 pagini)
Queries: 6, Total time: 23.676 ms [By time] [By id] [By file]
1 (0.157)
SELECT data
FROM `oc_session`
WHERE session_id = '99f5f9ecd2a92f1b602cadf65a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.628)
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('+brown' 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
4 (3.522)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.126)
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