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 4PD' order by fulladdress
SE1 4PD - 481,000
- Leasehold Flat/Maisonette
SE1 4PD - 518,000
- Leasehold Purpose built flat
SE1 4PD - 677,000
- Leasehold Flat/Maisonette
SE1 4PD - 637,000
- Leasehold Flat/Maisonette
SE1 4PD - 490,000
- Leasehold Purpose built flat
SE1 4PD - 545,000
- Leasehold Purpose built flat
SE1 4PD - 472,000
- Leasehold Flat/Maisonette
SE1 4PD - 523,000
- Leasehold Purpose built flat
SE1 4PD - 479,000
- Leasehold Flat/Maisonette
SE1 4PD - 499,000
- Leasehold Flat/Maisonette
SE1 4PD - 624,000
- Leasehold Purpose built flat
SE1 4PD - 488,000
- Leasehold Flat/Maisonette
SE1 4PD - 489,000
- Leasehold Flat/Maisonette
SE1 4PD - 486,000
- Leasehold Purpose built flat
SE1 4PD - 472,000
- Leasehold Purpose built flat
SE1 4PD - 476,000
- Leasehold Flat/Maisonette
SE1 4PD - 482,000
- Leasehold Flat/Maisonette
SE1 4PD - 493,000
- Leasehold Flat/Maisonette
SE1 4PD - 467,000
- Leasehold Flat/Maisonette
SE1 4PD - 469,000
- Leasehold Purpose built flat
SE1 4PD - 684,000
- Leasehold Flat/Maisonette
SE1 4PD - 692,000
- Leasehold Flat/Maisonette
SE1 4PD - 478,000
- Leasehold Purpose built flat
SE1 4PD - 495,000
- Leasehold Purpose built flat
SE1 4PD - 490,000
- Leasehold Flat/Maisonette
SE1 4PD - 489,000
- Leasehold Flat/Maisonette
SE1 4PD - 546,000
- Leasehold Purpose built flat
SE1 4PD - 488,000
- Leasehold Flat/Maisonette
SE1 4PD - 487,000
- Leasehold Flat/Maisonette
SE1 4PD - 507,000
- Leasehold Flat/Maisonette
SE1 4PD - 471,000
- Leasehold Purpose built flat
SE1 4PD - 469,000
- Leasehold Purpose built flat
SE1 4PD - 473,000
- Leasehold Flat/Maisonette
SE1 4PD - 710,000
- Leasehold Flat/Maisonette
SE1 4PD - 678,000
- Leasehold Flat/Maisonette
SE1 4PD - 517,000
- Leasehold Purpose built flat
SE1 4PD - 484,000
- Leasehold Purpose built flat
SE1 4PD - 470,000
- Leasehold Flat/Maisonette
SE1 4PD - 480,000
- Leasehold Flat/Maisonette
SE1 4PD - 488,000
- Leasehold Flat/Maisonette
SE1 4PD - 538,000
- Leasehold Flat/Maisonette
SE1 4PD - 467,000
- Leasehold Flat/Maisonette
SE1 4PD - 472,000
- Leasehold Flat/Maisonette
SE1 4PD - 477,000
- Leasehold Flat/Maisonette
SE1 4PD - 486,000
- Feudal Purpose built flat
SE1 4PD - 744,000
- Leasehold Flat/Maisonette
SE1 4PD - 478,000
- Leasehold Purpose built flat
SE1 4PD - 462,000
- Leasehold Purpose built flat
SE1 4PD - 490,000
- Leasehold Flat/Maisonette
SE1 4PD - 484,000
- Leasehold Flat/Maisonette
SE1 4PD - 495,000
- Leasehold Purpose built flat
SE1 4PD - 476,000
- Leasehold Flat/Maisonette
SE1 4PD - 481,000
- Leasehold Flat/Maisonette
SE1 4PD - 468,000
- Leasehold Purpose built flat
SE1 4PD - 483,000
- Leasehold Flat/Maisonette
SE1 4PD - 466,000
- Leasehold Flat/Maisonette
SE1 4PD - 673,000
- Leasehold Flat/Maisonette
SE1 4PD - 706,000
- Leasehold Flat/Maisonette
SE1 4PD - 468,000
- Leasehold Purpose built flat
SE1 4PD - 493,000
- Leasehold Flat/Maisonette
SE1 4PD - 478,000
- Leasehold Purpose built flat
SE1 4PD - 789,000
- Leasehold Purpose built flat
SE1 4PD - 740,000
- Leasehold Purpose built flat
SE1 4PD - 749,000
- Leasehold Purpose built flat
SE1 4PD - 712,000
- Leasehold Flat/Maisonette
SE1 4PD - 909,000
- Leasehold Flat/Maisonette
SE1 4PD - 470,000
- Leasehold Flat/Maisonette
SE1 4PD - 688,000
- Leasehold Flat/Maisonette
SE1 4PD - 688,000
- Leasehold Flat/Maisonette