.SW-1C COUNTERTOP WATER FILTER SYSTEM (CLEAR HOUSING) [SW1C]

$40.00

* SW-1C, COUNTERTOP WATER FILTER SYSTEM (CLEAR HOUSING) --- WHITE HOUSING SYSTEM IS AN OPTION -- NICE LOOKING --

* Next generation of the discontinued Honeywell countertop CT-6000, with better accessories and better performance

* Filter inside can be replaced, replacement filter # RF62 or # 208

* Includes filter wrench, long flexible tube, faucet spigot

* Color: Clear Housing

* Size: Medium 4.25" x 14"

* Service capacity: 650 gallon (99%) or 8 month (depends on water condition)

* NSF test standard 42 and NSF standard 53, ASTM method 180.1

* Easy installation: connect to kitchen faucet

* Easy filter replacement

* Removes: Lead, Iron, heavy metal

* 0.5 micron filtration rating

* Removes Protozoan Cysts-Cryptosporidia, and Giardia, 99.99%

* Removes VOC, volatile organic chemicals, 98.8%

* Removes chlorine, 99%

* Improves Taste, eliminate odors, and reduces Chlorine

* Great for drinking water, coffee & tea, Fruit juice concentrate, soup, and making ice cubes

* Filter Housings should be replaced every 5 years as part of maintenance routine to prevent leakage or crack due to material wear.

Reviews

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ktinfosoft_osc_old.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '125' and opa.orders_id = opb.orders_id and opb.products_id != '125' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]