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 1TX' order by fulladdress
SW18 1TX - 790,000
- Leasehold Purpose built flat
SW18 1TX - 688,000
- Leasehold Flat/Maisonette
SW18 1TX - 566,000
- Leasehold Purpose built flat
SW18 1TX - 909,000
- Leasehold Purpose built flat
SW18 1TX - 867,000
- Leasehold Flat/Maisonette
SW18 1TX - 848,000
- Leasehold Purpose built flat
SW18 1TX - 942,000
- Leasehold Purpose built flat
SW18 1TX - 795,000
- Leasehold Flat/Maisonette
SW18 1TX - 843,000
- Feudal Purpose built flat
SW18 1TX - 611,000
- Leasehold Flat/Maisonette
SW18 1TX - 587,000
- Leasehold Purpose built flat
SW18 1TX - 787,000
- Leasehold Purpose built flat
SW18 1TX - 858,000
- Leasehold Purpose built flat
SW18 1TX - 711,000
- Leasehold Purpose built flat
SW18 1TX - 836,000
- Leasehold Purpose built flat
SW18 1TX - 919,000
- Leasehold Flat/Maisonette
SW18 1TX - 891,000
- Feudal Purpose built flat
SW18 1TX - 1,002,000
- Leasehold Flat/Maisonette
SW18 1TX - 539,000
- Leasehold Flat/Maisonette
SW18 1TX - 696,000
- Leasehold Flat/Maisonette
SW18 1TX - 921,000
- Leasehold Flat/Maisonette
SW18 1TX - 833,000
- Feudal Purpose built flat
SW18 1TX - 984,000
- Leasehold Flat/Maisonette
SW18 1TX - 978,000
- Leasehold Flat/Maisonette
SW18 1TX - 634,000
- Leasehold Purpose built flat
SW18 1TX - 804,000
- Leasehold Purpose built flat
SW18 1TX - 920,000
- Leasehold Purpose built flat
SW18 1TX - 623,000
- Leasehold Purpose built flat
SW18 1TX - 551,000
- Leasehold Flat/Maisonette
SW18 1TX - 736,000
- Leasehold Purpose built flat
SW18 1TX - 791,000
- Leasehold Flat/Maisonette
SW18 1TX - 827,000
- Leasehold Flat/Maisonette
SW18 1TX - 853,000
- Leasehold Purpose built flat
SW18 1TX - 793,000
- Leasehold Purpose built flat
SW18 1TX - 872,000
- Leasehold Flat/Maisonette
SW18 1TX - 1,060,000
- Leasehold Flat/Maisonette
SW18 1TX - 618,000
- Leasehold Flat/Maisonette
SW18 1TX - 586,000
- Leasehold Purpose built flat
SW18 1TX - 939,000
- Leasehold Flat/Maisonette
SW18 1TX - 748,000
- Leasehold Flat/Maisonette
SW18 1TX - 857,000
- Leasehold Purpose built flat
SW18 1TX - 1,461,000
- Leasehold Purpose built flat
SW18 1TX - 1,574,000
- Leasehold Flat/Maisonette
SW18 1TX - 730,000
- Leasehold Purpose built flat
SW18 1TX - 843,000
- Leasehold Flat/Maisonette
SW18 1TX - 812,000
- Leasehold Purpose built flat
SW18 1TX - 1,119,000
- Leasehold Flat/Maisonette
SW18 1TX - 1,019,000
- Leasehold Flat/Maisonette
SW18 1TX - 907,000
- Leasehold Flat/Maisonette
SW18 1TX - 764,000
- Leasehold Flat/Maisonette
SW18 1TX - 795,000
- Leasehold Purpose built flat