SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='M1 5ED' order by fulladdress
M1 5ED - 449,000
- Leasehold Purpose built flat
M1 5ED - 325,000
- Leasehold Flat/Maisonette
M1 5ED - 307,000
- Leasehold Flat/Maisonette
M1 5ED - 337,000
- Leasehold Flat/Maisonette
M1 5ED - 199,000
- Leasehold Flat/Maisonette
M1 5ED - 232,000
- Leasehold Flat/Maisonette
M1 5ED - 204,000
- Leasehold Purpose built flat
M1 5ED - 332,000
- Leasehold Flat/Maisonette
M1 5ED - 365,000
- Leasehold Flat/Maisonette
M1 5ED - 248,000
- Leasehold Flat/Maisonette
M1 5ED - 289,000
- Leasehold Purpose built flat
M1 5ED - 319,000
- Leasehold Flat/Maisonette
M1 5ED - 207,000
- Leasehold Flat/Maisonette
M1 5ED - 308,000
- Leasehold Flat/Maisonette
M1 5ED - 230,000
- Leasehold Flat/Maisonette
M1 5ED - 302,000
- Leasehold Flat/Maisonette
M1 5ED - 307,000
- Leasehold Flat/Maisonette
M1 5ED - 301,000
- Leasehold Flat/Maisonette
M1 5ED - 318,000
- Leasehold Flat/Maisonette
M1 5ED - 354,000
- Leasehold Purpose built flat
M1 5ED - 381,000
- Leasehold Flat/Maisonette
M1 5ED - 283,000
- Leasehold Flat/Maisonette
M1 5ED - 377,000
- Leasehold Flat/Maisonette
M1 5ED - 356,000
- Leasehold Flat/Maisonette
M1 5ED - 373,000
- Leasehold Flat/Maisonette
M1 5ED - 354,000
- Leasehold Flat/Maisonette
M1 5ED - 352,000
- Leasehold Flat/Maisonette
M1 5ED - 272,000
- Leasehold Flat/Maisonette
M1 5ED - 341,000
- Leasehold Flat/Maisonette
M1 5ED - 242,000
- Leasehold Flat/Maisonette
M1 5ED - 223,000
- Leasehold Purpose built flat
M1 5ED - 205,000
- Leasehold Converted flat
M1 5ED - 336,000
- Leasehold Flat/Maisonette
M1 5ED - 338,000
- Leasehold Purpose built flat
M1 5ED - 331,000
- Leasehold Purpose built flat
M1 5ED - 311,000
- Leasehold Flat/Maisonette
M1 5ED - 350,000
- Leasehold Purpose built flat
M1 5ED - 216,000
- Leasehold Flat/Maisonette
M1 5ED - 343,000
- Leasehold Flat/Maisonette
M1 5ED - 227,000
- Leasehold Flat/Maisonette
M1 5ED - 245,000
- Leasehold Purpose built flat
M1 5ED - 332,000
- Leasehold Flat/Maisonette
M1 5ED - 297,000
- Leasehold Flat/Maisonette
M1 5ED - 321,000
- Leasehold Flat/Maisonette
M1 5ED - 338,000
- Leasehold Purpose built flat
M1 5ED - 344,000
- Leasehold Flat/Maisonette
M1 5ED - 407,000
- Leasehold Flat/Maisonette
M1 5ED - 205,000
- Leasehold Flat/Maisonette
M1 5ED - 340,000
- Leasehold Flat/Maisonette
M1 5ED - 365,000
- Leasehold Flat/Maisonette
M1 5ED - 391,000
- Leasehold Purpose built flat
M1 5ED - 349,000
- Leasehold Flat/Maisonette
M1 5ED - 439,000
- Leasehold Purpose built flat
M1 5ED - 519,000
- Leasehold Flat/Maisonette
M1 5ED - 445,000
- Leasehold Flat/Maisonette
M1 5ED - 465,000
- Leasehold Flat/Maisonette
M1 5ED - 471,000
- Leasehold Purpose built flat
M1 5ED - 209,000
- Leasehold Purpose built flat
M1 5ED - 493,000
- Leasehold Flat/Maisonette
M1 5ED - 417,000
- Leasehold Flat/Maisonette
M1 5ED - 421,000
- Leasehold Flat/Maisonette
M1 5ED - 376,000
- Leasehold Purpose built flat
M1 5ED - 445,000
- Leasehold Flat/Maisonette
M1 5ED - 494,000
- Leasehold Purpose built flat
M1 5ED - 284,000
- Leasehold Flat/Maisonette
M1 5ED - 490,000
- Leasehold Flat/Maisonette
M1 5ED - 497,000
- Leasehold Flat/Maisonette
M1 5ED - 314,000
- Leasehold Purpose built flat
M1 5ED - 438,000
- Leasehold Purpose built flat
M1 5ED - 387,000
- Leasehold Flat/Maisonette
M1 5ED - 363,000
- Leasehold Flat/Maisonette
M1 5ED - 439,000
- Leasehold Flat/Maisonette
M1 5ED - 401,000
- Leasehold Flat/Maisonette
M1 5ED - 423,000
- Leasehold Flat/Maisonette
M1 5ED - 519,000
- Leasehold Purpose built flat
M1 5ED - 427,000
- Leasehold Flat/Maisonette
M1 5ED - 344,000
- Leasehold Flat/Maisonette
M1 5ED - 450,000
- Leasehold Flat/Maisonette
M1 5ED - 492,000
- Leasehold Flat/Maisonette
M1 5ED - 378,000
- Leasehold Flat/Maisonette
M1 5ED - 460,000
- Leasehold Purpose built flat
