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 2BB' order by fulladdress
SE1 2BB - 1,276,000
- Leasehold Converted flat
SE1 2BB - 1,302,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,504,000
- Leasehold Flat/Maisonette
SE1 2BB - 779,000
- Leasehold Flat/Maisonette
SE1 2BB - 818,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,140,000
- Share of freehold Flat/Maisonette
SE1 2BB - 933,000
- Leasehold Converted flat
SE1 2BB - 1,762,000
- Leasehold Converted flat
SE1 2BB - 1,329,000
- Leasehold Converted flat
SE1 2BB - 2,009,000
- Leasehold Purpose built flat
SE1 2BB - 636,000
- Leasehold Converted flat
SE1 2BB - 1,758,000
- Leasehold Purpose built flat
SE1 2BB - 1,379,000
- Leasehold Converted flat
SE1 2BB - 714,000
- Leasehold Purpose built flat
SE1 2BB - 574,000
- Leasehold Purpose built flat
SE1 2BB - 2,154,000
- Leasehold Flat/Maisonette
SE1 2BB - 2,681,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,141,000
- Leasehold Converted flat
SE1 2BB - 673,000
- Leasehold Converted flat
SE1 2BB - 555,000
- Leasehold Converted flat
SE1 2BB - 1,957,000
- Leasehold Converted flat
SE1 2BB - 3,758,000
- Leasehold Converted flat
SE1 2BB - 1,150,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,295,000
- Leasehold Converted flat
SE1 2BB - 2,023,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,772,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,355,000
- Leasehold Converted flat
SE1 2BB - 1,778,000
- Leasehold Flat/Maisonette
SE1 2BB - 581,000
- Leasehold Converted flat
SE1 2BB - 909,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,237,000
- Share of freehold Flat/Maisonette
SE1 2BB - 3,084,000
- Leasehold Converted flat
SE1 2BB - 1,236,000
- Leasehold Flat/Maisonette
SE1 2BB - 791,000
- Leasehold Converted flat
SE1 2BB - 1,476,000
- Leasehold Converted flat
SE1 2BB - 870,000
- Leasehold Converted flat
SE1 2BB - 705,000
- Freehold Flat/Maisonette
SE1 2BB - 1,068,000
- Leasehold Flat/Maisonette
SE1 2BB - 2,926,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,156,000
- Leasehold Converted flat
SE1 2BB - 1,406,000
- Leasehold Flat/Maisonette
SE1 2BB - 810,000
- Feudal Converted flat
SE1 2BB - 1,235,000
- Leasehold Flat/Maisonette
SE1 2BB - 914,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,538,000
- Leasehold Purpose built flat
SE1 2BB - 2,843,000
- Feudal Converted flat
SE1 2BB - 1,457,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,562,000
- Leasehold Converted flat
SE1 2BB - 874,000
- Leasehold Converted flat
SE1 2BB - 711,000
- Leasehold Converted flat
SE1 2BB - 1,509,000
- Leasehold Flat/Maisonette
SE1 2BB - 2,596,000
- Leasehold Converted flat
SE1 2BB - 1,240,000
- Leasehold Converted flat
SE1 2BB - 559,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,434,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,536,000
- Leasehold Converted flat
SE1 2BB - 1,216,000
- Leasehold Flat/Maisonette
SE1 2BB - 3,388,000
- Leasehold Purpose built flat
SE1 2BB - 1,507,000
- Leasehold Flat/Maisonette
SE1 2BB - 1,229,000
- Leasehold Flat/Maisonette
SE1 2BB - 3,528,000
- Leasehold Flat/Maisonette
SE1 2BB - 2,129,000
- Leasehold Converted flat
SE1 2BB - 953,000
- Leasehold Flat/Maisonette