SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW3 5HG' order by fulladdress
SW3 5HG - 1,918,000
- Leasehold Flat/Maisonette
SW3 5HG - 837,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,280,000
- Leasehold Purpose built flat
SW3 5HG - 1,245,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,345,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,240,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,263,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,294,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,191,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,704,000
- Leasehold Purpose built flat
SW3 5HG - 1,664,000
- Leasehold Purpose built flat
SW3 5HG - 1,728,000
- Leasehold Flat/Maisonette
SW3 5HG - 837,000
- Leasehold Purpose built flat
SW3 5HG - 845,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,604,000
- Leasehold Purpose built flat
SW3 5HG - 794,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,593,000
- Leasehold Purpose built flat
SW3 5HG - 922,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,260,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,241,000
- Feudal Purpose built flat
SW3 5HG - 1,325,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,290,000
- Leasehold Purpose built flat
SW3 5HG - 1,694,000
- Leasehold Purpose built flat
SW3 5HG - 773,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,301,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,908,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,901,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,822,000
- Leasehold Purpose built flat
SW3 5HG - 2,059,000
- Leasehold Flat/Maisonette
SW3 5HG - 818,000
- Leasehold Purpose built flat
SW3 5HG - 1,965,000
- Leasehold Flat/Maisonette
SW3 5HG - 913,000
- Leasehold Purpose built flat
SW3 5HG - 818,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,103,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,877,000
- Leasehold Flat/Maisonette
SW3 5HG - 845,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,281,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,211,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,304,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,328,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,642,000
- Leasehold Flat/Maisonette
SW3 5HG - 867,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,807,000
- Leasehold Flat/Maisonette
SW3 5HG - 882,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,511,000
- Leasehold Flat/Maisonette
SW3 5HG - 811,000
- Leasehold Flat/Maisonette
SW3 5HG - 1,274,000
- Leasehold Purpose built flat
SW3 5HG - 1,598,000
- Leasehold Purpose built flat