forked from ArielleRamgoolie/MyBnB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Listings.sql
400 lines (400 loc) · 85.6 KB
/
Listings.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
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (7, 116, 'house', 55.4543246, 57.2840834, '4 Oneill Terrace', 55.95, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (8, 92, 'apartment', 111.6556388, -7.5450262, '5 Manufacturers Junction', 68.62, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (9, 8, 'house', 4.718821, 45.991471, '40 Kingsford Circle', 28.67, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (10, 372, 'apartment', 123.3766669, -8.4963229, '392 2nd Way', 27.26, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (11, 370, 'house', -85.3162066, 35.0010118, '62979 Westport Lane', 47.56, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (12, 170, 'hotel', 22.5927946, 38.6390583, '4 Nancy Avenue', 60.26, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (13, 110, 'apartment', 109.924347, 21.48227, '241 Moulton Hill', 74.62, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (14, 76, 'hotel', 84.8672171, 27.0449005, '87 Crownhardt Place', 14.49, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (15, 130, 'hotel', 25.3912281, 37.4475393, '56856 Brentwood Hill', 25.21, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (16, 244, 'apartment', 109.361864, 32.388854, '2648 Clyde Gallagher Parkway', 26.0, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (17, 240, 'house', 44.5593439, 40.025532, '442 Straubel Crossing', 81.53, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (18, 44, 'hotel', 7.3129299, 11.5184818, '2 Michigan Crossing', 77.47, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (19, 174, 'apartment', 85.9779314, 52.5277159, '687 Annamark Parkway', 84.3, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (20, 168, 'hotel', -111.8628205, 40.7345053, '122 Marquette Court', 7.93, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (21, 178, 'house', 121.8385996, 13.4485234, '2 Erie Pass', 41.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (22, 200, 'house', 36.7307641, 34.8422936, '3 Heath Street', 40.47, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (23, 378, 'apartment', -8.5995773, 42.4385891, '453 Magdeline Hill', 37.65, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (24, 182, 'house', 120.8898149, 15.6432256, '2 Florence Plaza', 74.28, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (25, 2, 'apartment', 121.0059518, 14.4693883, '42 Coolidge Center', 57.42, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (26, 344, 'hotel', 119.8815203, -3.4590744, '3104 Swallow Park', 35.8, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (27, 80, 'hotel', 121.1472247, 15.5700166, '66 Bluestem Lane', 75.06, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (28, 398, 'house', 20.7644305, 48.081286, '5 Lotheville Avenue', 49.62, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (29, 254, 'house', -89.362656, 15.113515, '8764 Lunder Circle', 94.94, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (30, 40, 'hotel', 95.775494, 29.849977, '713 Susan Place', 53.32, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (31, 268, 'hotel', 110.5215459, -1.5697615, '60 Forster Hill', 80.61, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (32, 102, 'hotel', -14.935965, 11.3410027, '242 Pawling Lane', 32.14, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (33, 208, 'house', 14.5139265, 35.8659607, '8597 Grasskamp Hill', 27.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (34, 164, 'hotel', -72.5293562, 18.5382815, '25 Lakewood Gardens Center', 63.63, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (35, 152, 'hotel', 12.3260336, 58.284686, '45 East Court', 38.64, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (36, 370, 'house', 122.4656415, 9.6026645, '534 Reindahl Hill', 70.94, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (37, 24, 'hotel', 106.8329412, -6.3007596, '5 Petterle Center', 5.75, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (38, 72, 'apartment', -75.282299, 6.724917, '53937 Rutledge Court', 20.53, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (39, 196, 'hotel', 17.8434702, 59.4205168, '4 High Crossing Park', 51.97, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (40, 308, 'house', 115.148803, -8.496803, '09 Pierstorff Park', 44.45, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (41, 236, 'hotel', 103.8923786, 52.53255, '7285 Pond Crossing', 79.33, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (42, 24, 'hotel', 108.5144791, -6.7597964, '250 Norway Maple Street', 60.91, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (43, 380, 'apartment', -127.17428, 54.78036, '31734 Lukken Alley', 87.5, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (44, 356, 'apartment', -84.3436881, 33.723039, '29789 Sachs Court', 48.58, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (45, 308, 'apartment', 25.5831031, 60.6458731, '54686 Southridge Parkway', 21.38, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (46, 304, 'house', 20.1143155, 51.30568, '5 Valley Edge Terrace', 26.15, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (47, 208, 'apartment', 117.130129, 25.732824, '9 Paget Terrace', 71.46, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (48, 136, 'hotel', -8.5359207, 41.0394198, '7258 Sunbrook Plaza', 55.41, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (49, 240, 'apartment', 22.7120308, 37.6883607, '520 Dovetail Circle', 1.12, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (50, 104, 'apartment', 103.035694, 11.5466458, '048 Walton Park', 17.52, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (51, 286, 'house', 3.8626074, 43.6121586, '6 Clove Lane', 65.2, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (52, 88, 'hotel', 44.0177989, 13.5775886, '6 Monterey Place', 46.95, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (53, 274, 'house', 33.8723511, 46.4566661, '485 Kipling Avenue', 52.03, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (54, 282, 'hotel', -49.6879727, -21.0482479, '3 Paget Road', 21.07, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (55, 270, 'hotel', -1.4703339, 43.4968733, '5 Thierer Plaza', 67.06, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (56, 86, 'house', 52.0111855, 55.3605576, '78 Oakridge Trail', 77.22, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (57, 88, 'apartment', 121.0004951, 6.0536421, '35022 Lien Hill', 57.37, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (58, 2, 'hotel', 117.970699, 37.38198, '654 Hansons Crossing', 74.24, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (59, 120, 'house', 31.4697, 49.751033, '205 Crescent Oaks Circle', 85.49, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (60, 330, 'apartment', -9.1570572, 38.6052584, '1 Lillian Junction', 64.61, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (61, 370, 'hotel', 17.4879349, 59.5782797, '64586 Moose Parkway', 1.66, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (62, 282, 'hotel', -73.268611, -14.1325, '3 Gulseth Circle', 79.8, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (63, 330, 'apartment', -97.4996835, 35.4674683, '2 Novick Center', 37.03, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (64, 188, 'apartment', -8.949136, 38.6491541, '9243 David Point', 32.39, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (65, 2, 'house', 108.6351043, -7.4977546, '6531 Moulton Terrace', 17.29, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (66, 90, 'hotel', 21.9055846, 40.4339379, '46 Anniversary Park', 44.16, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (67, 338, 'house', 31.1990697, 58.4981562, '89125 Longview Place', 25.88, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (68, 186, 'hotel', 114.938684, 24.44218, '1836 Linden Drive', 93.68, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (69, 292, 'house', -48.7162067, -25.4328356, '7595 Onsgard Plaza', 74.02, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (70, 180, 'hotel', 118.169798, 30.113962, '0430 Dennis Park', 22.89, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (71, 368, 'apartment', 114.497908, 31.28855, '7345 Pond Junction', 26.97, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (72, 18, 'house', 119.783935, 31.912048, '9 Linden Point', 95.84, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (73, 118, 'house', 16.0850004, 50.0521348, '051 Maple Wood Pass', 29.59, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (74, 80, 'house', 24.9412435, 60.1932037, '836 Becker Trail', 1.84, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (75, 326, 'apartment', -94.5521274, 39.0345609, '43 Lunder Street', 57.14, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (76, 224, 'house', -106.78, 32.31, '7 Tony Street', 83.45, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (77, 134, 'apartment', 22.7948195, 63.1454739, '98699 Brickson Park Parkway', 67.34, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (78, 388, 'hotel', -77.6534904, 0.9452075, '138 Arapahoe Street', 97.1, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (79, 320, 'hotel', -58.0352133, -34.9001596, '3354 Everett Pass', 24.63, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (80, 130, 'apartment', 121.266579, 30.169665, '48 Oriole Way', 80.52, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (81, 206, 'apartment', 111.982232, 21.857958, '58554 Westerfield Parkway', 65.53, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (82, 92, 'hotel', 109.752583, 18.400092, '0922 Mcbride Park', 3.41, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (83, 394, 'hotel', 14.5320278, 35.8914242, '17731 School Avenue', 99.37, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (84, 242, 'apartment', 122.5270677, 11.1946369, '21 Havey Trail', 29.52, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (85, 384, 'house', 114.033247, 28.008237, '89 Anthes Hill', 9.46, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (86, 176, 'house', 107.8346924, 21.1062206, '1 Logan Avenue', 44.93, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (87, 338, 'hotel', 44.99309, 12.87678, '728 Bartelt Pass', 93.75, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (88, 40, 'hotel', -110.7200371, 54.2681766, '01083 Northport Alley', 95.9, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (89, 152, 'house', 14.3013689, 49.9293234, '231 Armistice Lane', 10.24, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (90, 128, 'hotel', 3.7139045, 51.0003903, '882 Erie Hill', 10.17, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (91, 124, 'hotel', 13.553217, 58.175029, '64 Dwight Hill', 19.47, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (92, 304, 'apartment', -46.5282973, -22.5905906, '73 Moland Drive', 56.61, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (93, 386, 'house', 99.5096031, 16.4739491, '7127 Helena Way', 96.29, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (94, 262, 'hotel', 34.34085, 31.37389, '9 Bowman Way', 21.54, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (95, 40, 'house', 121.990929, 12.261245, '34407 Vernon Hill', 35.71, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (96, 204, 'hotel', 81.280527, 40.547653, '2 Hooker Lane', 73.18, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (97, 282, 'apartment', 24.9584208, 60.1946148, '6988 Oak Park', 63.74, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (98, 328, 'house', 113.366904, 22.948016, '586 Hagan Junction', 11.1, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (99, 308, 'house', -56.1494143, -21.4803962, '1 Hermina Alley', 83.99, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (100, 126, 'house', 17.592739, 43.3831419, '5 South Circle', 99.44, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (101, 316, 'house', 34.5830034, 58.5083791, '06585 Fisk Hill', 85.93, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (102, 88, 'house', 111.013556, 21.514163, '5 3rd Hill', 81.55, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (103, 190, 'hotel', -78.0682254, 18.2712491, '79910 Granby Terrace', 69.09, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (104, 74, 'house', 147.3271949, -42.8821377, '1 Mosinee Hill', 19.39, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (105, 358, 'apartment', 1.5948224, 50.7308185, '22859 2nd Drive', 35.73, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (106, 190, 'apartment', -49.5076392, -25.1169056, '03 Marcy Pass', 12.89, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (107, 126, 'house', -84.3857442, 30.4649282, '24701 Steensland Park', 92.25, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (108, 140, 'apartment', 122.615819, 10.829771, '42624 Beilfuss Crossing', 81.56, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (109, 8, 'hotel', 100.5577407, 14.4612646, '218 Eastlawn Way', 22.1, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (110, 122, 'hotel', 72.3382061, 53.6362335, '27 Westport Plaza', 7.21, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (111, 60, 'house', 44.1463438, 54.8583596, '56 Sachtjen Alley', 61.36, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (112, 108, 'apartment', 26.7198789, 56.8999269, '400 Mandrake Road', 69.57, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (113, 320, 'hotel', 16.1653052, 58.5706557, '65476 Amoth Center', 23.21, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (114, 288, 'hotel', -7.2170293, 41.0672146, '81136 Ramsey Trail', 72.24, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (115, 240, 'house', 113.9725126, 22.3908295, '3 Birchwood Crossing', 68.61, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (116, 68, 'house', 42.7491668, 44.0227778, '13510 Debs Avenue', 23.68, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (117, 132, 'house', -74.886835, 5.199505, '8 Pepper Wood Street', 71.78, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (118, 148, 'hotel', 111.144319, 37.518314, '2 High Crossing Circle', 60.95, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (119, 244, 'house', 6.0187806, 51.1806274, '60 Brentwood Parkway', 3.26, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (120, 184, 'hotel', 69.1809574, 41.4636032, '28285 Summit Lane', 51.86, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (121, 266, 'house', -8.942153, 39.7433445, '1604 Springview Plaza', 29.99, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (122, 378, 'apartment', 112.0267712, -7.9062121, '8515 Northland Terrace', 47.44, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (123, 354, 'house', 106.69511, -6.150443, '79643 Kenwood Circle', 98.15, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (124, 348, 'apartment', 104.158705, 30.823499, '35 Forest Run Junction', 28.91, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (125, 342, 'house', 96.0891032, 21.9588282, '5865 Fairview Terrace', 44.48, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (126, 242, 'apartment', 120.9869405, 14.7008738, '1 5th Place', 82.77, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (127, 136, 'hotel', 120.649341, 31.463475, '5 Laurel Place', 1.68, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (128, 354, 'house', 112.432825, 39.331595, '07520 Monterey Avenue', 71.55, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (129, 268, 'hotel', 19.8335496, 45.2671352, '6 Mendota Alley', 90.31, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (130, 284, 'hotel', 109.412626, 19.233277, '2426 Gina Drive', 10.05, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (131, 86, 'hotel', 100.309489, -0.679873, '7 Jay Drive', 87.81, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (132, 136, 'hotel', 35.254768, 31.896059, '6 Rieder Road', 34.18, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (133, 340, 'hotel', 112.999502, 28.1905018, '091 Haas Park', 47.28, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (134, 182, 'hotel', 119.7020606, -2.9755226, '60 Victoria Street', 54.64, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (135, 156, 'house', 117.3437409, 31.7304839, '95115 Karstens Court', 26.05, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (136, 194, 'apartment', 127.48889, 36.10306, '86 Old Gate Point', 97.18, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (137, 306, 'house', 15.3775245, 10.2748807, '915 Milwaukee Hill', 40.63, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (138, 12, 'hotel', 121.42076, 28.65638, '713 Swallow Parkway', 18.93, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (139, 382, 'apartment', 1.5994581, 42.5666535, '504 Kenwood Terrace', 53.56, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (140, 16, 'apartment', 35.9510395, 56.0349544, '161 Swallow Lane', 41.2, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (141, 132, 'hotel', 108.117456, 34.326903, '15020 Tennyson Hill', 80.08, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (142, 378, 'apartment', 18.4033, 49.94912, '5383 Green Ridge Park', 35.49, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (143, 300, 'hotel', 119.382381, 31.717564, '516 Trailsway Place', 95.14, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (144, 72, 'hotel', 127.5098827, 37.8315403, '5 Dakota Street', 70.82, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (145, 280, 'apartment', 17.5331351, 58.8946515, '94773 Moland Hill', 53.6, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (146, 278, 'house', 109.026675, 23.48193, '395 Corscot Pass', 81.64, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (147, 278, 'hotel', -8.5310302, 41.0394733, '78 Hoepker Court', 81.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (148, 10, 'house', 130.7788921, 45.730664, '56 Northview Point', 79.17, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (149, 278, 'hotel', 108.5196028, -6.7827104, '2142 Heath Drive', 4.07, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (150, 148, 'apartment', -77.5404459, 18.4691383, '7 Jay Parkway', 23.89, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (151, 274, 'apartment', 100.7323332, 14.2524816, '4 Thackeray Lane', 89.58, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (152, 18, 'hotel', 48.2667279, -13.3970988, '92016 Toban Point', 37.65, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (153, 312, 'house', 19.1490758, 51.718833, '845 Macpherson Drive', 91.65, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (154, 184, 'hotel', 102.664376, 25.038296, '43 Melby Lane', 30.67, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (155, 194, 'hotel', 117.694969, 27.027081, '19 Walton Street', 60.34, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (156, 84, 'house', 108.4691492, -7.4869186, '16309 Graedel Circle', 93.78, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (157, 198, 'hotel', 120.9888316, 14.657758, '48209 Prentice Point', 66.52, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (158, 116, 'house', 114.18077, 22.279379, '24 Iowa Alley', 29.97, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (159, 84, 'house', 3.1244315, 50.6140977, '51926 Main Drive', 29.94, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (160, 290, 'apartment', 18.7082571, 50.4072694, '9307 Pearson Circle', 35.18, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (161, 304, 'hotel', 71.9355029, 34.0078256, '07 Ludington Place', 54.99, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (162, 112, 'apartment', 18.946898, 53.3800563, '2 Pond Parkway', 71.17, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (163, 160, 'house', -149.4260421, -17.6509195, '089 Killdeer Circle', 33.23, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (164, 184, 'hotel', 118.674614, 37.433963, '55 Spenser Crossing', 43.07, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (165, 206, 'hotel', 12.7264154, 57.4715317, '91 Merchant Terrace', 79.3, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (166, 76, 'apartment', 47.3773853, 42.3728288, '277 Ramsey Point', 76.25, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (167, 188, 'apartment', 32.4715312, 26.1218315, '1931 Jay Trail', 4.04, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (168, 108, 'apartment', 27.5126688, 65.2674812, '2658 Pepper Wood Pass', 35.52, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (169, 108, 'hotel', 121.0299006, 14.4932929, '66 Susan Plaza', 98.66, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (170, 310, 'hotel', 25.33483, 57.5225959, '2 Oxford Circle', 35.62, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (171, 82, 'apartment', -1.5401497, 47.2550409, '1031 Fremont Center', 41.36, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (172, 18, 'apartment', 56.3724781, 57.7297471, '4119 Hermina Hill', 13.57, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (173, 254, 'house', 100.3617345, -0.9342008, '012 Roxbury Court', 65.68, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (174, 284, 'hotel', 108.28245, 45.23223, '25 Northwestern Hill', 55.4, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (175, 318, 'apartment', 109.482752, 28.178059, '1 Sycamore Hill', 13.3, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (176, 388, 'house', -49.4600885, -18.9745738, '8557 Goodland Junction', 84.57, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (177, 154, 'hotel', 120.266622, 30.30791, '3321 Crest Line Street', 91.93, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (178, 280, 'apartment', 33.9686556, 68.0986274, '21 Emmet Way', 10.18, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (179, 102, 'hotel', 32.3008149, 60.1163207, '00 Drewry Crossing', 33.17, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (180, 388, 'apartment', 19.6650593, 46.1005467, '15 Cascade Way', 82.99, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (181, 154, 'hotel', -86.2869507, 39.8911731, '9 Lien Hill', 85.18, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (182, 94, 'apartment', 103.8280655, 30.7998721, '55 Fulton Junction', 90.99, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (183, 58, 'apartment', 35.149421, 31.574996, '1159 Waywood Street', 67.33, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (184, 50, 'hotel', 102.267712, 27.88157, '378 Bluestem Center', 94.47, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (185, 152, 'hotel', 45.2217972, 54.147514, '4329 Sachtjen Park', 42.83, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (186, 328, 'house', 124.3754414, 6.7640051, '95960 Shasta Plaza', 54.65, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (187, 248, 'house', 110.643305, 24.633362, '89904 Moulton Trail', 39.34, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (188, 296, 'apartment', 32.3919624, 66.870387, '7 Main Junction', 14.72, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (189, 78, 'apartment', 72.5051389, 32.2298219, '5115 Pearson Parkway', 82.54, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (190, 230, 'apartment', 109.599191, 27.948308, '966 Bartelt Circle', 36.32, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (191, 322, 'house', 113.4895468, 23.3854292, '0063 Brickson Park Crossing', 29.56, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (192, 96, 'house', 123.5770012, -10.1790674, '3 Superior Crossing', 83.26, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (193, 50, 'hotel', 120.6359, -8.4539, '0260 Melrose Place', 96.35, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (194, 260, 'house', 71.6276159, 34.2211097, '88052 Karstens Junction', 67.42, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (195, 10, 'house', -4.031512, 57.961476, '226 Artisan Point', 94.43, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (196, 264, 'apartment', -74.7, -12.4, '13219 Gale Avenue', 97.74, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (197, 148, 'hotel', -46.5648481, -23.6898429, '48573 Graceland Circle', 77.58, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (198, 350, 'house', 6.7625867, 51.3305246, '943 Ludington Plaza', 98.59, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (199, 28, 'apartment', 37.4416961, 55.632969, '240 Quincy Center', 78.77, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (200, 320, 'house', -50.2475804, -20.2810232, '70 Arrowood Trail', 31.14, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (201, 210, 'house', -6.2554371, 53.2767301, '771 Bluestem Avenue', 35.46, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (202, 396, 'house', 68.4065979, 25.8056887, '6 Pepper Wood Terrace', 33.7, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (203, 232, 'apartment', 15.508083, 60.429728, '6 Melody Court', 99.26, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (204, 196, 'hotel', -7.8123805, 41.0953745, '75 Donald Way', 47.3, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (205, 350, 'hotel', 113.625328, 34.746611, '56 Bluejay Way', 41.55, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (206, 320, 'hotel', -80.1791368, 8.5974312, '32829 Erie Place', 13.01, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (207, 344, 'house', 123.6010244, -10.1573402, '77905 Donald Place', 19.08, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (208, 208, 'house', -46.4124616, -24.0088421, '85 Columbus Terrace', 78.04, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (209, 224, 'house', 110.332814, 31.052914, '4 Elka Parkway', 32.64, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (210, 214, 'house', 2.323941, 48.759003, '457 Crowley Point', 24.29, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (211, 394, 'house', -5.5781378, 32.6797904, '11279 Debra Drive', 51.05, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (212, 284, 'hotel', 73.9309807, 45.2068153, '5722 Sycamore Parkway', 93.89, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (213, 136, 'hotel', 94.928484, 36.406404, '5816 Shasta Parkway', 61.13, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (214, 328, 'house', 118.43196, 24.705643, '87 Esker Pass', 12.8, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (215, 368, 'house', 4.3520438, 43.8447278, '652 Gateway Circle', 53.9, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (216, 216, 'house', 116.854021, 29.519664, '0891 Kenwood Street', 89.58, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (217, 34, 'apartment', 122.3066411, 10.7179292, '819 Steensland Road', 87.46, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (218, 354, 'apartment', 115.5233, -8.7183, '5 Graceland Plaza', 55.2, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (219, 96, 'hotel', 5.8978018, 43.4945737, '418 Bayside Avenue', 41.98, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (220, 212, 'apartment', 126.7366293, 35.9676772, '13456 Spaight Crossing', 3.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (221, 388, 'hotel', 47.1156092, 36.4051945, '89 Arapahoe Trail', 11.75, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (222, 314, 'house', -92.08, 32.53, '5 Alpine Drive', 99.66, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (223, 138, 'house', 17.5142121, 47.5202786, '86536 Buell Drive', 20.42, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (224, 346, 'hotel', 102.746704, 23.156538, '935 Walton Park', 63.51, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (225, 248, 'house', 86.2093804, 54.2407853, '6073 Talmadge Point', 46.96, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (226, 160, 'house', 14.4161297, 48.6514469, '699 Butternut Circle', 27.49, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (227, 320, 'apartment', 129.7283548, 62.0587526, '60343 Oriole Road', 92.58, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (228, 278, 'house', 105.390592, 27.685255, '6 Sloan Hill', 20.64, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (229, 328, 'apartment', 123.309328, -8.2764084, '62933 Mariners Cove Circle', 2.51, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (230, 58, 'house', 26.8529432, 37.1321706, '6019 Warbler Alley', 36.14, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (231, 292, 'hotel', 120.6784858, 27.9937685, '1 Heffernan Place', 37.59, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (232, 234, 'hotel', 112.989854, 28.112525, '4045 Mesta Plaza', 49.5, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (233, 340, 'house', 17.3189958, 49.2277083, '5228 Sutherland Court', 78.35, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (234, 20, 'house', -73.616667, -14.116667, '5663 Hanson Center', 39.3, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (235, 164, 'house', 48.01667, 15.01667, '7 Dwight Court', 73.34, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (236, 286, 'hotel', 20.2835741, 49.4562624, '261 Bartillon Court', 11.51, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (237, 20, 'apartment', 121.5221244, 31.2367474, '0 Vahlen Center', 53.36, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (238, 16, 'apartment', -8.3542102, 39.4635996, '359 Express Lane', 58.06, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (239, 324, 'apartment', 50.3334447, 40.4746848, '49 Delladonna Plaza', 98.66, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (240, 72, 'hotel', -99.1829833, 23.7322067, '9677 Golf View Avenue', 54.8, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (241, 316, 'apartment', 4.810107, 44.1372925, '97609 2nd Terrace', 39.31, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (242, 210, 'hotel', 112.341117, 27.33699, '97 Forster Drive', 15.96, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (243, 192, 'hotel', 2.6780176, 48.5129473, '0930 East Park', 32.24, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (244, 136, 'hotel', -78.7348674, -6.5588437, '4 Dexter Circle', 1.11, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (245, 258, 'apartment', 48.079379, 29.2964866, '22 Katie Road', 35.03, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (246, 146, 'house', 111.244529, 21.955472, '75 Goodland Circle', 88.59, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (247, 112, 'house', 99.262763, 35.001453, '15 Alpine Crossing', 6.12, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (248, 22, 'hotel', 67.8812063, 55.0449125, '94 Fremont Alley', 22.88, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (249, 200, 'hotel', -57.2000138, -24.085215, '6 Service Way', 76.02, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (250, 156, 'hotel', 19.9262381, 50.133176, '8 Hoffman Drive', 60.34, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (251, 328, 'hotel', 44.2289441, 17.5656036, '5 Sommers Court', 32.64, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (252, 290, 'hotel', 131.0436289, 30.6509359, '62286 Bluestem Court', 9.76, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (253, 262, 'apartment', 120.6569721, 28.0093247, '551 New Castle Point', 39.91, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (254, 242, 'hotel', -58.5613439, -34.6504677, '48471 Sauthoff Street', 94.92, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (255, 74, 'house', 34.82621, 62.8487, '6220 Oriole Place', 61.86, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (256, 68, 'apartment', 138.9099913, 37.6533531, '304 Charing Cross Plaza', 78.46, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (257, 284, 'house', 122.6157793, 13.4734999, '2404 Hoffman Alley', 51.28, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (258, 210, 'hotel', 103.757315, 31.026394, '096 Logan Street', 34.38, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (259, 238, 'house', 21.6426843, 47.5962342, '06001 Jana Terrace', 50.5, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (260, 280, 'apartment', -75.508016, -11.8532073, '76 Donald Circle', 36.03, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (261, 364, 'apartment', 134.041335, 35.0780152, '70 Kensington Place', 98.12, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (262, 264, 'apartment', 101.6716295, 3.2093353, '87 Mosinee Place', 6.56, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (263, 326, 'apartment', -86.8722146, 36.1030036, '8 Sheridan Circle', 89.34, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (264, 300, 'apartment', 14.0921466, 50.287503, '5917 Dixon Way', 35.94, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (265, 248, 'hotel', 24.7371099, -34.007765, '19749 Almo Parkway', 25.34, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (266, 356, 'house', 120.9905117, 14.295795, '88094 Hollow Ridge Trail', 86.12, 'Mississauga', 'W3W 3W3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (267, 120, 'house', 55.1706992, 37.083896, '43 Forest Run Street', 75.69, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (268, 172, 'house', 46.0897124, -25.1720132, '985 5th Road', 36.59, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (269, 126, 'apartment', 100.8564355, -0.6000092, '62965 Mesta Park', 72.07, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (270, 60, 'hotel', -8.7261408, 41.5237953, '81 Express Lane', 64.39, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (271, 172, 'hotel', 114.021538, 33.387684, '3895 Fairview Hill', 68.38, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (272, 272, 'hotel', -8.5246084, 39.6812698, '35372 Spohn Crossing', 37.18, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (273, 266, 'hotel', 117.3028803, -8.9670697, '665 Memorial Lane', 78.37, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (274, 138, 'apartment', 109.715304, 32.318255, '73784 Northland Alley', 64.89, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (275, 280, 'apartment', -77.0296868, 38.8974442, '499 Atwood Place', 77.62, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (276, 230, 'hotel', 104.1019324, 1.1963019, '45651 Dwight Circle', 5.5, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (277, 206, 'house', 20.0136604, 51.3830331, '4 Vidon Place', 61.76, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (278, 232, 'apartment', 32.4242426, 54.4185233, '5 Heath Drive', 11.84, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (279, 352, 'house', 102.652483, 29.344616, '43 Clove Park', 50.29, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (280, 158, 'house', 110.6129124, -7.6966822, '952 Coleman Alley', 83.73, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (281, 268, 'house', -79.929616, -6.8324793, '27754 Lake View Crossing', 21.73, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (282, 26, 'hotel', 41.45968, 52.63744, '59201 Northview Way', 49.66, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (283, 34, 'hotel', 17.2842162, 62.3946271, '976 Bowman Court', 85.15, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (284, 100, 'house', 116.4559849, 39.9317949, '44614 Morning Street', 23.24, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (285, 388, 'hotel', -64.1959217, -31.4603741, '770 Fremont Alley', 12.44, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (286, 94, 'house', -77.1463593, -10.1239403, '51 Sage Hill', 94.8, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (287, 324, 'hotel', -68.693687, -16.20274, '607 Eastlawn Pass', 54.66, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (288, 116, 'house', 35.065202, 31.869937, '927 Melby Avenue', 35.95, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (289, 224, 'apartment', 37.690366, 55.874056, '8 8th Road', 50.44, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (290, 354, 'hotel', 5.2893597, 47.9318074, '86 Talisman Court', 69.3, 'Kitchener', 'I9I 9I9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (291, 328, 'house', 126.5151395, 39.8286394, '3386 Brentwood Crossing', 62.78, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (292, 64, 'house', 87.2598304, 53.5484776, '00440 Elgar Junction', 61.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (293, 254, 'apartment', 135.8074728, 35.5267333, '4889 Swallow Terrace', 23.17, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (294, 362, 'house', -43.8273373, -22.4720256, '40734 Merry Alley', 51.93, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (295, 324, 'hotel', -8.5893138, 41.4472964, '34 Steensland Lane', 99.89, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (296, 68, 'apartment', 23.8954385, 50.6507001, '96 Drewry Street', 96.83, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (297, 370, 'apartment', 37.5833061, 0.355636, '20 Southridge Avenue', 81.45, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (298, 64, 'house', 108.298731, -6.460817, '87177 Hovde Point', 61.45, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (299, 196, 'house', 24.7069091, 40.9063009, '4652 Washington Junction', 31.93, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (300, 208, 'hotel', -3.95453, 35.23619, '6479 Glendale Place', 15.06, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (301, 64, 'hotel', 113.0126011, 22.9550072, '47486 Sauthoff Parkway', 4.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (302, 362, 'apartment', -39.3621196, -3.3072032, '9050 Garrison Trail', 32.8, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (303, 238, 'hotel', 31.9594674, 53.6091856, '1 Harper Avenue', 21.02, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (304, 40, 'apartment', 121.0303692, 14.4332941, '12 Maple Wood Drive', 39.32, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (305, 106, 'apartment', 15.1025075, 32.3196827, '077 Laurel Drive', 22.15, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (306, 258, 'house', 124.6616, -8.3884, '5 Towne Avenue', 65.26, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (307, 124, 'house', 111.6556388, -7.5450262, '239 Pawling Trail', 36.02, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (308, 296, 'house', 14.3592112, 46.0082081, '2409 Northwestern Pass', 66.11, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (309, 302, 'apartment', 20.2147861, 63.8135855, '614 Jay Lane', 35.7, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (310, 166, 'house', 106.6352362, 10.7480929, '48573 Southridge Crossing', 14.95, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (311, 212, 'hotel', 115.104389, 35.88518, '89 Stephen Circle', 66.51, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (312, 286, 'house', 46.0479668, 50.7720302, '3993 Monica Pass', 75.15, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (313, 30, 'hotel', 18.6917922, 12.1862546, '3032 Hansons Street', 35.94, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (314, 248, 'apartment', -99.2577715, 19.3608203, '245 Graedel Avenue', 89.61, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (315, 212, 'apartment', 100.176498, 26.560231, '07 Sachs Drive', 59.87, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (316, 310, 'apartment', 18.1227285, 52.8886634, '03240 Toban Circle', 14.61, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (317, 74, 'apartment', 118.479654, 36.684789, '354 Charing Cross Pass', 43.65, 'Markham', 'O5O 5O5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (318, 112, 'apartment', 30.245977, 59.85299, '7 Florence Plaza', 11.56, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (319, 186, 'house', 22.9223719, 40.6536074, '3 Vera Junction', 43.43, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (320, 282, 'apartment', -73.2230401, -39.8084258, '6 Burning Wood Trail', 3.25, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (321, 320, 'apartment', 12.571637, 55.6790868, '55 South Alley', 29.02, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (322, 152, 'house', 21.053265, 52.1012559, '62 Vahlen Pass', 53.57, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (323, 242, 'apartment', 88.5278663, 56.1263981, '8 Vera Hill', 61.21, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (324, 60, 'hotel', 52.190142, 58.6772898, '5 Twin Pines Place', 62.28, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (325, 366, 'apartment', 111.528999, 1.411517, '088 Clemons Crossing', 13.58, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (326, 58, 'house', 112.4962138, 34.6914551, '8786 Pine View Lane', 43.47, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (327, 280, 'house', 100.3573891, 5.3523231, '68 Crowley Place', 50.26, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (328, 88, 'hotel', -87.8660235, 13.3050684, '6 Montana Road', 78.38, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (329, 154, 'apartment', -0.1550173, 51.4986953, '9950 Saint Paul Junction', 52.59, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (330, 144, 'hotel', 120.5622121, 37.0237497, '80786 Ruskin Hill', 54.71, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (331, 22, 'apartment', 34.950506, 32.235466, '77 Badeau Street', 28.31, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (332, 116, 'apartment', 106.7567589, -6.2649072, '998 Fordem Junction', 33.45, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (333, 98, 'house', -45.5313666, -20.0292302, '649 Hazelcrest Parkway', 82.87, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (334, 48, 'hotel', 20.8378422, 49.9579835, '2 Rigney Drive', 55.25, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (335, 170, 'apartment', 80.3038321, 41.1846097, '08 Mallard Way', 5.34, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (336, 114, 'apartment', 130.3267278, 31.2840967, '77 International Place', 37.24, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (337, 314, 'house', 119.831625, 31.880273, '45916 Eggendart Road', 16.32, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (338, 206, 'house', 57.5265289, -20.3170872, '1 Drewry Circle', 3.25, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (339, 378, 'apartment', 100.1255164, 17.2702191, '808 Morningstar Place', 17.64, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (340, 58, 'apartment', 102.7364962, -3.3552972, '28850 Myrtle Place', 74.45, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (341, 206, 'apartment', -68.1346594, -16.5030766, '32 Delaware Road', 27.44, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (342, 174, 'hotel', 120.4674034, 15.9769657, '55882 Superior Street', 82.51, 'Waterloo', 'B8B 8B8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (343, 162, 'hotel', 105.6691136, 20.1276773, '53 Little Fleur Crossing', 66.45, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (344, 250, 'apartment', 31.3198491, -17.3013059, '1810 Corben Way', 78.73, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (345, 124, 'hotel', 109.326383, 28.138525, '88882 Loeprich Place', 43.51, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (346, 390, 'house', 2.0928189, 44.2641474, '17882 Golf Lane', 36.09, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (347, 94, 'house', 4.6999899, 51.792865, '2 Golden Leaf Street', 69.34, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (348, 24, 'apartment', 15.2255472, 46.614358, '144 Heath Lane', 92.16, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (349, 398, 'apartment', 117.323725, 34.810487, '8 Arkansas Park', 8.85, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (350, 20, 'house', 100.980225, 18.601533, '5525 Glendale Avenue', 60.86, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (351, 372, 'house', 6.1553498, 9.8097475, '2 Dottie Point', 47.85, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (352, 250, 'apartment', 63.0632053, 57.6680135, '63 Warrior Alley', 58.9, 'Vaughan', 'Q7Q 7Q7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (353, 122, 'apartment', 174.9939663, -40.9026164, '34 Russell Terrace', 23.34, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (354, 178, 'apartment', 17.6300093, 59.8509005, '86 Dwight Point', 10.58, 'Toronto', 'A1A 1A1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (355, 190, 'hotel', 112.896606, 23.156045, '40613 Kedzie Alley', 7.92, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (356, 308, 'house', 91.5523435, 27.3325014, '674 Truax Plaza', 60.44, 'Oakville', 'Z6Z 6Z6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (357, 300, 'house', 18.4538421, 44.6254349, '5082 Duke Avenue', 7.21, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (358, 390, 'apartment', 118.5155901, -8.4589273, '407 Pearson Avenue', 67.27, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (359, 190, 'hotel', 106.8502879, -6.3621916, '089 Barnett Avenue', 74.64, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (360, 292, 'apartment', 21.888524, 50.643436, '50 Westport Plaza', 42.33, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (361, 340, 'hotel', 112.305145, 22.183206, '93 Sycamore Plaza', 5.96, 'Guelph', 'D0D 0D0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (362, 102, 'hotel', 49.0631743, 33.4955028, '78628 Novick Center', 22.79, 'Windsor', 'L2L 2L2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (363, 340, 'house', 110.846846, -6.808273, '73 7th Pass', 26.81, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (364, 306, 'house', 133.5697428, 34.0055653, '01844 Troy Lane', 20.88, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (365, 292, 'apartment', -71.5036905, 18.8782625, '4270 Prentice Point', 12.94, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (366, 242, 'apartment', 39.4372601, 10.5914216, '62911 Atwood Alley', 11.25, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (367, 238, 'house', 104.1698463, 15.8515169, '607 Arizona Alley', 69.99, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (368, 352, 'hotel', -96, 36.15, '264 Aberg Parkway', 23.33, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (369, 320, 'hotel', -43.9551381, -19.8446577, '5 Pond Plaza', 82.68, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (370, 234, 'house', 108.9383377, 11.9913493, '8506 Loftsgordon Center', 65.62, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (371, 28, 'house', 119.3081149, 26.0977366, '7355 Northridge Place', 67.02, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (372, 206, 'apartment', -11.4779299, 7.5048177, '8 Lakeland Hill', 93.84, 'Vaughan', 'R8R 8R8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (373, 346, 'hotel', 6.1549499, 45.9120061, '7 Sachtjen Plaza', 46.21, 'Toronto', 'B2B 2B2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (374, 172, 'house', 131.158416, 46.64635, '759 Union Street', 31.4, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (375, 300, 'hotel', 35.8080537, 58.5931974, '0 North Park', 86.32, 'Ottawa', 'C3C 3C3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (376, 350, 'house', 39.6526462, -5.3629365, '98233 Crownhardt Place', 73.68, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (377, 124, 'apartment', 113.447431, 28.94074, '4 Hoffman Center', 43.46, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (378, 24, 'house', 16.826031, 52.4368772, '185 Barby Trail', 47.65, 'Brampton', 'M3M 3M3', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (379, 132, 'apartment', 120.6428123, 15.1248652, '7 Ramsey Lane', 79.04, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (380, 94, 'house', -70.582502, -33.459409, '2 Fallview Circle', 40.18, 'Hamilton', 'F6F 6F6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (381, 34, 'hotel', 107.0096844, -6.2057339, '8 Marquette Pass', 57.43, 'London', 'H8H 8H8', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (382, 180, 'hotel', 104.063889, 34.392963, '2238 Clemons Point', 21.93, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (383, 192, 'house', 119.5281714, -3.8506762, '2116 Pine View Alley', 82.86, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (384, 298, 'house', 72.8160976, 40.5139985, '04956 Warbler Lane', 98.27, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (385, 398, 'house', -57.5872528, -25.3823822, '27 Prairie Rose Road', 23.93, 'Brampton', 'N4N 4N4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (386, 128, 'apartment', 113.1650014, -6.9216971, '8 Pankratz Court', 62.67, 'Burlington', 'V2V 2V2', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (387, 164, 'hotel', 123.380874, 12.481536, '2 Cottonwood Center', 74.08, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (388, 70, 'hotel', 16.1378776, 58.6144923, '834 Steensland Alley', 79.19, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (389, 386, 'house', 119.659553, 31.031933, '8 Jay Terrace', 71.46, 'Ottawa', 'D4D 4D4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (390, 164, 'house', 16.9388118, 8.2659713, '1797 Thierer Place', 40.82, 'Hamilton', 'E5E 5E5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (391, 120, 'apartment', 16.1084808, 48.7974858, '83 Brickson Park Lane', 11.62, 'Markham', 'P6P 6P6', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (392, 92, 'hotel', 114.397004, 38.135288, '3717 Brown Trail', 98.27, 'Kingston', 'S9S 9S9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (393, 136, 'house', 48.329762, 54.0282094, '6530 Fulton Place', 59.58, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (394, 2, 'apartment', 22.4510542, 40.946869, '5806 Elmside Lane', 76.0, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (395, 148, 'hotel', 19.3967698, 45.2497275, '0967 Thierer Terrace', 51.03, 'Kingston', 'T0T 0T0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (396, 274, 'hotel', -58.5845016, -34.4584447, '27 Monterey Park', 12.38, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (397, 278, 'hotel', 47.0875045, -21.4546147, '9 Merrick Park', 71.1, 'London', 'G7G 7G7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (398, 72, 'apartment', 48.26675, 54.42789, '40460 Trailsway Way', 37.91, 'Burlington', 'U1U 1U1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (399, 132, 'house', 5.7218985, 45.1934857, '95 Myrtle Circle', 16.98, 'Windsor', 'K1K 1K1', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (400, 392, 'apartment', 107.04219, 24.546876, '2959 Pawling Trail', 29.5, 'Guelph', 'C9C 9C9', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (401, 202, 'apartment', 19.4369847, 50.3879871, '350 Florence Trail', 70.71, 'Kitchener', 'J0J 0J0', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (402, 202, 'apartment', -7.6302454, 40.7003439, '8 Hoard Place', 24.16, 'Mississauga', 'X4X 4X4', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (403, 156, 'house', 77.0852258, 42.6503176, '160 Moland Drive', 13.62, 'Oakville', 'Y5Y 5Y5', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (404, 14, 'apartment', 109.23577, -7.62385, '00423 Chive Junction', 96.68, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (405, 256, 'house', -2.2298164, 34.9344195, '3 Welch Park', 31.7, 'Waterloo', 'A7A 7A7', 'Canada');
insert into Listings (id, host_id, type, longitude, latitude, address, price, city, postal_code, country) values (406, 176, 'house', -48.7862736, -22.3463487, '833 Anhalt Terrace', 96.44, 'Kitchener', 'I9I 9I9', 'Canada');