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 = '22' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: TARGUS ACCESSORIES
MFG Part#: APA63US
Condition: New Retail
In Stock: Yes
TARGUS UNIVERSAL LAPTOP AC ADAPTER |
$33.00 |
 |
 |
Product Title: HPQ HDD SATA/FATA/SAS/FC
MFG Part#: 504062-B21
Condition: New Retail
In Stock: Yes
HPQ 146GB 3G SAS 15K SFF DP HDD |
$458.70 |
|
 |
Product Title: HPQ MEMORY
MFG Part#: 516423-B21
Condition: New Retail
In Stock: Yes
HPQ 8GB 2RX4 PC3-8500R-7 MEM KIT |
$734.80 |
|
 |
Product Title: HPQ BLADE SWITCHES/NETWORKING
MFG Part#: 406740-B21
Condition: New Retail
In Stock: Yes
HPQ 1 GB ETH PASS THRU MOD 16PORT TX |
$691.90 |
|
 |
Product Title: 3COM COMPATIBLE
MFG Part#: 3CSFP91
Condition: New Retail
In Stock: Yes
3COM 1000BSX SFP MODULE (LC) CONNECTOR |
$34.00 |
|
 |
Product Title: Q-LOGIC PCI
MFG Part#: QLE2460-E-SP
Condition: New Retail
In Stock: Yes
QLOGIC PCI-E 4GB 1PT HBA EMC FIRMWARE |
$806.63 |
|
 |
Product Title: Q-LOGIC PCI
MFG Part#: QLE2460-CK
Condition: New Retail
In Stock: Yes
QLOGIC PCI-E 4GB 1PT HBA |
$799.70 |
|
 |
Product Title: HPQ PROCURVE POWER SUPPLIES
MFG Part#: J8712A#ABA
Condition: New Retail
In Stock: Yes
HP PROCURVE RPS P/S 875W 110V 220V 5406Z |
$477.40 |
|
 |
Product Title: CISCO INTERFACES AND MODS
MFG Part#: HWIC-4ESW=
Condition: New Retail
In Stock: Yes
CISCO FOUR PORT 10/100 ETHERNET SWITCH H |
$275.63 |
|
 |
Product Title: HPQ BL460C G5
MFG Part#: 492310-B21
Condition: New Retail
In Stock: Yes
HPQ BL460C G5 L5430 2.66GHz-12MB QC 1P |
$2,659.00
$2,105.40 |
|
| |
Product Title: HPQ BL480C
MFG Part#: 435460-B21
Condition: New Retail
In Stock: Yes
HPQ BL480C E5310 X/1.6GHz-8MB QC 1P 2GB |
$3,349.00
$2,586.10 |
|
| |
Product Title: CISCO SWITCHES
MFG Part#: WS-C3750G-24TS-S1U
Condition: New Retail
In Stock: Yes
CISCO CATALYST 3750 24 10/100/1000 + 4 S |
$4,015.00 |
|
| |
Product Title: IBM BLADE NETWORKING
MFG Part#: 2019A1X
Condition: New Retail
In Stock: Yes
IBM BC ADVANCED MANAGEMENT MODULE |
$849.00
$770.00 |
|
| |
Product Title: IBM BLADE NETWORKING
MFG Part#: 44X1905
Condition: New Retail
In Stock: Yes
IBM QLOGIC 20 PORT 8GB SAN SWITCH MODULE |
$8,999.00
$8,156.50 |
|
| |
Product Title: HPQ PROCURVE MODULES
MFG Part#: J8436A
Condition: New Retail
In Stock: Yes
HP PROCURVE 10GBE SC X2 SR OPTIC 3400 35 |
$2,999.00
$1,966.80 |
|
| |
Product Title: HPQ BL480C
MFG Part#: 459500-B21
Condition: New Retail
In Stock: Yes
HPQ BL480C E5410 2.33GHz-2X6MB QC 1P 2GB |
$2,659.00
$2,448.60 |
|
| |
Product Title: 3COM COMPATIBLE
MFG Part#: 3CSFP93
Condition: New Retail
In Stock: Yes
3COM 1000BT SFP MODULE RJ45 |
$52.00 |
|
 |
Product Title: CISCO WIC/VWIC
MFG Part#: VWIC2-1MFT-T1/E1=
Condition: New Retail
In Stock: Yes
CISCO 1PT MLTFLX TRNK 2ND GEN T1/E1 |
$838.80 |
|
 |
Product Title: Q-LOGIC PCI
MFG Part#: QLE4062C-CK
Condition: New Retail
In Stock: Yes
QLOGIC PCI-E 1GB 2PT iSCSI |
$1,078.00 |
|
 |
Product Title: IBM X3850M2
MFG Part#: 72335RU
Condition: New Retail
In Stock: Yes
IBM X3850M2 E7450 2.4/12M (2P) 6C 8GB |
$11,055.00 |
|
| Displaying 1 to 20 (of 43 products) |
Result Pages: 1 |
|
