tsql: SELECT a.*, f.Src, f.ImageHeight, f.ImageWidth, f.Folder AS ImageFolder, p.Src AS FloorplanSrc, p.ImageHeight AS FloorplanHeight, p.ImageWidth AS FloorplanWidth, p.Folder AS FloorplanFolder FROM tblAddresses a LEFT OUTER JOIN tblFiles f ON a.AddressId=f.BuildingId AND f.IsImage=1 AND f.IsFeatured=1 AND f.Folder <> '' LEFT OUTER JOIN tblFiles p ON a.AddressId=p.ListingId AND p.IsImage=1 AND p.IsFloorplan=1 AND p.Folder <> '' WHERE REPLACE(a.AddressNumber + '-' + a.AddressStreet + '-' + a.Nickname, ' ', '-') = '502-1280-richards-st-the-grace-(tower)/v760784'
myQuery: Resource id #148
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes

Building Not Found

Building information was not found. Try these pages: Active Listings | Sold Listings