Call: 888-885-2730

 



Elijah Slocum, Inc.

Hudson, New York 12534

888-885-2730 
518-671-6344 

E.mail: contact@elijahslocum.com 



 

Join Our Newsletter

facebook footer

 

sq 1 SELECT * FROM `products` p where MainCat = 'Case Pieces' AND (Active = 1) AND ProdID = ( SELECT ProdId FROM products ps WHERE p.MainCat = ps.MainCat AND p.SubCat = ps.SubCat AND Active = 1 ORDER BY SortOrder LIMIT 1 ) sq 2