SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE1 9DS' order by fulladdress
SE1 9DS - 1,775,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,380,000
- Feudal Purpose built flat
SE1 9DS - 1,690,000
- Leasehold Flat/Maisonette
SE1 9DS - 2,357,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,457,000
- Leasehold Purpose built flat
SE1 9DS - 1,405,000
- Leasehold Purpose built flat
SE1 9DS - 1,506,000
- Leasehold Purpose built flat
SE1 9DS - 832,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,263,000
- Leasehold Purpose built flat
SE1 9DS - 1,457,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,425,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,452,000
- Leasehold Purpose built flat
SE1 9DS - 1,729,000
- Leasehold Flat/Maisonette
SE1 9DS - 2,227,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,447,000
- Leasehold Purpose built flat
SE1 9DS - 1,308,000
- Leasehold Flat/Maisonette
SE1 9DS - 785,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,348,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,419,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,438,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,562,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,788,000
- Leasehold Converted flat
SE1 9DS - 2,712,000
- Leasehold Purpose built flat
SE1 9DS - 1,503,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,412,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,215,000
- Leasehold Flat/Maisonette
SE1 9DS - 739,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,386,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,815,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,560,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,440,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,736,000
- Leasehold Flat/Maisonette
SE1 9DS - 3,278,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,453,000
- Leasehold Purpose built flat
SE1 9DS - 1,481,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,289,000
- Feudal Purpose built flat
SE1 9DS - 1,374,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,470,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,544,000
- Leasehold Purpose built flat
SE1 9DS - 929,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,580,000
- Leasehold Purpose built flat
SE1 9DS - 1,557,000
- Leasehold Flat/Maisonette
SE1 9DS - 3,277,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,746,000
- Leasehold Purpose built flat
SE1 9DS - 1,348,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,256,000
- Leasehold Purpose built flat
SE1 9DS - 1,649,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,668,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,684,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,777,000
- Leasehold Flat/Maisonette
SE1 9DS - 780,000
- Leasehold Purpose built flat
SE1 9DS - 3,466,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,409,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,589,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,255,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,556,000
- Leasehold Purpose built flat
SE1 9DS - 1,593,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,764,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,883,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,824,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,974,000
- Leasehold Purpose built flat
SE1 9DS - 816,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,840,000
- Feudal Purpose built flat
SE1 9DS - 1,622,000
- Leasehold Purpose built flat
SE1 9DS - 1,582,000
- Leasehold Purpose built flat
SE1 9DS - 4,129,000
- Leasehold Flat/Maisonette
SE1 9DS - 3,987,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,287,000
- Leasehold Flat/Maisonette
SE1 9DS - 1,561,000
- Leasehold Flat/Maisonette