SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW7 3JH' order by fulladdress
SW7 3JH - 2,142,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,511,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,209,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,422,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,325,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,393,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,108,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,370,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,232,000
- Leasehold Flat/Maisonette
SW7 3JH - 1,911,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,896,000
- Share of freehold Flat/Maisonette
SW7 3JH - 2,098,000
- Leasehold Purpose built flat
SW7 3JH - 2,616,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,644,000
- Leasehold Purpose built flat
SW7 3JH - 1,780,000
- Leasehold Flat/Maisonette
SW7 3JH - 3,019,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,093,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,229,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,609,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,099,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,963,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,198,000
- Leasehold Purpose built flat
SW7 3JH - 2,176,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,051,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,955,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,191,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,543,000
- Leasehold Flat/Maisonette
SW7 3JH - 1,998,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,713,000
- Leasehold Flat/Maisonette
SW7 3JH - 2,199,000
- Leasehold Flat/Maisonette
