string(18) "shenandoah.har.com" SELECT MLSNUM,address_on_url FROM harnew.listings_sold WHERE ListingID = 3907163 LIMIT 1