SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E1 8RJ' order by fulladdress
E1 8RJ - 582,000
- Leasehold Converted flat
E1 8RJ - 702,000
- Leasehold Converted flat
E1 8RJ - 669,000
- Leasehold Flat/Maisonette
E1 8RJ - 870,000
- Leasehold Flat/Maisonette
E1 8RJ - 581,000
- Leasehold Purpose built flat
E1 8RJ - 490,000
- Leasehold Purpose built flat
E1 8RJ - 561,000
- Leasehold Flat/Maisonette
E1 8RJ - 447,000
- Leasehold Flat/Maisonette
E1 8RJ - 499,000
- Leasehold Flat/Maisonette
E1 8RJ - 608,000
- Leasehold Flat/Maisonette
E1 8RJ - 562,000
- Leasehold Converted flat
E1 8RJ - 616,000
- Leasehold Converted flat
E1 8RJ - 591,000
- Leasehold Converted flat
E1 8RJ - 570,000
- Leasehold Purpose built flat
E1 8RJ - 573,000
- Leasehold Flat/Maisonette
E1 8RJ - 640,000
- Leasehold Flat/Maisonette
E1 8RJ - 747,000
- Leasehold Converted flat
E1 8RJ - 533,000
- Leasehold Flat/Maisonette
E1 8RJ - 533,000
- Leasehold Flat/Maisonette
E1 8RJ - 722,000
- Leasehold Flat/Maisonette
E1 8RJ - 517,000
- Leasehold Flat/Maisonette
E1 8RJ - 722,000
- Leasehold Flat/Maisonette
E1 8RJ - 559,000
- Leasehold Purpose built flat
E1 8RJ - 514,000
- Leasehold Purpose built flat
E1 8RJ - 1,027,000
- Leasehold Flat/Maisonette
E1 8RJ - 629,000
- Leasehold Flat/Maisonette
E1 8RJ - 502,000
- Leasehold Purpose built flat
E1 8RJ - 529,000
- Leasehold Flat/Maisonette
E1 8RJ - 739,000
- Leasehold Flat/Maisonette
E1 8RJ - 820,000
- Leasehold Flat/Maisonette
E1 8RJ - 507,000
- Leasehold Flat/Maisonette
E1 8RJ - 546,000
- Leasehold Converted flat
E1 8RJ - 466,000
- Leasehold Flat/Maisonette
E1 8RJ - 535,000
- Leasehold Converted flat
E1 8RJ - 637,000
- Leasehold Converted flat
E1 8RJ - 880,000
- Leasehold Converted flat
E1 8RJ - 994,000
- Leasehold Flat/Maisonette
E1 8RJ - 818,000
- Leasehold Flat/Maisonette
E1 8RJ - 678,000
- Leasehold Flat/Maisonette
E1 8RJ - 503,000
- Feudal Converted flat
E1 8RJ - 695,000
- Leasehold Flat/Maisonette
E1 8RJ - 583,000
- Leasehold Flat/Maisonette
E1 8RJ - 609,000
- Leasehold Flat/Maisonette
E1 8RJ - 657,000
- Leasehold Converted flat
E1 8RJ - 602,000
- Leasehold Converted flat
E1 8RJ - 647,000
- Leasehold Flat/Maisonette
E1 8RJ - 582,000
- Leasehold Flat/Maisonette
E1 8RJ - 565,000
- Leasehold Flat/Maisonette
E1 8RJ - 581,000
- Leasehold Converted flat
E1 8RJ - 604,000
- Leasehold Flat/Maisonette
E1 8RJ - 792,000
- Leasehold Flat/Maisonette
E1 8RJ - 643,000
- Leasehold Flat/Maisonette
E1 8RJ - 572,000
- Leasehold Converted flat
E1 8RJ - 547,000
- Leasehold Flat/Maisonette
E1 8RJ - 784,000
- Leasehold Flat/Maisonette
E1 8RJ - 514,000
- Leasehold Flat/Maisonette
E1 8RJ - 572,000
- Leasehold Converted flat
E1 8RJ - 536,000
- Leasehold Flat/Maisonette
E1 8RJ - 581,000
- Leasehold Converted flat
E1 8RJ - 570,000
- Leasehold Converted flat
E1 8RJ - 582,000
- Leasehold Converted flat