SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE20 7LY' order by fulladdress
SE20 7LY - 1,249,000
- Freehold Semi-detached house
SE20 7LY - 1,216,000
- Freehold Semi-detached house
SE20 7LY - 1,237,000
- Freehold Semi-detached house
SE20 7LY - 1,091,000
- Freehold Semi-detached house
SE20 7LY - 1,259,000
- Freehold Semi-detached house
SE20 7LY - 757,000
- Freehold Detached house
SE20 7LY - 1,191,000
- Freehold Semi-detached house
SE20 7LY - 869,000
- Freehold Detached house
SE20 7LY - 1,264,000
- Freehold Semi-detached house
SE20 7LY - 765,000
- Freehold Semi-detached house
SE20 7LY - 1,191,000
- Freehold Semi-detached house
SE20 7LY - 775,000
- Freehold Semi-detached house
SE20 7LY - 743,000
- Leasehold Converted flat
SE20 7LY - 498,000
- Freehold Flat/Maisonette
SE20 7LY - 540,000
- Leasehold Converted flat
SE20 7LY - 1,289,000
- Freehold Semi-detached house
SE20 7LY - 1,185,000
- Freehold Semi-detached house
SE20 7LY - 1,171,000
- Freehold Detached house
SE20 7LY - 1,119,000
- Freehold Semi-detached house
SE20 7LY - 1,283,000
- Freehold Semi-detached house
SE20 7LY - 1,341,000
- Freehold Semi-detached property
SE20 7LY - 1,147,000
- Freehold Semi-detached house
SE20 7LY - 1,345,000
- Freehold Semi-detached house
SE20 7LY - 1,242,000
- Freehold Semi-detached house
SE20 7LY - 1,336,000
- Freehold Detached house
SE20 7LY - 1,319,000
- Freehold Detached house
