King

17 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.ecommerce_enabled_item AS ecommerce_enabled,
							 f.collection_id,
							 'mattresses/' AS catalog_folder,
							 'mattresses' AS rtable, 
							 f.in_stock,
							 f.on_display,
							 f.display_order,
							 f.comfort_title,
							 
							 f.materials_title
					  FROM mattresses AS f
					  
					  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.king='1')   
					  ORDER BY f.on_display DESC, f.display_order = 0, f.display_order ASC, available DESC, b_title ASC, title ASC
					  LIMIT 0, 16

iComfort Blue 300...

iComfort by Serta

Comfort Level

Firm

Sizes Available

Full, Queen, King

See in Store

King Sets

$2,199.95

iComfort Blue 300...

iComfort by Serta

Comfort Level

Soft

Sizes Available

Queen, King

See in Store

King Sets

$3,299.95

iComfort Blue Max...

iComfort by Serta

Comfort Level

Medium

Sizes Available

Queen, King

See in Store

King Sets

$2,599.95

Gracelyn Plush

Mattress 1st

Comfort Level

Soft

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,199.95

Gracelyn Super Pi...

Mattress 1st

Comfort Level

Soft

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,199.95

Apollo Firm

Restonic » ComfortCare

Comfort Level

Firm

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,599.95

Apollo Plush

Restonic » ComfortCare

Comfort Level

Soft

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,599.95

Apollo Ultra Euro...

Restonic » ComfortCare

Comfort Level

Soft

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,999.95

Ascot Euro Top

Restonic » ComfortCare

Comfort Level

Medium

Sizes Available

Twin, Full, Queen, King

See in Store

King Sets

$1,099.95

Motion Essentials...

Serta » Adjustable Foundations

Sizes Available

TwinXL, Full, Queen, King

See in Store

King Sets

$1,199.95

Motion Perfect III

Serta Perfect Sleeper

Sizes Available

TwinXL, Full, Queen, King

Adjustable Base

$2,299.00

Tempur-Cloud Supreme

Tempur-Pedic » Tempur-Pedic

Comfort Level

Soft

Construction Materials

Memory Foam

Sizes Available

Twin, TwinXL, Full, Queen, King, California King

King Sets

$3,599.00

Tempur-Cloud Supr...

Tempur-Pedic » Special Solutions

Comfort Level

Soft

Sizes Available

TwinXL, Full, Queen, King, California King

King Sets

$4,599.00

Tempur-Contour El...

Tempur-Pedic » TEMPUR-Contour

Comfort Level

Firm

Construction Materials

Memory Foam

Sizes Available

TwinXL, Queen, King, California King

King Sets

$5,099.00

Tempur-Contour Rh...

Tempur-Pedic » TEMPUR-Contour

Comfort Level

Firm

Construction Materials

Memory Foam

Sizes Available

TwinXL, Queen, King, California King

King Sets

$4,599.00

Tempur-Flex Elite

Tempur-Pedic » Tempur-Flex

Comfort Level

Soft

Construction Materials

Memory Foam, Innerspring

Sizes Available

TwinXL, Full, Queen, King, California King

King Sets

$4,399.00