SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SK10 4HR' order by fulladdress
SK10 4HR - 630,000
- Freehold Terrace property
SK10 4HR - 709,000
- Freehold Detached house
SK10 4HR - 697,000
- Freehold Mid terrace house
SK10 4HR - 640,000
- Freehold Mid terrace house
SK10 4HR - 932,000
- Freehold Detached house
SK10 4HR - 1,002,000
- Freehold Detached house
SK10 4HR - 637,000
- Freehold Mid terrace house
SK10 4HR - 898,000
- Freehold Detached house
SK10 4HR - 797,000
- Freehold Detached house
SK10 4HR - 802,000
- Freehold Detached house
SK10 4HR - 917,000
- Freehold Detached property
SK10 4HR - 768,000
- Freehold Detached house
SK10 4HR - 828,000
- Freehold Detached house
SK10 4HR - 827,000
- Freehold Detached house
SK10 4HR - 779,000
- Freehold Detached property
SK10 4HR - 666,000
- Freehold Mid terrace house
SK10 4HR - 767,000
- Freehold Detached house
SK10 4HR - 764,000
- Freehold Detached house
SK10 4HR - 833,000
- Freehold Detached house
SK10 4HR - 699,000
- Freehold End terrace house
SK10 4HR - 768,000
- Freehold Detached property
SK10 4HR - 665,000
- Freehold Terrace property
SK10 4HR - 601,000
- Freehold Mid terrace house
SK10 4HR - 643,000
- Freehold Detached house
SK10 4HR - 607,000
- Freehold End terrace house
SK10 4HR - 905,000
- Freehold Detached house
SK10 4HR - 1,029,000
- Leasehold Detached house