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


Averizor Carp Spirit BLAX -10%
Exclusiv online!

Averizor Carp Spirit BLAX

acs490077
Livrare 48-72ore

99,00Lei(-10%) 89,00Lei

Avertizor Electronic Prologic Bat Led Multicolor -20%
Exclusiv online!

Avertizor Electronic Prologic Bat Led Multicolor

a.pro.64107
Livrare 24-48 ore

158,08Lei(-20%) 126,46Lei

Lingura Rattling Zeck Vertical Jig 120g Black
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 120g Black

130805150011
Livrare 48-72 ore

81,06Lei

Lingura Rattling Zeck Vertical Jig 120g White
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 120g White

130805150015
Livrare 48-72 ore

81,06Lei

Montura Somn Jaxon Bongo Clonk Teaser Vertical C 140g
Exclusiv online!

Montura Somn Jaxon Bongo Clonk Teaser Vertical C 140g

bs-cf140c
Livrare 48-72 ore

119,00Lei

Set Avertizoare Prologic Element Com-Pact 3+1

Set Avertizoare Prologic Element Com-Pact 3+1

a.pro.1609323
Livrare imediată!

1.239,14Lei

Set Avertizori Carp Academy V-Head 4+1

Set Avertizori Carp Academy V-Head 4+1

6326-004
Livrare imediată!

736,00Lei

Snagears Mikado, Black
Exclusiv online!

Snagears Mikado, Black

aix-0003
Livrare 48-72 ore

39,00Lei

Carlige Gardner Covert Dark Chod Hook, Nr.8, 10buc/plic
Exclusiv online!

Carlige Gardner Covert Dark Chod Hook, Nr.8, 10buc/plic

cchod8
Livrare 48-72 ore

22,00Lei

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.234, 5.9kg, 150m
Exclusiv online!

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.234, 5.9kg, 150m

gcz-4039010
Livrare 48-72ore

30,00Lei

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.286, 8.7kg, 150m
Exclusiv online!

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.286, 8.7kg, 150m

gcz-4039012
Livrare 48-72ore

33,00Lei

Lingura Rattling Zeck Vertical Jig 140g Green
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 140g Green

130805150142
Livrare 48-72 ore

86,16Lei

Lingura Rattling Zeck Vertical Jig 55g Green
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 55g Green

130805150057
Livrare 48-72 ore

65,76Lei

Lingura Rattling Zeck Vertical Jig 85g Green
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 85g Green

130805150087
Livrare 48-72 ore

70,86Lei

Statie Trakker DB7-R Receiver, 9.2x5.4x4.5cm
Exclusiv online!

Statie Trakker DB7-R Receiver, 9.2x5.4x4.5cm

222203
Livrare 7-14 zile

574,95Lei

Avertizor + Baterie CARP SPIRIT, Bleu
Exclusiv online!

Avertizor + Baterie CARP SPIRIT, Bleu

acc490016
Livrare 48-72ore

49,00Lei

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X2000 -20%

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X2000

a.11.80101
Livrare imediată!

71,29Lei(-20%) 57,02Lei

Avertizor FL Led Varf Lanseta

Avertizor FL Led Varf Lanseta

64-8555
Livrare imediată!

7,90Lei

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.261, 7.4kg, 150m
Exclusiv online!

Fir Monofilament Golden Catch Verte-X Feeder Venom, 0.261, 7.4kg, 150m

gcz-4039011
Livrare 48-72ore

32,00Lei

Sac de Dormit Tip Mumie Coleman Silverton 150
Exclusiv online!

Sac de Dormit Tip Mumie Coleman Silverton 150

2000017868
Livrare 24-48 ore

399,00Lei

Afişare 501 - 520 din 823 (42 pagini)
Queries: 9, Total time: 2,550.897 ms [By time] [By id] [By file]
1 (0.788)
SELECT data
FROM `oc_session`
WHERE session_id = '791b8d18bc3e868611a5d16de8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2,549.200)
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 "%vert%") 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:725
4 (0.160)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.145)
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.120)
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.135)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
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
9 (0.133)
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