select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(p.products_price_override, p.products_price_override, p.products_price * (1 + p.products_markup)) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_quantity > 0 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5505-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA5505 10 U BDL CHAS S/W 10U |
$388.13 |
 |
 |
Product Title: SONICWALL SECURITY
MFG Part#: 01-SSC-8769
Condition: New Retail
In Stock: Yes
SONICWALL TZ 210 w/ Total Secure 1 Year |
$726.00 |
|
 |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5510-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA5510 APPL S/W 50 VPN PEERS 3FE |
$2,137.50 |
|
 |
Product Title: SONICWALL SECURITY
MFG Part#: 01-SSC-8753
Condition: New Retail
In Stock: Yes
SONICWALL TZ 210 |
$625.90 |
|
 |
Product Title: SONICWALL SECURITY
MFG Part#: 01-SSC-8760
Condition: New Retail
In Stock: Yes
SONICWALL NSA 240 w/Total Secure |
$1,770.00
$1,276.00 |
|
 |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5505-SEC-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA 5505 FIREWALL BUNDLE |
$956.75 |
|
 |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5505-UL-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA5505 UL BDL CHAS S/W UL 3DES/AE |
$598.78 |
|
| |
Product Title: JUNIPER NETSCREEN
MFG Part#: EX3200-24T
Condition: New Retail
In Stock: Yes
JUNIPER EX3200 24PT 10/100/1000BASET |
$1,870.00 |
|
 |
Product Title: JUNIPER NETSCREEN
MFG Part#: SSG-20-SH
Condition: New Retail
In Stock: Yes
JUNIPER NETSCREEN SEC SVCS GATEWAY 20 BA |
$703.13 |
|
 |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5510-SEC-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA5510 SEC PLUS APPL S/W 150 VPN |
$2,694.38 |
|
| |
Product Title: CISCO SECURITY PRODUCTS
MFG Part#: ASA5520-BUN-K9
Condition: New Retail
In Stock: Yes
CISCO ASA 5520 APPLIANCE W/SW 750 VPN PE |
$7,995.00
$4,950.00 |
|
 |
Product Title: JUNIPER NETSCREEN
MFG Part#: SSG-550M-SH
Condition: New Retail
In Stock: Yes
JUNIPER SSG 550M SYSTEM 1GB 1 PWR SUPPLY |
$5,720.00 |
|
 |
Product Title: JUNIPER NETSCREEN
MFG Part#: SSG-5-SH
Condition: New Retail
In Stock: Yes
JUNIPER NETSCREEN SEC SVCS GATEWAY 5 BAS |
$556.88 |
|
| Displaying 1 to 13 (of 13 products) |
Result Pages: 1 |
|
