kincrome - air tools
Professional quality tools supplier Kincrome has an entire air tool and accessory range designed for the trade professional or enthusiast looking for quality air tools for value for money. Branded under the ‘Kincrome Pneumatic’ name, the comprehensive range includes compressors, impact guns, hoses and ratchets. Kincrome has partnered with the reputable Italian compressor manufacturer FIAC to bring a range of quality air compressors to the Australian market.
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 = '362' 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:
$699.00
Special Price
$569.00
-
Regular Price:
$1,499.00
Special Price
$1,495.00
-
Regular Price:
$350.00
Special Price
$329.00
-
Regular Price:
$471.00
Special Price
$469.00
-
-
Regular Price:
$249.00
Special Price
$195.00
-
-
Regular Price:
$159.00
Special Price
$109.00
-
-
Regular Price:
$239.00
Special Price
$209.00
-
-
Regular Price:
$25.00
Special Price
$16.95
-
Regular Price:
$29.00
Special Price
$21.95
-
-
Regular Price:
$349.00
Special Price
$229.00
-
Regular Price:
$279.00
Special Price
$269.00
-
Regular Price:
$359.00
Special Price
$303.74
-
Regular Price:
$299.00
Special Price
$249.00
-