SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='S11 9NN' order by fulladdress
S11 9NN - 838,000
- Leasehold Detached house
S11 9NN - 1,201,000
- Freehold Detached house
S11 9NN - 1,923,000
- Freehold Detached house
S11 9NN - 1,498,000
- Freehold Detached house
S11 9NN - 1,155,000
- Leasehold Detached house
S11 9NN - 1,187,000
- Freehold Detached house
S11 9NN - 1,105,000
- Leasehold Detached house
S11 9NN - 1,929,000
- Freehold Detached house
S11 9NN - 1,428,000
- Leasehold Detached property
S11 9NN - 1,376,000
- Leasehold Detached house
S11 9NN - 891,000
- Leasehold Detached property
S11 9NN - 1,503,000
- Leasehold Detached property
S11 9NN - 1,399,000
- Leasehold Detached house
S11 9NN - 1,243,000
- Freehold Detached house
S11 9NN - 1,421,000
- Leasehold Detached house
S11 9NN - 1,051,000
- Freehold Detached house
S11 9NN - 1,398,000
- Freehold Detached house
S11 9NN - 1,461,000
- Freehold Detached house
S11 9NN - 1,467,000
- Freehold Detached house
S11 9NN - 2,267,000
- Leasehold Detached property
