SELECT p.id,p.product_id, p.product_name as name, p.product_short_description, p.product_description, p.dimensions, p.custom_spec, p.com, p.is_live, p.is_new, p.lm_collection, p.sample_sale, p.link, pi.image_file FROM products as p, products_to_categories as ptc, product_images as pi WHERE p.id=ptc.product_id AND pi.product_id = p.id AND pi.sort_order = 0 AND p.is_live='1' AND p.archive='0' AND pi.image_file!='' AND ptc.category_id= 4 ORDER by ptc.order ASC Lorin Marsh | Furniture | Occasional Pieces

LORIN MARSH

Sign Up for Lorin Marsh Updates

To join our email list, please fill out the following form.
All fields are required.

Lorin Marsh Thank You

Thank you
for signing up