What would you like to know?
What is your availability for a viewing?
1909 1111 Alberni Street, Vancouver
MLS®: R2856715
$1,898,000
1465
Sq.Ft.
2
Baths
2
Beds
2008
Built
$1,761.12
Maint. fees
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 '2024-04-23 06:09:19' and '2024-04-24 18:09:19', 1, 0) as datematch, IF (inserted between '2024-04-21 18:09:19' and '2024-04-23 06:09:19', 1, 0) as datematch2, IF (inserted < '2024-04-21 18:09:19', DATEDIFF(inserted, '2024-04-24 18:09:19'), 0) as datematch3, IF (listprice_2 between 1758000 and 2358000, 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 ('R2855838','R2865417','R2873396','R2840827','R2814436','R2822240','R2825567','R2825514','R2856255','R2869003','R2873985') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3