SELECT `pinfo`.`sku`,`pinfo`.`vendor`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('228')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('PASystems' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+PASystems' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"PASystems"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"PASystems"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"PASystems"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"PASystems"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+PASystems' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='PASystems',`category_4` ='PASystems') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'PASystems,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('PASystems', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

PA Systems

Refine Search

  GO
Brand

Amplivox(41)

HamiltonBuhl(14)

AmpliVox(11)

Color

Black|000000(17)

White|FFFFFF(4)

Height

11"(3)

23"(2)

10"(2)

19.5"(1)

11.25"(1)

3"(1)

13"(1)

Color(s)

Black(10)

Gray(1)

Width

13"(6)

14"(6)

11.5"(4)

9"(4)

7"(2)

Depth

11.5"(3)

5"(3)

3 1/2"(2)

9"(1)

6.5"(1)

3"(1)

Country of Origin

US(7)

CN(4)

Power Source(s)

10 D Batteries(3)

AC; Built-in Rechargeable Battery(2)

10 D Batteries (sold separately)(2)

AC; Rechargeable Battery(1)

SLA Battery(1)

NiMH Rechargable Batteries(1)

12V Rechargeable Battery(1)

Top Color

Black(7)

Type

Wireless Multimedia(1)

Multimedia(1)

Power

50 W(4)

50W(2)

250 W(2)

100W(1)

36 W(1)

5W(1)

Maximum Battery Operation Time

200 h(5)

10 h(3)

6 h(1)

8 h(1)

14 h(1)

Cord Length

10 ft(2)

5 ft(2)

15 ft(1)

Additional Features

Weatherproof and Scuff-Resistant Molded Black Luggage-Type Plastic Case(3)

16 Channel UHF Wireless Microphone; Bluetooth; Rechargeable Battery(2)

Wireless Microphone Kit(1)

16 Channel UHF Wireless Microphone; Bluetooth(1)

120 V ac Power Cord; Bluetooth Plug-In Receiver; FM Radio; Headset Microphone; Lapel Microphone; Media Player with USB/SD Inputs with Recording Capabilities; Remote Control; Wall Charger with USB Connection and 3.5 mm Charging Cable; Wireless Handheld Microphone(1)

Auxilliary Jack Types

3.5mm; RCA(2)

Base/Leg Color

Black(8)

Mic Input Types

Condenser; Dynamic; Wireless(5)

Combination XLR/1/4"(2)

0.25"(1)

Wireless(1)

Number of Mic Inputs

3(7)

1(3)

2(1)

Number of Speakers

1(8)

3(2)

Optional Power Source(s)

Rechargeable Amplivox S1465 Nicad Battery Pack With S1460 AC Adapter/Recharger(3)

APLS1460 (Sold Separately)(2)

Includes Power/Recharging Cable(1)

Platform Type

Flat or Tripod(1)

Speaker Type

6" x 8" Jensen Speaker(5)

6.5" Woofer and Tweeter(2)

8" Speaker(1)

6" Full Range Speaker (4 ohms)(1)

6.5" Full Range Speaker(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved