Critelli's Furniture & Mattress and Transitions Furniture in St. Catharines, Ontario, Canada
126 King Street, St. Catharines
Ontario, Canada
(877) 322-1172
(905) 684-8108

Mon. - Sat. 10am to 6pm
Fri. 10am to 8pm - Sun Closed

Welcome to

Welcome to Critellis Furniture


Sign up for all the latest styles and offers and get a $100 Coupon off any purchase of $999 or more today!

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

No Thanks

Beds

Narrow By

Availability

Store Location

Bed Size

Features

Upholstery

Brand

Collection

Style

827 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,
									f.brand_display_priority
								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 AND fc.active='1')
								JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
								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 fsc.u_id LIKE 'V5YSPAYVC8X47YV6W3E47'
								          
								 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.brand_display_priority = 0, f.brand_display_priority ASC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
								LIMIT 0, 15
BED
American Leather

See it at: Transitions Furniture

ALF Italia

See it at: Transitions Furniture

Huppe

See it at: Critelli's Furniture

Huppe

See it at: Critelli's Furniture

Harden Furniture

See it at: Critelli's Furniture

Harden Furniture

See it at: Critelli's Furniture

Precedent

See it at: Transitions Furniture

Precedent

See it at: Transitions Furniture

Precedent

See it at: Transitions Furniture

Precedent

See it at: Transitions Furniture

Stickley

See it at: Critelli's Furniture

Stickley

See it at: Critelli's Furniture

Stickley

See it at: Critelli's Furniture

West Bros

See it at: Critelli's Furniture

West Bros

See it at: Critelli's Furniture

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

Beds

Your Bed is the center piece of your bedroom furniture, and will distinguish your style from the moment you enter the room. Beds come in all different styles from contemporary, transitional, traditional or casual. Choose from sleigh beds, different styles of headboards, footboards, and platform beds to make your Bedroom your dream room.