What would you like to know?
What is your availability for a viewing?
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/Functions.php on line 285
Server shutdown in progressSELECT listingid, inserted, listprice_2, bedrooms, IF (inserted between '2025-07-04 07:00:28' and '2025-07-05 19:00:28', 1, 0) as datematch, IF (inserted between '2025-07-02 19:00:28' and '2025-07-04 07:00:28', 1, 0) as datematch2, IF (inserted < '2025-07-02 19:00:28', DATEDIFF(inserted, '2025-07-05 19:00:28'), 0) as datematch3, IF (listprice_2 between 880000 and 1030000, 1, 0) as pricematch, IF (bedrooms >= 2, 1, 0) as bedsmatch FROM boards.listings WHERE `table` = 'mlsr_listings' AND city = 'Vancouver' AND class = '2' AND `status` = 'Active' AND reciprocity = 'Yes' AND listingid not in ('R2542378') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3