SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RH16 2DT' order by fulladdress
RH16 2DT - 312,000
- Leasehold Detached house
RH16 2DT - 293,000
- Leasehold Purpose built flat
RH16 2DT - 293,000
- Leasehold Purpose built flat
RH16 2DT - 898,000
- Freehold Detached property
RH16 2DT - 288,000
- Leasehold Flat/Maisonette
RH16 2DT - 832,000
- Freehold Detached house
RH16 2DT - 829,000
- Freehold Detached property
RH16 2DT - 922,000
- Freehold Detached house
RH16 2DT - 359,000
- Freehold Purpose built flat
RH16 2DT - 348,000
- Feudal Purpose built flat
RH16 2DT - 819,000
- Freehold Detached house
RH16 2DT - 359,000
- Leasehold Purpose built flat
RH16 2DT - 923,000
- Freehold Detached house
RH16 2DT - 362,000
- Leasehold Purpose built flat
RH16 2DT - 871,000
- Freehold Detached house
RH16 2DT - 932,000
- Freehold Detached property
RH16 2DT - 817,000
- Freehold Detached bungalow
RH16 2DT - 839,000
- Freehold Detached house
RH16 2DT - 1,127,000
- Freehold Detached house
RH16 2DT - 870,000
- Freehold Detached house
RH16 2DT - 1,126,000
- Freehold Detached house
RH16 2DT - 919,000
- Freehold Detached house
RH16 2DT - 301,000
- Leasehold Flat/Maisonette
RH16 2DT - 916,000
- Freehold Detached house
RH16 2DT - 839,000
- Freehold Detached house
RH16 2DT - 1,069,000
- Freehold Detached house
RH16 2DT - 310,000
- Leasehold Purpose built flat
RH16 2DT - 1,512,000
- Freehold Detached house
RH16 2DT - 1,307,000
- Freehold Detached property