SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RH6 9ZE' order by fulladdress
RH6 9ZE - 721,000
- Freehold Detached house
RH6 9ZE - 746,000
- Freehold Detached house
RH6 9ZE - 886,000
- Freehold Detached house
RH6 9ZE - 826,000
- Freehold Detached house
RH6 9ZE - 843,000
- Freehold Detached house
RH6 9ZE - 550,000
- Freehold End terrace house
RH6 9ZE - 811,000
- Freehold Detached house
RH6 9ZE - 819,000
- Freehold Detached house
RH6 9ZE - 752,000
- Freehold Detached house
RH6 9ZE - 750,000
- Freehold Detached house
RH6 9ZE - 828,000
- Freehold Detached house
RH6 9ZE - 797,000
- Freehold Detached house
RH6 9ZE - 484,000
- Freehold Semi-detached house
RH6 9ZE - 501,000
- Freehold Semi-detached house
RH6 9ZE - 810,000
- Freehold Detached house
RH6 9ZE - 841,000
- Freehold Detached house
RH6 9ZE - 346,000
- Freehold Flat/Maisonette
RH6 9ZE - 832,000
- Freehold Detached house
RH6 9ZE - 815,000
- Freehold Detached house
RH6 9ZE - 308,000
- Freehold Flat/Maisonette
RH6 9ZE - 854,000
- Freehold Detached house
