Willis Furniture is looking for Furniture and Mattress Sales Staff. Click here to Apply Today. We look forward to meeting you.

Kearney Leather Ottoman

By Bradington Young

SKU 525-OT

Be the first to write a review!

Call for Current Event Pricing!

Need Help?

Do you have questions about this product?

Product Information

Description

Ship Weight: 80 lbs.

The Kearney Leather Ottoman by Bradington Young may be available at Willis Furniture & Mattress in the Virginia Beach area. Please contact us to check availability.

Please note that the finish or fabric of this product in-store may be different than the photo currently pictured. Please contact your local store to confirm product pricing, availability, finish and fabric colors and promotional dates.

Features
Upholstered, Leather

Specs

SKU 525-OT
Width 42.00"
Depth 42.00"
Height 19.50"

Return Policy

CANCELLED/RETURNED SPECIAL ORDERS ARE SUBJECT TO A 35% NON-REFUNDABLE DEPOSIT.   MERCHANDISE HELD FOR OVER 30 DAYS IS SUBJECT TO A STORAGE FEE (10% OF SALE, MAXIMUM OF $100 PER MONTH).   15 DAY NO QUESTIONS ASKED SATISFACTION GUARANTEE We take pride in offering you quality home furnishings and professional assistance and service. If, in the first 15 days after you have received your purchase from our stock, you are dissatisfied for any reason, simply return the item. We will replace, repa...Read More
SELECT lm.id,
				lm.title, 
				lm.videoId, 
				lm.file as fileName, 
				lbtm.mediaId, 
				lbtm.displayOrder, 
				'local' as videoType,
				lm.videoSrc,
				lbtm.brandId,
				cctm.categoryId,
				IF(lbtm.brandId IS NOT NULL && cctm.categoryId IS NOT NULL, 1, IF(lbtm.brandId IS NOT NULL && cctm.categoryId IS NULL, 2, IF(lbtm.brandId IS NULL && cctm.categoryId IS NOT NULL, 3, 4))) videoTagOrder
			FROM media lm
			LEFT JOIN catalogBrandsToMedia lbtm ON lbtm.mediaId=lm.id
			LEFT JOIN catalogCategoriesToMedia cctm ON cctm.mediaId=lm.id
			WHERE lm.type=3 AND ( (lbtm.brandId='4' AND cctm.categoryId='83') OR (lbtm.brandId='4' AND cctm.categoryId IS NULL) OR (lbtm.mediaId IS NULL AND cctm.categoryId='83') )
		UNION 
			SELECT m.id,
				m.title, 
				m.videoId, 
				m.fileName, 
				bm.mediaId, 
				bm.displayOrder, 
				'master' as videoType,
				'0' as videoSrc,
				bm.brandId,
				cm.categoryId,
				IF(bm.brandId IS NOT NULL && cm.categoryId IS NOT NULL, 1, IF(bm.brandId IS NOT NULL && cm.categoryId IS NULL, 2, IF(bm.brandId IS NULL && cm.categoryId IS NOT NULL, 3, 4))) videoTagOrder
			FROM `catalog`.`media` m 
			LEFT JOIN `catalog`.`brandsMedia` bm ON bm.mediaId=m.id
			LEFT JOIN catalog.categoriesMedia cm ON cm.mediaId=m.id
			WHERE m.type=3 AND ( (bm.brandId='87' AND cm.categoryId='106') OR (bm.brandId='87' AND cm.categoryId IS NULL) OR (bm.mediaId IS NULL AND cm.categoryId='106') )
		ORDER BY videoType, videoTagOrder, displayOrder, mediaId

You might also like

Related Products

Reviews

0

There are no reviews for this product. Be the first to write one!

Write a Product Review
Kearney Leather Ottoman
Kearney Leather Ottoman by Bradington Young
Please rate this product
Please enter your name
Please enter your email
Please enter your Zip

* required

Request More Information

Looking for more information? Simply fill out the form below and we will get back with you within 48 hours.

Please enter your name
Please enter your email
Please enter your phone
Please enter your zip
Please enter your comments
* required
Kearney Leather Ottoman

Request More Information

Looking for more information? Simply fill out the form below and we will get back with you within 48 hours.

Please enter your name
Please enter your email
Please enter your phone
Please enter your zip
Please enter your comments
* required
Willis Furniture & Mattress

4220 Virginia Beach Blvd
Virginia Beach, VA

(757) 340-2112

TOP