-
Building Name: 813 E. Broadway Address: 813 E. Broadway, Vancouver, BC, V5T 1Y2 Subarea: Mount Pleasant Levels: 3 Suites: 17 Type: Freehold Construction: Wood Year Built: 1976
Warning: mysql_query(): Unable to save result set in /home/sonjales/public_html/mls_open_houses.php on line 607
Server shutdown in progress SELECT building_id, COUNT(*) as count, MIN(listprice_2) as min, MAX(listprice_2) as max, SQRT(POWER((lat - 49.262620),2)+POWER((lng - -123.086612),2)) AS distance, (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 mlsr_listings WHERE STATUS = 'Active' AND reciprocity = 'Yes' AND building_id > 0 AND building_id <> 680 GROUP BY building_id HAVING has_open_houses>0 ORDER BY distance ASC LIMIT 10