Spreadsheet: 695986d1600518009-help-with-countifs-function-copy-of-rightmove-analysis-mt-2-
Sheet: House prices snapshot

Asking price, rightmove, snapshot August 2020 Eccles
 |  |  |  |  |  |  | Property Type | Number of properties | Asking Price range (pcm) |  |  |  |  |  |  | Baseline (May 2019)
1 bed apartment | 60000 |  | 1 bed apartment | 60000 |  |  | 1 bed House share’s (HMOs) | 0 | 0 |  |  |  |  |  | Rental type
1 bed apartment | 60000 |  | 1 bed apartment | 60000 |  |  | 1 bed/studio apartments | 7 | 60,000 to 85,000 |  |  |  |  |  | 4-bed, 2 storey semi-detached | 350000
1 bed apartment | 65000 |  | 1 bed apartment | 65000 |  |  | 2 bed apartments | 10 | 90,000 to 220,000
1 bed apartment | 70000 |  | 1 bed apartment | 70000 |  |  | 2 bed terrace | 11 | 105,000 to 218,000
1 bed apartment | 75000 |  | 1 bed apartment | 75000 |  |  | 2 bed semi | 5 | 120,000 to 225,000
1 bed apartment | 80000 |  | 1 bed apartment | 85000 |  |  | 3 bed terrace (including townhouses) | 9 | 120,000 to 225,000 |  |  |  |  |  | 3-bed, 3 storey townhouse | 300000
1 bed apartment | 85000 |  | 1 bed apartment | 80000 |  |  | 3 bed semi | 30 | 100,000 to 375,000
2 bed apartment | 90000 |  | 60,000 to 85,000 |  |  |  | 3 bed apartment | 4 | 150,000 to 265,000
3 bed semi | 100000 |  |  |  |  |  | 3 bed detached | 7 | 150,000 to 325,000
2 bed terraced | 105000 |  | 2 bed apartment | 90000 |  |  | 4 bed semi | 9 | 125,000 to 400,000 |  |  |  |  |  | 3 bed, 2 storey terrace | 225000
3 bed semi | 110000 |  | 2 bed apartment | 110000 |  |  | Total
2 bed apartment | 110000 |  | 2 bed apartment | 112000 |  |  | *Rightmove Swinton Housing Market snapshot analysis (June 24th 2019)
2 bed apartment | 112000 |  | 2 bed apartment | 120000 |  |  | **Asking price
2 bed terraced | 120000 |  | 2 bed apartment | 150000 |  |  |  |  |  |  |  |  |  |  | 2-bed 2 storey | 200000
2 bed apartment | 120000 |  | 2 bed flat | 130000
2 bed terraced | 120000 |  | 2 bed flat | 140000
2 bed semi | 120000 |  | 2 bed flat | 185000
3 bed terraced | 120000 |  | 2 bed flat | 220000 |  |  |  |  |  |  |  |  |  |  | 3 bed, 2 storey mews (integral) | 225000
4 bed semi | 125000 |  | 2 bed flat | 220000
2 bed terraced | 125000 |  | 90,000 to 220,000
2 bed flat | 130000 |  | 2 bed [NAME] | 160000 |  |  |  |  |  |  |  |  |  |  | Flat above Garage | 85000
2 bed terraced | 130000
2 bed terraced | 130000 |  | 2 bed semi | 225000
2 bed semi | 130000 |  | 2 bed semi | 120000
2 bed terraced | 130000 |  | 2 bed semi | 130000 |  |  |  |  |  |  |  |  |  |  | Studio apartment | 85000
2 bed terraced | 130000 |  | 2 bed semi | 140000
2 bed semi | 140000 |  | 2 bed semi bungalow | 180000
2 bed flat | 140000 |  | 120,000 to 225,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | One bed apartment | 100000
3 bed semi | 140000 |  | 2 bed terrace | 175000
3 bed terraced | 148000 |  | 2 bed terraced | 105000
3 bed flat | 150000 |  | 2 bed terraced | 120000
3 bed semi | 150000 |  | 2 bed terraced | 125000 |  |  |  |  |  |  |  |  |  |  | Two bed apartment | 150000
2 bed apartment | 150000 |  | 2 bed terraced | 130000
3 bed semi | 150000 |  | 2 bed terraced | 130000
3 bed detached | 150000 |  | 2 bed terraced | 130000
3 bed semi detached | 150000 |  | 2 bed terraced | 130000 |  |  |  |  |  |  |  |  |  |  | Three bed apartment | 200000
3 bed terraced | 150000 |  | 2 bed terraced | 195000
3 bed terraced | 150000 |  | 2 bed terraced | 218000
2 bed [NAME] | 160000 |  | 2 bed terraced | 120000
3 bed semi | 160000 |  | 105,000 to 218,000 |  |  |  |  |  |  |  |  |  |  |  | *baseline estimate assumes prodtcs will be at upper end of market
4 bed terrace | 160000 |  | 3 bed detached | 150000
3 bed detached | 170000 |  | 3 bed detached | 170000
3 bed semi | 170000 |  | 3 bed detached | 240000
3 bed semi | 170000 |  | 3 bed detached | 270000
2 bed terrace | 175000 |  | 3 bed detached | 300000
3 bed semi | 175000 | Queensway | 3 bed detached | 325000
3 bed townhouse | 175000 | Queensway | 3 bed detached | 795000
3 bed semi | 180000 | Queensway | 150,000 to 325,000
2 bed semi bungalow | 180000 |  | 3 bed flat | 150000
2 bed flat | 185000 |  | 3 bed flat | 260000
3 bed semi | 190000 |  | 3 bed flat | 260000
3 bed terraced | 190000 |  | 3 bed flat | 265000
2 bed terraced | 195000 |  | 150,000 to 265,000
3 bed semi | 200000 |  | 3 bed mews | 225000
3 bed semi | 200000
3 bed semi | 200000 |  | 3 bed semi | 100000
4 bed semi | 200000 |  | 3 bed semi | 110000
3 bed semi | 200000 |  | 3 bed semi | 140000
3 bed terraced | 200000 |  | 3 bed semi | 150000
3 bed terraced | 210000 |  | 3 bed semi | 160000
3 bed semi | 210000 |  | 3 bed semi | 170000
4 bed terraced | 210000 |  | 3 bed semi | 170000
3 bed terraced | 210000 |  | 3 bed semi | 175000
4 bed terraced | 215000 |  | 3 bed semi | 180000
2 bed terraced | 218000 |  | 3 bed semi | 190000
3 bed semi | 218000 |  | 3 bed semi | 200000
3 bed semi | 220000 |  | 3 bed semi | 200000
2 bed flat | 220000 |  | 3 bed semi | 200000
2 bed flat | 220000 |  | 3 bed semi | 210000
4 bed semi | 224000 |  | 3 bed semi | 220000
4 bed town house | 225000 |  | 3 bed semi | 230000
3 bed mews | 225000 |  | 3 bed semi | 230000
2 bed semi | 225000 |  | 3 bed semi | 250000
3 bed terraced | 225000 |  | 3 bed semi | 265000
3 bed semi | 230000 |  | 3 bed semi | 270000
3 bed semi | 230000 |  | 3 bed semi | 295000
3 bed semi | 230000 |  | 3 bed semi | 300000
3 bed detached | 240000 |  | 3 bed semi | 375000
3 bed semi | 250000 |  | 3 bed semi | 375000
4 bed semi | 250000 |  | 3 bed semi | 150000
3 bed flat | 260000 |  | 3 bed semi | 200000
3 bed flat | 260000 |  | 3 bed semi | 218000
3 bed flat | 265000 |  | 3 bed semi | 230000
3 bed semi | 265000 |  | 3 bed semi | 280000
3 bed semi | 270000 |  | 3 bed semi detached | 150000
3 bed detached | 270000 |  | 100,000 to 375,000
3 bed semi | 280000 |  | 3 bed terraced | 120000
4 bed detached | 285000 |  | 3 bed terraced | 148000
4 bed semi | 290000 |  | 3 bed terraced | 150000
3 bed semi | 295000 |  | 3 bed terraced | 150000
4 bed detached | 295000 |  | 3 bed terraced | 190000
4 bed detached | 300000 |  | 3 bed terraced | 200000
4 bed detached | 300000 |  | 3 bed terraced | 210000
3 bed semi | 300000 |  | 3 bed terraced | 210000
4 bed detached | 300000 |  | 3 bed terraced | 225000
4 bed terraced | 300000 |  | 120,000 to 225,000
3 bed detached | 300000 |  | 3 bed townhouse | 175000
4 bed detached | 310000
4 bed semi | 320000 |  | 4 bed detached | 285000
4 bed detached | 325000 |  | 4 bed detached | 295000
3 bed detached | 325000 |  | 4 bed detached | 300000
4 bed semi | 375000 |  | 4 bed detached | 300000
3 bed semi | 375000 |  | 4 bed detached | 300000
4 bed semi | 375000 |  | 4 bed detached | 310000
3 bed semi | 375000 |  | 4 bed detached | 325000
5 bed semi | 380000 |  | 4 bed detached | 650000
4 bed semi | 400000 |  | 4 bed detached | 800000
5 bed semi | 450000 |  | 285,000 to 325,000
4 bed terraced | 475000 |  | 4 bed semi | 125000
5 bed detached | 475000 |  | 4 bed semi | 200000
4 bed terraced | 485000 |  | 4 bed semi | 224000
5 bed terraced | 625000 |  | 4 bed semi | 250000
4 bed detached | 650000 |  | 4 bed semi | 290000
3 bed detached | 795000 |  | 4 bed semi | 320000
4 bed detached | 800000 |  | 4 bed semi | 375000
 |  |  | 4 bed semi | 375000
 |  |  | 4 bed semi | 400000
 |  |  | 125,000 to 400,000
 |  |  | 4 bed terrace | 160000
 |  |  | 4 bed terraced | 210000
 |  |  | 4 bed terraced | 215000
 |  |  | 4 bed terraced | 300000
 |  |  | 4 bed terraced | 475000
 |  |  | 4 bed terraced | 485000
 |  |  | 4 bed town house | 225000
 |  |  | 160,000 to 485,000
 |  |  | 5 bed detached | 475000
 |  |  | 5 bed semi | 380000
 |  |  | 5 bed semi | 450000
 |  |  | 5 bed terraced | 625000