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 4BB' order by fulladdress
E1 4BB - 441,000
- Freehold End terrace house
E1 4BB - 516,000
- Freehold End terrace house
E1 4BB - 518,000
- Freehold Mid terrace house
E1 4BB - 513,000
- Freehold Mid terrace house
E1 4BB - 617,000
- Freehold Semi-detached house
E1 4BB - 290,000
- Leasehold Purpose built flat
E1 4BB - 293,000
- Leasehold Flat/Maisonette
E1 4BB - 312,000
- Leasehold Flat/Maisonette
E1 4BB - 472,000
- Freehold Flat/Maisonette
E1 4BB - 286,000
- Leasehold Purpose built flat
E1 4BB - 238,000
- Leasehold Purpose built flat
E1 4BB - 294,000
- Leasehold Purpose built flat
E1 4BB - 239,000
- Leasehold Flat/Maisonette
E1 4BB - 347,000
- Leasehold Purpose built flat
E1 4BB - 335,000
- Leasehold Purpose built flat
E1 4BB - 339,000
- Leasehold Flat/Maisonette
E1 4BB - 331,000
- Leasehold Purpose built flat
E1 4BB - 269,000
- Leasehold Purpose built flat
E1 4BB - 598,000
- Freehold Mid terrace house
E1 4BB - 233,000
- Leasehold Flat/Maisonette
E1 4BB - 283,000
- Leasehold Flat/Maisonette
E1 4BB - 240,000
- Leasehold Flat/Maisonette
E1 4BB - 345,000
- Leasehold Purpose built flat
E1 4BB - 343,000
- Leasehold Flat/Maisonette
E1 4BB - 348,000
- Leasehold Purpose built flat
E1 4BB - 620,000
- Freehold Terraced
E1 4BB - 242,000
- Leasehold Purpose built flat
E1 4BB - 283,000
- Leasehold Purpose built flat
E1 4BB - 439,000
- Leasehold Terrace property
E1 4BB - 242,000
- Leasehold Flat/Maisonette
E1 4BB - 239,000
- Leasehold Flat/Maisonette
E1 4BB - 303,000
- Leasehold Flat/Maisonette
E1 4BB - 263,000
- Leasehold Flat/Maisonette
E1 4BB - 330,000
- Leasehold Flat/Maisonette
E1 4BB - 341,000
- Leasehold Flat/Maisonette
E1 4BB - 677,000
- Freehold Mid terrace house
E1 4BB - 341,000
- Leasehold Flat/Maisonette
E1 4BB - 666,000
- Freehold Terrace property
E1 4BB - 510,000
- Freehold Terrace property
E1 4BB - 764,000
- Freehold End terrace house
E1 4BB - 432,000
- Leasehold Flat/Maisonette
E1 4BB - 479,000
- Leasehold Flat/Maisonette
E1 4BB - 488,000
- Leasehold Purpose built flat
E1 4BB - 544,000
- Share of freehold End terrace property
E1 4BB - 518,000
- Freehold Semi-detached house
E1 4BB - 492,000
- Freehold Mid terrace house
E1 4BB - 680,000
- Freehold Semi-detached house
E1 4BB - 401,000
- Leasehold Flat/Maisonette
E1 4BB - 379,000
- Leasehold Flat/Maisonette
E1 4BB - 367,000
- Leasehold Purpose built flat
E1 4BB - 366,000
- Leasehold Flat/Maisonette
E1 4BB - 378,000
- Leasehold Flat/Maisonette
E1 4BB - 721,000
- Freehold End terrace house
E1 4BB - 728,000
- Freehold Mid terrace house
E1 4BB - 485,000
- Freehold Semi-detached house
E1 4BB - 482,000
- Freehold Terraced
E1 4BB - 506,000
- Freehold End terrace house
E1 4BB - 468,000
- Freehold Mid terrace house
E1 4BB - 516,000
- Freehold End terrace property