enterpristore.com Our Line Card Events Shop by Brand Store Locator

Language:

EnglishEspañol

My Cart (0)

My Shopping Cart

Your shopping cart is empty

Need help? Reach us at 1800.325.9708 Live Support

more search options

Access &
Intercom
- Gate Operator
- Credentials
  - Smart
  - Barcode
  - Mobile
  - Accessories
  - Prox
  - Multitech
  - RFID
- Door Controllers & Software
  - Panels
  - Accessories
  - Kits
  - Software
- Exit Devices
  - Motion
  - Accessories
  - Push Bar
  - Key Switch
  - Push Buttons
  - Non-Touch
- Intercoms
- Keypads
  - Stand Alone
- Locking Devices
- Metal Detectors
  - Hanheld Devices
- Readers
  - Accessories
  - Smart
  - UHF / RFID
  - Biometrics
  - Prox
  - Laser
- Tele-Entry
  - Accessories
  - Panels
- Voice over IP
  - IP Phones
- Accessories
  - Custom Buttons
Audio &
Video
CCTV
- Analog Cameras
  - Specialty
  - Turret
  - Dome
  - Fisheye
  - Box
  - Bullet
  - Eyeball
  - PTZ
- Analog Kits
- DVR
  - Hybrid
- Encoders & Decoders
  - Encoders
  - Decoders
- IP Cameras
  - PTZ
  - Bullet
  - Dome
  - Turret
  - Modular
  - Multisensor
  - Specialty
  - Eyeball
  - Fisheye
  - Panoramic
  - Thermal
- IP Kits
- NVR
- Software
- Accessories
  - Lens
  - Baluns & Receivers
  - Mounts
  - Monitors
  - Servers
  - Hard Drives
  - Workstations
  - Extenders
  - Microphones
Fire
Home Automation
Infrastructure
Networking
Power &
Batteries
- Batteries
- Power Accessories
- Power Supplies
  - Wall
  - Board Only
  - Plug-In
  - Laptop Style
  - Modules
  - Din-Rail
  - Rack Mount
- Surge Suppression
  - Surge Accessories
  - Intrusion
  - Fire
  - General
  - Data
  - CCTV
- Transformers
  - Bare
  - Plug-In
- UPS
  - Stand By
  - On-Line
Security
- Communication
  - Communicators
  - Central Station
- Contacts
  - Tampers
  - Accessories
  - Recessed
  - Overhead
  - Surface
  - Hold Up
- Control Panels & Keypads
  - Numeric
  - Panels
  - Icon Keypads
  - LCD Keypads
  - Touch Keypads
  - Kits
  - Gateway
- Intrusion Modules
  - Audio
  - Status
  - Translator
  - Expanders
  - Receivers
  - Repeaters
  - Wired to Wireless
- Panic
  - Hold Up
- Sensors
  - Motion & Glass
  - Glass & Shock
  - Heat
  - Motion
  - Door & Windows
  - Glass
  - Carbon Monoxide
  - Smoke
  - Flood
  - Environmental
  - Pool Alarm
  - Smoke & Heat
  - Photobeam Detectors
  - Temperature
  - Shock
  - Specialty
- Visual / Sounding Devices
  - Sirens
  - Speakers
  - Buzzer
  - Strobes
- Wireless Panic & Keyfobs
- Accessories
Tools &
Hardware

Home » Brands » Jonard Tools

Hand Tools Jonard Tools

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price

from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_groups pg ON pg.products_id = p.products_id AND pg.group_code = 'G' left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = '1' JOIN products_to_categories p2c ON p2c.products_id = p.products_id JOIN categories c ON c.categories_id = p2c.categories_id

where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '229' or p2c.categories_id = '229') and m.manufacturers_id = '5107'

group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name

5 items

Adjustable Round Hole Cutter with Vacuum Port, 9"
# AHC-19

Jonard Tools

Drywall Jab Saw, 6"
# DWS-6

Jonard Tools

Heavy-Duty Wire Stripping Pliers, 10-16 AWG
# WSC-1016

Jonard Tools

Magnetizer & Demagnetizer Tool
# MAG-100

Jonard Tools

Wall Box Template And Leveler For Old Work Electrical Boxes
# WTL-12

Jonard Tools

5 items

About Us

About Us
Store Locator
Silmar Team
Line Card
Webinars
Events
Site Map

Customer Care

Financing for Dealers
My Account
Shop by Brand
Express Order
Our Catalog
Technical Library
Contact Us

Our Policies

FAQs
Silmar Electronics Terms of Use
General Terms and conditions
Website support
Returns & Exchanges

Distributor of Security, Fire, Access, CCTV, IP Products, Commercial & Residential Sound Systems and Accessories.

Silmar Electronics, Inc 3405 NW 113th Ct, Miami, FL 33178, United States

305.513.0484 Toll Free: 1.800.325.9708

[email protected]

Please note that some areas of this site are password protected and all material contained in these areas is designed for and available ONLY to professional security installation companies.

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again