SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW8 2LJ' order by fulladdress
SW8 2LJ - 912,000
- Leasehold Purpose built flat
SW8 2LJ - 868,000
- Leasehold Flat/Maisonette
SW8 2LJ - 768,000
- Leasehold Purpose built flat
SW8 2LJ - 717,000
- Leasehold Flat/Maisonette
SW8 2LJ - 902,000
- Leasehold Flat/Maisonette
SW8 2LJ - 873,000
- Leasehold Purpose built flat
SW8 2LJ - 725,000
- Leasehold Purpose built flat
SW8 2LJ - 734,000
- Leasehold Flat/Maisonette
SW8 2LJ - 940,000
- Leasehold Flat/Maisonette
SW8 2LJ - 972,000
- Leasehold Flat/Maisonette
SW8 2LJ - 726,000
- Leasehold Flat/Maisonette
SW8 2LJ - 717,000
- Leasehold Flat/Maisonette
SW8 2LJ - 756,000
- Leasehold Flat/Maisonette
SW8 2LJ - 962,000
- Leasehold Purpose built flat
SW8 2LJ - 741,000
- Leasehold Purpose built flat
SW8 2LJ - 748,000
- Leasehold Flat/Maisonette
SW8 2LJ - 951,000
- Leasehold Purpose built flat
SW8 2LJ - 962,000
- Leasehold Purpose built flat
SW8 2LJ - 749,000
- Leasehold Flat/Maisonette
SW8 2LJ - 747,000
- Leasehold Flat/Maisonette
SW8 2LJ - 949,000
- Feudal Purpose built flat
SW8 2LJ - 990,000
- Leasehold Flat/Maisonette
SW8 2LJ - 736,000
- Leasehold Flat/Maisonette
SW8 2LJ - 725,000
- Leasehold Purpose built flat
SW8 2LJ - 986,000
- Leasehold Flat/Maisonette
SW8 2LJ - 855,000
- Leasehold Purpose built flat
SW8 2LJ - 784,000
- Leasehold Flat/Maisonette
SW8 2LJ - 720,000
- Leasehold Flat/Maisonette
SW8 2LJ - 934,000
- Leasehold Flat/Maisonette
SW8 2LJ - 1,374,000
- Leasehold Flat/Maisonette
SW8 2LJ - 1,096,000
- Leasehold Flat/Maisonette
SW8 2LJ - 1,183,000
- Leasehold Flat/Maisonette
SW8 2LJ - 1,080,000
- Leasehold Purpose built flat
SW8 2LJ - 1,440,000
- Leasehold Flat/Maisonette
