SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT21 1RT' order by fulladdress
KT21 1RT - 214,000
- Leasehold Flat/Maisonette
KT21 1RT - 415,000
- Leasehold Terraced bungalow
KT21 1RT - 187,000
- Leasehold Purpose built flat
KT21 1RT - 164,000
- Leasehold Flat/Maisonette
KT21 1RT - 198,000
- Leasehold Flat/Maisonette
KT21 1RT - 184,000
- Leasehold Flat/Maisonette
KT21 1RT - 169,000
- Leasehold Flat/Maisonette
KT21 1RT - 417,000
- Leasehold End terrace house
KT21 1RT - 200,000
- Leasehold Flat/Maisonette
KT21 1RT - 186,000
- Leasehold Flat/Maisonette
KT21 1RT - 156,000
- Leasehold Flat/Maisonette
KT21 1RT - 173,000
- Leasehold Flat/Maisonette
KT21 1RT - 197,000
- Leasehold Flat/Maisonette
KT21 1RT - 190,000
- Leasehold Flat/Maisonette
KT21 1RT - 188,000
- Leasehold Flat/Maisonette
KT21 1RT - 165,000
- Leasehold Purpose built flat
KT21 1RT - 386,000
- Leasehold Bungalow property
KT21 1RT - 405,000
- Leasehold Semi-detached bungalow
KT21 1RT - 203,000
- Leasehold Flat/Maisonette
KT21 1RT - 392,000
- Leasehold Semi-detached bungalow
KT21 1RT - 200,000
- Leasehold Flat/Maisonette
KT21 1RT - 381,000
- Leasehold Semi-detached bungalow
KT21 1RT - 181,000
- Leasehold Flat/Maisonette
KT21 1RT - 455,000
- Leasehold Flat/Maisonette
KT21 1RT - 194,000
- Leasehold Flat/Maisonette
KT21 1RT - 174,000
- Leasehold Flat/Maisonette
KT21 1RT - 439,000
- Leasehold Bungalow property
KT21 1RT - 422,000
- Leasehold Mid terrace bungalow
KT21 1RT - 196,000
- Leasehold Flat/Maisonette
KT21 1RT - 179,000
- Leasehold Flat/Maisonette
KT21 1RT - 188,000
- Leasehold Flat/Maisonette
KT21 1RT - 190,000
- Leasehold Flat/Maisonette
KT21 1RT - 400,000
- Leasehold Terraced bungalow
KT21 1RT - 211,000
- Leasehold Flat/Maisonette
KT21 1RT - 398,000
- Leasehold Terraced bungalow
KT21 1RT - 408,000
- Leasehold Mid terrace bungalow
KT21 1RT - 194,000
- Leasehold Purpose built flat