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 6EJ' order by fulladdress
SE1 6EJ - 880,000
- Leasehold Flat/Maisonette
SE1 6EJ - 510,000
- Feudal Purpose built flat
SE1 6EJ - 436,000
- Leasehold Flat/Maisonette
SE1 6EJ - 477,000
- Leasehold Flat/Maisonette
SE1 6EJ - 704,000
- Leasehold Purpose built flat
SE1 6EJ - 488,000
- Leasehold Flat/Maisonette
SE1 6EJ - 682,000
- Leasehold Purpose built flat
SE1 6EJ - 504,000
- Leasehold Purpose built flat
SE1 6EJ - 425,000
- Leasehold Purpose built flat
SE1 6EJ - 676,000
- Leasehold Purpose built flat
SE1 6EJ - 795,000
- Feudal Flat/Maisonette
SE1 6EJ - 570,000
- Leasehold Flat/Maisonette
SE1 6EJ - 431,000
- Leasehold Purpose built flat
SE1 6EJ - 478,000
- Leasehold Purpose built flat
SE1 6EJ - 556,000
- Leasehold Flat/Maisonette
SE1 6EJ - 503,000
- Leasehold Flat/Maisonette
SE1 6EJ - 481,000
- Leasehold Purpose built flat
SE1 6EJ - 711,000
- Leasehold Purpose built flat
SE1 6EJ - 537,000
- Leasehold Flat/Maisonette
SE1 6EJ - 436,000
- Leasehold Flat/Maisonette
SE1 6EJ - 483,000
- Feudal Purpose built flat
SE1 6EJ - 756,000
- Leasehold Flat/Maisonette
SE1 6EJ - 565,000
- Leasehold Flat/Maisonette
SE1 6EJ - 494,000
- Leasehold Purpose built flat
SE1 6EJ - 501,000
- Leasehold Flat/Maisonette
SE1 6EJ - 682,000
- Leasehold Flat/Maisonette
SE1 6EJ - 482,000
- Leasehold Flat/Maisonette
SE1 6EJ - 482,000
- Leasehold Purpose built flat
SE1 6EJ - 693,000
- Leasehold Flat/Maisonette
SE1 6EJ - 483,000
- Leasehold Flat/Maisonette
SE1 6EJ - 422,000
- Leasehold Purpose built flat
SE1 6EJ - 495,000
- Leasehold Purpose built flat
SE1 6EJ - 938,000
- Leasehold Flat/Maisonette
SE1 6EJ - 549,000
- Leasehold Purpose built flat
SE1 6EJ - 437,000
- Leasehold Flat/Maisonette
SE1 6EJ - 534,000
- Leasehold Flat/Maisonette
SE1 6EJ - 495,000
- Leasehold Flat/Maisonette
SE1 6EJ - 484,000
- Leasehold Flat/Maisonette
SE1 6EJ - 653,000
- Leasehold Flat/Maisonette
SE1 6EJ - 500,000
- Leasehold Purpose built flat
SE1 6EJ - 421,000
- Leasehold Flat/Maisonette
SE1 6EJ - 505,000
- Feudal Purpose built flat
SE1 6EJ - 819,000
- Leasehold Flat/Maisonette
SE1 6EJ - 502,000
- Leasehold Flat/Maisonette
SE1 6EJ - 427,000
- Leasehold Purpose built flat
SE1 6EJ - 500,000
- Leasehold Purpose built flat
SE1 6EJ - 683,000
- Leasehold Purpose built flat
SE1 6EJ - 506,000
- Leasehold Flat/Maisonette
SE1 6EJ - 481,000
- Leasehold Purpose built flat
SE1 6EJ - 668,000
- Leasehold Flat/Maisonette
SE1 6EJ - 533,000
- Leasehold Flat/Maisonette
SE1 6EJ - 460,000
- Leasehold Flat/Maisonette
SE1 6EJ - 520,000
- Leasehold Purpose built flat
SE1 6EJ - 1,057,000
- Leasehold Flat/Maisonette
SE1 6EJ - 624,000
- Leasehold Flat/Maisonette
SE1 6EJ - 506,000
- Leasehold Purpose built flat
SE1 6EJ - 714,000
- Leasehold Flat/Maisonette
SE1 6EJ - 494,000
- Leasehold Flat/Maisonette
SE1 6EJ - 464,000
- Feudal Flat/Maisonette
SE1 6EJ - 674,000
- Leasehold Purpose built flat
SE1 6EJ - 520,000
- Leasehold Flat/Maisonette
SE1 6EJ - 537,000
- Leasehold Flat/Maisonette
SE1 6EJ - 1,053,000
- Leasehold Flat/Maisonette
SE1 6EJ - 558,000
- Leasehold Flat/Maisonette
SE1 6EJ - 518,000
- Leasehold Purpose built flat
SE1 6EJ - 694,000
- Leasehold Flat/Maisonette
SE1 6EJ - 462,000
- Leasehold Flat/Maisonette
SE1 6EJ - 521,000
- Leasehold Flat/Maisonette
SE1 6EJ - 684,000
- Leasehold Flat/Maisonette
SE1 6EJ - 493,000
- Leasehold Flat/Maisonette
SE1 6EJ - 539,000
- Leasehold Flat/Maisonette
SE1 6EJ - 1,048,000
- Leasehold Purpose built flat
SE1 6EJ - 551,000
- Leasehold Purpose built flat
SE1 6EJ - 491,000
- Leasehold Flat/Maisonette
SE1 6EJ - 644,000
- Leasehold Flat/Maisonette
SE1 6EJ - 483,000
- Leasehold Flat/Maisonette
SE1 6EJ - 484,000
- Leasehold Flat/Maisonette
SE1 6EJ - 680,000
- Leasehold Flat/Maisonette
SE1 6EJ - 508,000
- Leasehold Flat/Maisonette
SE1 6EJ - 656,000
- Leasehold Flat/Maisonette
