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 300 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 - Vergi 8 Metri

Produse ce potrivesc criteriilor de căutare


Combo Shakespeare Salt Boat Basher 2.40m, 100-300g, 2seg
Exclusiv online!

Combo Shakespeare Salt Boat Basher 2.40m, 100-300g, 2seg

1558970
Livrare 7-14 zile

292,46Lei

Lanseta Sakura Salt Sniper Finesse SALSS 802M, 5-20g, 2.44m, 2seg
Exclusiv online!

Lanseta Sakura Salt Sniper Finesse SALSS 802M, 5-20g, 2.44m, 2seg

20434saprj802280-2m
Livrare 48-72 ore

327,15Lei

Lanseta, Shakespeare, Salt, Boat, 502, 1.50m,, 12-20lb, 1544310, Lansete Pescuit din Barca, Lansete Pescuit din Barca Shakespeare, Shakespeare
Lanseta Daiwa Saltiga Slow Jig 1.85m, 250-400g, 1seg
Exclusiv online!

Lanseta Daiwa Saltiga Slow Jig 1.85m, 250-400g, 1seg

d.sgsl61b5
Livrare 24-48 ore

2.001,69Lei

Lanseta, Shakespeare, Salt, Boat, 502, 1.50m,, 8-12lb, 1544309, Lansete Pescuit din Barca, Lansete Pescuit din Barca Shakespeare, Shakespeare
Mulineta, Shakespeare, Salt, Spin, 20, FD, 1544317, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Mulineta, Shakespeare, Salt, Spin, 3000fd, 1544318, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Mulineta, Shakespeare, Salt, Spin, 50, FD, 1553759, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1
Exclusiv online!

Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1

1544321
Livrare 7-14 zile

269,96Lei

Saltea, Primire, Cadita, Mikado, Enclave, Cradle, Mat, 120x35x35cm, is14-r610, Saltele Receptie, Saltele Receptie Mikado, Mikado
Exclusiv online!

Saltea, Primire, Cadita, Mikado, Enclave, Cradle, Mat, 120x35x35cm, is14-r610, Saltele Receptie, Saltele Receptie Mikado, Mikado

is14-r610
Livrare 48-72 ore

540,00Lei

Saltea Primire Zeck Cat Mat 2.95x1.97m
Exclusiv online!

Saltea Primire Zeck Cat Mat 2.95x1.97m

90605180295
Livrare 48-72 ore

274,78Lei

Adapost Shakespeare Salt Beach Shelter
Exclusiv online!

Adapost Shakespeare Salt Beach Shelter

1545369
Livrare 7-14 zile

674,96Lei

Ancora Decoy Y-S25S Saltwater Game Nr.16
Exclusiv online!

Ancora Decoy Y-S25S Saltwater Game Nr.16

832882
Livrare 48-72 ore

27,00Lei

Combo Shakespeare Salt Herring Hustler 3.00m, 90g, Tele
Exclusiv online!

Combo Shakespeare Salt Herring Hustler 3.00m, 90g, Tele

1558971
Livrare 7-14 zile

269,96Lei

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

30234saprg70234004
Livrare imediată!

199,31Lei

Mulineta Shakespeare Salt Multiplier 20lb RH 1+1rul
Exclusiv online!

Mulineta Shakespeare Salt Multiplier 20lb RH 1+1rul

1545359
Livrare 7-14 zile

269,96Lei

Saltea Primire Crap Baracuda 100cm x 60cm

Saltea Primire Crap Baracuda 100cm x 60cm

salhkpc
Livrare imediată!

63,30Lei

Shad, Hide, Up, Stagger, Original, 1.5", Salt,, S-13, Akarame, Okiami,, 4cm,, 8buc/pac, hide84505, Shad-uri, Shad-uri Hide Up, Hide Up
Combo Shakespeare Salt Seabass Searcher 2.70m, 40-80g, 2seg
Exclusiv online!

Combo Shakespeare Salt Seabass Searcher 2.70m, 40-80g, 2seg

1558966
Livrare 7-14 zile

269,96Lei

Combo Shakespeare Salt Surf Slayer 4.20m, 100-200g, 3seg
Exclusiv online!

Combo Shakespeare Salt Surf Slayer 4.20m, 100-200g, 3seg

1560635
Livrare 7-14 zile

382,46Lei

Afişare 61 - 80 din 585 (30 pagini)
Queries: 5, Total time: 225.775 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '7874a577058dc9af926f63e7bc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (222.637)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%salt%") 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:698
4 (2.794)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.128)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38