;REA9, Version=9.4.0.0, Culture=neutral, PublicKeyToken=null%REA9.FlatFileImport.PropertyImportMapSiteContactMapOwnerContactMapAgentContactMap ImportListImportMap+Options$REA9.FlatFileImport.ContactImportMap$REA9.FlatFileImport.ContactImportMap$REA9.FlatFileImport.ContactImportMapREA9.FlatFileImport.ImportListREA9.FlatFileImport.OptionList     $REA9.FlatFileImport.ContactImportMap CompanyMap ImportListImportMap+Options$REA9.FlatFileImport.CompanyImportMapREA9.FlatFileImport.ImportListREA9.FlatFileImport.OptionList      REA9.FlatFileImport.ImportListListSystem.Collections.ArrayList REA9.FlatFileImport.OptionListList $REA9.FlatFileImport.CompanyImportMap ImportListImportMap+OptionsREA9.FlatFileImport.ImportListREA9.FlatFileImport.OptionList                 System.Collections.ArrayList_items_size_version  ! "#CSV file (with header)|*.csv $ % &' ( ) * +  ' - . / 0 ' 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G ! REA9.FlatFileImport.UpdateOptionvalue__"$REA9.FlatFileImport.ImportSourceTypevalue__$ H% ' J& (!) K* ' M+ N O P Q R S T U -!. V/ ' X0 2!3REA9.FlatFileImport.ImportField TableName FieldNameIndexSourceExpressionKeyField UpdateOption REA9.FlatFileImport.UpdateOptionY property_infoZ address_1[IConcat([Situs House No./House Alpha]," ",[Situs Direction/Street/Suffix])!43 Y^zip_code_[Situs ZIP/ZIP+4]!53 YbcitycIIf(RegexMatch([Situs City/State/ZIP/ZIP+4 DWL],"^\w\w$") ,"" ,RegexReplace([Situs City/State/ZIP/ZIP+4 DWL],"(.*)\s\w\w\s[0-9-]*$","$1") )!63 YfstategIIf(RegexMatch([Situs City/State/ZIP/ZIP+4 DWL],"^\w\w$") ,[Situs City/State/ZIP/ZIP+4 DWL] ,RegexReplace([Situs City/State/ZIP/ZIP+4 DWL],".*\s(\w\w)\s[0-9-]*$","$1") )!73 Yjzoningk[Zoning]!83 Ynsqfto[Bldg/Living Area]!93q listing_infor sale_prices [Sale Price]!:3 Yvlast_trans_datew [Sale Date]!;3 Yzlast_trans_price{ [Sale Price]!<3 q~ loan_amount[1st Mtg Amount]!=3 q loan_type[1st Mtg Loan Type]|!>3 q loan_rate[1st Mtg Interest Rate]x!?3 qlender[Lender]t!@3 Yassessed_value [Total Value]p!A3 q tax_per_sqft[Property Tax]l!B3 Yacres [Lot Acreage]h!C3 Yparcel[APN]d!D3 usage_info year_built [Year Built]`!E3 Yaddress_number_1[Situs House No./House Alpha]\!F3 Yaddress_directionIIf(RegexMatch([Situs Direction/Street/Suffix],"^([N|S|W|E|NW|NE|SW|SE])\s") ,RegexReplace([Situs Direction/Street/Suffix],"^([N|S|W|E|NW|NE|SW|SE])\s.*","$1") ,"")X!G3 Yaddress_streetQRegexReplace([Situs Direction/Street/Suffix],"^[N|W|S|E|NW|NE|SW|SE]\s(.*)","$1")T!H J!K M!N3 contact_info full_name=Coalesce([Mail Care Of Name],[Owner Name (First Name First)])J!O3  first_name[Owner First Name]F!P3  last_name[Owner Last Name]B!Q3primary_address Z[Mail Address]>!R3 bIIf(Left(Right([Mail City/State/ZIP/ZIP+4 DWL],5),1)="-",Substring( [Mail City/State/ZIP/ZIP+4 DWL],1,Len([Mail City/State/ZIP/ZIP+4 DWL])-14 ),Substring([Mail City/State/ZIP/ZIP+4 DWL],1,Len([Mail City/State/ZIP/ZIP+4 DWL])-9)):!S3 ^[Mail ZIP/ZIP+4]6!T3 f[Mail State DWL]2!U3 workFormatPhone([Phone Number]).!V X!3 address_info Z *!3 b &!3 ^ "!3 f !3 company_infoorganization_id[Owner Name (First Name First)]!3 company !