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 4YL' order by fulladdress
SE1 4YL - 878,000
- Freehold End terrace house
SE1 4YL - 850,000
- Freehold Mid terrace house
SE1 4YL - 838,000
- Freehold Mid terrace house
SE1 4YL - 843,000
- Freehold Terrace property
SE1 4YL - 847,000
- Freehold End terrace house
SE1 4YL - 788,000
- Freehold Flat/Maisonette
SE1 4YL - 663,000
- Freehold Terrace property
SE1 4YL - 852,000
- Freehold End terrace house
SE1 4YL - 1,041,000
- Freehold End terrace house
SE1 4YL - 0
- Freehold End terrace property
SE1 4YL - 949,000
- Freehold Mid terrace house
SE1 4YL - 981,000
- Freehold Semi-detached house
SE1 4YL - 983,000
- Freehold Mid terrace house
SE1 4YL - 1,047,000
- Freehold End terrace house
SE1 4YL - 1,142,000
- Leasehold Converted flat
SE1 4YL - 835,000
- Leasehold Flat/Maisonette
SE1 4YL - 939,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,279,000
- Leasehold Purpose built flat
SE1 4YL - 701,000
- Leasehold Converted flat
SE1 4YL - 868,000
- Leasehold Flat/Maisonette
SE1 4YL - 862,000
- Feudal Converted flat
SE1 4YL - 862,000
- Leasehold Converted flat
SE1 4YL - 736,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,249,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,012,000
- Leasehold Flat/Maisonette
SE1 4YL - 584,000
- Leasehold Flat/Maisonette
SE1 4YL - 734,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,504,000
- Leasehold Converted flat
SE1 4YL - 911,000
- Leasehold Converted flat
SE1 4YL - 1,495,000
- Leasehold Flat/Maisonette
SE1 4YL - 773,000
- Leasehold Flat/Maisonette
SE1 4YL - 675,000
- Leasehold Converted flat
SE1 4YL - 882,000
- Leasehold Converted flat
SE1 4YL - 919,000
- Leasehold Converted flat
SE1 4YL - 897,000
- Leasehold Converted flat
SE1 4YL - 958,000
- Leasehold Flat/Maisonette
SE1 4YL - 586,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,229,000
- Leasehold Converted flat
SE1 4YL - 1,054,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,198,000
- Leasehold Converted flat
SE1 4YL - 749,000
- Leasehold Flat/Maisonette
SE1 4YL - 1,203,000
- Leasehold Converted flat
SE1 4YL - 916,000
- Leasehold Converted flat
SE1 4YL - 1,020,000
- Leasehold Purpose built flat
