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 1TW' order by fulladdress
SW18 1TW - 742,000
- Leasehold Purpose built flat
SW18 1TW - 805,000
- Leasehold Flat/Maisonette
SW18 1TW - 768,000
- Leasehold Purpose built flat
SW18 1TW - 765,000
- Leasehold Flat/Maisonette
SW18 1TW - 844,000
- Leasehold Flat/Maisonette
SW18 1TW - 547,000
- Leasehold Flat/Maisonette
SW18 1TW - 520,000
- Leasehold Flat/Maisonette
SW18 1TW - 787,000
- Leasehold Purpose built flat
SW18 1TW - 799,000
- Leasehold Flat/Maisonette
SW18 1TW - 778,000
- Leasehold Purpose built flat
SW18 1TW - 792,000
- Leasehold Flat/Maisonette
SW18 1TW - 749,000
- Leasehold Flat/Maisonette
SW18 1TW - 756,000
- Leasehold Purpose built flat
SW18 1TW - 502,000
- Leasehold Flat/Maisonette
SW18 1TW - 535,000
- Leasehold Purpose built flat
SW18 1TW - 793,000
- Leasehold Purpose built flat
SW18 1TW - 762,000
- Leasehold Purpose built flat
SW18 1TW - 807,000
- Leasehold Flat/Maisonette
SW18 1TW - 785,000
- Leasehold Purpose built flat
SW18 1TW - 819,000
- Leasehold Flat/Maisonette
SW18 1TW - 715,000
- Leasehold Purpose built flat
SW18 1TW - 645,000
- Leasehold Flat/Maisonette
SW18 1TW - 564,000
- Leasehold Flat/Maisonette
SW18 1TW - 735,000
- Leasehold Purpose built flat
SW18 1TW - 773,000
- Leasehold Purpose built flat
SW18 1TW - 790,000
- Leasehold Purpose built flat
SW18 1TW - 748,000
- Leasehold Flat/Maisonette
SW18 1TW - 775,000
- Leasehold Flat/Maisonette
SW18 1TW - 812,000
- Leasehold Flat/Maisonette
SW18 1TW - 534,000
- Leasehold Purpose built flat
SW18 1TW - 506,000
- Leasehold Flat/Maisonette
SW18 1TW - 764,000
- Leasehold Flat/Maisonette
SW18 1TW - 805,000
- Leasehold Purpose built flat
SW18 1TW - 782,000
- Leasehold Purpose built flat
SW18 1TW - 790,000
- Leasehold Flat/Maisonette
SW18 1TW - 809,000
- Leasehold Flat/Maisonette
SW18 1TW - 716,000
- Leasehold Purpose built flat
SW18 1TW - 1,210,000
- Leasehold Purpose built flat
SW18 1TW - 1,050,000
- Leasehold Purpose built flat
SW18 1TW - 778,000
- Leasehold Purpose built flat
SW18 1TW - 820,000
- Leasehold Flat/Maisonette
SW18 1TW - 789,000
- Leasehold Purpose built flat
SW18 1TW - 1,579,000
- Leasehold Purpose built flat
SW18 1TW - 796,000
- Leasehold Purpose built flat
SW18 1TW - 733,000
- Leasehold Purpose built flat
SW18 1TW - 365,000
- Leasehold Flat/Maisonette
SW18 1TW - 510,000
- Leasehold Flat/Maisonette
SW18 1TW - 754,000
- Leasehold Purpose built flat
SW18 1TW - 751,000
- Leasehold Purpose built flat