SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW12 9SN' order by fulladdress
SW12 9SN - 471,000
- Leasehold Purpose built flat
SW12 9SN - 835,000
- Leasehold Purpose built flat
SW12 9SN - 729,000
- Leasehold Flat/Maisonette
SW12 9SN - 730,000
- Leasehold Purpose built flat
SW12 9SN - 916,000
- Leasehold Purpose built flat
SW12 9SN - 723,000
- Leasehold Purpose built flat
SW12 9SN - 725,000
- Leasehold Converted flat
SW12 9SN - 787,000
- Leasehold Purpose built flat
SW12 9SN - 660,000
- Leasehold Flat/Maisonette
SW12 9SN - 676,000
- Leasehold Flat/Maisonette
SW12 9SN - 441,000
- Leasehold Flat/Maisonette
SW12 9SN - 760,000
- Leasehold Purpose built flat
SW12 9SN - 756,000
- Leasehold Flat/Maisonette
SW12 9SN - 714,000
- Leasehold Purpose built flat
SW12 9SN - 686,000
- Leasehold Converted flat
SW12 9SN - 882,000
- Leasehold Purpose built flat
SW12 9SN - 710,000
- Leasehold Purpose built flat
SW12 9SN - 683,000
- Leasehold Flat/Maisonette
SW12 9SN - 752,000
- Leasehold Flat/Maisonette
SW12 9SN - 663,000
- Leasehold Purpose built flat
SW12 9SN - 664,000
- Leasehold Purpose built flat
SW12 9SN - 916,000
- Leasehold Flat/Maisonette
SW12 9SN - 731,000
- Leasehold Purpose built flat
SW12 9SN - 770,000
- Freehold Purpose built flat
SW12 9SN - 755,000
- Leasehold Purpose built flat
SW12 9SN - 837,000
- Leasehold Purpose built flat
SW12 9SN - 709,000
- Leasehold Purpose built flat
SW12 9SN - 674,000
- Freehold Flat/Maisonette
SW12 9SN - 690,000
- Freehold Flat/Maisonette
SW12 9SN - 719,000
- Leasehold Purpose built flat
SW12 9SN - 791,000
- Leasehold Purpose built flat
SW12 9SN - 700,000
- Leasehold Purpose built flat
SW12 9SN - 722,000
- Leasehold Flat/Maisonette
SW12 9SN - 796,000
- Leasehold End terrace house
SW12 9SN - 760,000
- Leasehold Purpose built flat
