SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT3 4SW' order by fulladdress
KT3 4SW - 2,200,000
- Freehold Detached house
KT3 4SW - 2,478,000
- Freehold Detached house
KT3 4SW - 2,449,000
- Leasehold Detached house
KT3 4SW - 1,943,000
- Freehold Detached house
KT3 4SW - 2,699,000
- Freehold Detached house
KT3 4SW - 2,011,000
- Freehold Detached house
KT3 4SW - 2,445,000
- Freehold Detached house
KT3 4SW - 1,932,000
- Freehold Detached house
KT3 4SW - 2,810,000
- Freehold Detached house
KT3 4SW - 2,305,000
- Freehold Detached property
KT3 4SW - 1,817,000
- Freehold Detached house
KT3 4SW - 3,155,000
- Freehold Detached property
KT3 4SW - 2,501,000
- Freehold Detached house
KT3 4SW - 2,262,000
- Freehold Detached house
KT3 4SW - 2,965,000
- Freehold Detached house
KT3 4SW - 2,565,000
- Freehold Detached house
KT3 4SW - 1,998,000
- Freehold Detached house
KT3 4SW - 2,120,000
- Freehold Detached house
KT3 4SW - 1,645,000
- Freehold Detached property
KT3 4SW - 2,526,000
- Freehold Detached house
KT3 4SW - 2,253,000
- Freehold Detached house
KT3 4SW - 2,108,000
- Freehold Detached property
KT3 4SW - 1,984,000
- Freehold Detached house
