SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='RM2 5LT' order by fulladdress
RM2 5LT - 711,000
- Freehold Semi-detached house
RM2 5LT - 734,000
- Freehold Semi-detached house
RM2 5LT - 723,000
- Freehold Semi-detached house
RM2 5LT - 785,000
- Freehold Semi-detached house
RM2 5LT - 1,003,000
- Freehold Detached house
RM2 5LT - 821,000
- Freehold Semi-detached house
RM2 5LT - 909,000
- Freehold Semi-detached house
RM2 5LT - 839,000
- Freehold Semi-detached house
RM2 5LT - 753,000
- Freehold Semi-detached house
RM2 5LT - 865,000
- Freehold Semi-detached house
RM2 5LT - 724,000
- Freehold Semi-detached house
RM2 5LT - 755,000
- Freehold Semi-detached property
RM2 5LT - 689,000
- Freehold Semi-detached property
RM2 5LT - 892,000
- Freehold Semi-detached house
RM2 5LT - 700,000
- Freehold Semi-detached house
RM2 5LT - 758,000
- Freehold Semi-detached house
RM2 5LT - 710,000
- Freehold Semi-detached house
RM2 5LT - 699,000
- Freehold Semi-detached house
RM2 5LT - 700,000
- Freehold Semi-detached house
RM2 5LT - 832,000
- Freehold Semi-detached house
RM2 5LT - 711,000
- Freehold Semi-detached house
RM2 5LT - 774,000
- Semi-detached house
RM2 5LT - 801,000
- Freehold Detached bungalow
RM2 5LT - 928,000
- Freehold Detached house
RM2 5LT - 1,025,000
- Freehold Detached house
RM2 5LT - 780,000
- Freehold Semi-detached house
RM2 5LT - 899,000
- Freehold Semi-detached house
RM2 5LT - 862,000
- Freehold Semi-detached house
RM2 5LT - 776,000
- Freehold Detached bungalow
