SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E1W 2JG' order by fulladdress
E1W 2JG - 548,000
- Leasehold Purpose built flat
E1W 2JG - 523,000
- Leasehold Purpose built flat
E1W 2JG - 729,000
- Leasehold Purpose built flat
E1W 2JG - 448,000
- Leasehold Flat/Maisonette
E1W 2JG - 404,000
- Leasehold Flat/Maisonette
E1W 2JG - 458,000
- Leasehold Flat/Maisonette
E1W 2JG - 413,000
- Leasehold Flat/Maisonette
E1W 2JG - 415,000
- Leasehold Purpose built flat
E1W 2JG - 396,000
- Leasehold Purpose built flat
E1W 2JG - 583,000
- Leasehold Flat/Maisonette
E1W 2JG - 524,000
- Leasehold Flat/Maisonette
E1W 2JG - 543,000
- Leasehold Purpose built flat
E1W 2JG - 380,000
- Leasehold Flat/Maisonette
E1W 2JG - 522,000
- Leasehold Flat/Maisonette
E1W 2JG - 373,000
- Leasehold Flat/Maisonette
E1W 2JG - 531,000
- Leasehold Purpose built flat
E1W 2JG - 684,000
- Leasehold Purpose built flat
E1W 2JG - 706,000
- Leasehold Flat/Maisonette
E1W 2JG - 532,000
- Leasehold Purpose built flat
E1W 2JG - 508,000
- Leasehold Flat/Maisonette
E1W 2JG - 398,000
- Leasehold Flat/Maisonette
E1W 2JG - 516,000
- Leasehold Purpose built flat
E1W 2JG - 500,000
- Leasehold Flat/Maisonette
E1W 2JG - 456,000
- Leasehold Purpose built flat
E1W 2JG - 693,000
- Leasehold Purpose built flat
E1W 2JG - 319,000
- Leasehold Purpose built flat
E1W 2JG - 321,000
- Feudal Purpose built flat
E1W 2JG - 340,000
- Leasehold Purpose built flat
E1W 2JG - 315,000
- Leasehold Purpose built flat
E1W 2JG - 312,000
- Leasehold Flat/Maisonette
E1W 2JG - 282,000
- Leasehold Purpose built flat
E1W 2JG - 312,000
- Leasehold Purpose built flat
E1W 2JG - 269,000
- Leasehold Flat/Maisonette
E1W 2JG - 323,000
- Leasehold Purpose built flat
E1W 2JG - 298,000
- Leasehold Purpose built flat
E1W 2JG - 451,000
- Leasehold Purpose built flat
E1W 2JG - 407,000
- Leasehold Flat/Maisonette
E1W 2JG - 317,000
- Leasehold Purpose built flat
E1W 2JG - 277,000
- Leasehold Purpose built flat
E1W 2JG - 278,000
- Leasehold Purpose built flat
E1W 2JG - 277,000
- Leasehold Purpose built flat
E1W 2JG - 286,000
- Leasehold Flat/Maisonette
E1W 2JG - 273,000
- Leasehold Purpose built flat
E1W 2JG - 281,000
- Leasehold Purpose built flat
E1W 2JG - 694,000
- Leasehold Flat/Maisonette
E1W 2JG - 287,000
- Leasehold Flat/Maisonette
E1W 2JG - 293,000
- Leasehold Converted flat
E1W 2JG - 290,000
- Leasehold Flat/Maisonette
E1W 2JG - 398,000
- Leasehold Purpose built flat
E1W 2JG - 433,000
- Leasehold Purpose built flat
E1W 2JG - 462,000
- Leasehold Purpose built flat
E1W 2JG - 405,000
- Leasehold Purpose built flat
E1W 2JG - 487,000
- Leasehold Flat/Maisonette
E1W 2JG - 386,000
- Leasehold Purpose built flat
E1W 2JG - 516,000
- Leasehold Purpose built flat
E1W 2JG - 517,000
- Leasehold Flat/Maisonette
E1W 2JG - 655,000
- Leasehold Flat/Maisonette
E1W 2JG - 657,000
- Feudal Purpose built flat
E1W 2JG - 1,005,000
- Freehold Mid terrace house
E1W 2JG - 600,000
- Freehold Mid terrace house
E1W 2JG - 1,129,000
- Leasehold Terrace property
E1W 2JG - 1,051,000
- Leasehold Terrace property
E1W 2JG - 1,007,000
- Freehold End terrace house
E1W 2JG - 1,223,000
- Leasehold Detached house
E1W 2JG - 525,000
- Leasehold Flat/Maisonette
E1W 2JG - 566,000
- Leasehold Purpose built flat