Ask Your Question

Revision history [back]

Pensacola - ClostDT < ListDT SoldListing

Hi, We just converted to Pensacola RETS provider from different vendor. For the following sold listings we are getting CloseDate earlier than ListDate. Could you please let us know if this something that can be fixed.

We use the following credentials - URL - parmls.rets.paragonrels.com/rets/fnisrets.aspx/PARMLS/login Username - NRT2

    mlsnum  closedate   listdate    contractdate
336489  9/6/2007    9/7/2007    NULL
346127  2/15/2007   1/1/2008    NULL
370921  6/4/2009    6/5/2009    NULL
392902  5/15/2009   3/30/2010   NULL
405517  3/15/2011   3/17/2011   NULL
412771  7/26/2011   8/2/2011    NULL
451352  9/9/2013    9/19/2013   NULL
451864  9/27/2013   10/1/2013   NULL
466184  7/3/2014    7/16/2014   6/3/2014
477967  7/3/2014    3/12/2015   6/3/2014
485200  7/14/2015   7/21/2015   6/3/2014
495986  3/4/2016    3/7/2016    2/17/2016
498732  4/14/2016   4/26/2016   6/3/2014
508670  11/4/2016   11/8/2016   11/4/2016

mlsnum  closedate   listdate    contractdate
539765  7/18/2018   7/23/2018   6/1/2018
438657  11/13/2012  2/6/2013    NULL
277389  1/14/2005   4/22/2005   NULL
335574  4/25/2007   8/22/2007   NULL
524406  9/5/2017    9/22/2017   7/1/2017
261086  4/16/2004   4/19/2004   NULL
413571  8/8/2011    8/16/2011   NULL
528128  12/12/2017  12/14/2017  12/12/2017
318308  5/25/2006   12/21/2006  NULL
263182  8/30/2002   6/1/2004    NULL
450075  10/4/2012   8/28/2013   NULL
502428  6/30/2016   7/5/2016    2/29/2016
502422  6/30/2016   7/5/2016    3/7/2016
410327  9/9/2010    6/16/2011   8/24/2011
253026  9/22/2003   10/10/2003  NULL
283410  6/29/2005   7/29/2005   NULL
435403  1/25/2012   11/12/2012  1/4/2013
531869  3/2/2018    3/5/2018    1/12/2018
381881  10/29/2009  1/4/2010    NULL
441670  4/1/2013    4/2/2013    NULL
441291  3/21/2013   3/26/2013   NULL
412844  7/27/2011   8/3/2011    NULL
436432  12/4/2012   12/17/2012  NULL
347920  6/4/2007    3/31/2008   NULL
442214  2/22/2013   4/10/2013   NULL
438300  1/28/2013   1/30/2013   NULL
347923  5/14/2007   3/21/2008   NULL
347911  9/11/2007   3/31/2008   NULL
435190  10/29/2012  11/14/2012  NULL
429546  4/3/2012    7/18/2012   NULL
435192  11/5/2012   11/14/2012  NULL
435193  11/5/2012   11/14/2012  NULL
437317  12/17/2012  1/11/2013   NULL
438347  1/30/2013   1/31/2013   NULL
438345  1/30/2013   1/31/2013   NULL
439837  2/20/2013   2/28/2013   NULL
391840  6/11/2010   6/17/2010   NULL
429522  4/12/2012   7/17/2012   NULL
438155  1/16/2013   1/28/2013   NULL
442223  3/29/2013   4/10/2013   NULL
431101  8/8/2012    8/16/2012   NULL
441664  4/1/2013    4/2/2013    NULL
439090  2/4/2013    2/14/2013   NULL
435174  10/15/2012  11/13/2012  NULL
439846  2/25/2013   2/28/2013   NULL
439849  2/25/2013   2/28/2013   NULL
437247  12/17/2012  1/10/2013   NULL
435188  10/15/2012  11/14/2012  NULL
442710  4/15/2013   4/19/2013   NULL
439850  2/25/2013   2/28/2013   NULL
347924  4/23/2007   3/31/2008   NULL
440198  3/4/2013    3/6/2013    NULL
440212  3/4/2013    3/6/2013    NULL
441272  3/21/2013   3/26/2013   NULL
440182  3/4/2013    3/6/2013    NULL
347852  11/7/2007   3/28/2008   NULL
442963  4/22/2013   4/24/2013   NULL
392913  4/15/2010   7/6/2010    NULL
411633  6/30/2011   7/12/2011   NULL
347916  6/22/2007   3/31/2008   NULL
429520  4/18/2012   7/17/2012   NULL
416476  9/30/2011   10/11/2011  NULL
416752  10/7/2011   10/18/2011  NULL
435189  10/29/2012  11/14/2012  NULL
440525  3/7/2013    3/12/2013   NULL
440217  3/4/2013    3/6/2013    NULL
347921  6/4/2007    3/21/2008   NULL
442706  4/15/2013   4/19/2013   NULL
347927  2/13/2007   3/31/2008   NULL
429548  4/2/2012    7/18/2012   NULL
429526  4/9/2012    7/17/2012   NULL
352181  1/30/2008   6/10/2008   NULL
496058  3/7/2016    3/8/2016    3/7/2016
485841  7/16/2015   7/31/2015   6/26/2015
390637  5/13/2009   4/16/2010   NULL
240595  2/10/2002   1/10/2003   NULL
364326  11/1/2008   1/30/2009   NULL
334646  1/22/2007   7/24/2007   8/21/2007
295074  1/6/2006    1/20/2006   NULL
310802  1/6/2006    7/24/2006   NULL
338132  2/22/2007   10/6/2007   NULL
270323  8/1/2004    11/12/2004  NULL
415565  9/1/2011    9/21/2011   NULL
333340  1/4/2007    7/23/2007   12/14/2007
502424  6/30/2016   7/5/2016    3/7/2016
393306  12/28/2009  12/30/2009  NULL
418361  8/29/2011   11/21/2011  NULL
291213  10/21/2005  11/15/2005  NULL
275654  6/15/2004   3/22/2005   NULL
278578  5/2/2005    5/4/2005    NULL
332148  3/20/2007   6/28/2007   2/2/2007
375654  8/7/2009    8/30/2009   NULL
450782  5/1/2013    8/1/2013    NULL
468103  6/11/2014   8/21/2014   5/29/2014
445267  6/1/2013    6/3/2013    NULL
468101  4/30/2014   8/21/2014   3/29/2014
468102  7/10/2014   8/21/2014   6/1/2014
347918  6/15/2007   3/31/2008   NULL
439092  2/4/2013    2/14/2013   NULL
441241  3/21/2013   3/26/2013   NULL
440523  3/7/2013    3/12/2013   NULL
439892  2/25/2013   3/1/2013    NULL
429566  3/7/2012    7/18/2012   NULL
431098  8/6/2012    8/16/2012   NULL
429648  5/21/2012   7/19/2012   NULL
347925  4/19/2007   3/21/2008   NULL
438152  1/23/2013   1/28/2013   NULL
431114  8/13/2012   8/16/2012   NULL
431095  8/2/2012    8/16/2012   NULL
438309  1/28/2013   1/30/2013   NULL
436433  11/21/2012  12/17/2012  NULL
439260  2/13/2013   2/18/2013   NULL
391842  6/9/2010    6/17/2010   NULL
438317  1/8/2013    1/30/2013   NULL
429552  3/20/2012   7/18/2012   NULL
429649  6/22/2012   7/19/2012   NULL
439851  2/25/2013   2/28/2013   NULL
442721  4/16/2013   4/19/2013   NULL
442736  4/16/2013   4/19/2013   NULL
441276  3/21/2013   3/26/2013   NULL
435169  10/12/2012  11/13/2012  NULL
381458  9/28/2009   12/21/2009  NULL
347914  8/5/2007    3/31/2008   NULL
347913  8/6/2007    3/31/2008   NULL
412845  4/21/2011   8/3/2011    NULL
408706  3/7/2011    5/17/2011   NULL
407364  6/20/2001   4/20/2011   6/9/2011
240552  1/5/2003    1/9/2003    NULL
431088  8/1/2012    8/16/2012   NULL
442970  4/22/2013   4/24/2013   NULL
438313  1/8/2013    1/30/2013   NULL
416473  9/30/2011   10/11/2011  NULL
438315  1/8/2013    1/30/2013   NULL
441269  3/21/2013   3/26/2013   NULL
441281  3/21/2013   3/26/2013   NULL
439812  2/19/2013   2/28/2013   NULL
429564  3/12/2012   7/18/2012   NULL
429647  5/18/2012   7/19/2012   NULL
429650  6/29/2012   7/19/2012   NULL
429551  3/29/2012   7/18/2012   NULL
412847  4/21/2011   8/3/2011    NULL
347922  6/4/2007    3/31/2008   NULL
442212  1/25/2013   4/10/2013   NULL
441275  3/21/2013   3/26/2013   NULL
441290  3/21/2013   3/26/2013   NULL
429652  7/6/2012    7/19/2012   NULL
442979  4/22/2013   4/24/2013   NULL
539215  7/12/2018   7/13/2018   6/8/2018

