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, ' ', '-') = '138-furry-creek-drive-furry-creek-drive'
myQuery: Resource id #152
Active Downtown Vancouver Condo Building Information & Listings For Sale | Jay McInnes
Building
Furry Creek Drive @ 138 Furry Creek Drive - West Vancouver
0
# of Suites
0
# of Levels
0
Year Built
Yes
Pets Allowed
Yes
Rentals Allowed
The perfect Furry Creek Drive view home, offering picturesque sight lines of Howe Sound Water & Mountains. At 4 Bedrooms, 3 Bathrooms & 2 Car Garage, this is the perfect family home or weekend home away. Your own Private heated Pool & Hot-Tub await you on your oversized entertaining patio with uninterrupted vistas of the Water & Mountains. All rooms additionally offer this perfect West Coast View from within.
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='FA43E949-EA53-4DB9-B338-E19847A4D5BC' 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='FA43E949-EA53-4DB9-B338-E19847A4D5BC'
missingImageThumbnail: /images/uploads/fa43e949-ea53-4db9-b338-e19847a4d5bc/a87c0f0992a5764a10c42c953f64d3e8-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='FA43E949-EA53-4DB9-B338-E19847A4D5BC' 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='FA43E949-EA53-4DB9-B338-E19847A4D5BC' 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='FA43E949-EA53-4DB9-B338-E19847A4D5BC' ORDER BY i.Timestamp
No documents for this building

JayMcInnes.com sales at Furry Creek Drive

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='FA43E949-EA53-4DB9-B338-E19847A4D5BC' AND LOWER(l.Status) <> 'active' AND l.SoldByMe=1 ORDER BY l.SuiteNumber ASC

There are currently no sold listings at Furry Creek Drive.

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