SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE22 9PN' order by fulladdress
SE22 9PN - 824,000
- Freehold Mid terrace house
SE22 9PN - 886,000
- Freehold Mid terrace house
SE22 9PN - 778,000
- Freehold Mid terrace house
SE22 9PN - 759,000
- Freehold Mid terrace house
SE22 9PN - 788,000
- Freehold Mid terrace house
SE22 9PN - 887,000
- Freehold Mid terrace house
SE22 9PN - 986,000
- Freehold Mid terrace house
SE22 9PN - 943,000
- Freehold Mid terrace house
SE22 9PN - 900,000
- Freehold Detached house
SE22 9PN - 1,153,000
- Freehold Mid terrace house
SE22 9PN - 841,000
- Freehold Mid terrace house
SE22 9PN - 888,000
- Freehold Mid terrace house
SE22 9PN - 989,000
- Freehold Mid terrace house
SE22 9PN - 1,133,000
- Freehold Mid terrace house
SE22 9PN - 816,000
- Freehold Mid terrace house
SE22 9PN - 796,000
- Freehold Mid terrace house
SE22 9PN - 794,000
- Freehold Mid terrace house
SE22 9PN - 811,000
- Freehold Mid terrace house
SE22 9PN - 868,000
- Freehold Terrace property
SE22 9PN - 612,000
- Freehold Converted flat
SE22 9PN - 408,000
- Leasehold Converted flat
SE22 9PN - 497,000
- Leasehold Purpose built flat
