SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CT5 4AY' order by fulladdress
CT5 4AY - 446,000
- Freehold Detached bungalow
CT5 4AY - 543,000
- Freehold Detached house
CT5 4AY - 374,000
- Freehold Semi-detached bungalow
CT5 4AY - 400,000
- Freehold Semi-detached bungalow
CT5 4AY - 412,000
- Freehold Semi-detached property
CT5 4AY - 414,000
- Freehold Semi-detached bungalow
CT5 4AY - 398,000
- Freehold Semi-detached bungalow
CT5 4AY - 365,000
- Freehold Semi-detached bungalow
CT5 4AY - 383,000
- Freehold Semi-detached bungalow
CT5 4AY - 448,000
- Freehold Detached bungalow
CT5 4AY - 509,000
- Freehold Detached house
CT5 4AY - 368,000
- Freehold Semi-detached house
CT5 4AY - 392,000
- Freehold Semi-detached property
CT5 4AY - 380,000
- Freehold Semi-detached house
CT5 4AY - 501,000
- Freehold Detached bungalow
CT5 4AY - 514,000
- Freehold Detached bungalow
CT5 4AY - 518,000
- Freehold Detached bungalow
CT5 4AY - 503,000
- Freehold Detached bungalow
CT5 4AY - 519,000
- Freehold Semi-detached property
