SELECT TOP 8 Product_ID, PartNumber, ProductTitle, Price, Smimage, SmimageParams, ProductDescription1, DateCreated, Categories.CategoryImgStub,Companies.CDomainName,Companies.CompanyDS_ID, Companies.Company_ID,StoreTemplate,ProductTemplate, Companies.CompanyName, Companies.Directory, Companies.ReturnURL, Companies.MallCategory, Products.SmImage,Products.SmImageParams, Products.ProductTitle, Products.Product_ID, Products.Retail, Products.Price, Products.Unit, Products.Active,Products.ProductDescription1,Products.DateCreated, Companies.Active, Products.OnSpecial, Categories.CategoryImgStub FROM Companies, Categories, ObjectGroups, Products WHERE Companies.Company_ID = Categories.Company_ID AND Categories.Category_ID = ObjectGroups.Category_ID AND ObjectGroups.ObjectGroup_ID = Products.ObjectGroup_ID AND ObjectGroups.Active = 1 AND Products.OnSpecial = OFF AND Products.Active = 1 ORDER BY Products.DateCreated DESC
HandleyHouse.com - miniatures, dollhouse, dollhouse miniatures, doll, house, miniature, mini, house, miniature furniture, handley house, handley, classics, collectibles, collectables, dolls, scale, models, one inch scale, hobby, free catalog, on-line catalog, manufacturer Visit one of our sponsors - miniatures, dollhouse, dollhouse miniatures, doll, house, miniature, mini, house, miniature furniture, handley house, handley, classics, collectibles, collectables, dolls, scale, models, one inch scale, hobby, free catalog, on-line catalog, manufacturer
Visit one of our sponsors.

Handley  House is proud to present the most comprehensive 1" scale (also known as 1/12th scale where 1"=1') miniatures catalog available on the world wide web.  To ease your viewing, our products have been organized by manufacturer and category.

Browse By Category:
SELECT DISTINCT Categories.Category_ID, Categories.OrderByString, Categories.CategoryTitle, Categories.CategoryPageOptions FROM Companies INNER JOIN ((Categories INNER JOIN ObjectGroups ON Categories.Category_ID = ObjectGroups.Category_ID) INNER JOIN Products ON ObjectGroups.ObjectGroup_ID = Products.ObjectGroup_ID) ON Companies.Company_ID = Categories.Company_ID WHERE (((ObjectGroups.Active)=1) AND ((Products.Active)=1) AND ((Companies.Company_ID)=#CID#)) ORDER BY Categories.CategoryTitle Select * from objectgroups where active = 1

 

 

 Product Directory

SELECT DISTINCT Categories.Category_ID, Categories.OrderByString, Categories.CategoryTitle, Categories.CategoryPageOptions FROM Companies INNER JOIN ((Categories INNER JOIN ObjectGroups ON Categories.Category_ID = ObjectGroups.Category_ID) INNER JOIN Products ON ObjectGroups.ObjectGroup_ID = Products.ObjectGroup_ID) ON Companies.Company_ID = Categories.Company_ID WHERE (((ObjectGroups.Active)=1) AND ((Products.Active)=1) AND ((Companies.Company_ID)=1)) ORDER BY Categories.CategoryTitle SELECT C.CategoryTitle, C.CategoryDescription, C.CategoryIcon, C.CategoryIconParams, C.OrderByString, O.Category_ID, O.ObjectGroup_ID, C.CategoryImgStub FROM Categories C, ObjectGroups O WHERE O.Active = 1 AND C.Category_ID = O.Category_ID AND C.Category_ID IN (#Valuelist(GetCategories.Category_ID)#) GROUP BY O.Category_ID, C.OrderByString, C.CategoryTitle, C.CategoryDescription, C.CategoryIcon, C.CategoryIconParams, O.ObjectGroup_ID, C.CategoryImgStub ORDER BY C.CategoryTitle
#CategoryTitle#

 What's New at HandleyHouse.com

#trim(ProductTitle)# #ProductDescription1#

 More NEW ITEMS

SmCatCover04
SmCatCover02

REQUEST A CATALOG
click here to receive a copy of our new 650 page color catalog

 

REQUEST A CATALOG

click here to find out how to receive our new 650 page catalog.

All prices listed are suggested retail
in US Dollars. If you would like to convert our prices into another
currency please use this link to the
Personal Currency Assistant™

COPYRIGHT © 1998-2005 HANDLEY HOUSE. ALL RIGHTS RESERVED.
2 Fourth Street, Wheeling, WV 26003, USA  -  (304) 232-5040  (304)232-5245 (fax)
Refer any questions or comments to
Info@HandleyHouse.com
Site last modified 01/18/08