Riley's Furniture & Mattress - Shop Furniture Locally in Monroe Ohio
Riley's Furniture & Mattress Tagline
Phone Icon
 Hours: Mon-Fri: 10am - 9pm | Sat: 10am - 6pm | Sun: Closed

Welcome to

Welcome to Riley's Furniture & Mattress


Get updates on our latest styles & savings!

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

Shop All Bedroom

Narrow By

Availability

Category

Features

Brand

Style

6,839 Items
(SELECT f.u_id, 
									f.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,						
									f.page,
									f.display_price AS price,
									f.sale_price AS sale_price,
									f.sale_price_start AS sale_price_start,
									f.sale_price_end AS sale_price_end,
									f.msrp_price AS msrpPrice,
									f.ecommerce_enabled_item AS ecommerce_enabled,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title, 
									IF(sb.display_title='', sb.title, sb.display_title) AS sbtitle,
									fb.title AS origTitle,
									fb.hide_brand_name AS hideAbrand,
									fc.folder AS c_f,
									f.sub_category_u_id,
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order,
									f.brand_display_priority
								FROM furniture AS f
								JOIN knorrweb_NEWcatalog.furniture 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 furniture_brands AS fb ON f.brand_u_id = fb.u_id
								LEFT JOIN furniture_brands sb ON f.sub_brand_u_id=sb.u_id
								JOIN furniture_categories AS fc ON f.category_u_id = fc.u_id
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fc.active = 1 AND fc.u_id LIKE 'QXGJJYNB7868OBOROA949'
								          
								 AND ((f.u_id NOT IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages)) OR (f.u_id IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages WHERE hide='0'))) 
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, f.brand_display_priority = 0, f.brand_display_priority ASC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
American Drew
$4,619.99
41% OFF
$2,713.99
TEST

See in Store

American Drew
$5,739.99
43% OFF
$3,300.49
TEST

See in Store

American Drew
$1,979.99
45% OFF
$1,092.49
TEST

See in Store

American Drew
$1,649.99
41% OFF
$977.49
TEST

See in Store

Ashley Furniture
$229.99
40% OFF
$137.99
TEST

See in Store

Ashley Furniture
$339.99
43% OFF
$195.49
TEST

See in Store

Ashley Furniture
$299.99
43% OFF
$172.49
TEST

See in Store

Ashley Furniture
$269.99
40% OFF
$160.99
TEST

See in Store

Ashley Furniture
$319.99
35% OFF
$206.99
TEST

See in Store

Ashley Furniture
$219.99
43% OFF
$126.49
TEST

See in Store

Ashley Furniture
$229.99
35% OFF
$149.49
TEST

See in Store

Signature Design by Ashley
$509.99
37% OFF
$321.99
TEST

See in Store

Signature Design by Ashley
$469.99
39% OFF
$287.49
TEST

See in Store

Signature Design by Ashley
$569.99
33% OFF
$379.49
TEST

See in Store

Ashley Furniture
$429.99
41% OFF
$252.99
TEST

See in Store

Aspen Home
$3,059.99
40% OFF
$1,839.99
TEST

See in Store

Coast To Coast
$669.99
26% OFF
$494.49
TEST

See in Store

Coast To Coast
$1,029.99
36% OFF
$655.49
TEST

See in Store

Daniel's Amish Collection
$2,409.99
41% OFF
$1,414.49
TEST

See in Store

Daniel's Amish Collection
$2,769.99
40% OFF
$1,667.49
TEST

See in Store

Daniel's Amish Collection
$2,889.99
42% OFF
$1,678.99
TEST

See in Store

Daniel's Amish Collection
$3,129.99
41% OFF
$1,839.99
TEST

See in Store

Daniel's Amish Collection
$3,359.99
42% OFF
$1,954.99
TEST

See in Store

Daniel's Amish Collection
$3,389.99
42% OFF
$1,954.99
TEST

See in Store

Daniel's Amish Collection
$1,579.99
42% OFF
$919.99
TEST

See in Store

Daniel's Amish Collection
$1,409.99
43% OFF
$804.99
TEST

See in Store

Daniel's Amish Collection
$1,369.99
41% OFF
$804.99
TEST

See in Store

Daniel's Amish Collection
$829.99
42% OFF
$482.99
TEST

See in Store

Daniel's Amish Collection
$879.99
41% OFF
$517.49
TEST

See in Store

Hillsdale Furniture
$999.99
43% OFF
$574.99
TEST

See in Store

Hillsdale Furniture
$1,179.99
37% OFF
$747.49
TEST

See in Store

Hillsdale Furniture
$1,139.99
39% OFF
$689.99
TEST

See in Store

Hillsdale Furniture
$854.96
39% OFF
$517.49
TEST

See in Store

Hillsdale Furniture
$529.99
46% OFF
$287.49
TEST

See in Store

Kincaid Furniture
$539.99
25% OFF
$402.49
TEST

See in Store

Kincaid Furniture
$3,079.99
44% OFF
$1,724.99
TEST

See in Store

Liberty Furniture
$819.99
40% OFF
$494.49
TEST

See in Store

Liberty Furniture
$4,829.99
40% OFF
$2,874.99
TEST

See in Store

Liberty Furniture
$1,449.99
41% OFF
$862.49
TEST

See in Store

Liberty Furniture
$1,424.96
39% OFF
$862.49
TEST

See in Store

Liberty Furniture
$4,049.99
38% OFF
$2,529.99
TEST

See in Store

Magnussen Home
$2,809.99
40% OFF
$1,690.49
TEST

See in Store

Magnussen Home
$2,374.96
39% OFF
$1,437.49
TEST

See in Store

Stein World
$609.99
34% OFF
$402.49
TEST

See in Store

Stein World
$1,199.99
38% OFF
$747.49
TEST

See in Store

Stein World
$1,219.99
40% OFF
$735.99
TEST

See in Store

Stein World
$1,009.99
43% OFF
$574.99
TEST

See in Store

Stein World
$1,569.99
41% OFF
$919.99
TEST

See in Store

Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button