Your cart is currently empty!
AC Parts
Showing 1–12 of 95 results
WordPress database error: [Unknown column 'wc.weight' in 'SELECT']
SELECT
MIN(CAST(wc.weight AS DECIMAL(10,2))) as min_weight,
MAX(CAST(wc.weight AS DECIMAL(10,2))) as max_weight
FROM wp_wc_product_meta_lookup wc
WHERE wc.product_id NOT IN (
SELECT tr3.object_id
FROM wp_term_relationships tr3
INNER JOIN wp_term_taxonomy tt3 ON tr3.term_taxonomy_id = tt3.term_taxonomy_id
WHERE tt3.term_id = 9
)
AND wc.product_id IN (
SELECT tr.object_id
FROM wp_term_relationships tr
INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.term_id = 2093
)
WordPress database error: [Unknown column 'wc.length' in 'SELECT']
SELECT
MIN(CAST(wc.length AS DECIMAL(10,2))) as min_length,
MAX(CAST(wc.length AS DECIMAL(10,2))) as max_length,
MIN(CAST(wc.width AS DECIMAL(10,2))) as min_width,
MAX(CAST(wc.width AS DECIMAL(10,2))) as max_width,
MIN(CAST(wc.height AS DECIMAL(10,2))) as min_height,
MAX(CAST(wc.height AS DECIMAL(10,2))) as max_height
FROM wp_wc_product_meta_lookup wc
WHERE wc.product_id NOT IN (
SELECT tr3.object_id
FROM wp_term_relationships tr3
INNER JOIN wp_term_taxonomy tt3 ON tr3.term_taxonomy_id = tt3.term_taxonomy_id
WHERE tt3.term_id = 9
)
AND wc.product_id IN (
SELECT tr.object_id
FROM wp_term_relationships tr
INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.term_id = 2093
)
-
111920868 Frigidaire Lower Wash Arm
$40.31 -
3720A20710A LG Control Panel
$20.67 -
3831A20145E LG Air Conditioner Escutcheon
$20.78 -
4681A20169B LG Indoor DC Motor Assembly
$385.12 -
4974AR3262S LG Air Conditioner Guide
$14.17 -
5040A30027A LG Damper
$2.66 -
5230A20064B LG Air Filter
$8.38 -
5230A20069B LG Air Filter
$14.17 -
5231AR6159G LG Air Conditioner Filter Assembly
$14.17 -
5300A20003V LG Air Conditioner Electric Heater
$87.92 -
5304464991 Frigidaire Side Panel Set
$15.01 -
5304476180 Frigidaire Power Cord Air Conditioner
$127.32












