"An Authorized Dreamaire Business Partner"

Home » Catalog » ***IN STOCK SPECIAL***

My Account  |  Cart Contents  |  Checkout

Choose Your Comfort ***IN STOCK SPECIAL*** Dreamaire    Celesta Digital 10K    Celenia Digtial 7001    Cerulean 5001    Cerenity 4001    Cirrus 3001 Sleep Accessories    Air Pillow    Bed Frames Information Freq. Asked Questions Financing Options 90 Day Trial Period Contact Us Which mattress is right for me? What is a Dreamaire? Dreamaire vs. Select                        Comfort

***IN STOCK SPECIAL*** Displaying 1 to 1 (of 1 products) Result Pages:  1  1064 - 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 'limit 0, 50' at line 1 select pd.products_name, p.products_artist, p.products_collection, p.products_id, p.hide_item, p.manufacturers_id, p.products_sort_order, p.products_list_price, p.products_show_price_cart, p.products_artist, p.products_collection, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, categories c , products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id=p2c.categories_id and c.categories_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1108' and find_in_set('0', products_hide_from_groups) = 0 order by limit 0, 50 [TEP STOP]