SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE5 8LG' order by fulladdress
SE5 8LG - 560,000
- Leasehold Flat/Maisonette
SE5 8LG - 509,000
- Leasehold Flat/Maisonette
SE5 8LG - 492,000
- Leasehold Flat/Maisonette
SE5 8LG - 1,704,000
- Freehold Semi-detached house
SE5 8LG - 2,076,000
- Freehold Semi-detached house
SE5 8LG - 3,234,000
- Freehold Detached property
SE5 8LG - 3,509,000
- Freehold Detached house
SE5 8LG - 2,767,000
- Freehold Detached house
SE5 8LG - 2,097,000
- Freehold Semi-detached house
SE5 8LG - 531,000
- Leasehold Converted flat
SE5 8LG - 1,637,000
- Freehold End terrace house
SE5 8LG - 2,287,000
- Freehold Semi-detached house
SE5 8LG - 604,000
- Leasehold Flat/Maisonette
SE5 8LG - 617,000
- Leasehold Flat/Maisonette
SE5 8LG - 687,000
- Leasehold Converted flat
SE5 8LG - 2,143,000
- Freehold Semi-detached house
SE5 8LG - 2,481,000
- Freehold Semi-detached house
SE5 8LG - 769,000
- Leasehold Converted flat
SE5 8LG - 2,368,000
- Freehold Semi-detached house
SE5 8LG - 3,594,000
- Freehold Detached house
SE5 8LG - 3,148,000
- Freehold Detached house
SE5 8LG - 3,232,000
- Freehold Detached house
SE5 8LG - 1,959,000
- Freehold Detached house
SE5 8LG - 824,000
- Leasehold Converted flat
SE5 8LG - 2,781,000
- Freehold Detached house
SE5 8LG - 3,274,000
- Freehold Detached house
SE5 8LG - 493,000
- Feudal Converted flat
SE5 8LG - 489,000
- Leasehold Converted flat
SE5 8LG - 717,000
- Leasehold Converted flat
SE5 8LG - 469,000
- Leasehold Flat/Maisonette
SE5 8LG - 513,000
- Leasehold Flat/Maisonette
SE5 8LG - 688,000
- Leasehold Converted flat
SE5 8LG - 532,000
- Leasehold Converted flat
SE5 8LG - 439,000
- Leasehold Flat/Maisonette
SE5 8LG - 612,000
- Leasehold Converted flat
SE5 8LG - 538,000
- Leasehold Converted flat
SE5 8LG - 573,000
- Leasehold Flat/Maisonette
SE5 8LG - 499,000
- Leasehold Converted flat