S: SELECT EntityID,EntityName,EntityDisplayURL,EntityURL,GoodDatePosted,GoodHeading,GoodFullDesc,GoodImageSL,GoodStockID,GoodImage1Path,GoodDisplayURL,GoodURL,StockImagePath FROM Goods,Entitys,Stocks WHERE GoodEntityID = EntityID AND GoodStockID = StockID AND GoodID = 31 AND GoodActive = 'Y' , -- real estate | property | realtors | home finance | home inspectors | brokers | real estate auctions
