RecordId|MelissaAddressKey|BaseMelissaAddressKey|FirstName|LastName|AddressLine1|City|State|ZipCode|Plus4|DeliveryPoint|AddressKey|CarrierRoute|FIPSCode|PlaceCode|Latitude|Longitude|CensusKey|PhoneNumber|PurchasePrice|SellDate|Lender|TransactionType|PublishedDate|CondoCode|MortgageAmount|RateType|LoanType
1|3271039317||Alex J|Park|132 Seacountry Ln|Rancho Santa Margarita|CA|92688|5536|32|92688553632|C069|06059|0640526|33.590111|-117.628735|060590320534004|9495468998|445|2016-11-09|United Wholesale Mtg|1|2016-00-16|C|356||CNV
2|4907717470||Daniel|Khani|18 Via Gatillo|Rancho Santa Margarita|CA|92688|3185|18|92688318518|C064|06059|0659587|33.650335|-117.622134|060590320484003||635|2016-12-02||1|2016-00-23||0||
3|1122076153||Jonathan M|Atkinson|11 Castano|Rancho Santa Margarita|CA|92688|1662|11|92688166211|C059|06059|0659587|33.645809|-117.593167|060590320513005||250|2016-10-26||1|2016-00-28|C|226||FHA
4|4009684514||Matthew|Borland|11 La Cueva|Rancho Santa Margarita|CA|92688|1664|11|92688166411|C054|06059|0659587|33.648130|-117.592039|060590320513003||595|2016-12-08||1|2016-00-28||584||FHA
5|6388975994||Christopher B|Helvajian|31 Poppyfield Ln|Rancho Santa Margarita|CA|92688|8725|31|92688872531|R101|06059|0640526|33.583780|-117.624230|060590320565015||528|2016-11-29||1|2016-00-28|C|463||CNV
6|3993033644||Haibo|You|26 Santa Inez|Rancho Santa Margarita|CA|92688|2676|26|92688267626|C073|06059|0659587|33.630179|-117.610347|060590320531008||880|2016-09-26||1|2016-00-29||572|ADJ|CNV
7|1183393223||Espiridion|Bustillos|22 Calle Katrina|Rancho Santa Margarita|CA|92688|5434|22|92688543422|C054|06059|0659587|33.654382|-117.582372|060590320512002||490|2016-03-22||1|2016-00-30|C|416||CNV
8|1662633569||John J|Fan|292 Pasto Rico|Rancho Santa Margarita|CA|92688|2903|92|92688290392|C062|06059|0659587|33.621554|-117.614371|060590320533004|9497090943|388|2016-12-07||1|2016-00-30|C|0||
9|7819009496||Hea Y S|Han|1 Castilla|Rancho Santa Margarita|CA|92688|2920|01|92688292001|C071|06059|0659587|33.635929|-117.598438|060590320544015||585|2016-12-02||1|2016-00-30||468||CNV
10|4738004420||Laura Q|Zhou|82 Montana Del Lago Dr|Rancho Santa Margarita|CA|92688|1366|82|92688136682|C054|06059|0659587|33.649242|-117.585152|060590320512013||358|2016-12-23||1|2016-00-30|C|0||