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


Brat RAM Mounts Double Socket Arm - C Size Short

Brat RAM Mounts Double Socket Arm - C Size Short

ram-201u-b
Livrare imediată!

178,40Lei

Cutie Dubla pentru Accesorii Flambeau Fishing Double Satchel Tackle Box 7320
Exclusiv online!

Cutie Dubla pentru Accesorii Flambeau Fishing Double Satchel Tackle Box 7320

rf-7320
Livrare 48-72 ore

194,01Lei

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 13cm Yellow 20buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 13cm Yellow 20buc/set

p0020027
Livrare 7-14 zile

76,46Lei

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 18cm Red 14buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 18cm Red 14buc/set

p0020020
Livrare 7-14 zile

76,46Lei

Brat RAM Mounts Double Socket Arm - B Size Long

Brat RAM Mounts Double Socket Arm - B Size Long

ram-b-201u-c
Livrare imediată!

183,00Lei

Brat Pivotant RAM Mounts Swivel Double Socket Arm for B Size & C Size Ball

Brat Pivotant RAM Mounts Swivel Double Socket Arm for B Size & C Size Ball

rap-bc-201u
Livrare imediată!

183,50Lei

Brat RAM Mounts Double Socket Arm - B Size Medium

Brat RAM Mounts Double Socket Arm - B Size Medium

ram-b-201u
Livrare imediată!

125,79Lei

Bride Duble Pole Position Double Crimps S 0.60mm, 50buc/pac

Bride Duble Pole Position Double Crimps S 0.60mm, 50buc/pac

008036-00302-00000
Livrare imediată!

25,00Lei

Fir Inaintas Conic Exocet Pro Double Tapered, Line Trans, Kaki, 0.30mm-0.50mm, 300m -46%

Fir Inaintas Conic Exocet Pro Double Tapered, Line Trans, Kaki, 0.30mm-0.50mm, 300m

cml155
Livrare imediată!

67,04Lei(-46%) 36,00Lei

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 18cm Red 14buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS BOX 18cm Red 14buc/set

p0020028
Livrare 7-14 zile

76,46Lei

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 26cm Wide Purple 7buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 26cm Wide Purple 7buc/set

p0020030
Livrare 7-14 zile

76,46Lei

Suport Feeder Colmic EVA Double, 25cm
Exclusiv online!

Suport Feeder Colmic EVA Double, 25cm

ap61e
Livrare 48-72 ore

250,00Lei

Brat, RAM, Mounts, Double, Socket, Arm, -, C, Size, Medium, ram-201u, Componente Suporturi Modulare RAM Mounts, Componente Suporturi Modulare RAM Mounts RAM Mounts, Componente RAM Mounts, Suporturi RAM Mounts, Modulare RAM Mounts, RAM RAM Mounts, Mounts RAM Mounts, RAM Mounts
PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 26cm Orange 9buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 26cm Orange 9buc/set

p0020068
Livrare 7-14 zile

76,46Lei

Reflector Led cu Suport RAM Mounts Tough-Claw Double Ball Mount with LED Spotlight

Reflector Led cu Suport RAM Mounts Tough-Claw Double Ball Mount with LED Spotlight

ram-b-152-404
Livrare imediată!

1.034,90Lei

Brat, RAM, Mounts, Double, Socket, Arm, -, D, Size, Short, ram-d-201u-c, Componente Suporturi Modulare RAM Mounts, Componente Suporturi Modulare RAM Mounts RAM Mounts, Componente RAM Mounts, Suporturi RAM Mounts, Modulare RAM Mounts, RAM RAM Mounts, Mounts RAM Mounts, RAM Mounts
Cutie Muste Rapture LMF Double Dry Fly Box, Transparent, 18.8x10.3x1.7cm
Exclusiv online!

Cutie Muste Rapture LMF Double Dry Fly Box, Transparent, 18.8x10.3x1.7cm

113-19-080
Livrare 48-72 ore

40,00Lei

Hamac Ticket to the Moon Double Purple & Pink, 320x200cm
Exclusiv online!

Hamac Ticket to the Moon Double Purple & Pink, 320x200cm

tmd3021
Livrare 24-48 ore

315,00Lei

Bride pentru Monturi NGT Double Crimps, 0.8mm (L), 10buc/cutie

Bride pentru Monturi NGT Double Crimps, 0.8mm (L), 10buc/cutie

ngt-ft-crimps-08mm-10pc
Livrare imediată!

7,50Lei

Cutie, Accesorii, Plano, Double, Sided, Tackle, Organizer, pmc321508, Cutii, Cutii Plano, Plano
Exclusiv online!

Cutie, Accesorii, Plano, Double, Sided, Tackle, Organizer, pmc321508, Cutii, Cutii Plano, Plano

pmc321508
Livrare 7-14 zile

85,46Lei

Afişare 141 - 160 din 227 (12 pagini)
Queries: 13, Total time: 208.606 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '009f4d4abf821fda03ca7326ee'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.068)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (203.297)
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 "%double%") 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:697
5 (0.135)
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:1547
6 (1.144)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.358)
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:1204
8 (0.074)
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:1223
9 (0.089)
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:982
10 (3.008)
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:904
11 (0.086)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.077)
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