SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM15 8RF' order by fulladdress
CM15 8RF - 933,000
- Freehold Detached house
CM15 8RF - 1,038,000
- Freehold Detached bungalow
CM15 8RF - 977,000
- Freehold Semi-detached house
CM15 8RF - 838,000
- Freehold Semi-detached house
CM15 8RF - 1,155,000
- Freehold Detached house
CM15 8RF - 965,000
- Freehold Semi-detached property
CM15 8RF - 803,000
- Freehold Detached bungalow
CM15 8RF - 841,000
- Freehold Semi-detached house
CM15 8RF - 997,000
- Freehold Detached house
CM15 8RF - 888,000
- Freehold Semi-detached house
CM15 8RF - 971,000
- Freehold Detached house
CM15 8RF - 936,000
- Freehold Semi-detached house
CM15 8RF - 1,058,000
- Freehold Detached house
CM15 8RF - 966,000
- Freehold Semi-detached house
CM15 8RF - 1,273,000
- Freehold Detached house
CM15 8RF - 1,470,000
- Freehold Detached house
CM15 8RF - 994,000
- Freehold Detached house
CM15 8RF - 1,138,000
- Freehold Detached house
CM15 8RF - 970,000
- Freehold Detached bungalow
CM15 8RF - 1,108,000
- Freehold Detached house
CM15 8RF - 1,115,000
- Freehold Detached house
CM15 8RF - 835,000
- Freehold Semi-detached house