SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW20 9LT' order by fulladdress
SW20 9LT - 840,000
- Freehold Terrace property
SW20 9LT - 899,000
- Freehold Terrace property
SW20 9LT - 869,000
- Freehold Mid terrace house
SW20 9LT - 874,000
- Freehold End terrace house
SW20 9LT - 907,000
- Freehold Mid terrace house
SW20 9LT - 915,000
- Freehold Mid terrace house
SW20 9LT - 832,000
- Freehold Mid terrace house
SW20 9LT - 962,000
- Freehold End terrace house
SW20 9LT - 794,000
- Freehold Mid terrace house
SW20 9LT - 816,000
- Freehold Mid terrace house
SW20 9LT - 765,000
- Freehold Detached house
SW20 9LT - 787,000
- Freehold Terrace property
SW20 9LT - 915,000
- Freehold Semi-detached house
SW20 9LT - 772,000
- Freehold Semi-detached house
SW20 9LT - 838,000
- Freehold Mid terrace house
SW20 9LT - 879,000
- Freehold Mid terrace house
SW20 9LT - 873,000
- Freehold End terrace house
SW20 9LT - 834,000
- Freehold End terrace house
SW20 9LT - 846,000
- Freehold Mid terrace house
SW20 9LT - 969,000
- Freehold Mid terrace house
SW20 9LT - 853,000
- Freehold End terrace house
SW20 9LT - 809,000
- Freehold Mid terrace house
SW20 9LT - 890,000
- Freehold Mid terrace house
SW20 9LT - 841,000
- Freehold Mid terrace house
SW20 9LT - 881,000
- Freehold Mid terrace house
SW20 9LT - 856,000
- Freehold End terrace house
SW20 9LT - 821,000
- Freehold Mid terrace house
SW20 9LT - 859,000
- Freehold Mid terrace house
SW20 9LT - 992,000
- Freehold Mid terrace house
SW20 9LT - 889,000
- Freehold End terrace house
SW20 9LT - 893,000
- Freehold End terrace house