Kloss Furniture Store & Mattress 1st - Shop Furniture Locally In Illinois
Kloss Furniture and Mattress Tagline
Phone Icon Store Icon
O'Fallon (618) 628-2802
Highland (618) 654-7433

Welcome to

Welcome to Kloss Furniture and Mattress


Get updates on our latest styles & savings!

Coupon-Overlay


We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

Bassett

Narrow By

Availability

Store Location

Category

Features

Collection

Style

2,057 Items
(SELECT f.u_id, 
									f.id,
									IF(f.display_title = '', f.title, f.display_title) AS title, 
									IF(f.retail_sku = '', f.brand_sku, f.retail_sku) AS public_sku, 
									IF(f.on_display = '1', '1', '0') AS available,						
									f.page,
									f.display_price AS price,
									f.sale_price AS sale_price,
									f.sale_price_start AS sale_price_start,
									f.sale_price_end AS sale_price_end,
									f.msrp_price AS msrpPrice,
									f.ecommerce_enabled_item AS ecommerce_enabled,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title,
									IF(sb.display_title='', sb.title, sb.display_title) AS sbtitle,
									fb.title AS origTitle,
									fb.hide_brand_name AS hideAbrand,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order
								FROM furniture AS f
								JOIN knorrweb_NEWcatalog.furniture AS mf ON ((f.u_id = mf.u_id AND f.on_display='0' AND mf.active='1' AND mf.expired='0') OR (f.u_id = mf.u_id AND f.on_display='1'))
								JOIN furniture_brands AS fb ON f.brand_u_id = fb.u_id
								LEFT JOIN furniture_brands sb ON f.sub_brand_u_id=sb.u_id
								JOIN furniture_categories AS fc ON f.category_u_id = fc.u_id
								JOIN furniture_categories AS fsc ON f.sub_category_u_id = fsc.u_id
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fb.u_id='69FN75XZ43EQB4AI46J6E' AND fc.active='1' AND fsc.active='1'
								        
								 AND ((f.u_id NOT IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages)) OR (f.u_id IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages WHERE hide='0'))) 
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
Bassett
$1,209.99
43% OFF
$689.99

See it at: O'Fallon

Bassett
$4,149.99
43% OFF
$2,369.99

See it at: O'Fallon

Bassett
$6,879.99
43% OFF
$3,919.99

See it at: O'Fallon

Bassett
$4,979.99
43% OFF
$2,839.99

See it at: O'Fallon

Bassett
$1,309.99
43% OFF
$749.99

See it at: O'Fallon, Highland

Bassett
$1,429.99
43% OFF
$819.99

See it at: O'Fallon

Bassett
$2,259.99
43% OFF
$1,289.99

See it at: O'Fallon

Bassett
$719.99
43% OFF
$409.99

See it at: O'Fallon

Bassett
$829.99
42% OFF
$479.99

See it at: O'Fallon

Bassett
$2,849.99
43% OFF
$1,629.99

See it at: O'Fallon

Bassett
$4,499.99
43% OFF
$2,569.99

See it at: O'Fallon

Bassett
$809.99
43% OFF
$459.99

See it at: O'Fallon

Bassett
$2,699.99
43% OFF
$1,539.99

See it at: O'Fallon, Highland

Bassett
$689.99
42% OFF
$399.99

See it at: O'Fallon

Bassett
$949.99
42% OFF
$549.99

See it at: O'Fallon

Bassett
$1,069.99
43% OFF
$609.99

See it at: O'Fallon, Highland

Bassett
$2,129.99
43% OFF
$1,219.99

See it at: O'Fallon, Highland

Bassett
$1,419.99
43% OFF
$809.99

See it at: O'Fallon

Bassett
$1,569.99
43% OFF
$899.99

See it at: O'Fallon

Bassett
$3,469.99
43% OFF
$1,979.99

See it at: O'Fallon, Highland

Bassett
$1,519.99
43% OFF
$869.99

See it at: O'Fallon

Bassett
$1,499.99
43% OFF
$859.99

See it at: O'Fallon, Highland

Bassett
$2,089.99
43% OFF
$1,189.99

See it at: O'Fallon

Bassett
$1,549.99
43% OFF
$879.99

See it at: O'Fallon

Bassett
$4,059.99
43% OFF
$2,309.99

See it at: O'Fallon

Bassett
$2,259.99
43% OFF
$1,289.99

See it at: O'Fallon

Bassett
$3,319.99
43% OFF
$1,899.99

See it at: O'Fallon

Bassett
$1,739.99
43% OFF
$989.99

See it at: O'Fallon

Bassett
$3,789.99
43% OFF
$2,159.99

See it at: O'Fallon

Bassett
$3,789.99
43% OFF
$2,159.99

See it at: O'Fallon

Bassett
$1,429.99
43% OFF
$819.99

See it at: O'Fallon

Bassett
$2,109.99
43% OFF
$1,209.99

See it at: O'Fallon

Bassett
$1,209.99
43% OFF
$689.99

See it at: O'Fallon

Bassett
$4,599.99
43% OFF
$2,619.99

See it at: O'Fallon

Bassett
$2,369.99
43% OFF
$1,349.99

See it at: O'Fallon

Bassett
$1,419.99
43% OFF
$809.99

See it at: O'Fallon

Bassett
$1,449.99
43% OFF
$829.99

See it at: O'Fallon

Bassett
$1,739.99
43% OFF
$989.99

See it at: O'Fallon

Bassett
$1,589.99
43% OFF
$909.99

See it at: O'Fallon

Bassett
$2,399.99
43% OFF
$1,369.99

See it at: O'Fallon

Bassett
$4,479.99
43% OFF
$2,559.99

See it at: O'Fallon

Bassett
$7,349.99
43% OFF
$4,189.99

See it at: O'Fallon

Bassett
$1,229.99
43% OFF
$699.99

See it at: O'Fallon, Highland

Bassett
$1,739.99
43% OFF
$989.99

See it at: O'Fallon

Bassett

See it at: O'Fallon

Bassett
$2,449.99
43% OFF
$1,399.99

See it at: O'Fallon

Bassett
$1,119.99
43% OFF
$639.99

See it at: O'Fallon

Bassett
$1,279.99
43% OFF
$729.99

See it at: O'Fallon

Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Bassett