Spreadsheet: 672087d1586719870-retriving-most-recent-payment-2020-payment-history-test
Sheet: Customer database

No. | Address | OBA No. | SA Lot - Line Status | Occupancy | Builder Code | Development Code | Recent payment date
CU000001 | 12 [NAME] | 643150FF56921ED59FB544F724968400 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000002 | 10 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
[NAME] | 8 [NAME] | 52E007EC2F850544E10000000AAA0C28 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000004 | 6 [NAME] | 543D4F6F780D52EBE10000000AAA0C0D | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000005 | 4 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000006 | 2 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000007 | 41 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000008 | 39 [NAME] | 51D6B2EC081835E6E10000000AAA0C3E | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000009 | 37 [NAME] | 51F26EE862B80E3BE10000000AAA0C11 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000010 | 35 [NAME] | 51FB1A7E582F1B0EE10000000AAA0C2B | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000011 | 33 [NAME] | 51D51ED93F9141CCE10000000AAA0C10 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000012 | 31 [NAME] | 51D49D05DADC0F66E10000000AAA0C28 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000014 | 11 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000015 | 9 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000016 | 7 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000017 | 5 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000018 | 3 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000019 | 26 Wallace Gate | QUARTERLY BILLING | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000020 | 58 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000021 | 60 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000022 | 62 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000023 | 109 Burns Blvd | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000025 | 66 Burning Springs Pl | 5229F3B4C8B12BD4E10000000AAA0C3D | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000026 | 49 Burning Springs Pl | 520A448078646F1FE10000000AAA0C2B | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000027 | 15 Indian Way | 532564F62F2D4925E10000000AAA0C2B | Active | Owner | FOURTEEN ESTATES | INDIAN WAY
CU000028 | 1 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000029 | 64 Burning Springs Pl | 523482790BE054A0E10000000AAA0C3E | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000030 | 60 Burning Springs Pl | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000031 | 81 [NAME] | D89D67C59DCA1EE596DDB16A9DE20900 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000032 | 83 [NAME] | D89D67C59DCA1ED5A1875377282C8502 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000033 | 85 [NAME] | 54C58C10E8DB1765E10000000AAA0C3D | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000034 | 87 [NAME] | 5231DC748ADC3C39E10000000AAA0C10 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000035 | 101 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000036 | 68 [NAME] | 3C4A924803B61ED5948C510649725704 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000037 | 70 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000038 | 72 [NAME] | 54745D1DB3932C0EE10000000AAA0C28 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000039 | 74 [NAME] | 5210BA027E1250ECE10000000AAA0C2B | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000040 | 76 [NAME] | 5217180B1F1B50EAE10000000AAA0C2B | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000042 | 44 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000043 | 42 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000044 | 40 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000045 | 32 [NAME] | 5230A60D092923B8E10000000AAA0C3D | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000046 | 11 Bri Way | 5585EDFCD71F1515E10000000AAA0C0E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000048 | 17 Bri Way | X-ENBRIDGE-TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000049 | 75 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000050 | 73 [NAME] | 52232E37C3226C2BE10000000AAA0C0E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000051 | 11 Burning Springs Pl | 526EBCB76E16511EE10000000AAA0C28 | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000052 | 43 Burning Springs Pl | D89D67C59BF61ED591EBA61754E51C0E | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000053 | 107 Burns Blvd | 523A3FA7877F3BA5E10000000AAA0C3E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000055 | 89 [NAME] | 525F978E561B47C0E10000000AAA0C3E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000056 | 87 [NAME] | 52369DCEC25C3604E10000000AAA0C3E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000057 | 93 [NAME] | D89D67C59DB81ED593B6F74B147DC70A | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000058 | 91 [NAME] | 3C4A924803B61ED599D7EE9F74118006 | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000059 | 83 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000060 | 81 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000061 | 79 [NAME] | 55520C1B92A512B7E10000000AAA0C3D | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000062 | 18 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000063 | 16 Furrow St | 5510BF8BE63C2E02E10000000AAA0C0E | Active | Owner | LINDVEST HOMES | [NAME]
CU000064 | 14 Furrow St | 543438E97B4113D2E10000000AAA0C28 | Active | Owner | LINDVEST HOMES | [NAME]
CU000065 | 10 Furrow St | 5240DDF165665A7BE10000000AAA0C11 | Active | Owner | LINDVEST HOMES | [NAME]
CU000066 | 8 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000067 | 6 Furrow St | 523C9179D88515D0E10000000AAA0C11 | Active | Owner | LINDVEST HOMES | [NAME]
CU000068 | 1 Furrow St | D89D67C5A53E1ED595A35C818FBD5706 | Active | Owner | LINDVEST HOMES | [NAME]
CU000069 | 3 Furrow St | 5236DFA1CDA5359AE10000000AAA0C3D | Active | Owner | LINDVEST HOMES | [NAME]
CU000070 | 5 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000071 | 7 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000072 | 9 [NAME] | 5232E767976D069EE10000000AAA0C11 | Active | Owner | LINDVEST HOMES | [NAME]
CU000073 | 11 Furrow St | 5239E76A4B8B12DAE10000000AAA0C28 | Active | Owner | LINDVEST HOMES | [NAME]
CU000074 | 15 Furrow St | 52618A0EF09B1A04E10000000AAA0C10 | Active | Owner | LINDVEST HOMES | [NAME]
CU000075 | 17 Furrow St | 523094E9BDE0025AE10000000AAA0C28 | Active | Owner | LINDVEST HOMES | [NAME]
CU000076 | 19 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000077 | 21 Furrow St | X-ENBRIDGE TERMINATED | Active | Owner | LINDVEST HOMES | [NAME]
CU000078 | 23 Furrow St | 524EDBB6FB9F0E52E10000000AAA0C28 | Active | Owner | LINDVEST HOMES | [NAME]
CU000079 | 54 Lilly Valley Cres | 525B1B9F2BF75118E10000000AAA0C28 | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000080 | 52 Lilly Valley Cres | 525F9BA6A73247BAE10000000AAA0C3E | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000081 | 10 Nicort Rd | 52847E70E8A22B8AE10000000AAA0C11 | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000082 | 18 Lilly Valley Cres | 5276333F02EE3E3EE10000000AAA0C0E | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000083 | 16 Lilly Valley Cres | D89D67C59DCA1EE59085B6E44898800C | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000084 | 6 Nicort Rd | 528EC5BE924A68A8E10000000AAA0C3D | Active | Owner | ZANCOR HOMES | MARKET COLL PH1
CU000085 | 26 [NAME] | 527E4E7AB364399BE10000000AAA0C10 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000086 | 24 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000087 | 22 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000088 | 20 [NAME] | X-ENBRIDGE-TERMINATED | Active | Assignment | SOLMAR HOMES | PARKVIEW PH1
CU000089 | 18 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000090 | 16 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000091 | 27 [NAME] | 5435DE738F1E3EE8E10000000AAA0C3E | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000092 | 25 [NAME] | X-ENBRIDGE TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000093 | 23 [NAME] | X-ENBRIDGE-TERMINATED | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000094 | 21 [NAME] | 643150FF56921EE58D84AF9C63265A04 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000095 | 19 [NAME] | 523AF2674FA052B5E10000000AAA0C2B | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000096 | 17 [NAME] | 521E3802F2773523E10000000AAA0C10 | Active | Owner | SOLMAR HOMES | PARKVIEW PH1
CU000097 | 18 Burning Springs Pl | 529A640ED18A69B6E10000000AAA0C0E | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000098 | 14 Burning Springs Pl | 527C85F672E60560E10000000AAA0C28 | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000099 | 3 Burning Springs Pl | X-ENBRIDGE TERMINATED | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000100 | 7 Burning Springs Pl | 52567BCA4C632792E10000000AAA0C11 | Active | Owner | ZANCOR HOMES | BROOKLINS FOREST 123
CU000102 | 116 Burns Blvd | 5262E7640FF51C86E10000000AAA0C0E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000104 | 24 [NAME] | 5252FCB237DB522EE10000000AAA0C2B | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000106 | 4 Bri way | D89D67C59F321EE59084DA393CC4CF06 | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1
CU000107 | 2 Bri way | 534B8D34F4072163E10000000AAA0C3E | Active | Owner | ZANCOR HOMES | ROYAL COLLECTION PH1