string(16) "bellaire.har.com" SELECT MLSNUM,address_on_url FROM harnew.listings_sold WHERE ListingID = 4143424 LIMIT 1