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, ' ', '-') = '888-homer-st-beasley'
myQuery: Resource id #15
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes
Building
Beasley @ 888 Homer St - Vancouver BC
222
# of Suites
34
# of Levels
2011
Year Built
Yes
Pets Allowed
Yes
Rentals Allowed
The Beasley is a high-end development at the corner of Smithe St & Homer Street in the heart of Downtown Vancouver. 888 Homer Street was built by Amacon Developments & completed in 2011. This is a Concrete High-Rise tower offering 222 homes over 34 levels.
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='F896A9EB-1F31-4702-8605-C52595D6A124' 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='F896A9EB-1F31-4702-8605-C52595D6A124'
missingImageThumbnail: /images/uploads/f896a9eb-1f31-4702-8605-c52595d6a124/44eab810446cfdf02010cc26f56d91b4-thumb.jpg

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='F896A9EB-1F31-4702-8605-C52595D6A124' 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='F896A9EB-1F31-4702-8605-C52595D6A124' 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='F896A9EB-1F31-4702-8605-C52595D6A124' ORDER BY i.Timestamp
No documents for this building

JayMcInnes.com sales at Beasley

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='F896A9EB-1F31-4702-8605-C52595D6A124' AND LOWER(l.Status) <> 'active' AND l.SoldByMe=1 ORDER BY l.SuiteNumber ASC

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