SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SK9 2AE' order by fulladdress
SK9 2AE - 1,684,000
- Freehold Detached property
SK9 2AE - 1,690,000
- Freehold Detached house
SK9 2AE - 2,723,000
- Freehold Detached house
SK9 2AE - 2,453,000
- Freehold Detached house
SK9 2AE - 2,427,000
- Freehold Detached house
SK9 2AE - 2,140,000
- Freehold Detached house
SK9 2AE - 1,918,000
- Freehold Detached house
SK9 2AE - 2,078,000
- Freehold Detached house
SK9 2AE - 2,119,000
- Freehold Detached house
SK9 2AE - 1,657,000
- Leasehold Detached house
SK9 2AE - 2,210,000
- Freehold Detached house
SK9 2AE - 2,073,000
- Freehold Detached property
SK9 2AE - 2,060,000
- Leasehold Detached house
SK9 2AE - 2,391,000
- Freehold Detached house
SK9 2AE - 2,595,000
- Freehold Detached house
SK9 2AE - 2,167,000
- Freehold Detached house
SK9 2AE - 4,526,000
- Freehold Detached house
SK9 2AE - 3,626,000
- Freehold Detached house
SK9 2AE - 1,710,000
- Freehold Detached house
SK9 2AE - 2,044,000
- Freehold Detached house
SK9 2AE - 2,138,000
- Freehold Detached house
SK9 2AE - 2,137,000
- Freehold Detached house
SK9 2AE - 1,671,000
- Freehold Detached house
SK9 2AE - 2,496,000
- Freehold Detached house
SK9 2AE - 1,497,000
- Freehold Detached bungalow
