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 4BF' order by fulladdress
SW1P 4BF - 945,000
- Leasehold Purpose built flat
SW1P 4BF - 763,000
- Leasehold Flat/Maisonette
SW1P 4BF - 877,000
- Leasehold Flat/Maisonette
SW1P 4BF - 916,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,254,000
- Freehold Flat/Maisonette
SW1P 4BF - 1,547,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,000,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,092,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,117,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,007,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,050,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,309,000
- Leasehold Purpose built flat
SW1P 4BF - 753,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,203,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,085,000
- Leasehold Flat/Maisonette
SW1P 4BF - 953,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,271,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,365,000
- Leasehold Purpose built flat
SW1P 4BF - 829,000
- Leasehold Purpose built flat
SW1P 4BF - 973,000
- Leasehold Purpose built flat
SW1P 4BF - 1,065,000
- Leasehold Purpose built flat
SW1P 4BF - 1,025,000
- Leasehold Flat/Maisonette
SW1P 4BF - 848,000
- Leasehold Flat/Maisonette
SW1P 4BF - 961,000
- Leasehold Purpose built flat
SW1P 4BF - 756,000
- Leasehold Purpose built flat
SW1P 4BF - 792,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,317,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,008,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,346,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,382,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,003,000
- Leasehold Purpose built flat
SW1P 4BF - 1,160,000
- Leasehold Flat/Maisonette
SW1P 4BF - 970,000
- Leasehold Converted flat
SW1P 4BF - 989,000
- Leasehold Purpose built flat
SW1P 4BF - 863,000
- Leasehold Purpose built flat
SW1P 4BF - 974,000
- Leasehold Flat/Maisonette
SW1P 4BF - 781,000
- Leasehold Flat/Maisonette
SW1P 4BF - 780,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,325,000
- Leasehold Flat/Maisonette
SW1P 4BF - 979,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,541,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,012,000
- Leasehold Purpose built flat
SW1P 4BF - 853,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,008,000
- Leasehold Flat/Maisonette
SW1P 4BF - 828,000
- Leasehold Purpose built flat
SW1P 4BF - 1,311,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,391,000
- Leasehold Flat/Maisonette
SW1P 4BF - 981,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,396,000
- Leasehold Flat/Maisonette
SW1P 4BF - 957,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,259,000
- Leasehold Purpose built flat
SW1P 4BF - 1,348,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,276,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,033,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,316,000
- Leasehold Purpose built flat
SW1P 4BF - 1,638,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,847,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,367,000
- Leasehold Purpose built flat
SW1P 4BF - 659,000
- Leasehold Purpose built flat
SW1P 4BF - 1,128,000
- Leasehold Flat/Maisonette
SW1P 4BF - 1,050,000
- Leasehold Purpose built flat
SW1P 4BF - 781,000
- Leasehold Purpose built flat