SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='M30 9NP' order by fulladdress
M30 9NP - 573,000
- Leasehold Detached house
M30 9NP - 699,000
- Leasehold Detached house
M30 9NP - 607,000
- Leasehold Semi-detached house
M30 9NP - 580,000
- Leasehold Detached house
M30 9NP - 565,000
- Leasehold Detached house
M30 9NP - 688,000
- Leasehold Detached house
M30 9NP - 669,000
- Leasehold Detached house
M30 9NP - 643,000
- Leasehold Detached house
M30 9NP - 379,000
- Leasehold End terrace house
M30 9NP - 615,000
- Leasehold Detached house
M30 9NP - 371,000
- Leasehold Terrace property
M30 9NP - 596,000
- Leasehold Semi-detached house
M30 9NP - 414,000
- Leasehold Semi-detached house
M30 9NP - 602,000
- Leasehold Semi-detached house
M30 9NP - 534,000
- Leasehold Semi-detached house
