SELECT L_Address,L_City,L_Zip FROM mls2.listings_taar_res WHERE L_ListingID=1741073