Turner's Budget Furniture & Mattress Albany, Tifton, Moultrie, Valdosta, Thomasville/Tallhassee | Turner's Fine Furniture »
Turner's Budget Furniture Tagline
Phone Icon

Welcome to

Welcome to Turner's Budget Furniture


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 Dining Room

Narrow By

Availability

Category

Features

45 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 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 'Q5V9VADJGAQ3QT8TNZF59'
								          
								 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
$115.00
43% OFF
$65.00
TEST

See in Store

$2,849.90
44% OFF
$1,599.95
TEST

See in Store

$1,205.95
36% OFF
$769.95
TEST

See in Store

$109.95
36% OFF
$69.95
TEST

See in Store

$125.00
40% OFF
$75.00
TEST

See in Store

$220.00
41% OFF
$130.00
TEST

See in Store

$250.00
46% OFF
$135.00
TEST

See in Store

$280.00
45% OFF
$155.00
TEST

See in Store

$135.00
37% OFF
$85.00
TEST

See in Store

$569.95
37% OFF
$359.95
TEST

See in Store

$759.95
34% OFF
$499.95
TEST

See in Store

$879.95
36% OFF
$559.95
TEST

See in Store

$1,349.95
39% OFF
$819.95
TEST

See in Store

$159.95
38% OFF
$99.95
TEST

See in Store

$169.95
41% OFF
$99.95
TEST

See in Store

$119.95
42% OFF
$69.95
TEST

See in Store

$219.95
32% OFF
$149.95
TEST

See in Store

$139.95
36% OFF
$89.95
TEST

See in Store

$149.95
33% OFF
$99.95
TEST

See in Store

$139.95
29% OFF
$99.95
TEST

See in Store

$219.95
32% OFF
$149.95
TEST

See in Store

$149.95
33% OFF
$99.95
TEST

See in Store

$559.95
38% OFF
$349.95
TEST

See in Store

$659.95
39% OFF
$399.95
TEST

See in Store

$849.95
41% OFF
$499.95
TEST

See in Store

$99.95
40% OFF
$59.95
TEST

See in Store

$899.95
33% OFF
$599.95
TEST

See in Store

$1,039.95
38% OFF
$639.95
TEST

See in Store

$2,199.95
38% OFF
$1,369.95
TEST

See in Store

$1,669.95
38% OFF
$1,029.95
TEST

See in Store

$169.95
41% OFF
$99.95
TEST

See in Store

$1,919.95
34% OFF
$1,259.95
TEST

See in Store

$599.95
33% OFF
$399.95
TEST

See in Store

$919.95
35% OFF
$599.95
TEST

See in Store

$219.95
32% OFF
$149.95
TEST

See in Store

$599.95
33% OFF
$399.95
TEST

See in Store

$529.95
32% OFF
$359.95
TEST

See in Store

$729.95
36% OFF
$469.95
TEST

See in Store

$539.95
35% OFF
$349.95
TEST

See in Store

$899.95
36% OFF
$579.95
TEST

See in Store

$959.95
40% OFF
$579.95
TEST

See in Store

$159.95
38% OFF
$99.95
TEST

See in Store

$139.95
36% OFF
$89.95
TEST

See in Store

$189.95
37% OFF
$119.95
TEST

See in Store

$749.95
33% OFF
$499.95
TEST

See in Store

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