SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW18 1TS' order by fulladdress
SW18 1TS - 650,000
- Leasehold Flat/Maisonette
SW18 1TS - 664,000
- Feudal Purpose built flat
SW18 1TS - 406,000
- Leasehold Purpose built flat
SW18 1TS - 891,000
- Leasehold Flat/Maisonette
SW18 1TS - 834,000
- Leasehold Flat/Maisonette
SW18 1TS - 898,000
- Leasehold Flat/Maisonette
SW18 1TS - 687,000
- Leasehold Flat/Maisonette
SW18 1TS - 806,000
- Leasehold Flat/Maisonette
SW18 1TS - 934,000
- Leasehold Purpose built flat
SW18 1TS - 637,000
- Leasehold Flat/Maisonette
SW18 1TS - 737,000
- Feudal Purpose built flat
SW18 1TS - 789,000
- Leasehold Flat/Maisonette
SW18 1TS - 881,000
- Leasehold Flat/Maisonette
SW18 1TS - 804,000
- Leasehold Purpose built flat
SW18 1TS - 884,000
- Leasehold Flat/Maisonette
SW18 1TS - 824,000
- Leasehold Purpose built flat
SW18 1TS - 797,000
- Leasehold Purpose built flat
SW18 1TS - 759,000
- Leasehold Flat/Maisonette
SW18 1TS - 383,000
- Leasehold Flat/Maisonette
SW18 1TS - 437,000
- Leasehold Purpose built flat
SW18 1TS - 723,000
- Leasehold Purpose built flat
SW18 1TS - 645,000
- Leasehold Flat/Maisonette
SW18 1TS - 898,000
- Leasehold Flat/Maisonette
SW18 1TS - 676,000
- Leasehold Purpose built flat
SW18 1TS - 641,000
- Leasehold Purpose built flat
SW18 1TS - 893,000
- Leasehold Flat/Maisonette
SW18 1TS - 426,000
- Leasehold Flat/Maisonette
SW18 1TS - 514,000
- Leasehold Purpose built flat
SW18 1TS - 908,000
- Leasehold Flat/Maisonette
SW18 1TS - 833,000
- Leasehold Flat/Maisonette
SW18 1TS - 919,000
- Leasehold Purpose built flat
SW18 1TS - 834,000
- Leasehold Flat/Maisonette
SW18 1TS - 893,000
- Leasehold Purpose built flat
SW18 1TS - 945,000
- Leasehold Flat/Maisonette
SW18 1TS - 615,000
- Leasehold Flat/Maisonette
SW18 1TS - 627,000
- Leasehold Flat/Maisonette
SW18 1TS - 907,000
- Leasehold Flat/Maisonette
SW18 1TS - 832,000
- Leasehold Flat/Maisonette
SW18 1TS - 910,000
- Leasehold Flat/Maisonette
SW18 1TS - 841,000
- Leasehold Purpose built flat
SW18 1TS - 857,000
- Leasehold Purpose built flat
SW18 1TS - 1,264,000
- Leasehold Flat/Maisonette
SW18 1TS - 771,000
- Leasehold Purpose built flat
SW18 1TS - 1,322,000
- Leasehold Flat/Maisonette
SW18 1TS - 869,000
- Leasehold Flat/Maisonette
SW18 1TS - 951,000
- Leasehold Purpose built flat
SW18 1TS - 768,000
- Leasehold Flat/Maisonette
SW18 1TS - 892,000
- Leasehold Purpose built flat
SW18 1TS - 1,149,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,304,000
- Leasehold Purpose built flat
SW18 1TS - 842,000
- Leasehold Purpose built flat
SW18 1TS - 798,000
- Leasehold Flat/Maisonette
SW18 1TS - 739,000
- Leasehold Purpose built flat
SW18 1TS - 1,520,000
- Leasehold Flat/Maisonette
SW18 1TS - 907,000
- Leasehold Flat/Maisonette
SW18 1TS - 835,000
- Leasehold Purpose built flat
SW18 1TS - 1,194,000
- Leasehold Purpose built flat
SW18 1TS - 842,000
- Leasehold Purpose built flat
SW18 1TS - 1,493,000
- Leasehold Purpose built flat
SW18 1TS - 1,689,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,083,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,097,000
- Leasehold Flat/Maisonette
SW18 1TS - 880,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,167,000
- Leasehold Purpose built flat
SW18 1TS - 766,000
- Leasehold Flat/Maisonette
SW18 1TS - 885,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,133,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,168,000
- Leasehold Purpose built flat
SW18 1TS - 1,384,000
- Leasehold Flat/Maisonette
SW18 1TS - 1,550,000
- Leasehold Purpose built flat
SW18 1TS - 1,231,000
- Leasehold Purpose built flat
SW18 1TS - 762,000
- Leasehold Flat/Maisonette
SW18 1TS - 2,560,000
- Leasehold Flat/Maisonette
SW18 1TS - 907,000
- Leasehold Flat/Maisonette
SW18 1TS - 977,000
- Leasehold Flat/Maisonette