Filter Your Results menu

Filters Clear All

 

Search Results Hybrid

<<1 2 >>

TEMPUR-Adapt® Collection - TEMPUR-Adapt® Medium Hybrid - Cal King

Store Specials

Features

  • 3cm TEMPUR-ES®: The tighter, slightly rougher cell structure see more... of TEMPUR-ES® creates a softer feel that works in combination with other layers to support and relax. ...see less
  • 5cm Original TEMPUR®: Originally formulated to absorb the see more... G-Force of NASA astronauts travelling into space and then perfected by us for sleepers-it's as comfortable and supportive as it is iconic. ...see less
  • Hybrid Technology: 1000+ premium spring coils designed in-house see more... to work with our proprietary material - made for easier movement. ...see less
  • Cool-To-Touch Cover: Premium knit technology for superior cool-to-touch see more... feel. Crafted from ultra-high molecular weight yarn it moves heat away from your body. ...see less
  • 11" Height
California King$3149.99
  • Twin $1949.99
  • Twin XL $1949.99
  • Full $2299.99
  • Queen $2449.99
  • King $3149.99
  • California King $3149.99
  • Split California King $1949.99

Starting at

$ 3,149.99 

Cloverland Hybrid Cushion Firm

Store Specials

Features

  • Mattress height is 14 inches
  • Luxury hybrid construction for the perfect balance of see more... support and pressure relief ...see less
  • Soft, Fresh Comfort Quilt faced with cooling gel see more... fibers on the surface of the mattress maintains ideal body temperature throughout the night. ...see less
  • Nestled at the surface of the mattress, ultra see more... plush SoyPur foam is made with natural soy and offers a cozy comfort layer that eliminates pressure points. ...see less
  • Motion Separation Foam: Our coil system is embedded see more... with Motion Separation Foam, which runs the length of the mattress, from head to toe. This durable, undetectable divider decreases motion transfer and partner disturbance. ...see less
California King$2299.99
  • Twin $1699.99
  • Twin XL $1779.99
  • Full $1779.99
  • Queen $1799.99
  • King $2299.99
  • California King $2299.99
SAVE $100.00 Was $2399.99

Starting at

$ 2,299.99 

Beautyrest - Harmony Lux Hybrid - Empress Series - Medium - Full

Store Specials

Features

  • PRECISION SUPPORT SYSTEM™ - Powered by T2 Pocketed see more... Coil® Technology ...see less
  • COOL, COMFORTABLE SLEEP - Infinicool® Plus Technology
  • CONSISTENT PRESSURE RELIEF - Beautyrest® Gel Memory Foam see more... GelTouch® Foam ...see less
  • SUSTAINABLE COMFORT - Seaqual™ Fabric Technology
SELECT p.id, p.cSlug, p.SKU, IF(p.StandardColor = 'Other',CONCAT(UCASE(SUBSTRING(p.ColorDescription, 1, 1)),LCASE(SUBSTRING(p.ColorDescription, 2))),IF(p.StandardColor = 'SPLITKING', 'Split King',p.StandardColor)) AS ModelColor, mp.MSRP, mp.Sale, mp.Available, mp.Featured, IF((mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.Sale, mp.Sale))) AS calcPrice, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '0.00') AS RegPrice, mp.OutletPrice, mp.outlet, mp.on_line, mp.in_store, mp.closeout, mp.quick_ship, mp.PowerBuy, (mp.MSRP - mp.Sale) AS Discount, IF(bd.MAP = 1 OR p.is_package = 1, 1, .90) AS MapDiscount, mp.in_stock, mp.free_shipping, p.Sale AS MinTargetPrice, p.RootModelNumber, mp.FreeShip, bd.UMRP, (SELECT COUNT(pbm.pkID) FROM PromotionsByModel AS pbm INNER JOIN Rebates ON (Rebates.PromotionName = pbm.PromotionName AND Rebates.FileName <> '') WHERE pbm.pkProduct = p.pkID AND pbm.EffectiveDate <= CURDATE() AND pbm.ExpirationDate > CURDATE() GROUP BY pbm.pkProduct) AS rwsPromotion, (SELECT COUNT(rbm.pkID) FROM rebatesbymodel AS rbm INNER JOIN Rebates AS r ON r.pkID = rbm.pkRebates WHERE rbm.pkProduct = p.pkID AND r.ExpirationDate > CURDATE() AND r.EffectiveDate < CURDATE() GROUP BY rbm.PromotionName) AS rwsRebates, (p.Sale * (IF(bd.MAP = 1 OR p.is_package = 1, 1,.90))) AS MAP, c.ConsumerDescription AS cDescription, IF(bd.no_cart =1 OR mp.on_line = 0,1,0) AS no_cart, (SELECT COUNT(*) FROM tbl_products WHERE RootModelNumber = p.RootModelNumber) AS sizeCount FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN (SELECT tbl_products.* FROM tbl_products INNER JOIN tbl_store_brands ON tbl_store_brands.brandID = tbl_products.pkBrand AND tbl_store_brands.categoryID = tbl_products.pkCategory ORDER BY FIELD( lower( StandardColor ), 'queen', 'standard', 'twin', 'twin xl', 'Full', 'full xl', 'splitqueen', 'king', 'splitking', 'split king', 'dividedking', 'divided king', 'cal king', 'california king', 'split cal king', 'split california king' )) AS p ON (p.cSlug = c.slug AND p.cgSlug = cg.slug AND p.mhSlug = mh.slug) INNER JOIN Brand_Data AS bd ON (bd.pkID = p.pkBrand) INNER JOIN tbl_store_brands AS sb ON (sb.brandID = bd.pkID AND sb.categoryID = c.pkID) INNER JOIN tbl_fulltextsearch AS fsearch ON (fsearch.SKU = p.SKU ) INNER JOIN ModelPrice AS mp ON (mp.pkProduct = p.pkID AND mp.SKU = p.SKU AND mp.Available = 1 ) WHERE p.BaseModel IN (SELECT BaseModel FROM tbl_products WHERE SKU=?) AND (((((`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?)))((`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?))) and (((`p`.`cSlug` = ? OR `p`.`cSlug` = ? OR `p`.`cSlug` = ?)))) ORDER BY FIELD(p.StandardColor, "Twin", "Twin XL", "Full", "Full XL", "Queen", "SPLITQUEEN", "King", "SPLITKING", "California King", "Split California King"), mp.Sale ASC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '((`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?) OR (`p`.`cSlug` = ?))) and (((`p`.`cSlu' at line 5