Save $100 when you sign up for emails

Enter your email below and receive a coupon for $100 off your next purchase of $1299 or more! Plus, you will receive email exclusive coupons, special offers and more from Critelli's Furniture!

Sign Up »
No Thanks

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

Critelli's Furniture & Mattress in St. Catharines, Ontario, Canada
|
|
|
(877) 322-1172 • (905) 684-8108
Unlimited Possibilities, Unbeatable Values
Living Room
Bedroom
Dining Room
Entertainment
Home Office
Accessories
Rugs
Mattresses
»
CTH Sherrill Occasional

CTH Sherrill Occasional

 

Narrow By

Category

Features

370 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,
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order
								FROM furniture AS f USE INDEX(u_id)
								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
								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='8TL5N88I3ORV3NC8X6JUP' AND fc.active='1' AND fsc.active='1'
								        
								GROUP BY u_id)
								UNION
								(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, 
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture_ashley' AS rtable,
									f.display_order
								FROM furniture_ashley AS f USE INDEX(u_id)
								JOIN furniture_brands AS fb ON f.brand_u_id = fb.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.images > 0 AND f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fb.u_id='8TL5N88I3ORV3NC8X6JUP' AND fc.active='1' AND fsc.active='1'
								       
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, display_order = 0, display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
CTH Sherrill Occasional
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button
Powered By KnorrWeb
Back To Top Button