SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1P 2NE' order by fulladdress
SW1P 2NE - 940,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,053,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,682,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,208,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,200,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,387,000
- Leasehold Purpose built flat
SW1P 2NE - 1,174,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,686,000
- Leasehold Flat/Maisonette
SW1P 2NE - 831,000
- Leasehold Converted flat
SW1P 2NE - 1,314,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,113,000
- Leasehold Flat/Maisonette
SW1P 2NE - 710,000
- Leasehold Converted flat
SW1P 2NE - 782,000
- Leasehold Purpose built flat
SW1P 2NE - 1,160,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,498,000
- Leasehold Purpose built flat
SW1P 2NE - 1,527,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,263,000
- Leasehold Converted flat
SW1P 2NE - 1,575,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,261,000
- Feudal Converted flat
SW1P 2NE - 955,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,436,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,202,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,614,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,106,000
- Leasehold Purpose built flat
SW1P 2NE - 1,253,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,457,000
- Leasehold Converted flat
SW1P 2NE - 936,000
- Leasehold Flat/Maisonette
SW1P 2NE - 953,000
- Leasehold Flat/Maisonette
SW1P 2NE - 808,000
- Leasehold Flat/Maisonette
SW1P 2NE - 652,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,218,000
- Leasehold Flat/Maisonette
SW1P 2NE - 795,000
- Leasehold Flat/Maisonette
SW1P 2NE - 685,000
- Leasehold Converted flat
SW1P 2NE - 865,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,857,000
- Leasehold Flat/Maisonette
SW1P 2NE - 787,000
- Leasehold Purpose built flat
SW1P 2NE - 1,226,000
- Leasehold Purpose built flat
SW1P 2NE - 1,047,000
- Leasehold Flat/Maisonette
SW1P 2NE - 702,000
- Leasehold Flat/Maisonette
SW1P 2NE - 767,000
- Leasehold Purpose built flat
SW1P 2NE - 747,000
- Leasehold Purpose built flat
SW1P 2NE - 1,090,000
- Leasehold Purpose built flat
SW1P 2NE - 826,000
- Leasehold Flat/Maisonette
SW1P 2NE - 859,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,053,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,178,000
- Feudal Purpose built flat
SW1P 2NE - 1,699,000
- Leasehold Flat/Maisonette
SW1P 2NE - 779,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,268,000
- Leasehold Purpose built flat
SW1P 2NE - 715,000
- Leasehold Purpose built flat
SW1P 2NE - 1,140,000
- Feudal Purpose built flat
SW1P 2NE - 613,000
- Leasehold Flat/Maisonette
SW1P 2NE - 727,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,091,000
- Leasehold Flat/Maisonette
SW1P 2NE - 1,546,000
- Leasehold Purpose built flat
SW1P 2NE - 1,153,000
- Leasehold Purpose built flat
SW1P 2NE - 1,142,000
- Leasehold Converted flat