armeg - tool accessories

Armeg are the award winning power tool accessory manufacturer including SDS Plus and SDS Max drill bits. Armeg drill bits are manufactured in the United Kingdom to the highest premium quality levels. They offer SDS+ SDS multi-fit SDS max K taper Heavy duty core drills Light weight core drills Termatrol Earth Augers Also adapters and accessories
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`price`, `e`.`small_image`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`thumbnail`, `e`.`short_description`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`wtp_model`, `e`.`call_for_price_active`, `e`.`tool_a_day_date`, `e`.`tool_a_day_price`, `e`.`wtp_nav_product`, `e`.`wtp_newsletter`, `e`.`wtp_bonus_description`, `e`.`wtp_bonus_type`, `e`.`wtp_bonus_type_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '576' AND cat_index.is_parent=1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `e`.`name` ASC LIMIT 48
-
Regular Price:
$9.00
Special Price
$5.00
-
Regular Price:
$99.00
Special Price
$75.00
-
Regular Price:
$39.00
Special Price
$29.00
-
-
Regular Price:
$229.00
Special Price
$209.00
-
Regular Price:
$289.00
Special Price
$229.00
-
Regular Price:
$339.00
Special Price
$279.00
-
Regular Price:
$159.00
Special Price
$99.00
-
Regular Price:
$129.00
Special Price
$79.00
-
Regular Price:
$129.00
Special Price
$79.00
-
Regular Price:
$129.00
Special Price
$79.00
-
Regular Price:
$129.00
Special Price
$89.00
-
Regular Price:
$139.00
Special Price
$99.00
-
-