select listingid from boards.listings
where
`table` in ('mlsr_listings','vancouver_lotsland') and
class = 1 and subarea = 'Campbell Valley' and
streetaddress = '22625 38 AVENUE' and city = 'Langley' and status = 'Active'
Sorry, this listing has been taken off the market | Vijay Virk - Macdonald Realty (Surrey/152)