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' TheMidWest, -- apartments | rental properties | storage units
