SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE8 4HN' order by fulladdress
SE8 4HN - 347,000
- Leasehold Purpose built flat
SE8 4HN - 385,000
- Leasehold Purpose built flat
SE8 4HN - 542,000
- Leasehold Flat/Maisonette
SE8 4HN - 362,000
- Leasehold Flat/Maisonette
SE8 4HN - 396,000
- Leasehold Converted flat
SE8 4HN - 311,000
- Leasehold Flat/Maisonette
SE8 4HN - 432,000
- Leasehold Purpose built flat
SE8 4HN - 464,000
- Leasehold Converted flat
SE8 4HN - 366,000
- Leasehold Flat/Maisonette
SE8 4HN - 386,000
- Leasehold Purpose built flat
SE8 4HN - 450,000
- Leasehold Purpose built flat
SE8 4HN - 374,000
- Leasehold Purpose built flat
SE8 4HN - 426,000
- Leasehold Flat/Maisonette
SE8 4HN - 369,000
- Leasehold Purpose built flat
SE8 4HN - 501,000
- Leasehold Purpose built flat
SE8 4HN - 522,000
- Leasehold Converted flat
SE8 4HN - 340,000
- Leasehold Flat/Maisonette
SE8 4HN - 407,000
- Leasehold Flat/Maisonette
SE8 4HN - 332,000
- Leasehold Flat/Maisonette
SE8 4HN - 494,000
- Leasehold Flat/Maisonette
SE8 4HN - 403,000
- Leasehold Flat/Maisonette
SE8 4HN - 384,000
- Leasehold Converted flat
SE8 4HN - 384,000
- Leasehold Flat/Maisonette
SE8 4HN - 404,000
- Leasehold Purpose built flat
SE8 4HN - 491,000
- Leasehold Flat/Maisonette
SE8 4HN - 405,000
- Leasehold Purpose built flat
SE8 4HN - 311,000
- Leasehold Flat/Maisonette
SE8 4HN - 365,000
- Feudal Flat/Maisonette
SE8 4HN - 521,000
- Leasehold Flat/Maisonette
SE8 4HN - 491,000
- Leasehold Flat/Maisonette
SE8 4HN - 399,000
- Leasehold Flat/Maisonette
SE8 4HN - 356,000
- Leasehold Flat/Maisonette
SE8 4HN - 450,000
- Leasehold Purpose built flat
SE8 4HN - 457,000
- Leasehold Purpose built flat
SE8 4HN - 358,000
- Feudal Flat/Maisonette
SE8 4HN - 328,000
- Leasehold Flat/Maisonette
SE8 4HN - 410,000
- Leasehold Purpose built flat
SE8 4HN - 462,000
- Leasehold Purpose built flat
SE8 4HN - 450,000
- Leasehold Purpose built flat
SE8 4HN - 358,000
- Feudal Flat/Maisonette
SE8 4HN - 305,000
- Leasehold Flat/Maisonette
SE8 4HN - 486,000
- Feudal Flat/Maisonette
SE8 4HN - 413,000
- Leasehold Flat/Maisonette
SE8 4HN - 356,000
- Leasehold Flat/Maisonette
SE8 4HN - 405,000
- Leasehold Flat/Maisonette
SE8 4HN - 472,000
- Leasehold Flat/Maisonette
SE8 4HN - 452,000
- Leasehold Purpose built flat
SE8 4HN - 379,000
- Leasehold Flat/Maisonette
SE8 4HN - 535,000
- Leasehold Flat/Maisonette
SE8 4HN - 367,000
- Leasehold Flat/Maisonette
SE8 4HN - 521,000
- Leasehold Flat/Maisonette
SE8 4HN - 339,000
- Leasehold Flat/Maisonette
SE8 4HN - 413,000
- Leasehold Flat/Maisonette
SE8 4HN - 498,000
- Leasehold Purpose built flat
SE8 4HN - 379,000
- Leasehold Flat/Maisonette
SE8 4HN - 412,000
- Leasehold Flat/Maisonette
SE8 4HN - 325,000
- Leasehold Purpose built flat
SE8 4HN - 396,000
- Leasehold Purpose built flat
SE8 4HN - 490,000
- Leasehold Flat/Maisonette
SE8 4HN - 349,000
- Leasehold Flat/Maisonette
SE8 4HN - 371,000
- Leasehold Flat/Maisonette