SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1X 0JY' order by fulladdress
SW1X 0JY - 9,122,000
- Freehold Terrace property
SW1X 0JY - 2,185,000
- Share of freehold Flat/Maisonette
SW1X 0JY - 2,309,000
- Leasehold Converted flat
SW1X 0JY - 1,736,000
- Leasehold Flat/Maisonette
SW1X 0JY - 911,000
- Leasehold Converted flat
SW1X 0JY - 2,372,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,095,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,469,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,527,000
- Leasehold Converted flat
SW1X 0JY - 2,039,000
- Leasehold Converted flat
SW1X 0JY - 1,801,000
- Leasehold Converted flat
SW1X 0JY - 846,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,229,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,642,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,897,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,695,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,103,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,243,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,217,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,665,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,845,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,961,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,544,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,207,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,476,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,038,000
- Leasehold Purpose built flat
SW1X 0JY - 2,084,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,437,000
- Leasehold Flat/Maisonette
SW1X 0JY - 2,050,000
- Leasehold Flat/Maisonette
SW1X 0JY - 1,879,000
- Leasehold Flat/Maisonette