SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW15 2QB' order by fulladdress
SW15 2QB - 731,000
- Feudal Purpose built flat
SW15 2QB - 772,000
- Feudal Purpose built flat
SW15 2QB - 845,000
- Leasehold Purpose built flat
SW15 2QB - 869,000
- Leasehold Purpose built flat
SW15 2QB - 792,000
- Leasehold Flat/Maisonette
SW15 2QB - 863,000
- Leasehold Purpose built flat
SW15 2QB - 811,000
- Leasehold Purpose built flat
SW15 2QB - 755,000
- Leasehold Purpose built flat
SW15 2QB - 1,173,000
- Leasehold Semi-detached house
SW15 2QB - 792,000
- Leasehold Purpose built flat
SW15 2QB - 873,000
- Leasehold Flat/Maisonette
SW15 2QB - 752,000
- Leasehold Flat/Maisonette
SW15 2QB - 872,000
- Leasehold Flat/Maisonette
SW15 2QB - 810,000
- Leasehold Purpose built flat
SW15 2QB - 655,000
- Leasehold Converted flat
SW15 2QB - 858,000
- Leasehold Purpose built flat
SW15 2QB - 833,000
- Leasehold Purpose built flat
SW15 2QB - 775,000
- Leasehold Flat/Maisonette
SW15 2QB - 833,000
- Leasehold Purpose built flat
SW15 2QB - 734,000
- Leasehold Flat/Maisonette
SW15 2QB - 836,000
- Leasehold Flat/Maisonette
SW15 2QB - 837,000
- Leasehold Purpose built flat
SW15 2QB - 838,000
- Leasehold Flat/Maisonette
SW15 2QB - 826,000
- Leasehold Flat/Maisonette
SW15 2QB - 795,000
- Leasehold Purpose built flat
SW15 2QB - 845,000
- Leasehold Flat/Maisonette
SW15 2QB - 837,000
- Leasehold Purpose built flat
SW15 2QB - 841,000
- Leasehold Purpose built flat
SW15 2QB - 846,000
- Leasehold Flat/Maisonette
SW15 2QB - 808,000
- Leasehold Purpose built flat
SW15 2QB - 760,000
- Leasehold Flat/Maisonette
SW15 2QB - 1,073,000
- Feudal Purpose built flat
SW15 2QB - 858,000
- Leasehold Flat/Maisonette
SW15 2QB - 1,300,000
- Leasehold Semi-detached house
SW15 2QB - 916,000
- Leasehold Mid terrace house