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


Geanta Rive Pentru Tava Laterala Desserte XXL 2020, 90x67cm

Geanta Rive Pentru Tava Laterala Desserte XXL 2020, 90x67cm

90410370105
Stoc epuizat

354,99Lei

GEANTA TERMOIZOLANTA PRESTON SUPERA ROUND COOL BAG 22X27X27CM

GEANTA TERMOIZOLANTA PRESTON SUPERA ROUND COOL BAG 22X27X27CM

p0130076
Stoc epuizat

132,80Lei

Geanta de Umar Helikon Tex Bushcraft Satchel Bag Molle Earth Brown Clay, 17L

Geanta de Umar Helikon Tex Bushcraft Satchel Bag Molle Earth Brown Clay, 17L

tb-bst-cd-0a0ba
Stoc epuizat

260,00Lei

Geanta de Umar Helikon Tex Bushcraft Satchel Bag Molle Woodland US, 17L

Geanta de Umar Helikon Tex Bushcraft Satchel Bag Molle Woodland US, 17L

tb-bst-cd-03
Stoc epuizat

260,00Lei

Geanta de Umar Quantum 4street Deluxe Sling Bag Black

Geanta de Umar Quantum 4street Deluxe Sling Bag Black

8810102
Stoc epuizat

224,78Lei

Geanta Spinning Golden Catch Bakkan Rod Stand M

Geanta Spinning Golden Catch Bakkan Rod Stand M

gcz-7139305
Stoc epuizat

220,00Lei

Geanta Abu Garcia Beast Pro Big Boat Bag, 60x30x40cm

Geanta Abu Garcia Beast Pro Big Boat Bag, 60x30x40cm

1528432
Stoc epuizat

674,96Lei

Geanta Minciog Greys Fish Wet Wader Bag

Geanta Minciog Greys Fish Wet Wader Bag

1447278
Stoc epuizat

179,96Lei

Geanta Spinning Golden Catch Bakkan Rod Stand XL

Geanta Spinning Golden Catch Bakkan Rod Stand XL

gcz-7139307
Stoc epuizat

290,00Lei

Geanta Zebco Shoulder Bag 38x12x30 cm

Geanta Zebco Shoulder Bag 38x12x30 cm

8420022
Stoc epuizat

80,78Lei

Geanta Colmic Chicago 300, 44x25x22 cm

Geanta Colmic Chicago 300, 44x25x22 cm

bo268
Stoc epuizat

225,01Lei

Geanta Greys Prodigy Roving Cool Bag 60x34x34cm

Geanta Greys Prodigy Roving Cool Bag 60x34x34cm

1326285
Stoc epuizat

293,20Lei

Geanta Minciog Matrix Aquos PVC Net Bag, 60x15x55cm

Geanta Minciog Matrix Aquos PVC Net Bag, 60x15x55cm

glu177
Stoc epuizat

188,96Lei

Geanta Zfish Fish Tank Momeala Vie 18L, 36x24x25cm

Geanta Zfish Fish Tank Momeala Vie 18L, 36x24x25cm

ZF-8453
Stoc epuizat

79,52Lei

Scaun Pliabil Shakespeare cu Geantă Frigorifică

Scaun Pliabil Shakespeare cu Geantă Frigorifică

1154484
Stoc epuizat

224,96Lei

Geanta Accesorii Fox Rage Tackle Belt

Geanta Accesorii Fox Rage Tackle Belt

nlu129
Stoc epuizat

148,46Lei

Geanta Aqua Products Accesorii Security Pouch, 21x6x15cm

Geanta Aqua Products Accesorii Security Pouch, 21x6x15cm

405716
Stoc epuizat

149,95Lei

Geanta Aqua Products Black Series Security Pouch, 21x6x15cm

Geanta Aqua Products Black Series Security Pouch, 21x6x15cm

404933
Stoc epuizat

134,95Lei

Geanta NGT GTS cu 6 Compartimente 65x30x30cm

Geanta NGT GTS cu 6 Compartimente 65x30x30cm

ngt-fla-carryall-gts-ind
Stoc epuizat

189,90Lei

GEANTA SCIERRA WADERS AND DRY 40X38X30CM 43L

GEANTA SCIERRA WADERS AND DRY 40X38X30CM 43L

a8.sie.65483
Stoc epuizat

121,33Lei

Afişare 1021 - 1040 din 1042 (53 pagini)
Queries: 8, Total time: 233.217 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '11e9a0a60e8ba58b085ec1cca9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (227.944)
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 "%geantă%") 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 (4.552)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.142)
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.125)
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.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.139)
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