SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW8 1GA' order by fulladdress
SW8 1GA - 754,000
- Leasehold Converted flat
SW8 1GA - 794,000
- Leasehold Purpose built flat
SW8 1GA - 835,000
- Leasehold Purpose built flat
SW8 1GA - 821,000
- Leasehold Flat/Maisonette
SW8 1GA - 967,000
- Leasehold Converted flat
SW8 1GA - 945,000
- Leasehold Flat/Maisonette
SW8 1GA - 798,000
- Leasehold Purpose built flat
SW8 1GA - 871,000
- Leasehold Flat/Maisonette
SW8 1GA - 794,000
- Leasehold Converted flat
SW8 1GA - 902,000
- Leasehold Flat/Maisonette
SW8 1GA - 858,000
- Leasehold Converted flat
SW8 1GA - 745,000
- Leasehold Converted flat
SW8 1GA - 867,000
- Leasehold Purpose built flat
SW8 1GA - 863,000
- Leasehold Flat/Maisonette
SW8 1GA - 822,000
- Leasehold Converted flat
SW8 1GA - 1,049,000
- Leasehold Flat/Maisonette
SW8 1GA - 935,000
- Leasehold Converted flat
SW8 1GA - 843,000
- Leasehold Purpose built flat
SW8 1GA - 969,000
- Leasehold Flat/Maisonette
SW8 1GA - 885,000
- Leasehold Purpose built flat
SW8 1GA - 786,000
- Feudal Purpose built flat
SW8 1GA - 831,000
- Leasehold Purpose built flat
SW8 1GA - 971,000
- Leasehold Converted flat
SW8 1GA - 1,215,000
- Leasehold Flat/Maisonette
SW8 1GA - 797,000
- Leasehold Flat/Maisonette
SW8 1GA - 795,000
- Leasehold Flat/Maisonette
SW8 1GA - 875,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,127,000
- Feudal Converted flat
SW8 1GA - 810,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,158,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,031,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,175,000
- Leasehold Purpose built flat
SW8 1GA - 691,000
- Leasehold Purpose built flat
SW8 1GA - 1,037,000
- Leasehold Flat/Maisonette
SW8 1GA - 829,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,145,000
- Leasehold Converted flat
SW8 1GA - 1,252,000
- Leasehold Flat/Maisonette
SW8 1GA - 581,000
- Leasehold Flat/Maisonette
SW8 1GA - 932,000
- Leasehold Purpose built flat
SW8 1GA - 760,000
- Leasehold Converted flat
SW8 1GA - 1,076,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,108,000
- Leasehold Flat/Maisonette
SW8 1GA - 879,000
- Leasehold Purpose built flat
SW8 1GA - 1,014,000
- Leasehold Flat/Maisonette
SW8 1GA - 795,000
- Leasehold Flat/Maisonette
SW8 1GA - 1,026,000
- Leasehold Flat/Maisonette
SW8 1GA - 980,000
- Leasehold Flat/Maisonette
SW8 1GA - 936,000
- Feudal Purpose built flat
SW8 1GA - 1,216,000
- Leasehold Flat/Maisonette
SW8 1GA - 792,000
- Feudal Purpose built flat
SW8 1GA - 704,000
- Leasehold Purpose built flat
SW8 1GA - 880,000
- Leasehold Purpose built flat
SW8 1GA - 931,000
- Feudal Purpose built flat