-
Notifications
You must be signed in to change notification settings - Fork 1
/
contacts.sql
5227 lines (5190 loc) · 232 KB
/
contacts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 15, 2018 at 12:32 AM
-- Server version: 5.6.34-log
-- PHP Version: 7.1.5
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `contacts`
--
DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `contacts_sp` (IN `fname` VARCHAR(100), IN `mname` VARCHAR(100), IN `lname` VARCHAR(100), OUT `out_param` INT(11)) BEGIN
INSERT INTO contact (Fname, Mname, Lname) VALUES (fname,mname,lname);
SET out_param = LAST_INSERT_ID();
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Table structure for table `address`
--
CREATE TABLE `address` (
`address_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
`address_type` varchar(15) NOT NULL,
`address` varchar(200) NOT NULL,
`City` varchar(100) NOT NULL,
`State` varchar(100) NOT NULL,
`Zip` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `address`
--
INSERT INTO `address` (`address_id`, `contact_id`, `address_type`, `address`, `City`, `State`, `Zip`) VALUES
(1, 1, 'home', '', '', '', 75018),
(2, 2, 'home', '2287 Sutteridge Park', 'Dallas', 'Texas', 75062),
(3, 3, 'home', '', '', '', 75029),
(4, 4, 'home', '', '', '', 75099),
(5, 5, 'home', '62477 Hovde Hill', 'Allen', 'Texas', 75061),
(6, 6, 'home', '06 Heffernan Center', 'Richardson', 'Texas', 0),
(7, 7, 'home', '', '', '', 75031),
(9, 9, 'home', '626 Orin Center', 'Addison', 'Texas', 0),
(10, 10, 'home', '6687 Dottie Plaza', 'Richardson', 'Texas', 75027),
(11, 11, 'home', '8 Luster Terrace', 'Dallas', 'Texas', 75059),
(12, 12, 'home', '', '', '', 75076),
(13, 13, 'home', '15 Jackson Lane', 'Allen', 'Texas', 75013),
(14, 14, 'home', '79254 Pond Center', 'Dallas', 'Texas', 75083),
(15, 15, 'home', '9 Logan Parkway', 'Dallas', 'Texas', 75078),
(16, 16, 'home', '65052 Heath Point', 'Plano', 'Texas', 75046),
(17, 17, 'home', '', '', '', 75005),
(18, 18, 'home', '8 Fuller Road', 'Addison', 'Texas', 75088),
(19, 19, 'home', '1961 Division Hill', 'Addison', 'Texas', 0),
(20, 20, 'home', '', '', '', 75042),
(21, 21, 'home', '', '', '', 75060),
(22, 22, 'home', '528 Main Junction', 'Dallas', 'Texas', 75046),
(23, 23, 'home', '9086 Sommers Crossing', 'Richardson', 'Texas', 0),
(24, 24, 'home', '', '', '', 75099),
(25, 25, 'home', '83 Shoshone Parkway', 'Plano', 'Texas', 75046),
(26, 26, 'home', '333 Scoville Hill', 'Allen', 'Texas', 75091),
(27, 27, 'home', '18894 Division Lane', 'Richardson', 'Texas', 75083),
(28, 28, 'home', '250 2nd Drive', 'Richardson', 'Texas', 0),
(29, 29, 'home', '85701 Basil Road', 'Allen', 'Texas', 75004),
(30, 30, 'home', '23 Kings Lane', 'Plano', 'Texas', 75086),
(31, 31, 'home', '4 Maple Trail', 'Richardson', 'Texas', 0),
(32, 32, 'home', '504 Bayside Pass', 'Dallas', 'Texas', 75060),
(33, 33, 'home', '', '', '', 75009),
(34, 34, 'home', '26 Towne Road', 'Richardson', 'Texas', 75047),
(35, 35, 'home', '9324 Onsgard Parkway', 'Dallas', 'Texas', 0),
(36, 36, 'home', '016 Oak Valley Parkway', 'Dallas', 'Texas', 0),
(37, 37, 'home', '660 Truax Way', 'Dallas', 'Texas', 75037),
(38, 38, 'home', '75903 Linden Circle', 'Plano', 'Texas', 75045),
(39, 39, 'home', '36 Alpine Drive', 'Richardson', 'Texas', 0),
(40, 40, 'home', '6 Muir Circle', 'Dallas', 'Texas', 75078),
(41, 41, 'home', '5395 Becker Drive', 'Plano', 'Texas', 75011),
(42, 42, 'home', '4585 Bluestem Avenue', 'Plano', 'Texas', 75013),
(43, 43, 'home', '9 Orin Alley', 'Richardson', 'Texas', 75002),
(44, 44, 'home', '9274 Spohn Hill', 'Dallas', 'Texas', 75041),
(45, 45, 'home', '34 Northfield Plaza', 'Dallas', 'Texas', 75061),
(46, 46, 'home', '825 Dixon Lane', 'Dallas', 'Texas', 75030),
(47, 47, 'home', '', '', '', 0),
(48, 48, 'home', '', '', '', 75071),
(49, 49, 'home', '160 Grasskamp Park', 'Allen', 'Texas', 75011),
(50, 50, 'home', '', '', '', 0),
(51, 51, 'home', '3681 Schmedeman Park', 'Allen', 'Texas', 75010),
(52, 52, 'home', '1330 Thackeray Junction', 'Plano', 'Texas', 75002),
(53, 53, 'home', '70 Gina Point', 'Richardson', 'Texas', 0),
(54, 54, 'home', '0 Golf View Plaza', 'Dallas', 'Texas', 75095),
(55, 55, 'home', '22839 Stuart Park', 'Richardson', 'Texas', 75074),
(56, 56, 'home', '92 Elmside Way', 'Plano', 'Texas', 0),
(57, 57, 'home', '589 Mccormick Parkway', 'Dallas', 'Texas', 75067),
(58, 58, 'home', '56378 Talisman Drive', 'Allen', 'Texas', 75032),
(59, 59, 'home', '99570 Bayside Parkway', 'Allen', 'Texas', 0),
(60, 60, 'home', '99687 Jenna Circle', 'Richardson', 'Texas', 75016),
(61, 61, 'home', '9028 Carberry Avenue', 'Addison', 'Texas', 75011),
(62, 62, 'home', '55 Del Mar Hill', 'Allen', 'Texas', 75017),
(63, 63, 'home', '', '', '', 75041),
(64, 64, 'home', '', '', '', 0),
(65, 65, 'home', '72772 Northfield Way', 'Dallas', 'Texas', 75002),
(66, 66, 'home', '11 Donald Plaza', 'Allen', 'Texas', 75048),
(67, 67, 'home', '67412 Sundown Parkway', 'Addison', 'Texas', 0),
(68, 68, 'home', '3 Moulton Junction', 'Addison', 'Texas', 75049),
(69, 69, 'home', '434 Farwell Plaza', 'Plano', 'Texas', 75059),
(70, 70, 'home', '08 Fremont Road', 'Allen', 'Texas', 75048),
(71, 71, 'home', '1251 Graceland Point', 'Dallas', 'Texas', 75051),
(72, 72, 'home', '', '', '', 75023),
(73, 73, 'home', '86545 Tennyson Crossing', 'Richardson', 'Texas', 75064),
(74, 74, 'home', '1430 Linden Way', 'Addison', 'Texas', 75040),
(75, 75, 'home', '2268 Nancy Lane', 'Richardson', 'Texas', 75081),
(76, 76, 'home', '', '', '', 75022),
(77, 77, 'home', '840 Kingsford Parkway', 'Richardson', 'Texas', 75073),
(78, 78, 'home', '4 Sunbrook Avenue', 'Addison', 'Texas', 75067),
(79, 79, 'home', '8735 Bultman Circle', 'Dallas', 'Texas', 75094),
(80, 80, 'home', '65183 Delladonna Avenue', 'Allen', 'Texas', 75079),
(81, 81, 'home', '89640 Cody Terrace', 'Richardson', 'Texas', 0),
(82, 82, 'home', '12 Butternut Terrace', 'Richardson', 'Texas', 75006),
(83, 83, 'home', '204 Farwell Avenue', 'Plano', 'Texas', 75074),
(84, 84, 'home', '1 Anhalt Junction', 'Dallas', 'Texas', 0),
(85, 85, 'home', '933 Debra Terrace', 'Allen', 'Texas', 75021),
(86, 86, 'home', '4265 Mayer Junction', 'Plano', 'Texas', 75053),
(87, 87, 'home', '46 Oakridge Avenue', 'Richardson', 'Texas', 75059),
(88, 88, 'home', '71 Jay Terrace', 'Plano', 'Texas', 75055),
(89, 89, 'home', '598 Elmside Drive', 'Dallas', 'Texas', 75067),
(90, 90, 'home', '', '', '', 75001),
(91, 91, 'home', '421 8th Drive', 'Addison', 'Texas', 75004),
(92, 92, 'home', '', '', '', 75047),
(93, 93, 'home', '27 Talmadge Park', 'Plano', 'Texas', 75034),
(94, 94, 'home', '801 Pleasure Trail', 'Addison', 'Texas', 75057),
(95, 95, 'home', '2449 Pepper Wood Court', 'Plano', 'Texas', 75055),
(96, 96, 'home', '79761 Carioca Point', 'Allen', 'Texas', 0),
(97, 97, 'home', '', '', '', 75093),
(98, 98, 'home', '', '', '', 75033),
(99, 99, 'home', '27015 Nelson Parkway', 'Richardson', 'Texas', 0),
(100, 100, 'home', '470 Derek Plaza', 'Richardson', 'Texas', 75013),
(101, 101, 'home', '622 Iowa Terrace', 'Allen', 'Texas', 75086),
(102, 102, 'home', '', '', '', 75097),
(103, 103, 'home', '8 Colorado Alley', 'Dallas', 'Texas', 75094),
(104, 104, 'home', '4 Dwight Court', 'Richardson', 'Texas', 75072),
(105, 105, 'home', '7 Sugar Parkway', 'Richardson', 'Texas', 75014),
(106, 106, 'home', '5221 Pearson Parkway', 'Addison', 'Texas', 0),
(107, 107, 'home', '80 Welch Street', 'Allen', 'Texas', 75061),
(108, 108, 'home', '3 Derek Alley', 'Richardson', 'Texas', 0),
(109, 109, 'home', '', '', '', 75003),
(110, 110, 'home', '1409 Loftsgordon Alley', 'Plano', 'Texas', 75003),
(111, 111, 'home', '3188 Fieldstone Circle', 'Plano', 'Texas', 75072),
(112, 112, 'home', '', '', '', 0),
(113, 113, 'home', '', '', '', 0),
(114, 114, 'home', '86 Welch Parkway', 'Allen', 'Texas', 0),
(115, 115, 'home', '210 Victoria Hill', 'Allen', 'Texas', 0),
(116, 116, 'home', '', '', '', 0),
(117, 117, 'home', '19886 Pine View Terrace', 'Addison', 'Texas', 75056),
(118, 118, 'home', '24 Welch Avenue', 'Plano', 'Texas', 75031),
(119, 119, 'home', '0 Karstens Way', 'Allen', 'Texas', 75088),
(120, 120, 'home', '8101 Jenna Court', 'Dallas', 'Texas', 75085),
(121, 121, 'home', '24 Doe Crossing Court', 'Dallas', 'Texas', 75028),
(122, 122, 'home', '79 Buena Vista Drive', 'Allen', 'Texas', 0),
(123, 123, 'home', '82883 Ohio Junction', 'Plano', 'Texas', 0),
(124, 124, 'home', '7595 Rusk Crossing', 'Dallas', 'Texas', 75097),
(125, 125, 'home', '4 Elmside Park', 'Addison', 'Texas', 0),
(126, 126, 'home', '67 Corscot Drive', 'Plano', 'Texas', 75098),
(127, 127, 'home', '4 Heath Parkway', 'Addison', 'Texas', 75005),
(128, 128, 'home', '202 Pankratz Terrace', 'Addison', 'Texas', 75007),
(129, 129, 'home', '', '', '', 75049),
(130, 130, 'home', '1652 Rowland Plaza', 'Addison', 'Texas', 75064),
(131, 131, 'home', '84 Sommers Plaza', 'Addison', 'Texas', 75004),
(132, 132, 'home', '97 Cardinal Road', 'Dallas', 'Texas', 75027),
(133, 133, 'home', '54 Lakewood Drive', 'Richardson', 'Texas', 75063),
(134, 134, 'home', '', '', '', 0),
(135, 135, 'home', '', '', '', 0),
(136, 136, 'home', '3 Gulseth Alley', 'Addison', 'Texas', 75052),
(137, 137, 'home', '', '', '', 75044),
(138, 138, 'home', '207 Fulton Avenue', 'Dallas', 'Texas', 75094),
(139, 139, 'home', '28 Hollow Ridge Lane', 'Plano', 'Texas', 75068),
(140, 140, 'home', '37 Hauk Avenue', 'Dallas', 'Texas', 75098),
(141, 141, 'home', '137 Moose Circle', 'Plano', 'Texas', 75026),
(142, 142, 'home', '63832 Shasta Crossing', 'Plano', 'Texas', 75044),
(143, 143, 'home', '', '', '', 0),
(144, 144, 'home', '38977 Karstens Lane', 'Allen', 'Texas', 0),
(145, 145, 'home', '6 Browning Point', 'Plano', 'Texas', 75097),
(146, 146, 'home', '3785 Heath Pass', 'Dallas', 'Texas', 75005),
(147, 147, 'home', '8406 Golf Course Trail', 'Allen', 'Texas', 75033),
(148, 148, 'home', '2 Truax Trail', 'Addison', 'Texas', 75071),
(149, 149, 'home', '', '', '', 0),
(150, 150, 'home', '7 Scott Place', 'Plano', 'Texas', 0),
(151, 151, 'home', '', '', '', 75012),
(152, 152, 'home', '299 Golf View Way', 'Allen', 'Texas', 75085),
(153, 153, 'home', '003 Morrow Crossing', 'Allen', 'Texas', 75049),
(154, 154, 'home', '', '', '', 0),
(155, 155, 'home', '679 Pankratz Lane', 'Addison', 'Texas', 75052),
(156, 156, 'home', '272 Farmco Lane', 'Addison', 'Texas', 75003),
(157, 157, 'home', '3229 Huxley Hill', 'Richardson', 'Texas', 75091),
(158, 158, 'home', '', '', '', 0),
(159, 159, 'home', '168 Eagan Road', 'Allen', 'Texas', 75018),
(160, 160, 'home', '3037 Center Crossing', 'Plano', 'Texas', 75043),
(161, 161, 'home', '7 Vermont Terrace', 'Allen', 'Texas', 0),
(162, 162, 'home', '90 Elmside Hill', 'Richardson', 'Texas', 75010),
(163, 163, 'home', '', '', '', 75056),
(164, 164, 'home', '9547 Michigan Lane', 'Addison', 'Texas', 75054),
(165, 165, 'home', '38 Mallard Place', 'Richardson', 'Texas', 75038),
(166, 166, 'home', '2873 Rusk Crossing', 'Allen', 'Texas', 75040),
(167, 167, 'home', '9976 Mccormick Terrace', 'Allen', 'Texas', 0),
(168, 168, 'home', '66 Hallows Trail', 'Allen', 'Texas', 0),
(169, 169, 'home', '', '', '', 0),
(170, 170, 'home', '', '', '', 75055),
(171, 171, 'home', '13 Cascade Crossing', 'Plano', 'Texas', 0),
(172, 172, 'home', '48833 Atwood Alley', 'Addison', 'Texas', 75001),
(173, 173, 'home', '21 Canary Park', 'Plano', 'Texas', 75018),
(174, 174, 'home', '', '', '', 75069),
(175, 175, 'home', '6235 Longview Pass', 'Plano', 'Texas', 0),
(176, 176, 'home', '', '', '', 75025),
(177, 177, 'home', '', '', '', 75082),
(178, 178, 'home', '7224 Daystar Pass', 'Allen', 'Texas', 0),
(179, 179, 'home', '35825 Maple Alley', 'Richardson', 'Texas', 75001),
(180, 180, 'home', '2 Sunfield Street', 'Plano', 'Texas', 75064),
(181, 181, 'home', '9 Vahlen Drive', 'Richardson', 'Texas', 75081),
(182, 182, 'home', '2031 School Trail', 'Addison', 'Texas', 0),
(183, 183, 'home', '25234 Transport Drive', 'Plano', 'Texas', 0),
(184, 184, 'home', '2 Nova Point', 'Addison', 'Texas', 75095),
(185, 185, 'home', '1 Kropf Circle', 'Addison', 'Texas', 0),
(186, 186, 'home', '68 Cherokee Way', 'Addison', 'Texas', 75061),
(187, 187, 'home', '1 Kenwood Road', 'Richardson', 'Texas', 75064),
(188, 188, 'home', '281 Waxwing Point', 'Richardson', 'Texas', 75080),
(189, 189, 'home', '', '', '', 75091),
(190, 190, 'home', '1 Jay Parkway', 'Plano', 'Texas', 0),
(191, 191, 'home', '4 Kinsman Junction', 'Plano', 'Texas', 75013),
(192, 192, 'home', '3 Karstens Park', 'Dallas', 'Texas', 75058),
(193, 193, 'home', '3396 Claremont Trail', 'Allen', 'Texas', 75018),
(194, 194, 'home', '04546 Tennyson Alley', 'Plano', 'Texas', 75027),
(195, 195, 'home', '4 Bunting Plaza', 'Addison', 'Texas', 75085),
(196, 196, 'home', '7069 Victoria Court', 'Allen', 'Texas', 0),
(197, 197, 'home', '3774 Shoshone Hill', 'Addison', 'Texas', 75062),
(198, 198, 'home', '', '', '', 75098),
(199, 199, 'home', '48 Tony Parkway', 'Plano', 'Texas', 75083),
(200, 200, 'home', '8 Twin Pines Lane', 'Richardson', 'Texas', 75032),
(201, 201, 'home', '90 Lakeland Pass', 'Richardson', 'Texas', 0),
(202, 202, 'home', '091 Old Shore Plaza', 'Richardson', 'Texas', 75014),
(203, 203, 'home', '8 Sheridan Point', 'Allen', 'Texas', 0),
(204, 204, 'home', '', '', '', 75019),
(205, 205, 'home', '41 Lakewood Terrace', 'Allen', 'Texas', 0),
(206, 206, 'home', '', '', '', 75004),
(207, 207, 'home', '6247 Macpherson Way', 'Addison', 'Texas', 75061),
(208, 208, 'home', '3 Buell Avenue', 'Addison', 'Texas', 0),
(209, 209, 'home', '054 Mccormick Court', 'Richardson', 'Texas', 75045),
(210, 210, 'home', '83 Esch Road', 'Plano', 'Texas', 75048),
(211, 211, 'home', '85937 Burrows Pass', 'Addison', 'Texas', 0),
(212, 212, 'home', '0 Stuart Road', 'Dallas', 'Texas', 0),
(213, 213, 'home', '', '', '', 75087),
(214, 214, 'home', '', '', '', 75026),
(215, 215, 'home', '', '', '', 75015),
(216, 216, 'home', '430 Hudson Hill', 'Allen', 'Texas', 75077),
(217, 217, 'home', '', '', '', 75060),
(218, 218, 'home', '5303 Stoughton Circle', 'Allen', 'Texas', 75012),
(219, 219, 'home', '2250 Bunting Point', 'Addison', 'Texas', 75061),
(220, 220, 'home', '86414 Gateway Alley', 'Plano', 'Texas', 75082),
(221, 221, 'home', '7 Hagan Parkway', 'Richardson', 'Texas', 0),
(222, 222, 'home', '27 Hovde Place', 'Addison', 'Texas', 0),
(223, 223, 'home', '88997 Summit Plaza', 'Addison', 'Texas', 0),
(224, 224, 'home', '', '', '', 75052),
(225, 225, 'home', '51 Dexter Drive', 'Dallas', 'Texas', 75032),
(226, 226, 'home', '', '', '', 75045),
(227, 227, 'home', '812 Hermina Road', 'Richardson', 'Texas', 75046),
(228, 228, 'home', '267 Russell Park', 'Addison', 'Texas', 0),
(229, 229, 'home', '50 Gale Pass', 'Plano', 'Texas', 0),
(230, 230, 'home', '44995 Johnson Court', 'Allen', 'Texas', 75003),
(231, 231, 'home', '3 Village Green Parkway', 'Addison', 'Texas', 75023),
(232, 232, 'home', '', '', '', 75097),
(233, 233, 'home', '0 Rockefeller Hill', 'Dallas', 'Texas', 0),
(234, 234, 'home', '', '', '', 75070),
(235, 235, 'home', '6 Valley Edge Hill', 'Addison', 'Texas', 75025),
(236, 236, 'home', '390 Kenwood Hill', 'Richardson', 'Texas', 75023),
(237, 237, 'home', '', '', '', 0),
(238, 238, 'home', '13429 Northport Circle', 'Richardson', 'Texas', 75051),
(239, 239, 'home', '90 Canary Crossing', 'Richardson', 'Texas', 0),
(240, 240, 'home', '3595 Huxley Way', 'Addison', 'Texas', 75052),
(241, 241, 'home', '67573 Judy Junction', 'Allen', 'Texas', 0),
(242, 242, 'home', '50 Sycamore Plaza', 'Addison', 'Texas', 75030),
(243, 243, 'home', '762 Roxbury Alley', 'Allen', 'Texas', 75046),
(244, 244, 'home', '33 Hintze Center', 'Richardson', 'Texas', 75089),
(245, 245, 'home', '16 Knutson Pass', 'Allen', 'Texas', 0),
(246, 246, 'home', '', '', '', 75026),
(247, 247, 'home', '', '', '', 0),
(248, 248, 'home', '5357 7th Road', 'Addison', 'Texas', 0),
(249, 249, 'home', '', '', '', 75040),
(250, 250, 'home', '5 Jana Alley', 'Richardson', 'Texas', 75063),
(251, 251, 'home', '57366 Hayes Pass', 'Addison', 'Texas', 75065),
(252, 252, 'home', '07 Kenwood Plaza', 'Allen', 'Texas', 75014),
(253, 253, 'home', '830 Mccormick Drive', 'Plano', 'Texas', 75012),
(254, 254, 'home', '440 Harper Parkway', 'Addison', 'Texas', 75095),
(255, 255, 'home', '6821 8th Pass', 'Dallas', 'Texas', 0),
(256, 256, 'home', '8067 Bayside Parkway', 'Plano', 'Texas', 0),
(257, 257, 'home', '42330 Hooker Parkway', 'Allen', 'Texas', 75073),
(258, 258, 'home', '', '', '', 0),
(259, 259, 'home', '27 Lotheville Road', 'Dallas', 'Texas', 0),
(260, 260, 'home', '81 Talisman Point', 'Allen', 'Texas', 75010),
(261, 261, 'home', '0 Oakridge Center', 'Plano', 'Texas', 0),
(262, 262, 'home', '9113 Dakota Crossing', 'Richardson', 'Texas', 75083),
(263, 263, 'home', '94 Forest Park', 'Dallas', 'Texas', 0),
(264, 264, 'home', '', '', '', 75038),
(265, 265, 'home', '4553 Moulton Center', 'Richardson', 'Texas', 0),
(266, 266, 'home', '87 Warrior Center', 'Allen', 'Texas', 0),
(267, 267, 'home', '', '', '', 75019),
(268, 268, 'home', '', '', '', 75081),
(269, 269, 'home', '1222 Pond Drive', 'Richardson', 'Texas', 75006),
(270, 270, 'home', '', '', '', 75084),
(271, 271, 'home', '31 Summer Ridge Street', 'Dallas', 'Texas', 0),
(272, 272, 'home', '5 Hanover Crossing', 'Dallas', 'Texas', 75066),
(273, 273, 'home', '9 Melrose Street', 'Plano', 'Texas', 75008),
(274, 274, 'home', '', '', '', 0),
(275, 275, 'home', '8359 Columbus Circle', 'Plano', 'Texas', 75092),
(276, 276, 'home', '72920 Ruskin Trail', 'Dallas', 'Texas', 75029),
(277, 277, 'home', '40 Garrison Circle', 'Allen', 'Texas', 75015),
(278, 278, 'home', '1 Spohn Lane', 'Plano', 'Texas', 75028),
(279, 279, 'home', '37 Rusk Place', 'Addison', 'Texas', 75071),
(280, 280, 'home', '', '', '', 75015),
(281, 281, 'home', '2 Hanson Point', 'Addison', 'Texas', 75083),
(282, 282, 'home', '96 Acker Way', 'Allen', 'Texas', 0),
(283, 283, 'home', '328 Farragut Circle', 'Richardson', 'Texas', 75031),
(284, 284, 'home', '2194 Messerschmidt Lane', 'Richardson', 'Texas', 75001),
(285, 285, 'home', '1 Monterey Point', 'Dallas', 'Texas', 75055),
(286, 286, 'home', '5547 Mallard Park', 'Allen', 'Texas', 75027),
(287, 287, 'home', '3 Menomonie Court', 'Plano', 'Texas', 75050),
(288, 288, 'home', '82 Duke Street', 'Allen', 'Texas', 75090),
(289, 289, 'home', '', '', '', 75090),
(290, 290, 'home', '', '', '', 75003),
(291, 291, 'home', '', '', '', 0),
(292, 292, 'home', '808 Merry Avenue', 'Dallas', 'Texas', 75047),
(293, 293, 'home', '36365 Esch Road', 'Dallas', 'Texas', 0),
(294, 294, 'home', '75 Red Cloud Trail', 'Richardson', 'Texas', 0),
(295, 295, 'home', '1174 Sullivan Avenue', 'Allen', 'Texas', 75040),
(296, 296, 'home', '1 Grasskamp Park', 'Dallas', 'Texas', 0),
(297, 297, 'home', '', '', '', 75070),
(298, 298, 'home', '2317 Annamark Alley', 'Dallas', 'Texas', 0),
(299, 299, 'home', '37 Sachtjen Center', 'Plano', 'Texas', 75021),
(300, 300, 'home', '58 Redwing Court', 'Plano', 'Texas', 75097),
(301, 301, 'home', '632 Graedel Place', 'Addison', 'Texas', 0),
(302, 302, 'home', '37 Mayer Way', 'Plano', 'Texas', 0),
(303, 303, 'home', '563 Mockingbird Point', 'Richardson', 'Texas', 75035),
(304, 304, 'home', '03 Tomscot Circle', 'Plano', 'Texas', 75030),
(305, 305, 'home', '', '', '', 0),
(306, 306, 'home', '', '', '', 75074),
(307, 307, 'home', '26 Erie Hill', 'Richardson', 'Texas', 75075),
(308, 308, 'home', '', '', '', 0),
(309, 309, 'home', '5 Nobel Avenue', 'Addison', 'Texas', 0),
(310, 310, 'home', '9940 Dunning Parkway', 'Addison', 'Texas', 0),
(311, 311, 'home', '5598 Waxwing Crossing', 'Richardson', 'Texas', 75029),
(312, 312, 'home', '3 Bayside Way', 'Richardson', 'Texas', 75010),
(313, 313, 'home', '271 Bowman Way', 'Plano', 'Texas', 75027),
(314, 314, 'home', '2953 Scoville Drive', 'Addison', 'Texas', 0),
(315, 315, 'home', '35 Caliangt Terrace', 'Addison', 'Texas', 75082),
(316, 316, 'home', '83 Nova Park', 'Plano', 'Texas', 0),
(317, 317, 'home', '597 Schmedeman Point', 'Dallas', 'Texas', 0),
(318, 318, 'home', '8232 Chive Point', 'Plano', 'Texas', 75042),
(319, 319, 'home', '8 Packers Lane', 'Plano', 'Texas', 0),
(320, 320, 'home', '07066 Monica Center', 'Richardson', 'Texas', 0),
(321, 321, 'home', '', '', '', 75046),
(322, 322, 'home', '', '', '', 0),
(323, 323, 'home', '318 Moose Trail', 'Richardson', 'Texas', 75076),
(324, 324, 'home', '38654 Novick Point', 'Plano', 'Texas', 0),
(325, 325, 'home', '', '', '', 75025),
(326, 326, 'home', '45 Miller Trail', 'Plano', 'Texas', 75042),
(327, 327, 'home', '8 Forest Dale Way', 'Plano', 'Texas', 75051),
(328, 328, 'home', '087 Duke Pass', 'Dallas', 'Texas', 75005),
(329, 329, 'home', '811 Petterle Park', 'Addison', 'Texas', 0),
(330, 330, 'home', '2737 School Avenue', 'Richardson', 'Texas', 75061),
(331, 331, 'home', '1 Chive Junction', 'Dallas', 'Texas', 75063),
(332, 332, 'home', '2 Randy Way', 'Addison', 'Texas', 75076),
(333, 333, 'home', '318 Canary Place', 'Richardson', 'Texas', 75016),
(334, 334, 'home', '474 Weeping Birch Park', 'Dallas', 'Texas', 75048),
(335, 335, 'home', '5762 Toban Alley', 'Addison', 'Texas', 75048),
(336, 336, 'home', '944 Porter Crossing', 'Addison', 'Texas', 75041),
(337, 337, 'home', '2960 Myrtle Drive', 'Plano', 'Texas', 75008),
(338, 338, 'home', '1 Sachs Way', 'Addison', 'Texas', 0),
(339, 339, 'home', '53 Hermina Plaza', 'Richardson', 'Texas', 75015),
(340, 340, 'home', '01 Fieldstone Terrace', 'Addison', 'Texas', 75021),
(341, 341, 'home', '19 Forest Dale Pass', 'Plano', 'Texas', 0),
(342, 342, 'home', '9 Schlimgen Trail', 'Allen', 'Texas', 0),
(343, 343, 'home', '79 Onsgard Drive', 'Plano', 'Texas', 0),
(344, 344, 'home', '4899 Fremont Way', 'Addison', 'Texas', 0),
(345, 345, 'home', '8733 Aberg Crossing', 'Addison', 'Texas', 75054),
(346, 346, 'home', '0 Green Drive', 'Dallas', 'Texas', 0),
(347, 347, 'home', '52 Morningstar Road', 'Plano', 'Texas', 75043),
(348, 348, 'home', '0 Brickson Park Place', 'Plano', 'Texas', 75009),
(349, 349, 'home', '5930 Clarendon Point', 'Allen', 'Texas', 0),
(350, 350, 'home', '3852 Fallview Pass', 'Richardson', 'Texas', 75034),
(351, 351, 'home', '', '', '', 75003),
(352, 352, 'home', '4 Independence Hill', 'Plano', 'Texas', 75048),
(353, 353, 'home', '9 Lighthouse Bay Court', 'Allen', 'Texas', 75031),
(354, 354, 'home', '1 Namekagon Hill', 'Allen', 'Texas', 0),
(355, 355, 'home', '', '', '', 75076),
(356, 356, 'home', '4 Havey Hill', 'Allen', 'Texas', 75085),
(357, 357, 'home', '', '', '', 75045),
(358, 358, 'home', '6 Crescent Oaks Parkway', 'Addison', 'Texas', 75035),
(359, 359, 'home', '95 Mallory Point', 'Plano', 'Texas', 0),
(360, 360, 'home', '1131 Marquette Parkway', 'Richardson', 'Texas', 75031),
(361, 361, 'home', '988 Vernon Avenue', 'Plano', 'Texas', 75086),
(362, 362, 'home', '36 Nova Junction', 'Addison', 'Texas', 75061),
(363, 363, 'home', '029 Derek Crossing', 'Allen', 'Texas', 75060),
(364, 364, 'home', '', '', '', 75004),
(365, 365, 'home', '85 Mandrake Street', 'Allen', 'Texas', 0),
(366, 366, 'home', '53 Thierer Junction', 'Dallas', 'Texas', 75010),
(367, 367, 'home', '', '', '', 75091),
(368, 368, 'home', '12 Springs Drive', 'Allen', 'Texas', 75089),
(369, 369, 'home', '1 Hovde Pass', 'Addison', 'Texas', 75040),
(370, 370, 'home', '620 West Drive', 'Addison', 'Texas', 75073),
(371, 371, 'home', '463 5th Junction', 'Addison', 'Texas', 75020),
(372, 372, 'home', '02 Northport Park', 'Richardson', 'Texas', 75077),
(373, 373, 'home', '0 Truax Park', 'Plano', 'Texas', 75033),
(374, 374, 'home', '778 Carey Avenue', 'Addison', 'Texas', 75025),
(375, 375, 'home', '4510 Southridge Circle', 'Allen', 'Texas', 75050),
(376, 376, 'home', '', '', '', 75066),
(377, 377, 'home', '9322 Armistice Park', 'Plano', 'Texas', 75032),
(378, 378, 'home', '98252 Manufacturers Parkway', 'Allen', 'Texas', 75092),
(379, 379, 'home', '6694 Columbus Plaza', 'Richardson', 'Texas', 75004),
(380, 380, 'home', '', '', '', 75009),
(381, 381, 'home', '47 Dakota Parkway', 'Dallas', 'Texas', 75091),
(382, 382, 'home', '7986 Fallview Point', 'Richardson', 'Texas', 75057),
(383, 383, 'home', '', '', '', 75033),
(384, 384, 'home', '66 Sunbrook Hill', 'Richardson', 'Texas', 75049),
(385, 385, 'home', '09 Farragut Way', 'Dallas', 'Texas', 75003),
(386, 386, 'home', '86112 Michigan Alley', 'Plano', 'Texas', 75017),
(387, 387, 'home', '', '', '', 75046),
(388, 388, 'home', '1 Continental Crossing', 'Dallas', 'Texas', 75087),
(389, 389, 'home', '5 Sunfield Trail', 'Plano', 'Texas', 75018),
(390, 390, 'home', '21338 Jenna Center', 'Plano', 'Texas', 0),
(391, 391, 'home', '4216 Ridgeview Way', 'Plano', 'Texas', 75093),
(392, 392, 'home', '', '', '', 0),
(393, 393, 'home', '7260 Hudson Street', 'Richardson', 'Texas', 0),
(394, 394, 'home', '11738 Harbort Road', 'Allen', 'Texas', 75003),
(395, 395, 'home', '44 Harbort Alley', 'Richardson', 'Texas', 75088),
(396, 396, 'home', '83453 Clemons Junction', 'Allen', 'Texas', 0),
(397, 397, 'home', '81 Lillian Crossing', 'Plano', 'Texas', 75084),
(398, 398, 'home', '928 Karstens Place', 'Dallas', 'Texas', 0),
(399, 399, 'home', '88 Anderson Trail', 'Dallas', 'Texas', 75035),
(400, 400, 'home', '413 Grasskamp Terrace', 'Richardson', 'Texas', 75003),
(401, 401, 'home', '7996 Oak Valley Circle', 'Plano', 'Texas', 75019),
(402, 402, 'home', '108 Pepper Wood Alley', 'Dallas', 'Texas', 75089),
(403, 403, 'home', '4991 Dapin Crossing', 'Richardson', 'Texas', 75034),
(404, 404, 'home', '1 Ludington Circle', 'Richardson', 'Texas', 0),
(405, 405, 'home', '084 Thackeray Trail', 'Richardson', 'Texas', 0),
(406, 406, 'home', '77379 Hermina Lane', 'Plano', 'Texas', 75085),
(407, 407, 'home', '', '', '', 75034),
(408, 408, 'home', '1 Superior Park', 'Dallas', 'Texas', 75037),
(409, 409, 'home', '45 Summit Trail', 'Dallas', 'Texas', 75037),
(410, 410, 'home', '', '', '', 75095),
(411, 411, 'home', '5 Debs Park', 'Allen', 'Texas', 75068),
(412, 412, 'home', '2 Ridgeway Drive', 'Allen', 'Texas', 75003),
(413, 413, 'home', '978 Buell Circle', 'Richardson', 'Texas', 0),
(414, 414, 'home', '696 Esch Way', 'Addison', 'Texas', 75001),
(415, 415, 'home', '0 Express Pass', 'Addison', 'Texas', 0),
(416, 416, 'home', '9165 Colorado Way', 'Richardson', 'Texas', 75036),
(417, 417, 'home', '', '', '', 0),
(418, 418, 'home', '8831 Waxwing Point', 'Addison', 'Texas', 75012),
(419, 419, 'home', '25 Straubel Lane', 'Allen', 'Texas', 75077),
(420, 420, 'home', '5 Melvin Drive', 'Richardson', 'Texas', 75038),
(421, 421, 'home', '6367 Annamark Junction', 'Plano', 'Texas', 75024),
(422, 422, 'home', '', '', '', 75086),
(423, 423, 'home', '77 Dakota Alley', 'Allen', 'Texas', 75001),
(424, 424, 'home', '828 Shoshone Drive', 'Plano', 'Texas', 0),
(425, 425, 'home', '57306 Westridge Junction', 'Plano', 'Texas', 0),
(426, 426, 'home', '', '', '', 0),
(427, 427, 'home', '43 Tennessee Park', 'Dallas', 'Texas', 75054),
(428, 428, 'home', '333 Montana Avenue', 'Richardson', 'Texas', 0),
(429, 429, 'home', '03062 Express Crossing', 'Richardson', 'Texas', 0),
(430, 430, 'home', '', '', '', 0),
(431, 431, 'home', '', '', '', 75004),
(432, 432, 'home', '570 Prairie Rose Terrace', 'Richardson', 'Texas', 75011),
(433, 433, 'home', '50463 Novick Road', 'Richardson', 'Texas', 0),
(434, 434, 'home', '1703 Portage Place', 'Plano', 'Texas', 75096),
(435, 435, 'home', '66 Service Pass', 'Dallas', 'Texas', 75069),
(436, 436, 'home', '15 Marquette Center', 'Allen', 'Texas', 0),
(437, 437, 'home', '1152 Basil Crossing', 'Plano', 'Texas', 75024),
(438, 438, 'home', '00 Aberg Trail', 'Dallas', 'Texas', 0),
(439, 439, 'home', '97897 Nevada Place', 'Richardson', 'Texas', 0),
(440, 440, 'home', '86669 Kings Court', 'Addison', 'Texas', 0),
(441, 441, 'home', '639 Del Mar Plaza', 'Dallas', 'Texas', 75091),
(442, 442, 'home', '28 Kipling Pass', 'Addison', 'Texas', 0),
(443, 443, 'home', '6 Aberg Hill', 'Allen', 'Texas', 75042),
(444, 444, 'home', '39881 Vidon Center', 'Richardson', 'Texas', 75098),
(445, 445, 'home', '29509 Calypso Circle', 'Plano', 'Texas', 75098),
(446, 446, 'home', '49285 Huxley Park', 'Richardson', 'Texas', 75039),
(447, 447, 'home', '3990 Lakeland Plaza', 'Dallas', 'Texas', 75090),
(448, 448, 'home', '3757 Truax Park', 'Richardson', 'Texas', 0),
(449, 449, 'home', '', '', '', 75058),
(450, 450, 'home', '18975 Harbort Hill', 'Dallas', 'Texas', 75004),
(451, 451, 'home', '47751 Red Cloud Street', 'Dallas', 'Texas', 75013),
(452, 452, 'home', '648 Hooker Junction', 'Dallas', 'Texas', 75061),
(453, 453, 'home', '60302 Longview Way', 'Richardson', 'Texas', 75004),
(454, 454, 'home', '834 Manitowish Center', 'Addison', 'Texas', 0),
(455, 455, 'home', '3 Onsgard Plaza', 'Addison', 'Texas', 75005),
(456, 456, 'home', '0 Larry Way', 'Allen', 'Texas', 75060),
(457, 457, 'home', '370 Longview Hill', 'Allen', 'Texas', 75005),
(458, 458, 'home', '90777 Northwestern Street', 'Addison', 'Texas', 0),
(459, 459, 'home', '72116 Rockefeller Street', 'Allen', 'Texas', 75097),
(460, 460, 'home', '71 Loftsgordon Hill', 'Dallas', 'Texas', 0),
(461, 461, 'home', '4574 Sachs Street', 'Allen', 'Texas', 0),
(462, 462, 'home', '472 Merchant Street', 'Allen', 'Texas', 0),
(463, 463, 'home', '3912 Riverside Circle', 'Richardson', 'Texas', 75039),
(464, 464, 'home', '79872 Roth Way', 'Plano', 'Texas', 75082),
(465, 465, 'home', '34 Dexter Drive', 'Plano', 'Texas', 75044),
(466, 466, 'home', '212 School Hill', 'Plano', 'Texas', 75093),
(467, 467, 'home', '', '', '', 75011),
(468, 468, 'home', '2 Kinsman Avenue', 'Allen', 'Texas', 0),
(469, 469, 'home', '887 Mockingbird Park', 'Richardson', 'Texas', 75011),
(470, 470, 'home', '', '', '', 0),
(471, 471, 'home', '1 Havey Hill', 'Plano', 'Texas', 0),
(472, 472, 'home', '', '', '', 75023),
(473, 473, 'home', '4106 Dapin Court', 'Dallas', 'Texas', 75003),
(474, 474, 'home', '', '', '', 0),
(475, 475, 'home', '135 Mariners Cove Parkway', 'Richardson', 'Texas', 75038),
(476, 476, 'home', '60 Graedel Plaza', 'Dallas', 'Texas', 0),
(477, 477, 'home', '', '', '', 75079),
(478, 478, 'home', '', '', '', 75071),
(479, 479, 'home', '51 High Crossing Street', 'Allen', 'Texas', 75002),
(480, 480, 'home', '8142 Mccormick Pass', 'Dallas', 'Texas', 75083),
(481, 481, 'home', '5652 Pierstorff Road', 'Plano', 'Texas', 0),
(482, 482, 'home', '5 Graceland Place', 'Allen', 'Texas', 0),
(483, 483, 'home', '33 Bluestem Center', 'Addison', 'Texas', 0),
(484, 484, 'home', '78 Caliangt Way', 'Plano', 'Texas', 75005),
(485, 485, 'home', '114 La Follette Crossing', 'Addison', 'Texas', 75077),
(486, 486, 'home', '74197 Mcguire Avenue', 'Addison', 'Texas', 75061),
(487, 487, 'home', '', '', '', 75017),
(488, 488, 'home', '65 Tony Way', 'Plano', 'Texas', 75020),
(489, 489, 'home', '26 Riverside Drive', 'Plano', 'Texas', 75065),
(490, 490, 'home', '', '', '', 75088),
(491, 491, 'home', '1775 Columbus Place', 'Addison', 'Texas', 75054),
(492, 492, 'home', '', '', '', 0),
(493, 493, 'home', '', '', '', 75092),
(494, 494, 'home', '289 Russell Pass', 'Plano', 'Texas', 75063),
(495, 495, 'home', '3 Maple Wood Plaza', 'Dallas', 'Texas', 75017),
(496, 496, 'home', '1 Stone Corner Terrace', 'Allen', 'Texas', 0),
(497, 497, 'home', '259 Fairview Center', 'Plano', 'Texas', 75090),
(498, 498, 'home', '1 Gulseth Center', 'Allen', 'Texas', 75057),
(499, 499, 'home', '86658 Merchant Parkway', 'Richardson', 'Texas', 0),
(500, 500, 'home', '036 Pleasure Parkway', 'Addison', 'Texas', 75039),
(501, 501, 'home', '41 Emmet Point', 'Allen', 'Texas', 75085),
(502, 502, 'home', '', '', '', 0),
(503, 503, 'home', '8 Morning Lane', 'Plano', 'Texas', 0),
(504, 504, 'home', '', '', '', 75054),
(505, 505, 'home', '1 Graceland Center', 'Addison', 'Texas', 0),
(506, 506, 'home', '3 Chinook Junction', 'Addison', 'Texas', 75021),
(507, 507, 'home', '28 Melvin Court', 'Allen', 'Texas', 75092),
(508, 508, 'home', '546 Arapahoe Alley', 'Allen', 'Texas', 75041),
(509, 509, 'home', '2 Mandrake Lane', 'Addison', 'Texas', 0),
(510, 510, 'home', '', '', '', 0),
(511, 511, 'home', '1160 Waubesa Court', 'Addison', 'Texas', 75080),
(512, 512, 'home', '74 Grim Center', 'Addison', 'Texas', 75047),
(513, 513, 'home', '3 Straubel Trail', 'Addison', 'Texas', 75022),
(514, 514, 'home', '09144 Waxwing Parkway', 'Plano', 'Texas', 75080),
(515, 515, 'home', '4 Golf View Street', 'Richardson', 'Texas', 75049),
(516, 516, 'home', '', '', '', 75043),
(517, 517, 'home', '6133 Blaine Plaza', 'Plano', 'Texas', 0),
(518, 518, 'home', '55 Utah Way', 'Dallas', 'Texas', 0),
(519, 519, 'home', '30380 Melvin Terrace', 'Addison', 'Texas', 75047),
(520, 520, 'home', '', '', '', 75071),
(521, 521, 'home', '443 Gale Avenue', 'Dallas', 'Texas', 0),
(522, 522, 'home', '57436 Merrick Lane', 'Dallas', 'Texas', 75065),
(523, 523, 'home', '64231 Green Ridge Parkway', 'Dallas', 'Texas', 75018),
(524, 524, 'home', '58 Northview Drive', 'Allen', 'Texas', 75032),
(525, 525, 'home', '26 Stuart Road', 'Plano', 'Texas', 75050),
(526, 526, 'home', '0 Crowley Circle', 'Allen', 'Texas', 75052),
(527, 527, 'home', '3896 Columbus Parkway', 'Addison', 'Texas', 75010),
(528, 528, 'home', '25867 Florence Avenue', 'Allen', 'Texas', 0),
(529, 529, 'home', '018 Muir Circle', 'Plano', 'Texas', 0),
(530, 530, 'home', '23 Sullivan Alley', 'Addison', 'Texas', 0),
(531, 531, 'home', '3392 Sherman Circle', 'Richardson', 'Texas', 0),
(532, 532, 'home', '217 Dayton Road', 'Plano', 'Texas', 75089),
(533, 533, 'home', '6537 Colorado Hill', 'Plano', 'Texas', 75087),
(534, 534, 'home', '', '', '', 75006),
(535, 535, 'home', '6 Carpenter Pass', 'Allen', 'Texas', 75001),
(536, 536, 'home', '837 Westridge Lane', 'Allen', 'Texas', 75079),
(537, 537, 'home', '114 Mitchell Terrace', 'Addison', 'Texas', 0),
(538, 538, 'home', '344 Glacier Hill Point', 'Addison', 'Texas', 0),
(539, 539, 'home', '23 Blackbird Alley', 'Plano', 'Texas', 75091),
(540, 540, 'home', '5 Merry Terrace', 'Richardson', 'Texas', 75081),
(541, 541, 'home', '149 Talisman Court', 'Plano', 'Texas', 0),
(542, 542, 'home', '516 Stoughton Plaza', 'Allen', 'Texas', 75093),
(543, 543, 'home', '0179 Kensington Trail', 'Dallas', 'Texas', 75087),
(544, 544, 'home', '1086 Ludington Pass', 'Addison', 'Texas', 75040),
(545, 545, 'home', '11388 Reinke Way', 'Addison', 'Texas', 75052),
(546, 546, 'home', '68 Laurel Plaza', 'Allen', 'Texas', 75079),
(547, 547, 'home', '05232 Knutson Pass', 'Richardson', 'Texas', 75059),
(548, 548, 'home', '3722 Summit Junction', 'Richardson', 'Texas', 0),
(549, 549, 'home', '6830 Lake View Hill', 'Allen', 'Texas', 0),
(550, 550, 'home', '963 Cottonwood Junction', 'Allen', 'Texas', 0),
(551, 551, 'home', '7 Comanche Plaza', 'Richardson', 'Texas', 75006),
(552, 552, 'home', '73097 Autumn Leaf Street', 'Addison', 'Texas', 0),
(553, 553, 'home', '6 Waywood Drive', 'Addison', 'Texas', 0),
(554, 554, 'home', '', '', '', 75079),
(555, 555, 'home', '70 Brown Place', 'Dallas', 'Texas', 0),
(556, 556, 'home', '', '', '', 75071),
(557, 557, 'home', '1 Mallard Trail', 'Addison', 'Texas', 75078),
(558, 558, 'home', '0848 Bluestem Hill', 'Dallas', 'Texas', 0),
(559, 559, 'home', '75026 Straubel Lane', 'Allen', 'Texas', 0),
(560, 560, 'home', '', '', '', 75061),
(561, 561, 'home', '502 Dawn Center', 'Addison', 'Texas', 75095),
(562, 562, 'home', '', '', '', 0),
(563, 563, 'home', '9 Dorton Hill', 'Addison', 'Texas', 75025),
(564, 564, 'home', '3 Pierstorff Lane', 'Dallas', 'Texas', 0),
(565, 565, 'home', '5 Old Shore Way', 'Dallas', 'Texas', 75094),
(566, 566, 'home', '6 Gale Point', 'Richardson', 'Texas', 0),
(567, 567, 'home', '0273 Fairview Way', 'Addison', 'Texas', 0),
(568, 568, 'home', '49356 Anhalt Court', 'Dallas', 'Texas', 75016),
(569, 569, 'home', '0187 Beilfuss Crossing', 'Allen', 'Texas', 75026),
(570, 570, 'home', '952 Browning Junction', 'Allen', 'Texas', 75025),
(571, 571, 'home', '59 Buell Park', 'Richardson', 'Texas', 75062),
(572, 572, 'home', '', '', '', 0),
(573, 573, 'home', '', '', '', 75032),
(574, 574, 'home', '45444 Sutherland Trail', 'Dallas', 'Texas', 75091),
(575, 575, 'home', '2457 Fuller Court', 'Richardson', 'Texas', 0),
(576, 576, 'home', '723 Bayside Alley', 'Richardson', 'Texas', 75013),
(577, 577, 'home', '9494 3rd Parkway', 'Addison', 'Texas', 75043),
(578, 578, 'home', '689 Maywood Trail', 'Dallas', 'Texas', 0),
(579, 579, 'home', '7839 Carioca Drive', 'Allen', 'Texas', 75091),
(580, 580, 'home', '8 Rockefeller Drive', 'Plano', 'Texas', 75021),
(581, 581, 'home', '44630 Elgar Avenue', 'Allen', 'Texas', 75062),
(582, 582, 'home', '680 Meadow Vale Parkway', 'Richardson', 'Texas', 75034),
(583, 583, 'home', '120 Tony Center', 'Addison', 'Texas', 75029),
(584, 584, 'home', '92383 North Crossing', 'Addison', 'Texas', 0),
(585, 585, 'home', '28 Cottonwood Circle', 'Addison', 'Texas', 75091),
(586, 586, 'home', '66 Charing Cross Trail', 'Plano', 'Texas', 75092),
(587, 587, 'home', '9 Warrior Plaza', 'Plano', 'Texas', 75008),
(588, 588, 'home', '', '', '', 75028),
(589, 589, 'home', '00220 Manufacturers Road', 'Dallas', 'Texas', 0),
(590, 590, 'home', '', '', '', 0),
(591, 591, 'home', '', '', '', 75017),
(592, 592, 'home', '', '', '', 75047),
(593, 593, 'home', '', '', '', 0),
(594, 594, 'home', '465 Rigney Way', 'Allen', 'Texas', 75051),
(595, 595, 'home', '', '', '', 0),
(596, 596, 'home', '89 Kenwood Trail', 'Addison', 'Texas', 75095),
(597, 597, 'home', '3 Mcguire Circle', 'Plano', 'Texas', 0),
(598, 598, 'home', '57438 Arrowood Alley', 'Dallas', 'Texas', 75070),
(599, 599, 'home', '810 Carberry Place', 'Dallas', 'Texas', 75082),
(600, 600, 'home', '25433 Sauthoff Place', 'Allen', 'Texas', 75024),
(601, 601, 'home', '9 Hoepker Parkway', 'Plano', 'Texas', 75003),
(602, 602, 'home', '', '', '', 75032),
(603, 603, 'home', '', '', '', 75094),
(604, 604, 'home', '', '', '', 75004),
(605, 605, 'home', '', '', '', 75036),
(606, 606, 'home', '32742 Fieldstone Plaza', 'Allen', 'Texas', 75051),
(607, 607, 'home', '509 Cherokee Circle', 'Dallas', 'Texas', 75014),
(608, 608, 'home', '04 Randy Circle', 'Allen', 'Texas', 75078),
(609, 609, 'home', '59 Talisman Road', 'Allen', 'Texas', 75019),
(610, 610, 'home', '43 Macpherson Terrace', 'Richardson', 'Texas', 75098),
(611, 611, 'home', '', '', '', 75077),
(612, 612, 'home', '188 Summerview Way', 'Plano', 'Texas', 0),
(613, 613, 'home', '0327 Monica Avenue', 'Addison', 'Texas', 75009),
(614, 614, 'home', '72 Macpherson Avenue', 'Plano', 'Texas', 75021),
(615, 615, 'home', '26807 Bayside Point', 'Allen', 'Texas', 75050),
(616, 616, 'home', '877 Fairview Road', 'Allen', 'Texas', 75071),
(617, 617, 'home', '51 Almo Circle', 'Allen', 'Texas', 75082),
(618, 618, 'home', '390 Garrison Place', 'Addison', 'Texas', 75096),
(619, 619, 'home', '', '', '', 75037),
(620, 620, 'home', '22191 Declaration Plaza', 'Allen', 'Texas', 75076),
(621, 621, 'home', '09440 Oak Junction', 'Richardson', 'Texas', 0),
(622, 622, 'home', '', '', '', 75075),
(623, 623, 'home', '417 Lighthouse Bay Lane', 'Plano', 'Texas', 75051),
(624, 624, 'home', '26 Gale Street', 'Richardson', 'Texas', 0),
(625, 625, 'home', '67 Cottonwood Plaza', 'Richardson', 'Texas', 75091),
(626, 626, 'home', '', '', '', 75093),
(627, 627, 'home', '0236 Memorial Park', 'Plano', 'Texas', 75048),
(628, 628, 'home', '', '', '', 0),
(629, 629, 'home', '7 5th Place', 'Plano', 'Texas', 0),
(630, 630, 'home', '2 High Crossing Way', 'Richardson', 'Texas', 0),
(631, 631, 'home', '', '', '', 75021),
(632, 632, 'home', '1 Blackbird Pass', 'Allen', 'Texas', 75032),
(633, 633, 'home', '6 Anzinger Street', 'Plano', 'Texas', 75027),
(634, 634, 'home', '15 Maywood Center', 'Addison', 'Texas', 75084),
(635, 635, 'home', '9716 Michigan Plaza', 'Allen', 'Texas', 0),
(636, 636, 'home', '28 Iowa Crossing', 'Addison', 'Texas', 0),
(637, 637, 'home', '5 Reinke Center', 'Addison', 'Texas', 75044),
(638, 638, 'home', '', '', '', 0),
(639, 639, 'home', '4090 Loeprich Place', 'Addison', 'Texas', 75036),
(640, 640, 'home', '88 Harbort Alley', 'Addison', 'Texas', 0),
(641, 641, 'home', '981 Rockefeller Crossing', 'Plano', 'Texas', 75072),
(642, 642, 'home', '8 Calypso Drive', 'Richardson', 'Texas', 75019),
(643, 643, 'home', '3 Memorial Terrace', 'Dallas', 'Texas', 75023),
(644, 644, 'home', '', '', '', 75069),
(645, 645, 'home', '8240 Dexter Avenue', 'Plano', 'Texas', 75083),
(646, 646, 'home', '478 Birchwood Court', 'Plano', 'Texas', 75045),
(647, 647, 'home', '07 North Way', 'Richardson', 'Texas', 0),
(648, 648, 'home', '5285 Moose Alley', 'Allen', 'Texas', 0),
(649, 649, 'home', '9 Stephen Way', 'Richardson', 'Texas', 75029),
(650, 650, 'home', '3 Jana Avenue', 'Allen', 'Texas', 75012),
(651, 651, 'home', '65148 Marcy Center', 'Dallas', 'Texas', 75021),
(652, 652, 'home', '0859 Elmside Point', 'Dallas', 'Texas', 75096),
(653, 653, 'home', '', '', '', 75093),
(654, 654, 'home', '677 Fordem Court', 'Allen', 'Texas', 75066),
(655, 655, 'home', '4985 Caliangt Trail', 'Allen', 'Texas', 0),
(656, 656, 'home', '', '', '', 0),
(657, 657, 'home', '', '', '', 75062),
(658, 658, 'home', '33 Farwell Junction', 'Allen', 'Texas', 75056),
(659, 659, 'home', '80253 Gulseth Circle', 'Richardson', 'Texas', 75094),
(660, 660, 'home', '48665 Eastwood Drive', 'Addison', 'Texas', 75039),
(661, 661, 'home', '14 4th Road', 'Allen', 'Texas', 0),
(662, 662, 'home', '0 Kinsman Plaza', 'Richardson', 'Texas', 75036),
(663, 663, 'home', '02 Onsgard Drive', 'Richardson', 'Texas', 0),
(664, 664, 'home', '', '', '', 75087),
(665, 665, 'home', '72 Tennessee Park', 'Allen', 'Texas', 75039),
(666, 666, 'home', '958 Prairieview Court', 'Allen', 'Texas', 0),
(667, 667, 'home', '2674 Monument Crossing', 'Allen', 'Texas', 75087),
(668, 668, 'home', '801 Stephen Point', 'Richardson', 'Texas', 0),
(669, 669, 'home', '6141 Summit Crossing', 'Addison', 'Texas', 0),
(670, 670, 'home', '855 Ramsey Lane', 'Plano', 'Texas', 75007),
(671, 671, 'home', '', '', '', 75044),
(672, 672, 'home', '2857 Weeping Birch Center', 'Plano', 'Texas', 75020),
(673, 673, 'home', '692 Atwood Drive', 'Richardson', 'Texas', 0),
(674, 674, 'home', '5 Claremont Junction', 'Allen', 'Texas', 75043),
(675, 675, 'home', '436 Fremont Circle', 'Allen', 'Texas', 75052),
(676, 676, 'home', '65146 Summer Ridge Crossing', 'Plano', 'Texas', 0),
(677, 677, 'home', '1766 Mifflin Court', 'Dallas', 'Texas', 75068),
(678, 678, 'home', '3133 Swallow Circle', 'Addison', 'Texas', 75057),
(679, 679, 'home', '219 Oxford Street', 'Allen', 'Texas', 75080),
(680, 680, 'home', '0 Daystar Avenue', 'Richardson', 'Texas', 0),
(681, 681, 'home', '', '', '', 0),
(682, 682, 'home', '', '', '', 75011),
(683, 683, 'home', '3325 Bartelt Place', 'Plano', 'Texas', 75011),
(684, 684, 'home', '21 Brickson Park Plaza', 'Allen', 'Texas', 0),
(685, 685, 'home', '', '', '', 75081),
(686, 686, 'home', '', '', '', 0),
(687, 687, 'home', '97 Hooker Point', 'Richardson', 'Texas', 0),
(688, 688, 'home', '', '', '', 75014),
(689, 689, 'home', '10220 Golden Leaf Lane', 'Richardson', 'Texas', 75057),
(690, 690, 'home', '7746 Sommers Circle', 'Richardson', 'Texas', 0),
(691, 691, 'home', '6417 Mccormick Lane', 'Addison', 'Texas', 75007),
(692, 692, 'home', '70662 Oak Valley Terrace', 'Addison', 'Texas', 75088),
(693, 693, 'home', '77873 Annamark Drive', 'Allen', 'Texas', 75055),
(694, 694, 'home', '', '', '', 75011),
(695, 695, 'home', '', '', '', 75097),
(696, 696, 'home', '69493 Amoth Alley', 'Plano', 'Texas', 75023),
(697, 697, 'home', '53 Harbort Center', 'Plano', 'Texas', 75033),
(698, 698, 'home', '84579 Blackbird Street', 'Dallas', 'Texas', 75035),
(699, 699, 'home', '9 Manley Lane', 'Plano', 'Texas', 75049),
(700, 700, 'home', '0 Summit Alley', 'Dallas', 'Texas', 0),
(701, 701, 'home', '7714 Mifflin Street', 'Dallas', 'Texas', 75043),
(702, 702, 'home', '', '', '', 0),
(703, 703, 'home', '7260 Laurel Alley', 'Richardson', 'Texas', 75064),
(704, 704, 'home', '2 Eliot Way', 'Addison', 'Texas', 75082),
(705, 705, 'home', '06 Knutson Place', 'Allen', 'Texas', 75022),
(706, 706, 'home', '9878 Caliangt Plaza', 'Plano', 'Texas', 75045),
(707, 707, 'home', '17946 Union Drive', 'Addison', 'Texas', 75085),
(708, 708, 'home', '6 6th Place', 'Plano', 'Texas', 75040),
(709, 709, 'home', '1684 Crest Line Trail', 'Richardson', 'Texas', 75085),
(710, 710, 'home', '6161 Clyde Gallagher Parkway', 'Dallas', 'Texas', 75034),
(711, 711, 'home', '3 Troy Road', 'Addison', 'Texas', 0),
(712, 712, 'home', '4169 Namekagon Park', 'Plano', 'Texas', 75015),
(713, 713, 'home', '', '', '', 75038),
(714, 714, 'home', '3 Spaight Hill', 'Allen', 'Texas', 75012),
(715, 715, 'home', '4530 Schurz Pass', 'Richardson', 'Texas', 75021),
(716, 716, 'home', '9 Rowland Pass', 'Addison', 'Texas', 75044),
(717, 717, 'home', '13053 American Drive', 'Dallas', 'Texas', 75004),
(718, 718, 'home', '', '', '', 75016),
(719, 719, 'home', '', '', '', 75090),
(720, 720, 'home', '2132 Eastwood Place', 'Plano', 'Texas', 75076),
(721, 721, 'home', '0758 Kings Drive', 'Dallas', 'Texas', 0),
(722, 722, 'home', '59 Emmet Crossing', 'Plano', 'Texas', 75069),
(723, 723, 'home', '93 Dapin Court', 'Allen', 'Texas', 75024),
(724, 724, 'home', '2 Dahle Hill', 'Allen', 'Texas', 0),
(725, 725, 'home', '27 Continental Lane', 'Plano', 'Texas', 0),
(726, 726, 'home', '09 Springs Avenue', 'Dallas', 'Texas', 75035),
(727, 727, 'home', '77822 Delladonna Terrace', 'Allen', 'Texas', 75068),
(728, 728, 'home', '868 Farmco Center', 'Plano', 'Texas', 75003),
(729, 729, 'home', '', '', '', 75025),
(730, 730, 'home', '', '', '', 75066),
(731, 731, 'home', '24 Center Hill', 'Dallas', 'Texas', 75038),
(732, 732, 'home', '1473 Farmco Circle', 'Plano', 'Texas', 75050),
(733, 733, 'home', '07389 Dorton Park', 'Plano', 'Texas', 75077),
(734, 734, 'home', '9 Russell Parkway', 'Addison', 'Texas', 75034),
(735, 735, 'home', '990 Northview Court', 'Plano', 'Texas', 75057),
(736, 736, 'home', '00818 Springs Court', 'Dallas', 'Texas', 75032),
(737, 737, 'home', '352 Westridge Parkway', 'Richardson', 'Texas', 75050),
(738, 738, 'home', '22 Magdeline Street', 'Dallas', 'Texas', 75063),
(739, 739, 'home', '', '', '', 0),
(740, 740, 'home', '929 Weeping Birch Avenue', 'Dallas', 'Texas', 75056),
(741, 741, 'home', '', '', '', 0),
(742, 742, 'home', '861 Lakewood Crossing', 'Allen', 'Texas', 0),
(743, 743, 'home', '156 Maryland Court', 'Dallas', 'Texas', 0),
(744, 744, 'home', '345 Erie Pass', 'Dallas', 'Texas', 75052),
(745, 745, 'home', '4 Mallory Point', 'Richardson', 'Texas', 0),
(746, 746, 'home', '8772 Iowa Road', 'Richardson', 'Texas', 75065),
(747, 747, 'home', '57 Hermina Center', 'Plano', 'Texas', 75025),
(748, 748, 'home', '', '', '', 75082),
(749, 749, 'home', '', '', '', 75076),
(750, 750, 'home', '', '', '', 0),
(751, 751, 'home', '820 Becker Trail', 'Richardson', 'Texas', 0),
(752, 752, 'home', '92 Onsgard Point', 'Allen', 'Texas', 75043),
(753, 753, 'home', '', '', '', 75081),
(754, 754, 'home', '6342 Eastwood Trail', 'Allen', 'Texas', 75008),
(755, 755, 'home', '', '', '', 75037),
(756, 756, 'home', '', '', '', 75014),
(757, 757, 'home', '8332 Larry Center', 'Addison', 'Texas', 75005),
(758, 758, 'home', '66 Jenifer Avenue', 'Addison', 'Texas', 0),
(759, 759, 'home', '77474 Anhalt Junction', 'Plano', 'Texas', 75094),
(760, 760, 'home', '23 Scott Plaza', 'Addison', 'Texas', 75076),
(761, 761, 'home', '5236 Linden Park', 'Dallas', 'Texas', 0),
(762, 762, 'home', '581 2nd Avenue', 'Allen', 'Texas', 75029),
(763, 763, 'home', '80509 Glendale Circle', 'Plano', 'Texas', 75076),
(764, 764, 'home', '', '', '', 75069),
(765, 765, 'home', '905 Muir Circle', 'Richardson', 'Texas', 75062),
(766, 766, 'home', '', '', '', 0),
(767, 767, 'home', '6190 Sutherland Circle', 'Dallas', 'Texas', 0),
(768, 768, 'home', '9022 Shopko Lane', 'Richardson', 'Texas', 0),
(769, 769, 'home', '1384 Arizona Road', 'Richardson', 'Texas', 75046),
(770, 770, 'home', '96058 Lakewood Place', 'Allen', 'Texas', 75028),
(771, 771, 'home', '', '', '', 75080),
(772, 772, 'home', '63 Jenifer Parkway', 'Dallas', 'Texas', 0),
(773, 773, 'home', '120 Loomis Avenue', 'Dallas', 'Texas', 75086),
(774, 774, 'home', '20022 Marcy Hill', 'Dallas', 'Texas', 75054),
(775, 775, 'home', '40973 Victoria Center', 'Richardson', 'Texas', 75080),
(776, 776, 'home', '', '', '', 0),
(777, 777, 'home', '', '', '', 75010),
(778, 778, 'home', '', '', '', 75038),
(779, 779, 'home', '', '', '', 0),
(780, 780, 'home', '32266 Bartillon Avenue', 'Plano', 'Texas', 0),
(781, 781, 'home', '42352 Fuller Way', 'Plano', 'Texas', 0),
(782, 782, 'home', '75395 Luster Plaza', 'Dallas', 'Texas', 0),
(783, 783, 'home', '22617 Farragut Park', 'Richardson', 'Texas', 75021),
(784, 784, 'home', '', '', '', 75088),
(785, 785, 'home', '', '', '', 0),
(786, 786, 'home', '808 Weeping Birch Lane', 'Addison', 'Texas', 0),
(787, 787, 'home', '3088 Troy Trail', 'Richardson', 'Texas', 75074),
(788, 788, 'home', '', '', '', 75009),
(789, 789, 'home', '72330 Emmet Circle', 'Plano', 'Texas', 75093),
(790, 790, 'home', '7 Armistice Place', 'Richardson', 'Texas', 75064),
(791, 791, 'home', '5 Schmedeman Plaza', 'Addison', 'Texas', 0),
(792, 792, 'home', '07 Rockefeller Hill', 'Allen', 'Texas', 75044),
(793, 793, 'home', '84513 Heath Pass', 'Plano', 'Texas', 75026),
(794, 794, 'home', '24976 Eagan Parkway', 'Addison', 'Texas', 75065),
(795, 795, 'home', '', '', '', 75035),
(796, 796, 'home', '', '', '', 75039),
(797, 797, 'home', '6 Tomscot Point', 'Addison', 'Texas', 0),
(798, 798, 'home', '263 1st Street', 'Allen', 'Texas', 75040),
(799, 799, 'home', '75023 Carioca Drive', 'Plano', 'Texas', 75013),
(800, 800, 'home', '16 Acker Center', 'Addison', 'Texas', 75099),
(801, 801, 'home', '903 Becker Avenue', 'Allen', 'Texas', 75057),
(802, 802, 'home', '3649 Judy Pass', 'Dallas', 'Texas', 0),
(803, 803, 'home', '959 Tony Alley', 'Allen', 'Texas', 75012),
(804, 804, 'home', '2694 Pankratz Avenue', 'Allen', 'Texas', 75014),
(805, 805, 'home', '23 Waxwing Center', 'Dallas', 'Texas', 0),
(806, 806, 'home', '1476 Ramsey Street', 'Richardson', 'Texas', 75046),
(807, 807, 'home', '91870 Nevada Trail', 'Plano', 'Texas', 75066),
(808, 808, 'home', '9 New Castle Hill', 'Allen', 'Texas', 75043),
(809, 809, 'home', '1909 Farmco Alley', 'Dallas', 'Texas', 75021),
(810, 810, 'home', '335 Forest Drive', 'Allen', 'Texas', 75009),
(811, 811, 'home', '24942 Talisman Pass', 'Allen', 'Texas', 75032),
(812, 812, 'home', '2 Bashford Terrace', 'Richardson', 'Texas', 75064),
(813, 813, 'home', '26 Roxbury Terrace', 'Dallas', 'Texas', 75011),
(814, 814, 'home', '28 7th Lane', 'Allen', 'Texas', 0),
(815, 815, 'home', '5 Messerschmidt Street', 'Plano', 'Texas', 75069),
(816, 816, 'home', '592 Park Meadow Center', 'Addison', 'Texas', 75060),
(817, 817, 'home', '15752 Lillian Pass', 'Plano', 'Texas', 75034),
(818, 818, 'home', '1159 Harbort Center', 'Plano', 'Texas', 75007),
(819, 819, 'home', '14510 Northfield Street', 'Dallas', 'Texas', 75023),
(820, 820, 'home', '2171 Aberg Crossing', 'Addison', 'Texas', 0),
(821, 821, 'home', '5 Dorton Crossing', 'Dallas', 'Texas', 75050),
(822, 822, 'home', '2114 Ramsey Lane', 'Dallas', 'Texas', 75014),
(823, 823, 'home', '05 Oxford Way', 'Richardson', 'Texas', 0),
(824, 824, 'home', '4525 Fulton Alley', 'Dallas', 'Texas', 75070),
(825, 825, 'home', '9412 Kennedy Plaza', 'Richardson', 'Texas', 75050),
(826, 826, 'home', '8 Monica Park', 'Richardson', 'Texas', 75075),
(827, 827, 'home', '1 Manley Circle', 'Richardson', 'Texas', 75052),
(828, 828, 'home', '46 Bayside Point', 'Allen', 'Texas', 75052),
(829, 829, 'home', '', '', '', 75006),
(830, 830, 'home', '', '', '', 75086),
(831, 831, 'home', '14320 Beilfuss Hill', 'Plano', 'Texas', 75033),
(832, 832, 'home', '97 Holmberg Place', 'Addison', 'Texas', 0),
(833, 833, 'home', '27 Vahlen Street', 'Allen', 'Texas', 75040),
(834, 834, 'home', '46311 Caliangt Street', 'Plano', 'Texas', 75030),
(835, 835, 'home', '54 Novick Avenue', 'Plano', 'Texas', 0),
(836, 836, 'home', '09 Butternut Plaza', 'Allen', 'Texas', 75044),
(837, 837, 'home', '447 7th Pass', 'Addison', 'Texas', 75038),
(838, 838, 'home', '0559 Mosinee Park', 'Allen', 'Texas', 75020),
(839, 839, 'home', '96 Miller Plaza', 'Richardson', 'Texas', 75098),
(840, 840, 'home', '', '', '', 75029),
(841, 841, 'home', '1225 Corscot Lane', 'Plano', 'Texas', 75099),
(842, 842, 'home', '', '', '', 0),
(843, 843, 'home', '31006 Londonderry Pass', 'Allen', 'Texas', 75065),
(844, 844, 'home', '', '', '', 0),
(845, 845, 'home', '13 Park Meadow Way', 'Allen', 'Texas', 75065),
(846, 846, 'home', '9 Stephen Court', 'Richardson', 'Texas', 0),
(847, 847, 'home', '', '', '', 75022),
(848, 848, 'home', '827 Riverside Lane', 'Addison', 'Texas', 75063),
(849, 849, 'home', '', '', '', 75032),
(850, 850, 'home', '2791 Susan Circle', 'Richardson', 'Texas', 75093),
(851, 851, 'home', '', '', '', 0),
(852, 852, 'home', '', '', '', 0),
(853, 853, 'home', '4 Charing Cross Hill', 'Allen', 'Texas', 75017),
(854, 854, 'home', '8314 Dennis Junction', 'Plano', 'Texas', 75001);
INSERT INTO `address` (`address_id`, `contact_id`, `address_type`, `address`, `City`, `State`, `Zip`) VALUES
(855, 855, 'home', '925 Rieder Junction', 'Richardson', 'Texas', 75052),
(856, 856, 'home', '9 Ohio Street', 'Plano', 'Texas', 0),
(857, 857, 'home', '52 2nd Circle', 'Dallas', 'Texas', 0),
(858, 858, 'home', '16 Maryland Center', 'Richardson', 'Texas', 0),
(859, 859, 'home', '', '', '', 75049),
(860, 860, 'home', '7 Fairfield Drive', 'Plano', 'Texas', 75066),
(861, 861, 'home', '', '', '', 75060),
(862, 862, 'home', '1295 Warbler Court', 'Richardson', 'Texas', 75032),
(863, 863, 'home', '93552 Muir Plaza', 'Dallas', 'Texas', 75059),
(864, 864, 'home', '8 Stoughton Terrace', 'Addison', 'Texas', 75096),
(865, 865, 'home', '2 Rutledge Lane', 'Allen', 'Texas', 75019),
(866, 866, 'home', '57250 Butternut Alley', 'Dallas', 'Texas', 75065),
(867, 867, 'home', '', '', '', 0),
(868, 868, 'home', '708 Grover Parkway', 'Allen', 'Texas', 75083),
(869, 869, 'home', '', '', '', 75004),
(870, 870, 'home', '8590 Cardinal Place', 'Richardson', 'Texas', 0),
(871, 871, 'home', '9 John Wall Terrace', 'Allen', 'Texas', 75024),
(872, 872, 'home', '93 Butterfield Center', 'Allen', 'Texas', 75084),
(873, 873, 'home', '65458 Glacier Hill Plaza', 'Dallas', 'Texas', 75064),
(874, 874, 'home', '2498 Quincy Lane', 'Dallas', 'Texas', 0),
(875, 875, 'home', '959 Hallows Plaza', 'Dallas', 'Texas', 75061),
(876, 876, 'home', '60 Ridgeway Plaza', 'Addison', 'Texas', 0),
(877, 877, 'home', '7272 Hayes Point', 'Allen', 'Texas', 75008),
(878, 878, 'home', '6 Golf Parkway', 'Richardson', 'Texas', 75003),
(879, 879, 'home', '2 Grover Plaza', 'Richardson', 'Texas', 75038),
(880, 880, 'home', '17226 Arapahoe Parkway', 'Richardson', 'Texas', 0),
(881, 881, 'home', '', '', '', 0),
(882, 882, 'home', '25 Arrowood Circle', 'Richardson', 'Texas', 75053),
(883, 883, 'home', '9 Springs Circle', 'Addison', 'Texas', 75021),
(884, 884, 'home', '84964 Division Avenue', 'Plano', 'Texas', 75022),
(885, 885, 'home', '849 1st Circle', 'Plano', 'Texas', 0),
(886, 886, 'home', '', '', '', 75038),
(887, 887, 'home', '', '', '', 0),
(888, 888, 'home', '', '', '', 75019),
(889, 889, 'home', '84 Schmedeman Lane', 'Richardson', 'Texas', 75022),
(890, 890, 'home', '9 Montana Plaza', 'Dallas', 'Texas', 75061),
(891, 891, 'home', '', '', '', 75010),
(892, 892, 'home', '25181 La Follette Place', 'Dallas', 'Texas', 75056),
(893, 893, 'home', '', '', '', 75065),
(894, 894, 'home', '8118 Eastlawn Parkway', 'Allen', 'Texas', 75057),
(895, 895, 'home', '951 Forest Run Plaza', 'Richardson', 'Texas', 75064),
(896, 896, 'home', '', '', '', 75013),
(897, 897, 'home', '5013 Ilene Hill', 'Dallas', 'Texas', 0),
(898, 898, 'home', '8 Blaine Pass', 'Addison', 'Texas', 0),
(899, 899, 'home', '9463 Lake View Road', 'Allen', 'Texas', 75059),
(900, 900, 'home', '334 Almo Avenue', 'Dallas', 'Texas', 75070),
(901, 901, 'home', '9 Moulton Avenue', 'Richardson', 'Texas', 75052),
(902, 902, 'home', '0695 Dakota Terrace', 'Addison', 'Texas', 75069),
(903, 903, 'home', '472 Kennedy Road', 'Addison', 'Texas', 75032),
(904, 904, 'home', '9772 Eastwood Circle', 'Richardson', 'Texas', 75080),
(905, 905, 'home', '08299 Lillian Drive', 'Allen', 'Texas', 75076),
(906, 906, 'home', '4 Porter Circle', 'Addison', 'Texas', 75016),
(907, 907, 'home', '904 Fremont Way', 'Allen', 'Texas', 75090),
(908, 908, 'home', '43 Randy Avenue', 'Richardson', 'Texas', 0),
(909, 909, 'home', '87470 Northfield Circle', 'Allen', 'Texas', 75088),
(910, 910, 'home', '72792 Donald Avenue', 'Richardson', 'Texas', 0),
(911, 911, 'home', '3 Walton Point', 'Plano', 'Texas', 75064),
(912, 912, 'home', '06 Reinke Point', 'Addison', 'Texas', 0),
(913, 913, 'home', '', '', '', 75083),
(914, 914, 'home', '', '', '', 75085),
(915, 915, 'home', '26218 Prairieview Road', 'Allen', 'Texas', 0),
(916, 916, 'home', '5181 Hanson Avenue', 'Dallas', 'Texas', 75087),
(917, 917, 'home', '50 Eastwood Junction', 'Dallas', 'Texas', 75045),
(918, 918, 'home', '8 Dapin Center', 'Dallas', 'Texas', 0),
(919, 919, 'home', '', '', '', 75009),
(920, 920, 'home', '20776 Wayridge Hill', 'Richardson', 'Texas', 0),
(921, 921, 'home', '', '', '', 75006),
(922, 922, 'home', '34866 Lindbergh Circle', 'Allen', 'Texas', 75086),
(923, 923, 'home', '11950 Meadow Ridge Street', 'Addison', 'Texas', 75086),
(924, 924, 'home', '634 Dennis Drive', 'Plano', 'Texas', 75054),
(925, 925, 'home', '6 Steensland Plaza', 'Plano', 'Texas', 75037),
(926, 926, 'home', '0 Haas Alley', 'Plano', 'Texas', 0),
(927, 927, 'home', '9835 Kropf Terrace', 'Dallas', 'Texas', 75009),
(928, 928, 'home', '', '', '', 75018),
(929, 929, 'home', '4768 Bay Pass', 'Richardson', 'Texas', 0),
(930, 930, 'home', '93 Lotheville Hill', 'Allen', 'Texas', 75089),
(931, 931, 'home', '9 Longview Pass', 'Richardson', 'Texas', 0),
(932, 932, 'home', '16872 Mosinee Place', 'Addison', 'Texas', 75033),
(933, 933, 'home', '', '', '', 0),
(934, 934, 'home', '5271 Drewry Circle', 'Plano', 'Texas', 0),
(935, 935, 'home', '64 Morningstar Junction', 'Allen', 'Texas', 75075),
(936, 936, 'home', '16689 Sunfield Center', 'Addison', 'Texas', 0),
(937, 937, 'home', '8 Granby Junction', 'Dallas', 'Texas', 75093),
(938, 938, 'home', '0 Grim Trail', 'Dallas', 'Texas', 75026),
(939, 939, 'home', '306 Graceland Drive', 'Addison', 'Texas', 75094),
(940, 940, 'home', '4191 Del Sol Street', 'Allen', 'Texas', 75049),
(941, 941, 'home', '290 Londonderry Drive', 'Plano', 'Texas', 0),
(942, 942, 'home', '3 Saint Paul Pass', 'Allen', 'Texas', 75064),
(943, 943, 'home', '66 Surrey Circle', 'Dallas', 'Texas', 75082),