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, ' ', '-') = '428-w-8th-av-xl-lofts'
myQuery: Resource id #152
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes
Building
XL Lofts @ 428 W 8th Av - South Cambie Vancouver
77
# of Suites
5
# of Levels
1997
Year Built
Yes
Pets Allowed
Yes
Rentals Allowed
XL Lofts holds the title for the most unique Loft building in the new South Cambie neighbourhood. South Cambie has recently become extremely populated with both Residential & Commercial development.
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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A' 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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A'
missingImageThumbnail: /images/uploads/0969308b-1ce2-4ce0-87a1-7fbbe9ae878a/5ab867221cec2513e7bc07514d784c51-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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A' 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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A' 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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A' ORDER BY i.Timestamp
No documents for this building

JayMcInnes.com sales at XL Lofts

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='0969308B-1CE2-4CE0-87A1-7FBBE9AE878A' 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