mlsnum  closedate   listdate    contractdate
269350  1/7/2004    10/13/2004  NULL
288839  9/30/2005   10/11/2005  NULL
319149  6/6/2006    9/9/2006    NULL
529975  1/29/2018   1/30/2018   12/30/2017

mlsnum  closedate   listdate    contractdate
539144  7/10/2018   7/12/2018   6/8/2018
538075  6/18/2018   6/21/2018   4/23/2018
536559  5/23/2018   5/24/2018   4/22/2018
535156  4/26/2018   4/27/2018   1/27/2018
536864  5/29/2018   5/30/2018   2/21/2018
538709  6/22/2018   7/3/2018    5/22/2018
293527  7/28/2005   10/30/2005  NULL
378400  9/2/2009    10/19/2009  NULL
270095  1/31/2004   11/5/2004   NULL
444075  7/12/2012   5/10/2013   6/21/2013
530632  2/8/2018    2/10/2018   1/7/2018
327001  2/14/2007   4/12/2007   NULL
372564  8/14/2008   7/7/2009    7/16/2009
508818  11/10/2016  11/11/2016  10/11/2016
457893  2/10/2014   2/11/2014   10/31/2013
218124  1/2/2001    10/11/2001  12/1/2001
427493  7/17/2010   5/16/2012   NULL
479473  3/15/2015   4/8/2015    2/15/2015
477597  1/23/2015   2/6/2015    12/10/2014
284620  5/16/2005   8/16/2005   NULL
316383  10/31/2006  11/13/2006  NULL
481688  5/15/2015   5/18/2015   5/1/2015
465211  7/3/2014    7/4/2014    5/8/2014
458962  2/26/2014   3/4/2014    12/3/2013
489273  9/25/2015   10/8/2015   8/4/2015
513451  5/6/2016    2/25/2017   3/8/2016
502642  6/22/2016   7/8/2016    5/9/2016
362863  1/31/2008   12/4/2008   NULL
486922  8/14/2015   8/20/2015   7/17/2015
514623  3/14/2017   3/17/2017   1/22/2017
445710  5/31/2013   6/11/2013   NULL
442395  7/19/2012   4/13/2013   NULL
429343  5/3/2012    6/28/2012   NULL
389122  1/29/2010   4/30/2010   NULL
430369  1/28/2012   8/3/2012    NULL
334827  7/27/2007   8/12/2007   NULL
334861  8/9/2007    8/12/2007   NULL
334822  7/16/2007   8/12/2007   NULL
334818  7/11/2007   8/12/2007   NULL
334884  7/27/2007   8/12/2007   NULL
334817  7/24/2007   8/11/2007   NULL
334824  8/4/2007    8/12/2007   NULL
334881  7/31/2007   8/12/2007   NULL
334886  7/16/2007   8/11/2007   NULL
342310  9/21/2007   9/24/2007   NULL
334873  8/10/2007   8/12/2007   NULL
474686  3/5/2014    1/12/2015   2/6/2014
280750  5/29/2005   6/15/2005   NULL
430371  5/14/2012   8/3/2012    NULL
371688  4/28/2009   5/30/2009   6/1/2009
332941  1/28/2007   7/18/2007   1/8/2008
321284  5/1/2006    2/5/2007    NULL
362821  6/20/2008   7/7/2008    NULL
441790  3/8/2013    4/3/2013    NULL
272562  1/19/2005   1/20/2005   NULL
427762  1/9/2012    6/5/2012    NULL
514227  3/7/2017    3/10/2017   1/16/2017
509829  11/7/2016   12/7/2016   10/31/2016
516834  4/14/2017   4/28/2017   2/27/2017
354633  7/15/2008   7/18/2008   NULL
372276  9/18/2006   7/1/2009    9/14/2009
335246  3/24/2007   8/13/2007   9/14/2007
279923  5/27/2005   6/4/2005    NULL
444359  6/11/2003   5/17/2013   NULL
502895  6/30/2016   7/13/2016   3/4/2016
485622  7/21/2015   7/24/2015   1/31/2015
450496  10/19/2012  3/1/2013    NULL
297981  2/22/2005   2/1/2006    NULL
430027  3/30/2012   7/27/2012   NULL
410342  6/10/2011   6/14/2011   NULL
324134  3/8/2007    3/10/2007   NULL
342977  3/28/2007   1/11/2008   3/27/2008
514462  3/3/2017    3/15/2017   1/5/2017
365598  5/1/2008    2/23/2009   3/15/2009
320979  1/30/2007   2/2/2007    NULL
482089  5/22/2015   5/26/2015   11/6/2014
468611  8/29/2014   9/2/2014    8/13/2014
496207  3/7/2016    3/10/2016   9/10/2015
394860  1/10/2010   8/6/2010    NULL
274687  3/3/2004    9/5/2004    NULL
257403  1/26/2004   1/29/2004   NULL
383860  11/20/2009  2/5/2010    NULL
287022  1/27/2005   9/19/2005   NULL
510738  12/7/2016   12/30/2016  9/15/2016
524411  9/21/2017   9/22/2017   7/26/2017
421166  11/2/2011   1/31/2012   1/31/2012
358783  1/31/2008   10/1/2008   NULL
275407  4/29/2004   3/14/2005   NULL
478706  3/20/2015   3/24/2015   2/13/2015
401761  2/22/2010   12/15/2010  1/20/2011
336713  3/7/2007    9/10/2007   2/27/2008
276551  2/16/2005   4/6/2005    NULL
513212  1/21/2017   2/21/2017   1/11/2017
338933  1/31/2006   10/22/2007  NULL
410848  7/27/2010   6/1/2011    NULL
219172  1/23/2001   11/1/2001   NULL
517874  5/12/2017   5/17/2017   4/4/2017
508667  11/4/2016   11/8/2016   10/3/2016
396691  8/5/2010    8/27/2010   NULL
458404  2/7/2014    2/20/2014   7/10/2013
488580  9/16/2015   9/25/2015   9/8/2015
397993  2/15/2010   3/28/2010   10/4/2010
428867  6/29/2012   7/4/2012    NULL
445760  4/3/2013    6/11/2013   NULL
375693  8/31/2009   9/1/2009    9/2/2009
445215  5/28/2013   6/3/2013    NULL
318418  5/23/2006   12/26/2006  NULL
514016  5/5/2016    3/8/2017    8/18/2015
431697  8/21/2012   8/30/2012   NULL
470475  6/3/2014    10/8/2014   8/12/2013
458154  11/8/2013   2/13/2014   4/21/2013
527349  12/30/2016  11/24/2017  11/21/2016
400379  6/30/2001   8/27/2010   4/5/2011
508036  7/12/2016   10/25/2016  9/21/2015
438137  8/10/2012   8/16/2012   NULL
391263  5/24/2010   6/8/2010    NULL
431124  6/8/2010    8/9/2012    NULL
457375  1/20/2014   1/31/2014   8/20/2013
271352  11/22/2004  12/16/2004  NULL
232602  3/9/2002    4/16/2002   NULL
496535  3/15/2016   3/16/2016   2/20/2016
402189  2/16/2010   1/12/2011   1/24/2011
434781  4/25/2012   11/2/2012   NULL
337539  9/4/2007    9/26/2007   NULL
531142  2/20/2018   2/21/2018   2/1/2018
470462  12/19/2013  10/7/2014   11/17/2013
510778  12/19/2016  1/3/2017    5/17/2016
368075  3/26/2009   4/10/2009   NULL
292987  2/15/2005   12/14/2005  NULL
345365  5/6/2007    2/14/2008   4/27/2008
523662  9/5/2017    9/6/2017    9/23/2016
492023  4/30/2015   9/12/2015   9/3/2014
424255  3/15/2012   4/2/2012    NULL
290486  11/2/2005   11/4/2005   NULL
494876  12/18/2015  2/15/2016   5/30/2015
516774  3/30/2017   4/26/2017   3/2/2017
498702  3/17/2016   4/25/2016   6/30/2015
432298  1/11/2012   8/31/2012   NULL
484191  6/30/2015   7/1/2015    1/21/2015
483655  1/9/2015    6/16/2015   11/16/2014
496360  3/11/2016   3/14/2016   3/11/2016
482468  5/29/2015   6/1/2015    5/16/2015
435520  1/29/2012   11/21/2012  NULL
341972  9/10/2007   10/26/2007  NULL
422965  3/2/2012    3/6/2012    NULL
480586  4/10/2015   4/19/2015   3/13/2015
496735  3/18/2016   3/21/2016   2/11/2016
514967  3/23/2017   3/24/2017   5/24/2016
508354  10/31/2016  11/1/2016   2/29/2016
465483  6/30/2014   7/1/2014    11/4/2013
314550  6/30/2006   10/17/2006  NULL
261181  4/16/2004   4/20/2004   NULL
314548  7/28/2006   10/17/2006  NULL
417878  1/18/2011   11/9/2011   11/13/2011
410998  6/25/2011   6/29/2011   NULL
435930  1/25/2012   12/3/2012   12/10/2012
530736  2/12/2018   2/13/2018   1/12/2018
479556  3/25/2015   4/10/2015   3/25/2015
284621  7/22/2005   8/16/2005   NULL
341618  4/27/2007   11/16/2007  12/12/2007
457420  1/31/2014   2/1/2014    8/27/2013
440170  10/3/2012   3/6/2013    3/6/2013
490022  10/19/2015  10/21/2015  9/19/2015
523395  8/27/2017   8/30/2017   7/20/2017
454620  11/20/2013  11/25/2013  3/17/2013
362820  5/22/2008   5/29/2008   NULL
304598  3/16/2006   5/23/2006   NULL
304480  2/14/2006   5/23/2006   NULL
274340  1/25/2005   1/28/2005   NULL
291070  10/31/2005  11/14/2005  NULL
431543  1/31/2012   8/24/2012   1/16/2013
378401  8/25/2009   10/19/2009  NULL
255212  9/29/2001   12/8/2003   NULL
268923  9/30/2004   10/1/2004   NULL
319325  1/4/2007    1/10/2007   NULL
293326  4/3/2004    12/26/2005  NULL
509469  11/11/2016  11/29/2016  11/11/2016
302583  7/10/2003   4/25/2006   NULL
352234  10/23/2004  6/11/2008   9/12/2008
454805  11/30/2013  12/2/2013   10/3/2013
518629  5/26/2017   5/30/2017   3/3/2017
438400  1/15/2013   2/1/2013    NULL
424728  4/4/2012    4/11/2012   NULL
358300  9/19/2008   9/25/2008   NULL
326533  4/16/2007   4/17/2007   NULL
501055  3/13/2016   6/7/2016    12/30/2015
531887  3/2/2018    3/5/2018    12/18/2017
336177  4/11/2007   9/1/2007    10/11/2007
378750  10/20/2009  10/25/2009  NULL
456595  3/31/2014   4/13/2014   1/27/2014
265615  7/8/2004    7/19/2004   NULL
473929  11/10/2014  12/17/2014  9/12/2014
517937  5/17/2017   5/18/2017   4/10/2017
408675  5/11/2011   5/16/2011   NULL
269429  10/4/2004   10/18/2004  NULL
479715  4/9/2015    4/10/2015   3/3/2015
366539  1/12/2009   3/8/2009    12/10/2009
408846  5/5/2011    5/19/2011   NULL
346737  3/6/2008    3/10/2008   NULL
334825  8/7/2007    8/12/2007   NULL
334820  8/6/2007    8/11/2007   NULL
334882  7/27/2007   8/12/2007   NULL
422169  2/15/2012   2/20/2012   NULL
334864  8/9/2007    8/12/2007   NULL
259478  3/15/2004   3/18/2004   NULL
411039  6/6/2011    6/30/2011   NULL
519880  6/15/2017   6/23/2017   5/3/2017
534165  4/12/2018   4/13/2018   2/27/2018
456417  11/27/2013  1/11/2014   6/27/2013
408008  11/10/2001  4/15/2011   8/20/2011
516725  3/17/2017   4/26/2017   2/7/2017
469883  3/24/2014   9/26/2014   10/24/2013
416310  9/15/2011   10/6/2011   NULL
323512  2/28/2007   3/7/2007    NULL
309642  8/4/2006    8/7/2006    NULL
513115  2/15/2017   2/18/2017   9/23/2016
473931  11/26/2014  12/16/2014  10/28/2014
418228  2/8/2011    11/17/2011  1/30/2012
506274  9/9/2016    9/16/2016   8/1/2016
362007  1/5/2008    12/3/2008   12/23/2008
442355  3/31/2013   4/11/2013   5/19/2013
429426  6/29/2012   7/16/2012   NULL
437466  9/23/2012   1/14/2013   NULL
424969  5/31/2010   4/5/2012    4/17/2012
307749  10/5/2005   7/6/2006    NULL
430738  1/16/2012   8/6/2012    NULL
279922  5/27/2005   6/4/2005    NULL
453013  9/30/2013   10/22/2013  NULL
278499  5/2/2005    5/11/2005   NULL
386058  5/17/2009   3/10/2010   4/5/2010
286946  1/17/2005   9/1/2005    NULL
284618  5/22/2005   8/16/2005   NULL
310765  6/28/2006   8/22/2006   NULL
474920  12/30/2014  1/15/2015   7/29/2014
506000  9/9/2016    9/12/2016   8/19/2016
468116  8/5/2014    8/21/2014   4/3/2014
450497  10/18/2012  7/10/2013   NULL
422318  2/17/2012   2/22/2012   NULL
428370  7/11/2011   6/24/2012   6/27/2012
429424  7/12/2012   7/16/2012   NULL
429772  7/16/2012   7/22/2012   NULL
491155  8/4/2015    9/12/2015   2/3/2015
522232  8/4/2017    8/8/2017    2/21/2017
419729  1/12/2011   12/20/2011  NULL
408905  9/1/2001    5/20/2011   NULL
528291  11/30/2017  12/19/2017  10/29/2017
445611  6/1/2013    6/8/2013    NULL
244690  3/31/2003   4/11/2003   NULL
438589  12/28/2012  2/5/2013    NULL
213128  6/29/2001   7/11/2001   NULL
282066  2/7/2005    7/7/2005    NULL
450494  10/18/2012  9/1/2013    NULL
318421  6/29/2006   12/26/2006  NULL
316680  10/31/2006  11/20/2006  NULL
219169  5/25/2001   11/1/2001   NULL
501650  6/15/2016   6/20/2016   11/30/2015
336702  3/31/2007   9/10/2007   3/14/2008
397995  1/15/2010   3/28/2010   10/4/2010
463655  5/2/2014    5/28/2014   3/2/2014
431493  1/10/2012   8/24/2012   NULL
269243  10/11/2004  10/13/2004  NULL
276237  4/1/2005    4/4/2005    NULL
330121  1/25/2007   6/1/2007    12/27/2007
277984  5/2/2005    5/3/2005    NULL
323900  5/1/2006    3/12/2007   NULL
495789  2/29/2016   3/3/2016    10/22/2015
536174  5/14/2018   5/16/2018   3/27/2018
392625  6/29/2010   7/1/2010    NULL
446585  6/6/2013    6/27/2013   NULL
391262  5/21/2010   6/8/2010    NULL
446326  5/24/2013   6/21/2013   NULL
521098  6/6/2017    7/17/2017   6/24/2016
384952  1/10/2010   2/23/2010   NULL
291158  3/20/2005   11/14/2005  NULL
459977  3/10/2014   11/1/2014   1/1/2014
408856  4/28/2011   5/19/2011   NULL
477541  2/27/2015   3/4/2015    1/13/2015
481499  5/12/2015   5/13/2015   9/24/2014
461351  3/19/2014   4/16/2014   3/14/2014
524993  9/29/2017   10/2/2017   7/13/2017
361564  1/23/2008   11/28/2008  1/5/2009
500947  3/7/2016    6/6/2016    2/7/2016
432060  1/31/2012   9/6/2012    11/18/2012
492022  2/25/2015   9/12/2015   9/18/2014
209833  4/30/2001   5/15/2001   NULL
510109  12/12/2016  12/13/2016  11/13/2016
528490  12/22/2017  12/27/2017  11/20/2017
437971  4/16/2002   1/24/2013   NULL
363823  4/14/2008   1/20/2009   2/28/2009
367891  7/17/2007   4/4/2009    5/14/2009
246019  5/1/2003    5/11/2003   NULL
502910  6/16/2016   7/13/2016   5/9/2016
359432  1/1/2008    10/13/2008  11/3/2008
486701  9/23/2014   8/14/2015   8/15/2014
333488  5/25/2007   7/23/2007   NULL
527152  11/17/2017  11/18/2017  4/3/2017
455499  5/20/2013   6/1/2013    4/8/2013
392360  2/11/2010   6/25/2010   1/28/2011
423419  3/8/2012    3/15/2012   NULL
443406  4/1/2013    4/30/2013   NULL
494802  5/29/2015   2/3/2016    11/16/2014
337558  12/28/2006  9/27/2007   NULL
466039  6/30/2014   7/13/2014   5/22/2014
442910  6/3/2010    4/22/2013   5/9/2013
279834  4/9/2005    6/2/2005    NULL
350154  5/5/2008    5/6/2008    NULL
457428  1/30/2014   2/1/2014    8/21/2013
304786  2/24/2006   3/1/2006    NULL
263411  5/19/2004   6/4/2004    NULL
534587  4/17/2018   4/19/2018   3/2/2018
539293  7/13/2018   7/15/2018   6/25/2018
537295  5/25/2018   6/6/2018    4/24/2018
535647  5/7/2018    5/8/2018    3/27/2018
539931  7/23/2018   7/25/2018   2/13/2018
537511  6/8/2018    6/11/2018   5/1/2018