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


Carp Zoom BOILIES CZ MAGNET-X 16mm 800gr Black Pepper-Liver

Carp Zoom BOILIES CZ MAGNET-X 16mm 800gr Black Pepper-Liver

cz4136
Stoc epuizat

38,00Lei

Carp Zoom BOILIES CZ MAGNET-X 16mm 800gr Spicy Squid-Krill

Carp Zoom BOILIES CZ MAGNET-X 16mm 800gr Spicy Squid-Krill

cz4143
Stoc epuizat

38,00Lei

Boilies NASH Scopex Squid Stabilised 15mm 1kg

Boilies NASH Scopex Squid Stabilised 15mm 1kg

b6801
Stoc epuizat

69,99Lei

Cutit Delphin SPLITER -44%

Cutit Delphin SPLITER

101001592
Stoc epuizat

48,00Lei(-44%) 27,00Lei

Boilies NASH Scopex Squid Stabilised 20mm 1kg

Boilies NASH Scopex Squid Stabilised 20mm 1kg

b6802
Stoc epuizat

69,99Lei

Cizme pentru rau Delphin HRON 44 -25%

Cizme pentru rau Delphin HRON 44

101000589
Stoc epuizat

203,00Lei(-25%) 152,70Lei

Gentuta pentru documente Delphin Carpath

Gentuta pentru documente Delphin Carpath

101000412
Stoc epuizat

52,00Lei

Carp Zoom BOILIES CZ MAGNET X 16mm 800gr Strawberry-Fish

Carp Zoom BOILIES CZ MAGNET X 16mm 800gr Strawberry-Fish

cz4112
Stoc epuizat

38,00Lei

GEANTA SOLAR PENTRU ACCESORII UNDERCOVER CAMO CARRYALL LARGE

GEANTA SOLAR PENTRU ACCESORII UNDERCOVER CAMO CARRYALL LARGE

ca09
Stoc epuizat

324,99Lei

Husa rigida pentru lansete Fox Rage Voyager Camo Hard Rod Sleeves Single 1.30M
Boilies Dudi Bait Mister Red Tari 20mm 1kg

Boilies Dudi Bait Mister Red Tari 20mm 1kg

4122126473547
Stoc epuizat

45,00Lei

Boilies NASH Scopex Squid Stabilised 12mm 5Kg

Boilies NASH Scopex Squid Stabilised 12mm 5Kg

b6805
Stoc epuizat

269,99Lei

Salopeta pentru rau Delphin HRON 41

Salopeta pentru rau Delphin HRON 41

101000579
Stoc epuizat

328,00Lei

Boilies NASH Scopex Squid Stabilised 12mm 1kg

Boilies NASH Scopex Squid Stabilised 12mm 1kg

b6800
Stoc epuizat

75,99Lei

CARLIGE LEGATE TRABUCCO AKURA PENTRU CRAP Nr02x0.30mm 10BUC/PLIC

CARLIGE LEGATE TRABUCCO AKURA PENTRU CRAP Nr02x0.30mm 10BUC/PLIC

028-20-030
Stoc epuizat

15,01Lei

Boilies Dudi Bait Mister Red Tari 16mm 1kg

Boilies Dudi Bait Mister Red Tari 16mm 1kg

7122108433184
Stoc epuizat

45,00Lei

Husa rigida pentru lansete Fox Rage Voyager Camo Hard Rod Sleeves Double 1.30M
Penar pentru naluci Fox Rage Voyager Camo Soft Bait Binder

Penar pentru naluci Fox Rage Voyager Camo Soft Bait Binder

nlu096
Stoc epuizat

67,46Lei

Boilies Dudi Bait Mister Red Tari 24mm 1kg

Boilies Dudi Bait Mister Red Tari 24mm 1kg

8122105231102
Stoc epuizat

45,00Lei

Salopeta pentru rau Delphin HRON 42 -30%

Salopeta pentru rau Delphin HRON 42

101000580
Stoc epuizat

325,00Lei(-30%) 226,90Lei

Afişare 3221 - 3240 din 5144 (258 pagini)
Queries: 8, Total time: 107.891 ms [By time] [By id] [By file]
1 (0.141)
SELECT data
FROM `oc_session`
WHERE session_id = '9d001b03bb093122f65c89da90'
/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 (107.021)
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('+pentru' 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.142)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"DUDI BAIT"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"DUDI BAIT"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"DUDI BAIT"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.117)
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