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, ' ', '-') = '1-lamb-island-bc-lamb-island-bc'
myQuery: Resource id #152
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes
Building
Lamb Island BC @ 1 Lamb Island BC - Sechelt BC
0
# of Suites
0
# of Levels
2000
Year Built
Yes
Pets Allowed
Yes
Rentals Allowed
Lamb island is a Private Island in Sechelt BC Canada
SELECT i.* FROM tblFiles i LEFT OUTER JOIN tblAddresses a ON i.BuildingId=a.AddressId WHERE a.IsDeleted=0 AND i.IsImage=1 AND a.AddressId='B059A493-6525-4476-843C-2E5B8A8D8274' ORDER BY i.SortOrder ASC, i.Timestamp ASC
SELECT a.BuildingId, a.FileId, a.Folder, a.Src, a.ThumbSrc FROM tblFiles a WHERE a.IsImage=1 AND a.IsDefault=1 AND a.BuildingID='B059A493-6525-4476-843C-2E5B8A8D8274'

Active Listings

SELECT l.*, a.AddressNumber, a.AddressStreet, a.Nickname, f.FileId, f.Folder, f.Name, f.ContentType, f.Extension, f.ThumbSrc, f.ThumbSize, f.ThumbHeight, f.ThumbWidth FROM tblListings l LEFT OUTER JOIN tblAddresses a ON l.AddressId=a.AddressId LEFT OUTER JOIN tblFiles f ON l.ListingId=f.ListingId AND f.IsImage=1 AND f.IsFeatured=1 WHERE l.IsDeleted=0 AND l.AddressId='B059A493-6525-4476-843C-2E5B8A8D8274' AND LOWER(l.Status) = 'active' ORDER BY l.SuiteNumber ASC

Building Images

SELECT i.* FROM tblFiles i LEFT OUTER JOIN tblAddresses a ON i.BuildingId=a.AddressId WHERE a.IsDeleted=0 AND i.IsImage=1 AND a.AddressId='B059A493-6525-4476-843C-2E5B8A8D8274' AND Folder<>'' ORDER BY i.SortOrder ASC, i.Timestamp ASC

Building Documents

SELECT i.* FROM tblFiles i LEFT OUTER JOIN tblAddresses a ON i.BuildingId=a.AddressId WHERE a.IsDeleted=0 AND i.IsImage=0 AND a.AddressId='B059A493-6525-4476-843C-2E5B8A8D8274' ORDER BY i.Timestamp
No documents for this building

JayMcInnes.com sales at Lamb Island BC

SELECT l.*, a.AddressNumber, a.AddressStreet, a.Nickname, f.FileId, f.Folder, f.Name, f.ContentType, f.Extension, f.ThumbSrc, f.ThumbSize, f.ThumbHeight, f.ThumbWidth FROM tblListings l LEFT OUTER JOIN tblAddresses a ON l.AddressId=a.AddressId LEFT OUTER JOIN tblFiles f ON l.ListingId=f.ListingId AND f.IsImage=1 AND f.IsFeatured=1 WHERE l.IsDeleted=0 AND l.AddressId='B059A493-6525-4476-843C-2E5B8A8D8274' AND LOWER(l.Status) <> 'active' AND l.SoldByMe=1 ORDER BY l.SuiteNumber ASC

There are currently no sold listings at Lamb Island BC.

Copyright & Disclaimer

* Copyright © 2017 by the Real Estate Board of Greater Vancouver. All Rights Reserved.

** The data relating to real estate on this web site comes in part from the MLS Reciprocity program of the Real Estate Board of Greater Vancouver. Real estate listings held by participating real estate firms are marked with the MLSR logo and detailed information about the listing includes the name of the listing agent. This representation is based in whole or part on data generated by the Real Estate Board of Greater Vancouver which assumes no responsibility for its accuracy. The materials contained on this page may not be reproduced without the express written consent of the Real Estate Board of Greater Vancouver.

Copyright © 2011-2017 Jay McInnes Inc.


thumb