select listingid from boards.listings
where
`table` in ('mlsr_listings','vancouver_lotsland') and
class = 1 and subarea = 'Sunnyside Park Surrey' and
streetaddress = '1654 138B STREET' and city = 'Surrey' and status = 'Active'
Sorry, this listing has been taken off the market | Vijay Virk - Macdonald Realty (Surrey/152)