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, ' ', '-') = '58-keefer-street-firenze-1'
myQuery: Resource id #148
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes
Building
Firenze 1 @ 58 Keefer Street - Crosstown
173
# of Suites
25
# of Levels
2007
Year Built
Yes
Pets Allowed
Yes
Rentals Allowed
58 Keefer Street is located in the heart of Crosstown Vancouver and is a part of the Firenze Complex. 58 Keefer (Firenze 1) is accompanied by two other towers (1 X high-rise | 1 X low-rise). 58 Keefer Street offers 173 homes throughout 25 stories. The Firenze complex offers a full Amenity package including Concierge, indoor pool & hot tub, sauna, fitness centre, media room, common patios, children playground & a live lagoon!
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='66EB705E-AA79-402D-B790-29E878C351FF' 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='66EB705E-AA79-402D-B790-29E878C351FF'

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='66EB705E-AA79-402D-B790-29E878C351FF' 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='66EB705E-AA79-402D-B790-29E878C351FF' 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='66EB705E-AA79-402D-B790-29E878C351FF' ORDER BY i.Timestamp
No documents for this building

JayMcInnes.com sales at Firenze 1

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='66EB705E-AA79-402D-B790-29E878C351FF' AND LOWER(l.Status) <> 'active' AND l.SoldByMe=1 ORDER BY l.SuiteNumber ASC

There are currently no sold listings at Firenze 1.

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