SELECT L_Address,L_City,L_Zip FROM mls4.listings_taar_com WHERE L_ListingID=1895694