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 = 165
AND ps.qty > 0
AND pl.is_active = 1
ORDER BY pl.name ASC
Sofa 3+1+1 — Buy Online and Get Delivered | Sofa Sectional Studio
Select Size & Length to enable Buy Now
Description
Specifications
Reviews (0)
Sofa 3+1+1
(0 reviews)
₹21,000.00
₹25,000.00
16% OFF
(Max 10 per order)
Category: Sofa SetBrand: Sofa Sectional
Available Sizes:
one-size (10 left)
Available Lengths:
one-size (10 left)
Overall Stock:In stock (10 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:PROD1003
Brand: Sofa Sectional
Manufacturer: HBS
Write a Review
No reviews yet. Be the first to review this product!
🔗 Related Products
Sofa
₹12,000.00
₹900,000.00
Furny Arossa 5 Seater Leatherette LHS L Shape Sofa Set
