SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E15 3QS' order by fulladdress
E15 3QS - 354,000
- Freehold Flat/Maisonette
E15 3QS - 335,000
- Leasehold Converted flat
E15 3QS - 375,000
- Leasehold Purpose built flat
E15 3QS - 312,000
- Leasehold Purpose built flat
E15 3QS - 613,000
- Freehold Mid terrace house
E15 3QS - 400,000
- Share of freehold Terrace property
E15 3QS - 382,000
- Leasehold Purpose built flat
E15 3QS - 346,000
- Leasehold Purpose built flat
E15 3QS - 568,000
- Freehold Terrace property
E15 3QS - 396,000
- Leasehold Flat/Maisonette
E15 3QS - 803,000
- Freehold Mid terrace house
E15 3QS - 760,000
- Freehold Mid terrace house
E15 3QS - 681,000
- Freehold Mid terrace house
E15 3QS - 602,000
- Freehold Terrace property
E15 3QS - 424,000
- Freehold Detached bungalow
E15 3QS - 463,000
- Leasehold Converted flat
E15 3QS - 467,000
- Leasehold Converted flat
E15 3QS - 673,000
- Freehold Terrace property
E15 3QS - 679,000
- Freehold Terrace property
E15 3QS - 652,000
- Freehold Mid terrace house
E15 3QS - 615,000
- Freehold Mid terrace house
E15 3QS - 629,000
- Freehold Terrace property
E15 3QS - 634,000
- Freehold Semi-detached house
E15 3QS - 584,000
- Freehold End terrace house
E15 3QS - 690,000
- Freehold Mid terrace house
E15 3QS - 572,000
- Freehold Mid terrace house
E15 3QS - 625,000
- Freehold Terrace property
E15 3QS - 707,000
- Freehold End terrace house
E15 3QS - 309,000
- Leasehold Flat/Maisonette
E15 3QS - 374,000
- Leasehold Converted flat
E15 3QS - 548,000
- Freehold Semi-detached house
E15 3QS - 844,000
- Freehold End terrace house
E15 3QS - 698,000
- Freehold End terrace house
E15 3QS - 560,000
- Semi-detached house
E15 3QS - 692,000
- Freehold End terrace house
E15 3QS - 702,000
- Freehold End terrace house
E15 3QS - 695,000
- Freehold Mid terrace house
E15 3QS - 394,000
- Leasehold Purpose built flat
E15 3QS - 357,000
- Leasehold Converted flat
E15 3QS - 619,000
- Freehold Mid terrace house
E15 3QS - 683,000
- Freehold Semi-detached house
E15 3QS - 617,000
- Freehold Semi-detached house
E15 3QS - 639,000
- Freehold End terrace house
E15 3QS - 628,000
- Freehold Mid terrace house
E15 3QS - 329,000
- Leasehold Flat/Maisonette
E15 3QS - 389,000
- Freehold Flat/Maisonette
E15 3QS - 624,000
- Freehold Mid terrace house
E15 3QS - 563,000
- Freehold Mid terrace house
