SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E3 3GW' order by fulladdress
E3 3GW - 397,000
- Leasehold Flat/Maisonette
E3 3GW - 436,000
- Leasehold Flat/Maisonette
E3 3GW - 375,000
- Leasehold Flat/Maisonette
E3 3GW - 369,000
- Leasehold Flat/Maisonette
E3 3GW - 365,000
- Leasehold Flat/Maisonette
E3 3GW - 360,000
- Leasehold Purpose built flat
E3 3GW - 380,000
- Leasehold Flat/Maisonette
E3 3GW - 364,000
- Leasehold Flat/Maisonette
E3 3GW - 303,000
- Leasehold Flat/Maisonette
E3 3GW - 378,000
- Leasehold Flat/Maisonette
E3 3GW - 472,000
- Leasehold Flat/Maisonette
E3 3GW - 439,000
- Feudal Purpose built flat
E3 3GW - 455,000
- Leasehold Purpose built flat
E3 3GW - 363,000
- Leasehold Flat/Maisonette
E3 3GW - 370,000
- Leasehold Flat/Maisonette
E3 3GW - 344,000
- Leasehold Purpose built flat
E3 3GW - 360,000
- Leasehold Flat/Maisonette
E3 3GW - 344,000
- Leasehold Flat/Maisonette
E3 3GW - 357,000
- Leasehold Purpose built flat
E3 3GW - 558,000
- Leasehold Flat/Maisonette
E3 3GW - 375,000
- Leasehold Flat/Maisonette
E3 3GW - 468,000
- Leasehold Flat/Maisonette
E3 3GW - 443,000
- Leasehold Purpose built flat
E3 3GW - 439,000
- Leasehold Flat/Maisonette
E3 3GW - 366,000
- Leasehold Purpose built flat
E3 3GW - 337,000
- Leasehold Purpose built flat
E3 3GW - 348,000
- Leasehold Flat/Maisonette
E3 3GW - 349,000
- Leasehold Flat/Maisonette
E3 3GW - 360,000
- Leasehold Flat/Maisonette
E3 3GW - 365,000
- Leasehold Flat/Maisonette
E3 3GW - 544,000
- Leasehold Flat/Maisonette
E3 3GW - 385,000
- Leasehold Flat/Maisonette
E3 3GW - 457,000
- Leasehold Purpose built flat
E3 3GW - 446,000
- Leasehold Flat/Maisonette
E3 3GW - 456,000
- Leasehold Purpose built flat
E3 3GW - 369,000
- Leasehold Flat/Maisonette
E3 3GW - 438,000
- Leasehold Flat/Maisonette
E3 3GW - 434,000
- Leasehold Flat/Maisonette
E3 3GW - 420,000
- Leasehold Purpose built flat
E3 3GW - 279,000
- Leasehold Flat/Maisonette
E3 3GW - 547,000
- Leasehold Flat/Maisonette
E3 3GW - 361,000
- Leasehold Purpose built flat
E3 3GW - 467,000
- Leasehold Flat/Maisonette
E3 3GW - 578,000
- Leasehold Purpose built flat
E3 3GW - 589,000
- Leasehold Flat/Maisonette
E3 3GW - 339,000
- Leasehold Purpose built flat
E3 3GW - 332,000
- Leasehold Flat/Maisonette
E3 3GW - 573,000
- Leasehold Flat/Maisonette
E3 3GW - 368,000
- Leasehold Flat/Maisonette
E3 3GW - 476,000
- Leasehold Purpose built flat
E3 3GW - 530,000
- Leasehold Flat/Maisonette
E3 3GW - 546,000
- Leasehold Flat/Maisonette
E3 3GW - 440,000
- Leasehold Flat/Maisonette
E3 3GW - 263,000
- Leasehold Flat/Maisonette
E3 3GW - 454,000
- Leasehold Purpose built flat
E3 3GW - 550,000
- Feudal Flat/Maisonette
E3 3GW - 373,000
- Leasehold Flat/Maisonette
E3 3GW - 450,000
- Leasehold Purpose built flat
E3 3GW - 548,000
- Leasehold Flat/Maisonette
E3 3GW - 521,000
- Leasehold Flat/Maisonette
E3 3GW - 442,000
- Leasehold Flat/Maisonette
E3 3GW - 261,000
- Leasehold Flat/Maisonette
E3 3GW - 419,000
- Leasehold Purpose built flat
E3 3GW - 565,000
- Leasehold Flat/Maisonette
E3 3GW - 365,000
- Leasehold Purpose built flat
E3 3GW - 494,000
- Leasehold Flat/Maisonette
E3 3GW - 455,000
- Leasehold Purpose built flat
E3 3GW - 378,000
- Leasehold Flat/Maisonette
E3 3GW - 364,000
- Leasehold Flat/Maisonette
E3 3GW - 368,000
- Leasehold Flat/Maisonette
E3 3GW - 376,000
- Leasehold Purpose built flat
E3 3GW - 388,000
- Leasehold Flat/Maisonette
E3 3GW - 365,000
- Leasehold Flat/Maisonette
E3 3GW - 365,000
- Leasehold Flat/Maisonette