SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW11 6BB' order by fulladdress
SW11 6BB - 1,815,000
- Freehold Mid terrace house
SW11 6BB - 1,733,000
- Feudal Mid terrace house
SW11 6BB - 1,708,000
- Freehold End terrace house
SW11 6BB - 1,896,000
- Freehold Flat/Maisonette
SW11 6BB - 1,762,000
- Freehold Mid terrace house
SW11 6BB - 1,684,000
- Freehold Mid terrace house
SW11 6BB - 1,768,000
- Freehold Mid terrace house
SW11 6BB - 1,846,000
- Freehold Mid terrace house
SW11 6BB - 1,788,000
- Freehold Mid terrace house
SW11 6BB - 1,884,000
- Freehold Mid terrace house
SW11 6BB - 1,815,000
- Freehold Mid terrace house
SW11 6BB - 927,000
- Leasehold Purpose built flat
SW11 6BB - 923,000
- Leasehold Converted flat
SW11 6BB - 1,916,000
- Freehold Mid terrace house
SW11 6BB - 1,908,000
- Freehold Mid terrace house
SW11 6BB - 823,000
- Leasehold Converted flat
SW11 6BB - 880,000
- Leasehold Flat/Maisonette
SW11 6BB - 819,000
- Leasehold Converted flat
SW11 6BB - 2,030,000
- Freehold Terrace property
SW11 6BB - 2,185,000
- Freehold Terrace property
SW11 6BB - 1,828,000
- Freehold Mid terrace house
SW11 6BB - 1,766,000
- Freehold Mid terrace house
SW11 6BB - 1,912,000
- Freehold Mid terrace house
SW11 6BB - 885,000
- Leasehold Flat/Maisonette
