Northern Mattress & Furniture - Furniture & Mattresses in Central Maine

Augusta: (207) 620-8293 | Skowhegan: (207) 858-4258 | Waterville: (207) 877-7383

Phone Icon
NORTHERN MATTRESS & FURNITURE Tagline

Welcome to

Welcome to NORTHERN MATTRESS & FURNITURE

Get updates on our latest styles & savings!

Coupon-Overlay

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

No Thanks

Loveseats

3 Day Tent Sale
Amish Works

Narrow By

Features

Brand

Design 2 Recline
Serta Upholstery
HomeStretch
Decor-Rest Furniture Ltd.
Simple Elegance
Man Wah (USA), Inc.

Collection

Carolina Preserves Upholstery
DISTINCTIONS
ESSENTIALS
Klaussner

Style

Casual
Contemporary
Transitional
126 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,
									fsc.folder AS sc_f,
									'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 AND fc.active='1')
								JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
								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 fsc.u_id LIKE 'Q8JLZSPK7OAVLDKJSRR8E'
								          
								 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, 15
Click Here To Load More Items
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Loveseats

Loveseats are perfect for areas with less width for seating. You can get matching sofas and loveseats or mix-and-match any style. Loveseats are available in leather, microfiber, suede and fabric and can be stationary, reclining or even auto-reclining!

 

View Our Latest Ad Protection 1st Start Your Wishlist
X Close

  • Call Northern Mattress Augusta: (207) 620-8293
  • Call Northern Mattress Skowhegan: (207) 858-4258
  • Call Northern Mattress Waterville: (207) 877-7383