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

Produse ce potrivesc criteriilor de căutare


HUSA LANSETE JAXON CRAP X-TEAM, 210CM
Exclusiv online!

HUSA LANSETE JAXON CRAP X-TEAM, 210CM

uj-xdf210
Livrare 48-72 ore

345,00Lei

Protectie pentru Capete Lanseta Spro Freestyle 180-210cm -26%

Protectie pentru Capete Lanseta Spro Freestyle 180-210cm

006205-01450-00000
Livrare imediată!

62,00Lei(-26%) 45,99Lei

Minciog Cormoran Compact 210cm, 60x60cm
Exclusiv online!

Minciog Cormoran Compact 210cm, 60x60cm

a2.62.45213
Livrare 24-48 ore

200,76Lei

Groundsheet, DD, Hammocks, Superligh, Olive, Green, 210cmx150cm, 707273931658, Corturi Camping, Corturi Camping DDHammocks, Corturi DDHammocks, Camping DDHammocks, DDHammocks
Umbrela Cu Parasolar FL 210cm

Umbrela Cu Parasolar FL 210cm

7777065
Livrare imediată!

191,99Lei

Lanseta Fox Rage Prism X Zander Pro 210cm 7-28gram -20%

Lanseta Fox Rage Prism X Zander Pro 210cm 7-28gram

nrd329
Stoc epuizat

495,00Lei(-20%) 396,00Lei

Lanseta Delphin QUEEN Spin 210cm 2-10g 2seg -25%

Lanseta Delphin QUEEN Spin 210cm 2-10g 2seg

101001315
Stoc epuizat

177,00Lei(-25%) 132,99Lei

Lanseta Fox Rage Prism X Versatile Light Casting Rod 210cm 10-40gr 2seg -14%

Lanseta Fox Rage Prism X Versatile Light Casting Rod 210cm 10-40gr 2seg

nrd368
Stoc epuizat

539,96Lei(-14%) 464,06Lei

Husa FL pentru 4 Lansete cu Mulinete, 210cm

Husa FL pentru 4 Lansete cu Mulinete, 210cm

8307197059029
Stoc epuizat

299,90Lei

Lanseta Delphin Zandera NX LOWER 210cm, 3-18g, 2seg

Lanseta Delphin Zandera NX LOWER 210cm, 3-18g, 2seg

101004347
Stoc epuizat

279,00Lei

Husa Jrc Cocoon 2G Universal Barrow Cover, 260x210cm

Husa Jrc Cocoon 2G Universal Barrow Cover, 260x210cm

1485791
Stoc epuizat

166,66Lei

Lanseta Delphin BANG 210cm / 2-7g

Lanseta Delphin BANG 210cm / 2-7g

110382210
Stoc epuizat

159,00Lei

Maner Minciog Delphin HACKER 210cm -25%

Maner Minciog Delphin HACKER 210cm

941100580
Stoc epuizat

127,00Lei(-25%) 95,50Lei

Combo Spinning Delphin ZanderSPIN 210cm + 3T + 0.16mm

Combo Spinning Delphin ZanderSPIN 210cm + 3T + 0.16mm

101004211
Stoc epuizat

512,00Lei

Afişare 41 - 54 din 54 (3 pagini)
Queries: 10, Total time: 220.510 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'e1aba70b1ce7a4e617a962f07a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (218.153)
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 = '2' AND (pd.tag LIKE "%210cm%") 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 (0.094)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.441)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.324)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.105)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.096)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (0.953)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.123)
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