select listingid from boards.listings
`table` in ('mlsr_listings','vancouver_lotsland') and
class = 2 and subarea = 'Neilsen Grove' and
streetaddress = '49 5551 ADMIRAL WAY' and city = 'Ladner' and status = 'Active'
Sorry, this listing has been taken off the market Richmond Townhouses for Sale | Richmondtownhouse.ca
Call us: 604-218-7555
Richmond Townhouses & Homes for Sale
Multiple Realty Ltd.
#110-9780 Cambie Rd
Richmond, BC V6X 1K4