SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E7 8HE' order by fulladdress
E7 8HE - 538,000
- Mid terrace house
E7 8HE - 590,000
- Freehold Mid terrace house
E7 8HE - 548,000
- Mid terrace house
E7 8HE - 570,000
- Freehold Mid terrace house
E7 8HE - 542,000
- Freehold Terraced
E7 8HE - 554,000
- Freehold Mid terrace house
E7 8HE - 565,000
- Freehold Mid terrace house
E7 8HE - 559,000
- Freehold End terrace house
E7 8HE - 559,000
- Freehold Semi-detached house
E7 8HE - 593,000
- Freehold Mid terrace house
E7 8HE - 593,000
- Freehold Semi-detached house
E7 8HE - 567,000
- Freehold Mid terrace house
E7 8HE - 577,000
- Mid terrace house
E7 8HE - 617,000
- Freehold Mid terrace house
E7 8HE - 572,000
- Freehold Terraced
E7 8HE - 582,000
- Freehold Mid terrace house
E7 8HE - 597,000
- Freehold Mid terrace house
E7 8HE - 527,000
- Freehold Mid terrace house
E7 8HE - 519,000
- Freehold Mid terrace house
E7 8HE - 575,000
- Freehold Mid terrace house
E7 8HE - 555,000
- Freehold Mid terrace house
E7 8HE - 582,000
- Mid terrace house
E7 8HE - 531,000
- Freehold Terrace property
E7 8HE - 538,000
- Freehold Mid terrace house
E7 8HE - 551,000
- Mid terrace house
E7 8HE - 551,000
- Freehold Terraced
E7 8HE - 521,000
- Freehold Mid terrace house
E7 8HE - 557,000
- Freehold Terrace property
E7 8HE - 570,000
- Freehold Mid terrace house
E7 8HE - 561,000
- End terrace house
E7 8HE - 258,000
- Leasehold Converted flat
E7 8HE - 276,000
- Leasehold Converted flat
E7 8HE - 267,000
- Freehold Flat/Maisonette
E7 8HE - 268,000
- Leasehold Flat/Maisonette
E7 8HE - 284,000
- Leasehold Flat/Maisonette
E7 8HE - 288,000
- Leasehold Converted flat
E7 8HE - 277,000
- Feudal Converted flat
E7 8HE - 272,000
- Leasehold Flat/Maisonette
E7 8HE - 289,000
- Leasehold Converted flat
E7 8HE - 279,000
- Leasehold Converted flat
E7 8HE - 247,000
- Leasehold Flat/Maisonette
E7 8HE - 277,000
- Leasehold Purpose built flat
E7 8HE - 354,000
- Leasehold Converted flat
E7 8HE - 291,000
- Leasehold Flat/Maisonette
E7 8HE - 286,000
- Leasehold Converted flat
E7 8HE - 279,000
- Leasehold Purpose built flat
E7 8HE - 539,000
- Freehold Mid terrace house
E7 8HE - 283,000
- Leasehold Converted flat
E7 8HE - 281,000
- Leasehold Converted flat
E7 8HE - 279,000
- Leasehold Converted flat
E7 8HE - 270,000
- Leasehold Purpose built flat
E7 8HE - 276,000
- Leasehold Purpose built flat
E7 8HE - 255,000
- Leasehold Flat/Maisonette
E7 8HE - 271,000
- Leasehold Purpose built flat
E7 8HE - 267,000
- Leasehold Converted flat
E7 8HE - 276,000
- Leasehold Flat/Maisonette
E7 8HE - 287,000
- Leasehold Flat/Maisonette
E7 8HE - 268,000
- Leasehold Purpose built flat
E7 8HE - 275,000
- Freehold Flat/Maisonette
E7 8HE - 524,000
- Mid terrace house
E7 8HE - 533,000
- Freehold Mid terrace house
E7 8HE - 522,000
- Mid terrace house
E7 8HE - 585,000
- Freehold Mid terrace house
E7 8HE - 553,000
- Freehold Terraced
E7 8HE - 566,000
- Leasehold End terrace house
E7 8HE - 532,000
- Freehold Mid terrace house
