Model Not Found

We're sorry, but there is no page in the Snooze Mattress Co. Web Site that matches your request for https://snoozemattresscompany.com/products/Malouf/mouf/ma90stchpc.html/. It is possible you typed the address incorrectly, or that the page no longer exists.

You can try searching for this model by clicking the search button below.

Search our Site for model number: ma90stchpc

Reporting broken links

If you believe the link you tried is broken, we want to know about it. Please contact us via our contact page.

SELECT (SELECT GROUP_CONCAT(DISTINCT StandardColor,',',tbl_products.SKU,',',CONCAT( UCASE( SUBSTRING( ColorDescription, 1, 1 )), LCASE( SUBSTRING( ColorDescription, 2 )), ',', IF((ModelPrice.Sale = 0),ModelPrice.MSRP,IF((ModelPrice.MSRP = 0),ModelPrice.Sale,IF((ModelPrice.Sale > ModelPrice.MSRP), ModelPrice.MSRP, ModelPrice.Sale ))), ',', IF((ModelPrice.MSRP > 0 AND ModelPrice.MSRP > ModelPrice.Sale), ModelPrice.MSRP, '0.00')) ORDER BY FIELD( StandardColor, 'Queen', 'Twin', 'Twin XL', 'Full', 'Full XL', 'California King', 'King', 'SplitKing', 'Split California King' ) SEPARATOR '|' ) FROM tbl_products INNER JOIN ModelPrice ON (tbl_products.pkID = ModelPrice.pkProduct AND tbl_products.SKU = ModelPrice.SKU AND ModelPrice.Available = 1) WHERE tbl_products.RootModelNumber = p.RootModelNumber AND tbl_products.pkBrand = p.pkBrand) AS AvailableColors, p.mhDescription, p.mhSlug, p.cgDescription, p.cgSlug, p.CatDescription, p.cSlug, IF(p.thumb LIKE 'http%%',p.thumb,concat( 'https://snoozemattresscompany.com/uploads/products/', p.thumb )) AS thumbImage, IF(p.large LIKE 'http%%',p.large, concat( 'https://snoozemattresscompany.com/uploads/products/', p.large )) AS largeImage, p.SKU, p.ModelStatus, p.ModelDescription, p.pkID, p.pkSKU, p.pkCategory, p.id, IF(p.CommonBrandName = 'LG Appliances','LG',p.CommonBrandName) AS RevisedBrandName, p.CommonBrandName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5, p.ProductKey, bd.CommonBrandID, IF(p.StandardColor = 'Other',CONCAT(UCASE(SUBSTRING(p.ColorDescription, 1, 1)),LCASE(SUBSTRING(p.ColorDescription, 2))),p.StandardColor) AS ModelColor, mp.MSRP, mp.Sale, mp.Available, mp.Featured, IF((mp.outlet = 1 AND 'ma90stchpc' = 'outlet'), mp.OutletPrice, IF((mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale)))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '0.00') AS RegPrice, mp.OutletPrice, mp.PromoPrice, mp.start_date, mp.end_date, mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message, (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, mp.specials, mp.closeout, 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, p.ExpandedDescription, p.specifications, (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 > NOW() AND r.EffectiveDate < NOW() GROUP BY rbm.PromotionName) AS rwsRebates, (p.Sale * (IF(bd.MAP = 1 OR p.is_package = 1, 1,.90))) AS MAP, mh.super_category, IF(bd.no_cart =1 OR mp.on_line = 0,1,0) AS no_cart, mp.in_store, IF((mp.Sale = 0), mp.MSRP, IF ((mp.MSRP = 0 ), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS calcPrice, c.ConsumerDescription AS cDescription FROM tbl_products AS p INNER JOIN Brand_Data AS bd ON (p.pkBrand = bd.pkID) INNER JOIN ModelPrice AS mp ON (mp.pkProduct = p.pkID AND mp.SKU = p.SKU AND mp.Available = 1) INNER JOIN menu_heading AS mh ON (mh.slug = p.mhSlug) INNER JOIN Categories AS c ON (p.cSlug = c.slug) WHERE p.cgSlug = 'products' AND p.cSlug = 'malouf' AND p.SKU = 'mouf' LIMIT 1
Array
(
    [0] => products
    [1] => Malouf
    [2] => mouf
    [3] => ma90stchpc
)
Array
(
    [0] => adjustable-bases
    [1] => chairs
    [2] => sectionals
    [3] => sofas
    [4] => tables
)
Contact Us

Contact Us

We’d love to hear from you! Contact us today to get in touch with our team.