Spreadsheet: 69217d1269733950-vlookup-help-in-excel-excel
Sheet: Home Sales Data

Listing ID | Asking Price | Square Feet | Age | Annual Tax | Sales Price | Style | Bedroom | Bath | Date Listed | Date Sold | Days on Market | Price difference | Comment on Days on Market | Comment on Square Feet
101 | 87400 | 1236 | 3 | 707 | 77750 | Condo | 2 | 1 | 2009-11-22 00:00:00 | 2010-04-14 00:00:00 | 143 | 9650 | #N/A
102 | 110900 | 1740 | 4 | 816 | 105250 | Victorian | 2 | 1.5 | 2009-08-23 00:00:00 | 2010-06-20 00:00:00 | 301 | 5650 | #N/A
103 | 95000 | 1715 | 4 | 900 | 95000 | Ranch | 2 | 1.5 | 2010-05-18 00:00:00 | 2010-05-22 00:00:00 | 4 | 0 | #N/A
104 | 87000 | 1273 | 4 | 638 | 81750 | Condo | 2 | 1 | 2009-09-30 00:00:00 | 2010-05-12 00:00:00 | 224 | 5250 | #N/A
105 | 73900 | 970 | 4 | 541 | 63500 | Victorian | 1 | 0.5 | 2010-02-07 00:00:00 | 2010-04-24 00:00:00 | 76 | 10400 | #N/A
106 | 77000 | 900 | 5 | 391 | 67750 | Victorian | 1 | 0.5 | 2009-06-21 00:00:00 | 2010-05-14 00:00:00 | 327 | 9250 | #N/A
107 | 133000 | 1850 | 5 | 973 | 115500 | Ranch | 2 | 1.5 | 2010-03-02 00:00:00 | 2010-05-16 00:00:00 | 75 | 17500 | #N/A
108 | 116000 | 1720 | 5 | 867 | 99750 | Ranch | 2 | 1.5 | 2010-03-18 00:00:00 | 2010-04-23 00:00:00 | 36 | 16250 | #N/A
109 | 102000 | 1606 | 5 | 811 | 103000 | Ranch | 2 | 1.5 | 2009-08-05 00:00:00 | 2010-05-29 00:00:00 | 297 | -1000 | #N/A
110 | 94000 | 1305 | 5 | 647 | 88250 | Victorian | 2 | 1.5 | 2009-06-20 00:00:00 | 2010-05-25 00:00:00 | 339 | 5750 | #N/A
111 | 112900 | 1700 | 6 | 725 | 115000 | Condo | 2 | 1.5 | 2010-02-04 00:00:00 | 2010-04-08 00:00:00 | 63 | -2100 | #N/A
112 | 105000 | 1620 | 6 | 800 | 106000 | Condo | 2 | 1.5 | 2009-06-27 00:00:00 | 2010-05-03 00:00:00 | 310 | -1000 | #N/A
113 | 104500 | 1630 | 6 | 750 | 98000 | Condo | 2 | 1.5 | 2009-07-22 00:00:00 | 2010-04-02 00:00:00 | 254 | 6500 | #N/A
114 | 103000 | 1540 | 6 | 826 | 90500 | Ranch | 2 | 1.5 | 2010-03-24 00:00:00 | 2010-06-12 00:00:00 | 80 | 12500 | #N/A
115 | 87200 | 1229 | 6 | 721 | 87000 | Ranch | 2 | 1 | 2010-01-23 00:00:00 | 2010-06-26 00:00:00 | 154 | 200 | #N/A
116 | 97500 | 1500 | 7 | 700 | 82750 | Ranch | 2 | 1.5 | 2009-06-28 00:00:00 | 2010-04-16 00:00:00 | 292 | 14750 | #N/A
117 | 100000 | 1535 | 7 | 668 | 91000 | Victorian | 2 | 1.5 | 2009-05-09 00:00:00 | 2010-04-28 00:00:00 | 354 | 9000 | #N/A
118 | 92000 | 1415 | 7 | 866 | 91000 | Ranch | 2 | 1.5 | 2009-07-06 00:00:00 | 2010-04-24 00:00:00 | 292 | 1000 | #N/A
119 | 86900 | 1165 | 7 | 694 | 88500 | Victorian | 2 | 1 | 2009-08-10 00:00:00 | 2010-05-15 00:00:00 | 278 | -1600 | #N/A
120 | 76600 | 1200 | 7 | 634 | 68000 | Condo | 2 | 1 | 2009-05-07 00:00:00 | 2010-05-01 00:00:00 | 359 | 8600 | #N/A
121 | 105000 | 1920 | 8 | 944 | 95500 | Ranch | 2 | 1.5 | 2010-04-27 00:00:00 | 2010-05-14 00:00:00 | 17 | 9500 | #N/A
122 | 94500 | 1580 | 9 | 810 | 95250 | Victorian | 2 | 1.5 | 2010-04-05 00:00:00 | 2010-06-15 00:00:00 | 71 | -750 | #N/A
123 | 97500 | 1739 | 13 | 880 | 84750 | Victorian | 2 | 1.5 | 2010-05-10 00:00:00 | 2010-06-21 00:00:00 | 42 | 12750 | #N/A
124 | 70000 | 1505 | 14 | 591 | 70500 | Condo | 2 | 1.5 | 2010-03-15 00:00:00 | 2010-05-30 00:00:00 | 76 | -500 | #N/A
125 | 60000 | 1198 | 14 | 459 | 51000 | Ranch | 2 | 1 | 2010-03-08 00:00:00 | 2010-05-09 00:00:00 | 62 | 9000 | #N/A
126 | 158000 | 2563 | 14 | 1189 | 159500 | Victorian | 3 | 2.5 | 2009-11-19 00:00:00 | 2010-06-11 00:00:00 | 204 | -1500 | #N/A
127 | 58000 | 1051 | 15 | 426 | 58000 | Ranch | 2 | 1 | 2009-12-05 00:00:00 | 2010-05-17 00:00:00 | 163 | 0 | #N/A
128 | 169500 | 3750 | 19 | 1200 | 165000 | Victorian | 4 | 2.5 | 2010-03-14 00:00:00 | 2010-05-30 00:00:00 | 77 | 4500 | #N/A
129 | 78000 | 1080 | 21 | 600 | 68500 | Victorian | 2 | 1 | 2010-01-09 00:00:00 | 2010-04-02 00:00:00 | 83 | 9500 | #N/A
130 | 54000 | 1142 | 21 | 223 | 51750 | Victorian | 2 | 1 | 2009-10-11 00:00:00 | 2010-05-05 00:00:00 | 206 | 2250 | #N/A
131 | 107000 | 1464 | 22 | 376 | 107000 | Victorian | 2 | 1.5 | 2009-12-22 00:00:00 | 2010-05-25 00:00:00 | 154 | 0 | #N/A
132 | 210000 | 2116 | 25 | 1209 | 195250 | Victorian | 3 | 2 | 2009-09-01 00:00:00 | 2010-06-20 00:00:00 | 292 | 14750 | #N/A
133 | 66000 | 1159 | 25 | 225 | 62500 | Ranch | 2 | 1 | 2009-09-13 00:00:00 | 2010-06-13 00:00:00 | 273 | 3500 | #N/A
134 | 72500 | 1280 | 38 | 447 | 70250 | Victorian | 2 | 1 | 2010-03-01 00:00:00 | 2010-05-04 00:00:00 | 64 | 2250 | #N/A
135 | 93900 | 1428 | 40 | 701 | 82500 | Victorian | 2 | 1.5 | 2009-10-03 00:00:00 | 2010-05-23 00:00:00 | 232 | 11400 | #N/A
136 | 82000 | 1375 | 40 | 585 | 82750 | Victorian | 2 | 1.5 | 2009-05-17 00:00:00 | 2010-05-06 00:00:00 | 354 | -750 | #N/A
137 | 62000 | 1480 | 40 | 475 | 59500 | Ranch | 2 | 1.5 | 2009-09-11 00:00:00 | 2010-05-20 00:00:00 | 251 | 2500 | #N/A
138 | 184400 | 2250 | 40 | 915 | 182500 | Condo | 3 | 2 | 2009-11-04 00:00:00 | 2010-05-21 00:00:00 | 198 | 1900 | #N/A
139 | 69900 | 1400 | 45 | 481 | 60750 | Ranch | 2 | 1.5 | 2010-03-10 00:00:00 | 2010-04-10 00:00:00 | 31 | 9150 | #N/A
140 | 156000 | 1920 | 1 | 1161 | 134000 | Ranch | 2 | 1.5 | 2009-12-29 00:00:00 | 2010-04-28 00:00:00 | 120 | 22000 | #N/A
141 | 144900 | 1710 | 1 | 1010 | 143250 | Victorian | 2 | 1.5 | 2010-04-16 00:00:00 | 2010-06-02 00:00:00 | 47 | 1650 | #N/A
142 | 180000 | 2774 | 2 | 1765 | 165500 | Victorian | 3 | 2.5 | 2009-12-10 00:00:00 | 2010-04-05 00:00:00 | 116 | 14500 | #N/A
143 | 215000 | 2921 | 3 | 1635 | 215000 | Victorian | 3 | 2.5 | 2009-11-17 00:00:00 | 2010-05-06 00:00:00 | 170 | 0 | #N/A
144 | 75500 | 1275 | 3 | 570 | 77000 | Condo | 2 | 1 | 2009-10-10 00:00:00 | 2010-04-01 00:00:00 | 173 | -1500 | #N/A
145 | 199900 | 2580 | 4 | 1732 | 187750 | Ranch | 3 | 2.5 | 2009-06-30 00:00:00 | 2010-04-18 00:00:00 | 292 | 12150 | #N/A
146 | 190000 | 2580 | 4 | 1534 | 171000 | Victorian | 3 | 2.5 | 2009-09-02 00:00:00 | 2010-04-22 00:00:00 | 232 | 19000 | #N/A
147 | 137500 | 1837 | 4 | 1191 | 137500 | Victorian | 2 | 1.5 | 2009-04-16 00:00:00 | 2010-04-07 00:00:00 | 356 | 0 | #N/A
148 | 215000 | 2848 | 4 | 1487 | 193500 | Ranch | 3 | 2.5 | 2009-12-25 00:00:00 | 2010-05-30 00:00:00 | 156 | 21500 | #N/A
149 | 75000 | 1338 | 4 | 649 | 76500 | Ranch | 2 | 1.5 | 2010-04-08 00:00:00 | 2010-05-15 00:00:00 | 37 | -1500 | #N/A
150 | 75900 | 997 | 4 | 461 | 75000 | Ranch | 1 | 0.5 | 2009-06-13 00:00:00 | 2010-06-02 00:00:00 | 354 | 900 | #N/A
151 | 87000 | 1280 | 5 | 599 | 87000 | Victorian | 2 | 1 | 2010-01-23 00:00:00 | 2010-06-27 00:00:00 | 155 | 0 | #N/A
152 | 85500 | 1900 | 5 | 780 | 81000 | Ranch | 2 | 1.5 | 2009-07-04 00:00:00 | 2010-06-01 00:00:00 | 332 | 4500 | #N/A
153 | 215000 | 2664 | 6 | 1193 | 212750 | Victorian | 3 | 2.5 | 2009-09-20 00:00:00 | 2010-06-13 00:00:00 | 266 | 2250 | #N/A
154 | 87500 | 1173 | 6 | 456 | 87500 | Victorian | 2 | 1 | 2009-08-29 00:00:00 | 2010-05-27 00:00:00 | 271 | 0 | #N/A
155 | 81000 | 1365 | 6 | 673 | 81750 | Ranch | 2 | 1.5 | 2009-06-29 00:00:00 | 2010-06-23 00:00:00 | 359 | -750 | #N/A
156 | 75000 | 1030 | 6 | 486 | 69750 | Ranch | 2 | 1 | 2009-11-19 00:00:00 | 2010-05-28 00:00:00 | 190 | 5250 | #N/A
157 | 88900 | 1549 | 7 | 723 | 77250 | Condo | 2 | 1.5 | 2009-06-04 00:00:00 | 2010-05-04 00:00:00 | 334 | 11650 | #N/A
158 | 80500 | 1258 | 7 | 821 | 74750 | Victorian | 2 | 1 | 2010-04-16 00:00:00 | 2010-05-27 00:00:00 | 41 | 5750 | #N/A
159 | 127000 | 1880 | 8 | 930 | 127000 | Ranch | 2 | 1.5 | 2009-07-27 00:00:00 | 2010-04-29 00:00:00 | 276 | 0 | #N/A
160 | 208000 | 2600 | 10 | 1088 | 178750 | Victorian | 3 | 2.5 | 2009-08-04 00:00:00 | 2010-04-29 00:00:00 | 268 | 29250 | #N/A
161 | 145000 | 2150 | 10 | 1050 | 146250 | Victorian | 3 | 2 | 2009-11-02 00:00:00 | 2010-06-01 00:00:00 | 211 | -1250 | #N/A
162 | 89000 | 1746 | 10 | 591 | 77250 | Condo | 2 | 1.5 | 2010-02-04 00:00:00 | 2010-04-13 00:00:00 | 68 | 11750 | #N/A
163 | 61900 | 837 | 10 | 342 | 53000 | Condo | 1 | 0.5 | 2010-02-05 00:00:00 | 2010-06-20 00:00:00 | 135 | 8900 | #N/A
164 | 130000 | 2000 | 11 | 1076 | 117000 | Victorian | 2 | 2 | 2010-05-15 00:00:00 | 2010-05-25 00:00:00 | 10 | 13000 | #N/A
165 | 83500 | 1560 | 11 | 638 | 73250 | Ranch | 2 | 1.5 | 2009-08-13 00:00:00 | 2010-05-13 00:00:00 | 273 | 10250 | #N/A
166 | 99500 | 1725 | 12 | 923 | 98500 | Condo | 2 | 1.5 | 2010-02-25 00:00:00 | 2010-04-12 00:00:00 | 46 | 1000 | #N/A
167 | 205000 | 2650 | 13 | 1639 | 178250 | Victorian | 3 | 2.5 | 2010-01-09 00:00:00 | 2010-06-21 00:00:00 | 163 | 26750 | #N/A
168 | 97500 | 1430 | 13 | 752 | 99250 | Victorian | 2 | 1.5 | 2009-05-19 00:00:00 | 2010-04-05 00:00:00 | 321 | -1750 | #N/A
169 | 92500 | 1050 | 13 | 553 | 78500 | Ranch | 2 | 1 | 2010-05-04 00:00:00 | 2010-06-19 00:00:00 | 46 | 14000 | #N/A
170 | 105000 | 1680 | 13 | 875 | 101750 | Ranch | 2 | 1.5 | 2009-04-26 00:00:00 | 2010-04-06 00:00:00 | 345 | 3250 | #N/A
171 | 67000 | 1350 | 13 | 622 | 68250 | Condo | 2 | 1.5 | 2009-09-23 00:00:00 | 2010-05-06 00:00:00 | 225 | -1250 | #N/A
172 | 123500 | 1894 | 14 | 1112 | 123500 | Ranch | 2 | 1.5 | 2009-07-27 00:00:00 | 2010-05-15 00:00:00 | 292 | 0 | #N/A
173 | 97500 | 1360 | 14 | 696 | 97500 | Condo | 2 | 1.5 | 2009-05-25 00:00:00 | 2010-04-01 00:00:00 | 311 | 0 | #N/A
174 | 92200 | 1326 | 14 | 668 | 81000 | Victorian | 2 | 1.5 | 2010-04-20 00:00:00 | 2010-06-20 00:00:00 | 61 | 11200 | #N/A
175 | 123900 | 1706 | 14 | 810 | 110250 | Ranch | 2 | 1.5 | 2010-05-10 00:00:00 | 2010-05-13 00:00:00 | 3 | 13650 | #N/A
176 | 120000 | 1948 | 14 | 899 | 120000 | Condo | 2 | 1.5 | 2009-10-01 00:00:00 | 2010-04-03 00:00:00 | 184 | 0 | #N/A
177 | 79900 | 1314 | 14 | 671 | 70250 | Condo | 2 | 1.5 | 2010-02-23 00:00:00 | 2010-04-02 00:00:00 | 38 | 9650 | #N/A
178 | 125000 | 2150 | 15 | 984 | 123750 | Ranch | 3 | 2 | 2010-01-06 00:00:00 | 2010-05-25 00:00:00 | 139 | 1250 | #N/A
179 | 111000 | 1630 | 15 | 867 | 99750 | Victorian | 2 | 1.5 | 2009-07-13 00:00:00 | 2010-04-25 00:00:00 | 286 | 11250 | #N/A
180 | 99500 | 1500 | 15 | 743 | 99500 | Victorian | 2 | 1.5 | 2010-05-11 00:00:00 | 2010-05-29 00:00:00 | 18 | 0 | #N/A
181 | 70000 | 1215 | 15 | 477 | 67750 | Ranch | 2 | 1 | 2009-08-28 00:00:00 | 2010-04-15 00:00:00 | 230 | 2250 | #N/A
182 | 73000 | 1027 | 15 | 427 | 70750 | Victorian | 2 | 1 | 2009-11-18 00:00:00 | 2010-06-16 00:00:00 | 210 | 2250 | #N/A
183 | 69000 | 1348 | 15 | 520 | 70250 | Victorian | 2 | 1.5 | 2010-02-06 00:00:00 | 2010-06-04 00:00:00 | 118 | -1250 | #N/A
184 | 115500 | 1767 | 16 | 794 | 103750 | Condo | 2 | 1.5 | 2009-07-28 00:00:00 | 2010-05-31 00:00:00 | 307 | 11750 | #N/A
185 | 90000 | 1400 | 16 | 731 | 89000 | Victorian | 2 | 1.5 | 2009-09-10 00:00:00 | 2010-05-06 00:00:00 | 238 | 1000 | #N/A
186 | 86000 | 1385 | 16 | 653 | 75500 | Victorian | 2 | 1.5 | 2009-05-28 00:00:00 | 2010-04-08 00:00:00 | 315 | 10500 | #N/A
187 | 112500 | 1710 | 16 | 800 | 114750 | Victorian | 2 | 1.5 | 2009-10-05 00:00:00 | 2010-04-19 00:00:00 | 196 | -2250 | #N/A
188 | 113900 | 1680 | 17 | 750 | 105750 | Ranch | 2 | 1.5 | 2009-06-09 00:00:00 | 2010-06-03 00:00:00 | 359 | 8150 | #N/A
189 | 96000 | 1573 | 17 | 768 | 89250 | Victorian | 2 | 1.5 | 2009-06-20 00:00:00 | 2010-06-08 00:00:00 | 353 | 6750 | #N/A
190 | 125000 | 2180 | 17 | 1141 | 121250 | Ranch | 3 | 2 | 2010-02-02 00:00:00 | 2010-04-07 00:00:00 | 64 | 3750 | #N/A
191 | 117000 | 1928 | 18 | 600 | 112250 | Victorian | 2 | 1.5 | 2009-11-06 00:00:00 | 2010-04-18 00:00:00 | 163 | 4750 | #N/A
192 | 159900 | 2440 | 19 | 1265 | 163000 | Victorian | 3 | 2 | 2010-02-26 00:00:00 | 2010-05-26 00:00:00 | 89 | -3100 | #N/A
193 | 72900 | 1007 | 19 | 513 | 64750 | Ranch | 2 | 1 | 2010-01-04 00:00:00 | 2010-04-24 00:00:00 | 110 | 8150 | #N/A
194 | 110000 | 1657 | 20 | 865 | 100000 | Ranch | 2 | 1.5 | 2009-06-16 00:00:00 | 2010-05-29 00:00:00 | 347 | 10000 | #N/A
195 | 95500 | 1565 | 20 | 648 | 93500 | Ranch | 2 | 1.5 | 2009-11-08 00:00:00 | 2010-06-10 00:00:00 | 214 | 2000 | #N/A
196 | 93400 | 1543 | 20 | 820 | 83000 | Ranch | 2 | 1.5 | 2009-10-07 00:00:00 | 2010-04-16 00:00:00 | 191 | 10400 | #N/A
197 | 67000 | 1181 | 21 | 440 | 61500 | Ranch | 2 | 1 | 2010-02-13 00:00:00 | 2010-05-07 00:00:00 | 83 | 5500 | #N/A
198 | 89900 | 1464 | 22 | 566 | 90750 | Condo | 2 | 1.5 | 2009-05-14 00:00:00 | 2010-04-03 00:00:00 | 324 | -850 | #N/A
199 | 71000 | 1083 | 22 | 504 | 61000 | Ranch | 2 | 1 | 2009-10-15 00:00:00 | 2010-05-18 00:00:00 | 215 | 10000 | #N/A
200 | 118000 | 1830 | 23 | 733 | 114250 | Victorian | 2 | 1.5 | 2009-06-10 00:00:00 | 2010-04-01 00:00:00 | 295 | 3750 | #N/A
201 | 87600 | 1156 | 23 | 650 | 76000 | Condo | 2 | 1 | 2009-07-14 00:00:00 | 2010-05-04 00:00:00 | 294 | 11600 | #N/A
202 | 135000 | 2253 | 23 | 939 | 116000 | Ranch | 3 | 2 | 2010-04-25 00:00:00 | 2010-04-29 00:00:00 | 4 | 19000 | #N/A
203 | 73100 | 1299 | 24 | 585 | 70000 | Condo | 2 | 1 | 2009-12-23 00:00:00 | 2010-05-30 00:00:00 | 158 | 3100 | #N/A
204 | 77300 | 1320 | 24 | 580 | 75750 | Ranch | 2 | 1.5 | 2009-12-20 00:00:00 | 2010-04-04 00:00:00 | 105 | 1550 | #N/A
205 | 125000 | 2277 | 25 | 920 | 121250 | Ranch | 3 | 2 | 2009-08-09 00:00:00 | 2010-05-07 00:00:00 | 271 | 3750 | #N/A
206 | 129900 | 2743 | 25 | 1232 | 116750 | Victorian | 3 | 2.5 | 2009-09-13 00:00:00 | 2010-06-07 00:00:00 | 267 | 13150 | #N/A
207 | 108000 | 2200 | 26 | 1076 | 100250 | Condo | 3 | 2 | 2009-07-20 00:00:00 | 2010-04-28 00:00:00 | 282 | 7750 | #N/A
208 | 169500 | 2931 | 28 | 1142 | 169500 | Victorian | 3 | 2.5 | 2009-07-01 00:00:00 | 2010-05-08 00:00:00 | 311 | 0 | #N/A
209 | 155300 | 2200 | 28 | 1035 | 141250 | Victorian | 3 | 2 | 2010-02-21 00:00:00 | 2010-06-20 00:00:00 | 119 | 14050 | #N/A
210 | 102000 | 1713 | 30 | 600 | 98750 | Condo | 2 | 1.5 | 2010-02-09 00:00:00 | 2010-05-07 00:00:00 | 87 | 3250 | #N/A
211 | 72500 | 1140 | 30 | 490 | 66500 | Ranch | 2 | 1 | 2010-01-05 00:00:00 | 2010-06-27 00:00:00 | 173 | 6000 | #N/A
212 | 104900 | 1900 | 34 | 690 | 97500 | Victorian | 2 | 1.5 | 2009-08-11 00:00:00 | 2010-04-11 00:00:00 | 243 | 7400 | #N/A
213 | 72000 | 1050 | 40 | 542 | 65500 | Ranch | 2 | 1 | 2009-07-23 00:00:00 | 2010-04-17 00:00:00 | 268 | 6500 | #N/A
214 | 85000 | 1190 | 41 | 600 | 73750 | Ranch | 2 | 1 | 2009-10-02 00:00:00 | 2010-05-20 00:00:00 | 230 | 11250 | #N/A
215 | 74900 | 1733 | 43 | 656 | 66500 | Victorian | 2 | 1.5 | 2009-12-01 00:00:00 | 2010-05-04 00:00:00 | 154 | 8400 | #N/A
216 | 72000 | 1121 | 46 | 398 | 66750 | Ranch | 2 | 1 | 2009-09-02 00:00:00 | 2010-04-20 00:00:00 | 230 | 5250 | #N/A
217 | 102000 | 1478 | 53 | 626 | 91750 | Ranch | 2 | 1.5 | 2009-12-21 00:00:00 | 2010-04-17 00:00:00 | 117 | 10250 | #N/A