|
select p.products_image, pd.products_name, p.products_model, p.products_id, p.products_specials_options, pd.products_head_desc_tag, pd.products_head_keywords_tag, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id and s.stores_id = '1' INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '251' order by pd.products_name
| Click on Product Name & Desc, Model# or Price to sort your results below |
| |
 |
| |
Product Name & Desc |
Model # |
Price |
Buy/Select |
 |
Auto-Dial Enclosed Phone
Gai-Tronics 227 Auto-Dial Telephone w/ Enclosure Auto-Dials up to 16 Digits |
227-001 |
$936.25 |
|
| |
 |
Auto-Dial Enclosed Phone (Locking)
Gai-Tronics Auto-Dial Telephone & Enclosure w/ Locking Door & Keys Comes w/ Locking Door & Keys |
227-001LD |
$1,035.75 |
|
| |
 |
Ceeco L-Shaped Wrench, 5/32"
Ceeco L-Shaped Security Wrench Tool 5/32" Read More... |
301-065 |
$8.00 |
|
| |
 |
Ceeco Screwdriver Security Tool, 5/32"
Ceeco 5/32 Screwdriver/Security Tool for Ceeco Phone Installation Supports Ceeco BLC, SSW, SSP Models |
301-037 |
$15.50 |
|
| |
 |
Intrinsically Safe Outdoor Phone
Gai-Tronics Outdoor Intrinsically Safe Telephone Read More... |
271-001 |
$1,799.50 |
|
| |
 |
Weatherproof Enclosed Auto-Dial Phone
Ceeco Weatherproof Phone w/ ATD-11 Automatic Tone Dialer Available in Black, Red, Yellow or Grey |
WPP-331-D |
$732.75 |
|
| |
 |
Weatherproof Enclosed Auto-Dial Phone w/ MCRK-2
Ceeco Weatherproof Phone w/ MCRK-2 Anti-Fraud Automatic Dialer Available in Black, Red, Yellow or Grey |
WPP-333-D |
$476.50 |
|
| |
 |
Weatherproof Enclosed Handsfree Auto-Dial Phone
Ceeco Weatherproof Phone, Handsfree w/ Low Power Board & Automatic Dialer Available in Black, Red, Yellow or Grey |
WPP-530-D |
$539.75 |
|
| |
 |
Weatherproof Enclosed Handsfree No-Dial Phone
Ceeco Weatherproof Phone, Handsfree w/ Low Power Board for Manual Ring Down Operation Available in Black, Red, Yellow or Grey |
WPP-530-X |
$519.75 |
|
| |
 |
Weatherproof Enclosed Handsfree Phone
Ceeco Weatherproof Phone, Handsfree w/ Chrome Tone Dial Available in Black, Red, Yellow or Grey |
WPP-531-F |
$575.50 |
|
| |
 |
Weatherproof Enclosed No-Dial Phone
Ceeco Weatherproof Phone for Manual Ring Down Operation Available in Black, Red, Yellow or Grey |
WPP-331-X |
$399.75 |
|
| |
 |
Weatherproof Enclosed Phone
Ceeco Weatherproof Phone w/ Chrome Tone Dial Available in Black, Red, Yellow or Grey |
WPP-331-F |
$432.75 |
|
| |
 |
Weatherproof Enclosed Phone w/ MCRK-2
Ceeco Weatherproof Phone w/ MCRK-2 Call Restriction & Anti-Fraud Features Available in Black, Red, Yellow or Grey |
WPP-333-F |
$464.00 |
|
| |
 |
Weatherproof Handsfree ADA Phone w/ Dial & AD
Ceeco Weatherproof Dual Phone, Handsfree w/ Chrome Tone Dial & Emergency Push Button Automatic Dialer 100 % ADA Compliant! |
WPP-531-FD-ADA |
$577.50 |
|
| |
 |
Weatherproof Handsfree Auto-Dial ADA Phone
Ceeco Weatherproof Phone, Handsfree w/ Emergency Push Button Automatic Dialer & Braille Emergency Plate 100 % ADA Compliant! |
WPP-531-D-ADA |
$561.75 |
|
| |
|
|
