SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE14 5TT' order by fulladdress
SE14 5TT - 1,012,000
- Freehold Mid terrace house
SE14 5TT - 1,016,000
- Freehold Mid terrace house
SE14 5TT - 1,022,000
- Freehold Terrace property
SE14 5TT - 988,000
- Freehold Mid terrace house
SE14 5TT - 964,000
- Freehold Mid terrace house
SE14 5TT - 390,000
- Leasehold Flat/Maisonette
SE14 5TT - 948,000
- Freehold Terrace property
SE14 5TT - 958,000
- Freehold Mid terrace house
SE14 5TT - 902,000
- Freehold Terrace property
SE14 5TT - 1,037,000
- Freehold Mid terrace house
SE14 5TT - 526,000
- Freehold Flat/Maisonette
SE14 5TT - 975,000
- Freehold Mid terrace house
SE14 5TT - 960,000
- Freehold Mid terrace house
SE14 5TT - 1,013,000
- Freehold Mid terrace house
SE14 5TT - 966,000
- Freehold Terrace property
SE14 5TT - 896,000
- Freehold Terrace property
SE14 5TT - 987,000
- Freehold Mid terrace house
SE14 5TT - 1,126,000
- Freehold Terrace property
SE14 5TT - 1,034,000
- Freehold Mid terrace house
SE14 5TT - 1,033,000
- Freehold Mid terrace house
SE14 5TT - 935,000
- Freehold Mid terrace house
SE14 5TT - 941,000
- Freehold Mid terrace house
SE14 5TT - 422,000
- Leasehold Converted flat
SE14 5TT - 962,000
- Freehold Mid terrace house
SE14 5TT - 892,000
- Freehold Mid terrace house
SE14 5TT - 460,000
- Leasehold Converted flat
SE14 5TT - 382,000
- Leasehold Flat/Maisonette
SE14 5TT - 376,000
- Leasehold Converted flat
SE14 5TT - 996,000
- Freehold Mid terrace house
SE14 5TT - 920,000
- Freehold Mid terrace house
SE14 5TT - 508,000
- Leasehold Converted flat
SE14 5TT - 435,000
- Leasehold Converted flat
SE14 5TT - 1,057,000
- Freehold End terrace property
SE14 5TT - 1,118,000
- Freehold Detached house