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

Traeger Grills

Arrange By

Narrow By

Category

Features

Width

Height

Depth

21 Items
SELECT 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,						
									f.page,
									f.display_price,
									f.msrp_price,
									f.sale_price,
									f.sale_price_start,
									f.sale_price_end,
									IF(ab.display_title = '', ab.title, ab.display_title) AS b_title, 
									ac.folder AS c_f,
									a_sc.folder AS sc_f,
									'appliances/' AS catalog_folder,
									'appliance' AS rtable
								FROM appliance AS f
								JOIN knorrweb_NEWcatalog.appliance AS ma ON f.u_id = ma.u_id AND ma.active='1' AND ma.expired='0'
								JOIN appliance_brands AS ab ON f.brand_u_id = ab.u_id AND ab.u_id='DNRYSPN7PWSJMZ3OZZQWY'
								JOIN appliance_categories AS ac ON f.category_u_id = ac.u_id AND ac.active='1'
								JOIN appliance_categories AS a_sc ON f.sub_category_u_id = a_sc.u_id AND a_sc.active='1'
								WHERE f.active='1' AND f.expired='0' 
								      	 						
								ORDER BY f.display_price = 0.00, display_price ASC, b_title ASC, title ASC
								LIMIT 0, 48
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Traeger Grills
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

Traeger Grills