SELECT DISTINCT ActiveRank, ProductID, Comments, Description, PriceMask, EndRetailPrice, Manu, item_weight, RebateInfo, Qty, main_cat, Category, UPCcode_sku FROM ProductList WHERE Category = 'TV Antenna Installations' AND PS_status = 'A' AND main_cat = '03' AND searchable = 'Y' AND srSSCOM = 'Y' ORDER BY ActiveRank DESC, Description ASC;
Solid Signal > TV Antennas & Supplies >
TV Antenna Installations
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
NEED TV ANTENNA HELP?
