SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE1 3HS' order by fulladdress
SE1 3HS - 894,000
- Leasehold Terrace property
SE1 3HS - 549,000
- Leasehold Purpose built flat
SE1 3HS - 562,000
- Leasehold Flat/Maisonette
SE1 3HS - 666,000
- Leasehold Purpose built flat
SE1 3HS - 682,000
- Leasehold Purpose built flat
SE1 3HS - 605,000
- Leasehold Flat/Maisonette
SE1 3HS - 692,000
- Leasehold Purpose built flat
SE1 3HS - 697,000
- Leasehold Purpose built flat
SE1 3HS - 674,000
- Leasehold Flat/Maisonette
SE1 3HS - 688,000
- Leasehold Purpose built flat
SE1 3HS - 676,000
- Leasehold Purpose built flat
SE1 3HS - 556,000
- Leasehold Flat/Maisonette
SE1 3HS - 650,000
- Leasehold Flat/Maisonette
SE1 3HS - 693,000
- Leasehold Purpose built flat
SE1 3HS - 697,000
- Leasehold Purpose built flat
SE1 3HS - 815,000
- Leasehold Semi-detached house
SE1 3HS - 706,000
- Leasehold Flat/Maisonette
SE1 3HS - 678,000
- Leasehold Purpose built flat
SE1 3HS - 684,000
- Leasehold Flat/Maisonette
SE1 3HS - 696,000
- Leasehold Flat/Maisonette
SE1 3HS - 681,000
- Leasehold Flat/Maisonette
SE1 3HS - 556,000
- Leasehold Purpose built flat
SE1 3HS - 700,000
- Leasehold Purpose built flat
SE1 3HS - 695,000
- Leasehold Flat/Maisonette
SE1 3HS - 692,000
- Leasehold Flat/Maisonette
SE1 3HS - 696,000
- Leasehold Purpose built flat
SE1 3HS - 687,000
- Leasehold Flat/Maisonette
SE1 3HS - 667,000
- Leasehold Flat/Maisonette
SE1 3HS - 713,000
- Leasehold Purpose built flat
SE1 3HS - 641,000
- Leasehold Purpose built flat
SE1 3HS - 789,000
- Leasehold Semi-detached house
SE1 3HS - 685,000
- Leasehold Purpose built flat
SE1 3HS - 552,000
- Leasehold Purpose built flat
SE1 3HS - 690,000
- Leasehold Purpose built flat
SE1 3HS - 684,000
- Leasehold Purpose built flat
SE1 3HS - 695,000
- Leasehold Purpose built flat
SE1 3HS - 703,000
- Leasehold Flat/Maisonette
SE1 3HS - 681,000
- Leasehold Flat/Maisonette
SE1 3HS - 923,000
- Leasehold Flat/Maisonette
SE1 3HS - 695,000
- Leasehold Flat/Maisonette
SE1 3HS - 851,000
- Leasehold Flat/Maisonette
SE1 3HS - 660,000
- Leasehold Flat/Maisonette
SE1 3HS - 829,000
- Leasehold Purpose built flat
SE1 3HS - 557,000
- Leasehold Flat/Maisonette
SE1 3HS - 694,000
- Leasehold Purpose built flat
SE1 3HS - 859,000
- Leasehold Purpose built flat
SE1 3HS - 667,000
- Leasehold Purpose built flat
SE1 3HS - 717,000
- Leasehold Flat/Maisonette
SE1 3HS - 657,000
- Feudal Purpose built flat
SE1 3HS - 732,000
- Leasehold Flat/Maisonette
SE1 3HS - 639,000
- Leasehold Flat/Maisonette
SE1 3HS - 724,000
- Leasehold Purpose built flat
SE1 3HS - 655,000
- Leasehold Purpose built flat
SE1 3HS - 840,000
- Leasehold Flat/Maisonette
SE1 3HS - 521,000
- Leasehold Purpose built flat
SE1 3HS - 620,000
- Leasehold Flat/Maisonette
SE1 3HS - 668,000
- Leasehold Flat/Maisonette
SE1 3HS - 646,000
- Leasehold Purpose built flat
SE1 3HS - 664,000
- Leasehold Flat/Maisonette
SE1 3HS - 673,000
- Leasehold Purpose built flat
SE1 3HS - 644,000
- Leasehold Purpose built flat
SE1 3HS - 669,000
- Leasehold Flat/Maisonette
SE1 3HS - 765,000
- Leasehold End terrace house
SE1 3HS - 668,000
- Leasehold Purpose built flat
SE1 3HS - 560,000
- Leasehold Flat/Maisonette
SE1 3HS - 663,000
- Leasehold Flat/Maisonette
SE1 3HS - 660,000
- Leasehold Converted flat
SE1 3HS - 664,000
- Leasehold Purpose built flat
SE1 3HS - 670,000
- Leasehold Purpose built flat
SE1 3HS - 694,000
- Leasehold Flat/Maisonette
SE1 3HS - 657,000
- Leasehold Purpose built flat
SE1 3HS - 647,000
- Leasehold Flat/Maisonette
SE1 3HS - 558,000
- Leasehold Purpose built flat
SE1 3HS - 661,000
- Leasehold Flat/Maisonette
SE1 3HS - 553,000
- Leasehold Flat/Maisonette
SE1 3HS - 672,000
- Leasehold Flat/Maisonette
SE1 3HS - 671,000
- Leasehold Flat/Maisonette
SE1 3HS - 663,000
- Leasehold Flat/Maisonette
SE1 3HS - 643,000
- Leasehold Flat/Maisonette
SE1 3HS - 666,000
- Leasehold Purpose built flat
SE1 3HS - 662,000
- Leasehold Purpose built flat
SE1 3HS - 668,000
- Leasehold Purpose built flat
SE1 3HS - 672,000
- Leasehold Purpose built flat
SE1 3HS - 662,000
- Leasehold Purpose built flat
SE1 3HS - 917,000
- Leasehold Flat/Maisonette
SE1 3HS - 849,000
- Leasehold Detached house
SE1 3HS - 665,000
- Leasehold Purpose built flat