OVER-HEIGHT PENTHOUSE in the heart of downtown Vancouver, centrally located near transit, shopping and entertainment! This PH boasts over 1053 sqft of interior living space with 3 bedrooms and 2 bathrooms. 12-ft ceilings with floor to ceiling windows with panoramic city and mountain views!
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/Listing.php on line 1047
Sort aborted: Server shutdown in progressselect display from pixilink_mlsr.vancouver_intersections
where st_within(vancouver_intersections.point, ST_GeomFromText('POLYGON((-123.158974 49.274905, -123.158974 49.258905, -123.186974 49.258905, -123.186974 49.274905, -123.158974 49.274905))'))
order by ST_Distance_Sphere(vancouver_intersections.point, point(-123.172974,49.266905)) asc limit 1