SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW10 9JX' order by fulladdress
SW10 9JX - 952,000
- Leasehold Converted flat
SW10 9JX - 818,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,263,000
- Leasehold Flat/Maisonette
SW10 9JX - 930,000
- Leasehold Converted flat
SW10 9JX - 1,392,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,127,000
- Leasehold Flat/Maisonette
SW10 9JX - 859,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,372,000
- Leasehold Converted flat
SW10 9JX - 1,173,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,043,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,147,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,158,000
- Feudal Converted flat
SW10 9JX - 1,279,000
- Leasehold Converted flat
SW10 9JX - 1,264,000
- Leasehold Converted flat
SW10 9JX - 1,231,000
- Leasehold Converted flat
SW10 9JX - 1,098,000
- Leasehold Converted flat
SW10 9JX - 1,325,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,243,000
- Leasehold Flat/Maisonette
SW10 9JX - 2,337,000
- Leasehold Converted flat
SW10 9JX - 2,135,000
- Leasehold Converted flat
SW10 9JX - 2,587,000
- Leasehold Flat/Maisonette
SW10 9JX - 992,000
- Leasehold Flat/Maisonette
SW10 9JX - 900,000
- Leasehold Purpose built flat
SW10 9JX - 1,595,000
- Leasehold Converted flat
SW10 9JX - 1,405,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,416,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,357,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,113,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,171,000
- Feudal Converted flat
SW10 9JX - 749,000
- Leasehold Purpose built flat
SW10 9JX - 1,537,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,377,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,104,000
- Leasehold Flat/Maisonette
SW10 9JX - 780,000
- Leasehold Converted flat
SW10 9JX - 687,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,687,000
- Leasehold Purpose built flat
SW10 9JX - 1,154,000
- Leasehold Converted flat
SW10 9JX - 1,275,000
- Leasehold Converted flat
SW10 9JX - 1,839,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,626,000
- Leasehold Flat/Maisonette
SW10 9JX - 1,194,000
- Leasehold Converted flat
SW10 9JX - 1,417,000
- Leasehold Flat/Maisonette
