SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CT7 9NA' order by fulladdress
CT7 9NA - 555,000
- Freehold Detached bungalow
CT7 9NA - 545,000
- Freehold Detached bungalow
CT7 9NA - 583,000
- Freehold Detached bungalow
CT7 9NA - 607,000
- Freehold Detached house
CT7 9NA - 768,000
- Freehold Detached house
CT7 9NA - 706,000
- Freehold Detached property
CT7 9NA - 637,000
- Freehold Detached house
CT7 9NA - 946,000
- Freehold Detached house
CT7 9NA - 571,000
- Freehold Semi-detached property
CT7 9NA - 626,000
- Freehold Detached house
CT7 9NA - 941,000
- Freehold Detached house
CT7 9NA - 437,000
- Freehold Semi-detached bungalow
CT7 9NA - 674,000
- Freehold Detached house
CT7 9NA - 776,000
- Freehold Detached bungalow
CT7 9NA - 873,000
- Freehold Detached house
CT7 9NA - 763,000
- Freehold Detached house
CT7 9NA - 808,000
- Freehold Detached property
CT7 9NA - 802,000
- Freehold Detached house
CT7 9NA - 752,000
- Freehold Detached house
CT7 9NA - 681,000
- Freehold Detached property
CT7 9NA - 595,000
- Freehold Detached bungalow
CT7 9NA - 641,000
- Freehold Detached house
