SELECT DISTINCT
pl.id,
pl.name
FROM _product_lengths pl
INNER JOIN _product_stocks ps ON ps.length_id = pl.id
WHERE ps.product_id = 164
AND ps.qty > 0
AND pl.is_active = 1
ORDER BY pl.name ASC
Furny Arossa 5 Seater Leatherette LHS L Shape Sofa Set — Buy Online and Get Delivered | Sofa Sectional Studio
Select Size & Length to enable Buy Now
Description
Specifications
Reviews (0)
Furny Arossa 5 Seater Leatherette LHS L Shape Sofa Set
(0 reviews)
₹32,000.00
₹39,000.00
18% OFF
(Max 10 per order)
Category: Sofa SetBrand: Sofa Sectional
Available Sizes:
one-size (9 left)
Available Lengths:
one-size (9 left)
Overall Stock:In stock (9 available)
Selected: one-size, one-size
Get delivered in 4–5 days
Select Size and Length to enable purchase options
Description
Specifications
Reviews (0)
No description available.
SKU:PROD1002
Brand: Sofa Sectional
Manufacturer: HBS
Write a Review
No reviews yet. Be the first to review this product!
