SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E16 2ST' order by fulladdress
E16 2ST - 396,000
- Leasehold Purpose built flat
E16 2ST - 325,000
- Leasehold Flat/Maisonette
E16 2ST - 453,000
- Leasehold Flat/Maisonette
E16 2ST - 473,000
- Leasehold Flat/Maisonette
E16 2ST - 380,000
- Leasehold Purpose built flat
E16 2ST - 404,000
- Leasehold Purpose built flat
E16 2ST - 396,000
- Leasehold Purpose built flat
E16 2ST - 375,000
- Leasehold Flat/Maisonette
E16 2ST - 327,000
- Leasehold Flat/Maisonette
E16 2ST - 328,000
- Leasehold Flat/Maisonette
E16 2ST - 326,000
- Leasehold Purpose built flat
E16 2ST - 432,000
- Leasehold Flat/Maisonette
E16 2ST - 326,000
- Leasehold Purpose built flat
E16 2ST - 543,000
- Leasehold Flat/Maisonette
E16 2ST - 521,000
- Leasehold Purpose built flat
E16 2ST - 396,000
- Leasehold Purpose built flat
E16 2ST - 423,000
- Leasehold Purpose built flat
E16 2ST - 401,000
- Leasehold Flat/Maisonette
E16 2ST - 441,000
- Leasehold Flat/Maisonette
E16 2ST - 306,000
- Leasehold Flat/Maisonette
E16 2ST - 345,000
- Leasehold Purpose built flat
E16 2ST - 286,000
- Leasehold Flat/Maisonette
E16 2ST - 380,000
- Leasehold Purpose built flat
E16 2ST - 309,000
- Leasehold Purpose built flat
E16 2ST - 491,000
- Leasehold Purpose built flat
E16 2ST - 522,000
- Leasehold Purpose built flat
E16 2ST - 403,000
- Leasehold Flat/Maisonette
E16 2ST - 404,000
- Feudal Purpose built flat
E16 2ST - 398,000
- Feudal Purpose built flat
E16 2ST - 319,000
- Leasehold Purpose built flat
E16 2ST - 331,000
- Feudal Purpose built flat
E16 2ST - 312,000
- Leasehold Purpose built flat
E16 2ST - 394,000
- Leasehold Flat/Maisonette
E16 2ST - 328,000
- Leasehold Flat/Maisonette
E16 2ST - 513,000
- Leasehold Flat/Maisonette
E16 2ST - 530,000
- Leasehold Purpose built flat
E16 2ST - 389,000
- Leasehold Flat/Maisonette
E16 2ST - 411,000
- Leasehold Purpose built flat
E16 2ST - 381,000
- Leasehold Purpose built flat
E16 2ST - 441,000
- Leasehold Purpose built flat
E16 2ST - 281,000
- Leasehold Flat/Maisonette
E16 2ST - 398,000
- Leasehold Flat/Maisonette
E16 2ST - 317,000
- Leasehold End terrace house
E16 2ST - 379,000
- Leasehold Purpose built flat
E16 2ST - 300,000
- Leasehold Purpose built flat
E16 2ST - 441,000
- Leasehold Purpose built flat
E16 2ST - 468,000
- Leasehold Flat/Maisonette
E16 2ST - 394,000
- Leasehold Flat/Maisonette
E16 2ST - 404,000
- Leasehold Flat/Maisonette
E16 2ST - 387,000
- Leasehold Purpose built flat
E16 2ST - 376,000
- Leasehold Purpose built flat
E16 2ST - 331,000
- Leasehold Flat/Maisonette
E16 2ST - 333,000
- Leasehold Purpose built flat
E16 2ST - 306,000
- Leasehold Flat/Maisonette
E16 2ST - 410,000
- Leasehold Purpose built flat
E16 2ST - 310,000
- Leasehold Purpose built flat
E16 2ST - 309,000
- Leasehold Purpose built flat
E16 2ST - 233,000
- Leasehold Flat/Maisonette
E16 2ST - 369,000
- Leasehold Flat/Maisonette