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
»
»
Shop All Mattresses

Shop All Mattresses

 

Arrange By

Narrow By

Availability

Brands

Collections

Comfort

Type

Size

Magniflex Remove Sort Item
16 Items
SELECT f.id, 
							 f.u_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, 
							 fb.u_id AS brand_u_id,
							 IF(fb.display_title='', fb.title, fb.display_title) AS b_title,
							 f.brand_u_id,
							 f.page,
							 f.twin,
							 f.twin_price,
							 f.twin_set_price,
							 f.twinxl,
							 f.twinxl_price,
							 f.twinxl_set_price,
							 f.full,
							 f.full_price,
							 f.full_set_price,
							 f.queen,
							 f.queen_price,
							 f.queen_set_price,
							 f.king,
							 f.king_price,
							 f.king_set_price,
							 f.california,
							 f.california_price,
							 f.california_set_price,
							 f.collection_id,
							 'mattresses/' AS catalog_folder,
							 'mattresses' AS rtable, 
							 f.in_stock,
							 f.on_display,
							 f.display_order,
							 f.comfort_title,
							 mf.map_item,
									   mf.isFoundation,
							 f.materials_title
					  FROM mattresses AS f
					  JOIN knorrweb_NEWcatalog.mattresses 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 mattress_brands AS fb ON f.brand_u_id=fb.u_id
					  WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0'  AND (f.brand_u_id='RGQQ4Q3XWT7N3MIZJXPEN')      
					  ORDER BY f.on_display DESC, f.display_order = 0, f.display_order ASC, available DESC, b_title ASC, title ASC
					  LIMIT 0, 16
Comfort Dual 10 Image
Magniflex
Magniflex » Dolce Vita
Comfort Level
Firm
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,299.00
Comfort Dual Deluxe 12 Image
Magniflex
Magniflex » Dolce Vita
Comfort Level
Soft
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,499.00
DIAMANTE DUAL 14 Image
Magniflex
Magniflex » Supremo
Comfort Level
Medium
Construction Materials
Memory Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$3,999.00
Dolce Vita Comfort 9 Image
Magniflex
Magniflex » Dolce Vita
Comfort Level
Medium
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,999.00
Magni 10 Image
Magniflex
Magniflex » Classico
Comfort Level
Medium
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,599.00
Magni 12 Image
Magniflex
Magniflex » Classico
Comfort Level
Medium
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,799.00
Magni 9 Image
Magniflex
Magniflex » Classico
Comfort Level
Firm
Construction Materials
Memory Foam, Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,399.00
MAGNIGEL DELUXE DUAL 12 Image
Magniflex
Magniflex » Magnigel
Comfort Level
Soft
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,699.00
MAGNIGEL DUAL 10 Image
Magniflex
Magniflex » Magnigel
Comfort Level
Medium
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,299.00
MAGNIGEL DUAL 9 FIRM Image
Magniflex
Magniflex » Magnigel
Comfort Level
Firm
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,999.00
Magnistretch  12 Image
Magniflex
Magniflex » Magnistretch
Construction Materials
Memory Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,999.00
Magnistretch 10 Image
Magniflex
Magniflex » Magnistretch
Comfort Level
Soft
Construction Materials
Memory Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,599.00
Supremo 12
Magniflex
Magniflex » Supremo
Comfort Level
Soft
Construction Materials
Memory Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$3,699.00
Toscana 10 Image
Magniflex
Magniflex » Toscana
Comfort Level
Firm
Construction Materials
Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$2,699.00
Toscana 8 Image
Magniflex
Magniflex » Toscana
Comfort Level
Soft
Construction Materials
Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,799.00
Toscana 9 Image
Magniflex
Magniflex » Toscana
Comfort Level
Medium
Construction Materials
Foam
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Queen Sets
$1,999.00
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button
Back To Top Button
Powered By KnorrWeb