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


VOBLER JACKALL TN65 FULL TUNGSTEN 6.4CM 15G WABISABI GOLD&BLACK -23%

VOBLER JACKALL TN65 FULL TUNGSTEN 6.4CM 15G WABISABI GOLD&BLACK

ja.807126501
Livrare imediată!

112,59Lei(-23%) 86,91Lei

Hanorac Prologic Carp Logo Black L

Hanorac Prologic Carp Logo Black L

a8.pro.73870
Livrare imediată!

170,00Lei

Lanseta Sportex BLACK ARROW G-3 BAITCAST MUSKY 255 260gr
Exclusiv online!

Lanseta Sportex BLACK ARROW G-3 BAITCAST MUSKY 255 260gr

ba2509
Livrare 48-72 ore

1.280,00Lei

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 21kg 45cm
Exclusiv online!

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 21kg 45cm

rla19b-45c21t
Livrare 48-72ore

31,00Lei

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 12kg 45cm
Exclusiv online!

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 12kg 45cm

rla19b-45c12t
Livrare 48-72ore

31,00Lei

CARLIGE LEGATE BKK CHINU DIAMOND BLACK Nr.08 0.18mm x 70cm 10BUC/PLIC
Exclusiv online!

CARLIGE LEGATE BKK CHINU DIAMOND BLACK Nr.08 0.18mm x 70cm 10BUC/PLIC

6939067083241
Livrare 48-72 ore

15,51Lei

LANSETA DAIWA BLACK WIDOW CARP 3.00M 3,5LBS 2seg

LANSETA DAIWA BLACK WIDOW CARP 3.00M 3,5LBS 2seg

d.11584.300
Livrare imediată!

231,46Lei

Hanorac Madcat Mega Logo Black Caviar XL
Exclusiv online!

Hanorac Madcat Mega Logo Black Caviar XL

8053173802
Livrare 48-72 ore

211,03Lei

Husa lansete Mikado black 2 Compartiment 120cm

Husa lansete Mikado black 2 Compartiment 120cm

uwd-04202b-120
Livrare imediată!

89,00Lei

Husa lansete Mikado black 1 Compartiment 160cm

Husa lansete Mikado black 1 Compartiment 160cm

uwd-04201b-160
Livrare imediată!

93,00Lei

CARLIGE LEGATE BKK KEIRYU DIAMOND BLACK Nr.06 0.18mm x 70cm 10buc/plic
Exclusiv online!

CARLIGE LEGATE BKK KEIRYU DIAMOND BLACK Nr.06 0.18mm x 70cm 10buc/plic

6939067083937
Livrare 48-72 ore

15,51Lei

Husa lansete Mikado black 2 Compartiment 100cm

Husa lansete Mikado black 2 Compartiment 100cm

uwd-04202b-100
Livrare imediată!

85,00Lei

VOBLER JACKALL TN50 TRIGON HS IMPACT BLACK 5.2CM 11.2G
Exclusiv online!

VOBLER JACKALL TN50 TRIGON HS IMPACT BLACK 5.2CM 11.2G

ja.807166231
Livrare 24-48 ore

104,92Lei

BLUZA DAIWA D-VEC LS BLACK MARIME S -20%
Exclusiv online!

BLUZA DAIWA D-VEC LS BLACK MARIME S

d.18206.210
Livrare 24-48 ore

200,79Lei(-20%) 160,63Lei

Hanorac Madcat Mega Logo Black Caviar L -24%

Hanorac Madcat Mega Logo Black Caviar L

8053173801
Livrare imediată!

211,03Lei(-24%) 160,90Lei

Husa lansete Mikado black 1 Compartiment 140cm

Husa lansete Mikado black 1 Compartiment 140cm

uwd-04201b-140
Livrare imediată!

83,00Lei

BLUZA DAIWA D-VEC LS BLACK MARIME M -20%
Exclusiv online!

BLUZA DAIWA D-VEC LS BLACK MARIME M

d.18206.220
Livrare 24-48 ore

200,79Lei(-20%) 160,63Lei

TRICOU FOX RAGE LIMITED EDITION PIKE T-SHIRT BLACK MAR XXL -30%

TRICOU FOX RAGE LIMITED EDITION PIKE T-SHIRT BLACK MAR XXL

npr402
Livrare imediată!

139,96Lei(-30%) 97,97Lei

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 8kg 45cm
Exclusiv online!

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 8kg 45cm

rla19b-45c8t
Livrare 48-72ore

31,50Lei

Hanorac Madcat Badge Logo Zip Black Caviar XL -29%

Hanorac Madcat Badge Logo Zip Black Caviar XL

8053173798
Livrare imediată!

245,97Lei(-29%) 174,89Lei

Afişare 481 - 500 din 4757 (238 pagini)
Queries: 7, Total time: 103.615 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '783d7d90ce89fb67377e541db8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (102.885)
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 (MATCH(pd.tag) AGAINST('+black' 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 (0.125)
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
5 (0.109)
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.095)
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
7 (0.170)
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