-
Building Name: Village on False Creek - 118 Athletes Address: 118 Athletes Way, Vancouver, BC, V5Y 0B5 Subarea: Mount Pleasant Levels: 6 Suites: 11 Type: Freehold Construction: Concrete Year Built: 2009
SELECT
`les_les`.`listing`.id IS NOT NULL AS is_featured,
`pixilink_mlsr`.`mlsr_listings`.*,
`pixilink_mlsr`.`mlsr_listings`.`listprice_2`/`pixilink_mlsr`.`mlsr_listings`.`livingarea_2` AS dollfoot,
(SELECT CONCAT(file.directory, file.name) AS imageloc
FROM pixilink_mlsr.listing_file
JOIN pixilink_mlsr.file ON (listing_file.file_id = file.id)
WHERE listing_file.listing_id = mlsr_listings.id ORDER BY file.id ASC LIMIT 1) AS imageLoc,
(SELECT
COUNT(*)
FROM
`pixilink_mlsr`.`open_house`
WHERE
DATEDIFF(`pixilink_mlsr`.`open_house`.`start`, NOW())<7 AND
DATEDIFF(`pixilink_mlsr`.`open_house`.`start`, NOW())>=0 AND
`pixilink_mlsr`.`open_house`.`mls`=`pixilink_mlsr`.`mlsr_listings`.`listingid`) AS has_open_houses
FROM
`pixilink_mlsr`.`mlsr_listings`
LEFT JOIN
`les_les`.`listing` ON
(`les_les`.`listing`.`listingid`=`pixilink_mlsr`.`mlsr_listings`.`listingid` AND
`les_les`.`listing`.`status` = 'Active')
WHERE
`pixilink_mlsr`.`mlsr_listings`.`building_id` IN (41043) AND
`pixilink_mlsr`.`mlsr_listings`.`status` = 'Active' AND
`pixilink_mlsr`.`mlsr_listings`.`reciprocity` = 'Yes'
HAVING
has_open_houses>0
ORDER BY
`les_les`.`listing`.`id` IS NULL ASC,
`pixilink_mlsr`.`mlsr_listings`.`listprice_2` ASC