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 = '23' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: 3COM SWITCHES
MFG Part#: 3CRS42G-48-91
Condition: New Retail
In Stock: Yes
3COM 4200G 48PT 40PT GETH 4PT DP 1PT 10G |
$3,495.00
$2,194.50 |
 |
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9033A
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH VL 20P GIG-T+ 4P SFP MO |
$770.00 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9089A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2610-48-POE 48x10/100 |
$1,652.28 |
|
 |
Product Title: CISCO SWITCHES
MFG Part#: WS-C2960G-24TC-L
Condition: New Retail
In Stock: Yes
CISCO CATALYST 2960 20PT GETH 4PT DP UPL |
$1,811.25 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J8692A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 3500YL-24G-PWR POE SWIT |
$2,418.75 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CRS45G-48-91-US
Condition: New Retail
In Stock: Yes
3COM SWITCH 4510G - 48 PORT SWITCH - 10 |
$4,995.00
$3,186.70 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17562-91-US
Condition: New Retail
In Stock: Yes
3COM SWCH 4500 50PT 48PT10/100 2PT DP |
$1,175.00
$750.20 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9086A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2610-24/12-POE 24x10/10 |
$593.40 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9088A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2610-48 48x10/100 |
$660.05 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17761-91-US
Condition: New Retail
In Stock: Yes
3COM 4500G 24PT 10/100/1000 4PT DP 4PT10 |
$3,295.00
$2,102.10 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CRBSG5293-US
Condition: New Retail
In Stock: Yes
3COM 2952 52PT BASELINE PLUS SWCH |
$995.00
$634.70 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17771-91-US
Condition: New Retail
In Stock: Yes
3COM 4500G 24PT POE 10/100/1000 4PT DP 4 |
$3,995.00
$2,548.70 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9148A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2910Al-48G-POE 10/100/1 |
$4,125.00 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17772-91-US
Condition: New Retail
In Stock: Yes
3COM 4500G 48PT POE 10/100/1000 4PT DP 4 |
$6,995.00
$4,015.00 |
|
| |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9298A#ABA
Condition: New Retail
In Stock: Yes
HPQ PROCURVE SWCH 2520G-8-POE 8PT GIG |
$999.00
$625.90 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9145A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2910AL-24PT 10/100/1000 |
$1,634.60 |
|
| |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9279A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2510G-24 x 10/100/100 + |
$1,099.00
$688.60 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17561-91-US
Condition: New Retail
In Stock: Yes
3COM SWCH 4500 26PORT |
$695.00
$443.30 |
|
 |
Product Title: HPQ PROCURVE SWITCHES
MFG Part#: J9280A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE SWCH 2510G-48x 10/100/100 + |
$1,472.90 |
|
| |
Product Title: 3COM SWITCHES
MFG Part#: 3CR17333-91-US
Condition: New Retail
In Stock: Yes
SWITCH 4210 26PT MGD 24PT 10/100 2PT DP |
$450.00
$287.10 |
|
| Displaying 1 to 20 (of 64 products) |
Result Pages: 1 |
|
