SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E8 3EZ' order by fulladdress
E8 3EZ - 753,000
- Leasehold Flat/Maisonette
E8 3EZ - 779,000
- Leasehold Flat/Maisonette
E8 3EZ - 737,000
- Leasehold Flat/Maisonette
E8 3EZ - 773,000
- Leasehold Converted flat
E8 3EZ - 762,000
- Leasehold Converted flat
E8 3EZ - 565,000
- Leasehold Flat/Maisonette
E8 3EZ - 733,000
- Leasehold Converted flat
E8 3EZ - 762,000
- Leasehold Converted flat
E8 3EZ - 817,000
- Leasehold Flat/Maisonette
E8 3EZ - 800,000
- Leasehold Flat/Maisonette
E8 3EZ - 796,000
- Leasehold Converted flat
E8 3EZ - 835,000
- Leasehold Flat/Maisonette
E8 3EZ - 755,000
- Freehold Converted flat
E8 3EZ - 821,000
- Leasehold Converted flat
E8 3EZ - 784,000
- Leasehold Converted flat
E8 3EZ - 804,000
- Leasehold Converted flat
E8 3EZ - 1,333,000
- Leasehold Converted flat
E8 3EZ - 798,000
- Leasehold Converted flat
E8 3EZ - 849,000
- Leasehold Converted flat
E8 3EZ - 849,000
- Leasehold Converted flat
E8 3EZ - 839,000
- Feudal Converted flat
E8 3EZ - 739,000
- Leasehold Flat/Maisonette
E8 3EZ - 811,000
- Leasehold Flat/Maisonette
E8 3EZ - 736,000
- Leasehold Converted flat
E8 3EZ - 783,000
- Leasehold Converted flat
E8 3EZ - 734,000
- Leasehold Converted flat
E8 3EZ - 793,000
- Leasehold Converted flat
E8 3EZ - 928,000
- Leasehold Flat/Maisonette
E8 3EZ - 828,000
- Leasehold Converted flat
E8 3EZ - 765,000
- Leasehold Converted flat
E8 3EZ - 759,000
- Leasehold Converted flat
E8 3EZ - 777,000
- Leasehold Converted flat
E8 3EZ - 851,000
- Leasehold Flat/Maisonette
