SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RG9 1UJ' order by fulladdress
RG9 1UJ - 854,000
- Freehold Detached house
RG9 1UJ - 611,000
- Freehold End terrace house
RG9 1UJ - 729,000
- Freehold Semi-detached property
RG9 1UJ - 733,000
- Freehold Detached house
RG9 1UJ - 671,000
- Freehold Semi-detached house
RG9 1UJ - 652,000
- Freehold End terrace house
RG9 1UJ - 687,000
- Freehold End terrace house
RG9 1UJ - 672,000
- Freehold Mid terrace house
RG9 1UJ - 722,000
- Freehold Mid terrace house
RG9 1UJ - 840,000
- Freehold Detached house
RG9 1UJ - 705,000
- Freehold End terrace house
RG9 1UJ - 715,000
- Freehold Terrace property
RG9 1UJ - 624,000
- Freehold Terrace property
RG9 1UJ - 689,000
- Freehold End terrace house
RG9 1UJ - 676,000
- Freehold Terrace property
RG9 1UJ - 628,000
- Freehold Mid terrace house
RG9 1UJ - 814,000
- Freehold Detached property
RG9 1UJ - 684,000
- Freehold Mid terrace house
RG9 1UJ - 686,000
- Freehold End terrace house
RG9 1UJ - 771,000
- Freehold Semi-detached house
RG9 1UJ - 806,000
- Freehold Semi-detached house
RG9 1UJ - 705,000
- Freehold Semi-detached property
RG9 1UJ - 705,000
- Freehold Terrace property
RG9 1UJ - 637,000
- Freehold Mid terrace house
RG9 1UJ - 818,000
- Freehold Detached house
RG9 1UJ - 1,155,000
- Freehold Detached house
RG9 1UJ - 864,000
- Freehold Detached house
RG9 1UJ - 892,000
- Freehold Detached house
RG9 1UJ - 871,000
- Freehold Detached house
RG9 1UJ - 753,000
- Freehold Detached property
RG9 1UJ - 646,000
- Freehold Semi-detached house
RG9 1UJ - 639,000
- Freehold End terrace house
RG9 1UJ - 634,000
- Freehold Terrace property
RG9 1UJ - 805,000
- Freehold Detached property
