Spreadsheet: 104283d1301931257-editing-a-table-using-a-vlookup-status-version-1-
Sheet: Status

Prop Ref | Address | Special | Price | Status | In Book? | On RTM | On Market | Notes
3 | [NAME], Hallsall |  | 695000 | Fully Available | Yes | Yes | 2009-08-01 00:00:00
4 | Brookside Farm, [NAME], Lydiate | O/O | 640000 | Fully Avaliable | Yes | Yes | 2009-07-01 00:00:00
5 | 15 [NAME], Scarisbirck |  | 530000 | Fully Avaliable | Yes | Yes | 2010-02-01 00:00:00
6 | The Glade, Butchers [NAME], Aughton |  | 525000 | UNDER OFFER | Yes | Yes | 2010-08-01 00:00:00
7 | The [NAME], [NAME] |  | 460000 | Investment opportunity | Yes | Yes | 2009-05-01 00:00:00
8 | 132 [NAME], [NAME] | OIRO | 444950 | Fully Avaliable | Yes | Yes | 2006-08-01 00:00:00
9 | 26 High Moss, [NAME] |  | 435000 | Fully Avaliable | Yes | Yes | 2010-04-01 00:00:00
10 | Coopers Farm, Kirkby |  | 399950 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
12 | 6 Gaw [NAME], Aughton | OIRO | 395000 | Has A Tenant In | Yes | Yes | 2008-02-01 00:00:00
11 | 10 Southport Road, Lydiate | SDP | 395000 | Fully Avaliable | Yes | Yes | 2010-02-01 00:00:00
13 | 9 Holborn Drive, [NAME] |  | 385000 | Fully Avaliable | Yes | Yes | 2010-03-01 00:00:00
14 | 4 Lytham Court, Melling |  | 379950 | Fully Avaliable | Yes | Yes | 2010-01-01 00:00:00
15 | 283 [NAME], Scarisbrick |  | 345000 | Has A Tenant In | Yes | Yes | 2009-10-01 00:00:00
16 | 12 Broadlake, Williston Chester | OIRO | 329950 | Fully Avaliable | Yes | Yes | 2010-08-01 00:00:00
17 | 2 High House Barn, Aughton |  | 325000 | Has A Tenant In | Yes | Yes | 2007-04-01 00:00:00
19 | 49 Weld Blundell Ave, Lydiate |  | 290000 | Fully Avaliable | Yes | Yes | 2009-04-01 00:00:00
20 | 10 Brooklands Grove, Lathom |  | 280000 | Fully Avaliable | Yes | Yes | 2006-08-01 00:00:00
22 | 21 Rosslyn Avenue, Maghull |  | 260000 | Fully Avaliable | Yes | Yes | 2010-08-01 00:00:00
23 | 43 Liverpool Road South, Maghull |  | 250000 | Commercial Offices | Yes | Yes | 2010-10-01 00:00:00
103 | 24 [NAME], Ashurst |  | 249950 | Fully Available | Yes | Yes | 2011-03-01 00:00:00
28 | 15 [NAME], Maghull | OIRO | 249950 | Has A Tenant In | Yes | Yes | 2007-11-01 00:00:00
27 | 86 Long Lane, Aughton |  | 249950 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
26 | 2 Oak Tree Court, [NAME] |  | 249950 | Fully Avaliable | Yes | Yes | 2010-10-01 00:00:00
24 | 7 Avelon Close, Lydiate |  | 249950 | Fully Avaliable | Yes | Yes | 2007-06-01 00:00:00
29 | 25 Pine Avenue, Ormskirk | OIRO | 245950 | Fully Avaliable | Yes | Yes | 2009-09-01 00:00:00
30 | 7 Westbridge, Maghull |  | 240000 | Fully Avaliable | Yes | Yes
25 | 8 Norris House Drive, Aughton |  | 230000 | Fully Avaliable | Yes | Yes | 2009-08-01 00:00:00
32 | 2A Moss Lane, Lydiate |  | 229950 | Fully Avaliable | Yes | Yes | 2008-03-01 00:00:00
31 | 31 [NAME], Kirkby |  | 229950 | Has A Tenant In | Yes | Yes | 2010-06-01 00:00:00
33 | 30 Fouracres, Maghull |  | 220000 | Fully Avaliable | Yes | Yes | 2008-04-01 00:00:00
35 | 22 Mountwood, Skelmersdale |  | 219950 | Fully Avaliable | Yes | Yes | 2010-04-01 00:00:00
34 | 2 Greenbank Avenue, Maghull |  | 219950 | Fully Avaliable | Yes | Yes | 2010-08-01 00:00:00
36 | 6 Maplewood, Skelmersdale |  | 215000 | Fully Avaliable | Yes | Yes | 2008-09-01 00:00:00
38 | 9 Mountwood, Skelmersdale |  | 205000 | Fully Avaliable | Yes | Yes | 2009-09-01 00:00:00
37 | 22 Standhouse Lane, Aughton |  | 199950 | Fully Avaliable | Yes | Yes | 2008-02-01 00:00:00
39 | 82 Cottage Lane, Ormskirk |  | 199950 | Fully Avaliable | Yes | Yes | 2009-10-01 00:00:00
43 | 58 Calder Avenue, Ormskirk |  | 189950 | Fully Avaliable | Yes | Yes | 2010-08-01 00:00:00
41 | 9 [NAME], Orrell Park |  | 189950 | Fully Avaliable | Yes | Yes | 2010-09-01 00:00:00
45 | 18 Haymans Green, Maghull |  | 187500 | Fully Avaliable | Yes | Yes | 2010-12-01 00:00:00
48 | 161 [NAME], Melling |  | 185000 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
47 | 33 [NAME], Kirkby |  | 185000 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
46 | 107 New Street, Halsall |  | 185000 | SSTC | Yes | Yes | 2010-08-01 00:00:00
49 | 23 Broadwood Avenue, Maghull |  | 184950 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
40 | 20 Coronation Road, Lydiate |  | 184950 | Fully Avaliable | Yes | Yes | 2010-09-01 00:00:00
52 | 7 Arcadia Avenue, Lydiate |  | 174950 | Fully Avaliable | Yes | Yes | 2010-04-01 00:00:00
51 | 48 Trent Avenue, Maghull |  | 174950 | Fully Avaliable | Yes | Yes | 2008-05-01 00:00:00
53 | 4 Olive Grove, [NAME] |  | 172500 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
58 | 3 Station Road, Lydiate | NC | 169950 | Has A Tenant In | No | Yes | 2008-04-01 00:00:00
55 | 88 Thompson Avenue, Ormskirk |  | 169950 | Fully Avaliable | Yes | Yes | 2009-11-01 00:00:00
54 | 238 Northway, Maghull |  | 169950 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
59 | 4 Middlewood Close, [NAME] |  | 169500 | Fully Avaliable | Yes | Yes | 2009-11-01 00:00:00
60 | 202 Liverpool Road, Lydiate |  | 159950 | Fully Avaliable | Yes | Yes | 2007-09-01 00:00:00
61 | 4 [NAME], Maghull | OIRO | 158000 | Fully Avaliable | Yes | Yes | 2010-05-01 00:00:00
101 | 47 Alt Avenue, Maghull |  | 155000 | SSTC | Yes | Yes | 2011-04-04 00:00:00
63 | 3 Sunnyside, [NAME] |  | 155000 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
62 | 314 Liverpool Road South, Maghull |  | 155000 | UNDER OFFER | Yes | Yes | 2011-02-01 00:00:00
64 | 16 Fieldway, Maghull |  | 152950 | UNDER OFFER | Yes | Yes | 2011-02-01 00:00:00
65 | 25 Astor Court, Lydiate | OIRO | 150000 | Has A Tenant In | Yes | Yes | 2006-02-01 00:00:00
57 | 95a Wigan Road, Ormskirk |  | 149950 | Fully Avaliable | Yes | Yes | 2009-12-01 00:00:00
67 | 49 [NAME], [NAME] |  | 149950 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
66 | 106 Dodds Lane, Maghull |  | 149950 | SSTC | No | Yes | 2010-07-01 00:00:00
68 | 19 Deyes Court, Maghull |  | 144500 | Has A Tenant In | No | Yes | 2010-04-01 00:00:00
70 | 48 Felstead, [NAME], Skelmersdale | NC | 140000 | Fully Avaliable | Yes | Yes | 2007-07-01 00:00:00
73 | 49 Wigan Road, Westhead |  | 139950 | Fully Avaliable | Yes | Yes | 2010-07-01 00:00:00
71 | 6 Manor Drive, Burscough |  | 139950 | UNDER OFFER | Yes | Yes | 2010-04-01 00:00:00
104 | 11 Bridge House, Bridge Street, Ormskirk |  | 135000 | Fully Available | Yes | Yes | 2011-03-01 00:00:00
75 | 9 Hardacre Street, Ormskirk |  | 134950 | Fully Avaliable | Yes | Yes | 2010-12-01 00:00:00
74 | 16 Kingfisher Court, Lydiate |  | 134950 | Has A Tenant In | Yes | Yes | 2008-09-01 00:00:00
76 | 9 Brunsfield Close, [NAME] |  | 129950 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
102 | 41 Mayhall Court, Maghull |  | 126950 | Fully Avaliable | Yes | Yes | 2011-04-04 00:00:00
80 | 17 The Fieldings, Lydiate |  | 117500 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
78 | 21 Hants Lane, Ormskirk |  | 117000 | Fully Avaliable | Yes | Yes | 2009-10-01 00:00:00
79 | 19 Harrington View, [NAME] |  | 110000 | Fully Avaliable | Yes | Yes | 2009-05-01 00:00:00
81 | 133 Moorhey Road, Maghull |  | 107500 | Fully Avaliable | Yes | Yes | 2011-01-01 00:00:00
82 | 2 Wallcroft, [NAME] |  | 105000 | Fully Avaliable | Yes | Yes | 2010-12-01 00:00:00
83 | 12 Barnes Close, Kirkby |  | 104950 | Has A Tenant In | No | Yes | 2009-08-01 00:00:00
84 | 10 Birch Close, [NAME] |  | 95000 | SSTC | No | Yes | 2010-11-01 00:00:00
85 | 96a Liverpool Rd Sth, Maghull |  | 89950 | ON HOLD | No | Yes | 2009-10-01 00:00:00
87 | 16 Harrington View, [NAME] |  | 85000 | Fully Avaliable | Yes | Yes | 2009-05-01 00:00:00
86 | 380 Princess Drive, Liverpool |  | 85000 | Fully Avaliable | Yes | Yes | 2011-02-01 00:00:00
89 | 20 [NAME], [NAME] |  | 79950 | Fully Avaliable | Yes | Yes | 2008-02-01 00:00:00
88 | [NAME], [NAME] |  | 79950 | Fully Avaliable | Yes | Yes | 2010-09-01 00:00:00
90 | 107 [NAME], [NAME] |  | 67000 | SSTC | No | Yes | 2010-03-01 00:00:00
91 | 58 Pope Street, Bootle |  | 59950 | Fully Avaliable | Yes | Yes | 2008-03-01 00:00:00
92 | 43 Liverpool Road South, Maghull | To Let | 15000 | Commercial Offices | Yes | Yes | 2010-10-01 00:00:00
93 | 82 [NAME], Burscough | To Let | 10000 | Commercial Property | Yes | Yes | 2011-02-01 00:00:00
102 | 25 Kendal Drive, Maghull | To Let | 750 | Fully Avaliable | Yes | Yes | 2011-04-04 00:00:00
97 | 47 Liverpool Road South, Maghull | To Let | 700 | Commercial Offices | Yes | Yes | 2008-03-01 00:00:00
98 | 19 Barnes Close, Kirkby | To Let | 625 | ON HOLD | Yes | Yes | 2011-02-01 00:00:00
106 | 6 Ravenglass Avenue, Maghull | To Let | 545 | Fully Available | Yes | Yes | 2011-04-04 00:00:00
105 | 63 [NAME], Bickerstaffe | To Let | 545 | UNDER REF | Yes | Yes | 2011-03-01 00:00:00