SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E6 5XR' order by fulladdress
E6 5XR - 287,000
- Leasehold Purpose built flat
E6 5XR - 254,000
- Leasehold Purpose built flat
E6 5XR - 291,000
- Leasehold Purpose built flat
E6 5XR - 255,000
- Leasehold Purpose built flat
E6 5XR - 257,000
- Leasehold Purpose built flat
E6 5XR - 255,000
- Leasehold Flat/Maisonette
E6 5XR - 371,000
- Leasehold Terrace property
E6 5XR - 237,000
- Leasehold Purpose built flat
E6 5XR - 500,000
- Leasehold Terraced
E6 5XR - 249,000
- Leasehold Purpose built flat
E6 5XR - 267,000
- Leasehold Flat/Maisonette
E6 5XR - 257,000
- Leasehold Purpose built flat
E6 5XR - 413,000
- Mid terrace house
E6 5XR - 419,000
- End terrace house
E6 5XR - 506,000
- End terrace house
E6 5XR - 404,000
- End terrace house
E6 5XR - 406,000
- Mid terrace house
E6 5XR - 397,000
- Mid terrace house
E6 5XR - 392,000
- End terrace house
E6 5XR - 313,000
- End terrace house
E6 5XR - 317,000
- Mid terrace house
E6 5XR - 402,000
- Mid terrace house
E6 5XR - 400,000
- Mid terrace house
E6 5XR - 581,000
- Semi-detached house
E6 5XR - 581,000
- Semi-detached house
E6 5XR - 391,000
- Mid terrace house
E6 5XR - 404,000
- Mid terrace house
E6 5XR - 315,000
- Mid terrace house
E6 5XR - 394,000
- End terrace house
E6 5XR - 373,000
- End terrace house
E6 5XR - 387,000
- Mid terrace house
E6 5XR - 380,000
- Freehold Mid terrace house
E6 5XR - 389,000
- Mid terrace house
E6 5XR - 510,000
- End terrace house
E6 5XR - 392,000
- Mid terrace house
E6 5XR - 392,000
- Mid terrace house
E6 5XR - 314,000
- End terrace house
E6 5XR - 527,000
- Semi-detached house
E6 5XR - 452,000
- Semi-detached house
E6 5XR - 397,000
- Mid terrace house
E6 5XR - 314,000
- End terrace house
E6 5XR - 407,000
- End terrace house
E6 5XR - 389,000
- Mid terrace house
E6 5XR - 398,000
- Mid terrace house
E6 5XR - 305,000
- Mid terrace house
E6 5XR - 391,000
- Mid terrace house
E6 5XR - 521,000
- Mid terrace house
E6 5XR - 534,000
- Mid terrace house
E6 5XR - 398,000
- Mid terrace house
E6 5XR - 378,000
- Freehold End terrace house
E6 5XR - 376,000
- End terrace house
E6 5XR - 380,000
- Mid terrace house
E6 5XR - 568,000
- Semi-detached house
E6 5XR - 530,000
- End terrace house
E6 5XR - 379,000
- Mid terrace house
E6 5XR - 293,000
- End terrace house
E6 5XR - 551,000
- Freehold Semi-detached house
E6 5XR - 592,000
- Freehold Semi-detached house
E6 5XR - 275,000
- Leasehold Purpose built flat
E6 5XR - 251,000
- Leasehold Purpose built flat
