SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='M3 1AZ' order by fulladdress
M3 1AZ - 326,000
- Leasehold Flat/Maisonette
M3 1AZ - 451,000
- Leasehold Flat/Maisonette
M3 1AZ - 955,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,573,000
- Leasehold Flat/Maisonette
M3 1AZ - 578,000
- Leasehold Flat/Maisonette
M3 1AZ - 494,000
- Leasehold Flat/Maisonette
M3 1AZ - 521,000
- Leasehold Flat/Maisonette
M3 1AZ - 486,000
- Leasehold Flat/Maisonette
M3 1AZ - 558,000
- Leasehold Flat/Maisonette
M3 1AZ - 403,000
- Leasehold Flat/Maisonette
M3 1AZ - 254,000
- Leasehold Flat/Maisonette
M3 1AZ - 234,000
- Leasehold Purpose built flat
M3 1AZ - 228,000
- Leasehold Flat/Maisonette
M3 1AZ - 220,000
- Leasehold Purpose built flat
M3 1AZ - 442,000
- Leasehold Flat/Maisonette
M3 1AZ - 430,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,119,000
- Leasehold Flat/Maisonette
M3 1AZ - 750,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,143,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,963,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,605,000
- Leasehold Flat/Maisonette
M3 1AZ - 458,000
- Leasehold Flat/Maisonette
M3 1AZ - 451,000
- Leasehold Flat/Maisonette
M3 1AZ - 463,000
- Leasehold Purpose built flat
M3 1AZ - 217,000
- Leasehold Flat/Maisonette
M3 1AZ - 228,000
- Leasehold Purpose built flat
M3 1AZ - 223,000
- Leasehold Flat/Maisonette
M3 1AZ - 283,000
- Leasehold Flat/Maisonette
M3 1AZ - 371,000
- Leasehold Flat/Maisonette
M3 1AZ - 459,000
- Leasehold Flat/Maisonette
M3 1AZ - 560,000
- Leasehold Flat/Maisonette
M3 1AZ - 461,000
- Leasehold Flat/Maisonette
M3 1AZ - 356,000
- Leasehold Flat/Maisonette
M3 1AZ - 408,000
- Leasehold Purpose built flat
M3 1AZ - 413,000
- Leasehold Flat/Maisonette
M3 1AZ - 409,000
- Leasehold Flat/Maisonette
M3 1AZ - 431,000
- Leasehold Flat/Maisonette
M3 1AZ - 460,000
- Leasehold Flat/Maisonette
M3 1AZ - 465,000
- Feudal Purpose built flat
M3 1AZ - 496,000
- Leasehold Flat/Maisonette
M3 1AZ - 423,000
- Leasehold Purpose built flat
M3 1AZ - 425,000
- Leasehold Purpose built flat
M3 1AZ - 382,000
- Leasehold Purpose built flat
M3 1AZ - 407,000
- Leasehold Purpose built flat
M3 1AZ - 468,000
- Leasehold Flat/Maisonette
M3 1AZ - 489,000
- Leasehold Flat/Maisonette
M3 1AZ - 534,000
- Leasehold Flat/Maisonette
M3 1AZ - 457,000
- Leasehold Flat/Maisonette
M3 1AZ - 457,000
- Leasehold Flat/Maisonette
M3 1AZ - 497,000
- Leasehold Flat/Maisonette
M3 1AZ - 452,000
- Leasehold Purpose built flat
M3 1AZ - 414,000
- Leasehold Flat/Maisonette
M3 1AZ - 441,000
- Leasehold Flat/Maisonette
M3 1AZ - 442,000
- Leasehold Flat/Maisonette
M3 1AZ - 457,000
- Leasehold Flat/Maisonette
M3 1AZ - 464,000
- Leasehold Purpose built flat
M3 1AZ - 501,000
- Leasehold Flat/Maisonette
M3 1AZ - 429,000
- Leasehold Purpose built flat
M3 1AZ - 444,000
- Leasehold Flat/Maisonette
M3 1AZ - 516,000
- Leasehold Flat/Maisonette
M3 1AZ - 1,016,000
- Leasehold Purpose built flat
M3 1AZ - 477,000
- Leasehold Flat/Maisonette
M3 1AZ - 448,000
- Leasehold Purpose built flat
M3 1AZ - 532,000
- Leasehold Purpose built flat
M3 1AZ - 436,000
- Leasehold Purpose built flat
M3 1AZ - 411,000
- Leasehold Flat/Maisonette
M3 1AZ - 422,000
- Leasehold Flat/Maisonette
M3 1AZ - 388,000
- Leasehold Purpose built flat
M3 1AZ - 499,000
- Leasehold Purpose built flat
M3 1AZ - 466,000
- Leasehold Flat/Maisonette
M3 1AZ - 389,000
- Leasehold Flat/Maisonette
M3 1AZ - 366,000
- Leasehold Purpose built flat
M3 1AZ - 520,000
- Leasehold Flat/Maisonette
M3 1AZ - 922,000
- Leasehold Purpose built flat
M3 1AZ - 998,000
- Leasehold Flat/Maisonette
M3 1AZ - 443,000
- Leasehold Purpose built flat
M3 1AZ - 902,000
- Leasehold Flat/Maisonette
M3 1AZ - 489,000
- Share of freehold Flat/Maisonette
M3 1AZ - 388,000
- Leasehold Flat/Maisonette