SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW5 0HL' order by fulladdress
SW5 0HL - 2,082,000
- Share of freehold Flat/Maisonette
SW5 0HL - 945,000
- Leasehold Converted flat
SW5 0HL - 1,052,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,686,000
- Leasehold Converted flat
SW5 0HL - 757,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,141,000
- Leasehold Flat/Maisonette
SW5 0HL - 740,000
- Leasehold Converted flat
SW5 0HL - 1,293,000
- Leasehold Flat/Maisonette
SW5 0HL - 930,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,888,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,305,000
- Leasehold Converted flat
SW5 0HL - 1,292,000
- Leasehold Converted flat
SW5 0HL - 1,589,000
- Leasehold Purpose built flat
SW5 0HL - 1,688,000
- Leasehold Flat/Maisonette
SW5 0HL - 791,000
- Leasehold Converted flat
SW5 0HL - 1,854,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,169,000
- Leasehold Converted flat
SW5 0HL - 1,690,000
- Leasehold Flat/Maisonette
SW5 0HL - 804,000
- Leasehold Converted flat
SW5 0HL - 1,653,000
- Leasehold Converted flat
SW5 0HL - 1,215,000
- Leasehold Converted flat
SW5 0HL - 1,929,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,378,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,175,000
- Leasehold Purpose built flat
SW5 0HL - 1,409,000
- Leasehold Converted flat
SW5 0HL - 1,126,000
- Share of freehold Flat/Maisonette
SW5 0HL - 1,386,000
- Leasehold Converted flat
SW5 0HL - 1,168,000
- Leasehold Converted flat
SW5 0HL - 1,383,000
- Leasehold Flat/Maisonette
SW5 0HL - 1,272,000
- Leasehold Flat/Maisonette
