SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='M26 1UN' order by fulladdress
M26 1UN - 383,000
- Leasehold Detached house
M26 1UN - 125,000
- Leasehold Flat/Maisonette
M26 1UN - 269,000
- Leasehold Semi-detached house
M26 1UN - 134,000
- Leasehold Flat/Maisonette
M26 1UN - 136,000
- Leasehold Flat/Maisonette
M26 1UN - 301,000
- Leasehold Semi-detached house
M26 1UN - 123,000
- Leasehold Flat/Maisonette
M26 1UN - 136,000
- Leasehold Flat/Maisonette
M26 1UN - 391,000
- Leasehold Detached house
M26 1UN - 137,000
- Leasehold Purpose built flat
M26 1UN - 133,000
- Feudal Purpose built flat
M26 1UN - 143,000
- Leasehold Flat/Maisonette
M26 1UN - 140,000
- Leasehold Flat/Maisonette
M26 1UN - 144,000
- Leasehold Flat/Maisonette
M26 1UN - 420,000
- Leasehold Detached house
M26 1UN - 143,000
- Leasehold Flat/Maisonette
M26 1UN - 134,000
- Leasehold Flat/Maisonette
M26 1UN - 140,000
- Leasehold Flat/Maisonette
M26 1UN - 141,000
- Leasehold Flat/Maisonette
M26 1UN - 143,000
- Leasehold Flat/Maisonette
M26 1UN - 417,000
- Leasehold Detached house
M26 1UN - 141,000
- Leasehold Flat/Maisonette
M26 1UN - 140,000
- Leasehold Purpose built flat
M26 1UN - 133,000
- Leasehold Purpose built flat
M26 1UN - 135,000
- Leasehold Purpose built flat
M26 1UN - 391,000
- Leasehold Detached house
M26 1UN - 138,000
- Leasehold Flat/Maisonette
M26 1UN - 158,000
- Leasehold Terrace property
M26 1UN - 140,000
- Leasehold Purpose built flat
M26 1UN - 142,000
- Leasehold Flat/Maisonette
M26 1UN - 137,000
- Leasehold Purpose built flat
M26 1UN - 300,000
- Leasehold Semi-detached house
M26 1UN - 149,000
- Leasehold Flat/Maisonette
M26 1UN - 149,000
- Leasehold Flat/Maisonette
M26 1UN - 140,000
- Leasehold Purpose built flat
M26 1UN - 140,000
- Leasehold Purpose built flat
M26 1UN - 147,000
- Leasehold Flat/Maisonette
M26 1UN - 399,000
- Leasehold Detached house
M26 1UN - 145,000
- Leasehold Flat/Maisonette
M26 1UN - 143,000
- Leasehold Flat/Maisonette
M26 1UN - 141,000
- Leasehold Flat/Maisonette
M26 1UN - 139,000
- Leasehold Flat/Maisonette
M26 1UN - 131,000
- Leasehold Flat/Maisonette
M26 1UN - 316,000
- Leasehold Semi-detached house
M26 1UN - 136,000
- Leasehold Flat/Maisonette
M26 1UN - 148,000
- Leasehold Flat/Maisonette
M26 1UN - 153,000
- Leasehold Flat/Maisonette
M26 1UN - 372,000
- Leasehold Detached house