SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE24 0NS' order by fulladdress
SE24 0NS - 1,914,000
- Freehold Detached house
SE24 0NS - 1,685,000
- Freehold Semi-detached property
SE24 0NS - 539,000
- Leasehold Converted flat
SE24 0NS - 1,341,000
- Freehold Detached house
SE24 0NS - 1,207,000
- Freehold Detached house
SE24 0NS - 1,849,000
- Freehold Semi-detached house
SE24 0NS - 1,267,000
- Freehold Semi-detached house
SE24 0NS - 1,306,000
- Freehold Semi-detached house
SE24 0NS - 728,000
- Freehold Converted flat
SE24 0NS - 1,735,000
- Freehold Semi-detached house
SE24 0NS - 1,815,000
- Freehold Semi-detached house
SE24 0NS - 786,000
- Freehold Flat/Maisonette
SE24 0NS - 465,000
- Leasehold Converted flat
SE24 0NS - 713,000
- Leasehold Converted flat
SE24 0NS - 1,545,000
- Freehold Semi-detached house
SE24 0NS - 1,769,000
- Freehold Semi-detached house
SE24 0NS - 599,000
- Leasehold Purpose built flat
SE24 0NS - 627,000
- Leasehold Purpose built flat
SE24 0NS - 600,000
- Leasehold Purpose built flat
SE24 0NS - 1,510,000
- Freehold Semi-detached house
SE24 0NS - 665,000
- Leasehold Converted flat
SE24 0NS - 658,000
- Leasehold Converted flat
SE24 0NS - 595,000
- Leasehold Converted flat
SE24 0NS - 602,000
- Leasehold Converted flat
SE24 0NS - 583,000
- Leasehold Flat/Maisonette
SE24 0NS - 477,000
- Leasehold Converted flat
SE24 0NS - 592,000
- Leasehold Converted flat
SE24 0NS - 492,000
- Leasehold Converted flat
SE24 0NS - 421,000
- Leasehold Converted flat
SE24 0NS - 477,000
- Leasehold Converted flat
SE24 0NS - 530,000
- Leasehold Converted flat
SE24 0NS - 460,000
- Leasehold Converted flat
SE24 0NS - 449,000
- Leasehold Converted flat
SE24 0NS - 672,000
- Leasehold Converted flat
SE24 0NS - 668,000
- Leasehold Converted flat
SE24 0NS - 528,000
- Leasehold Converted flat
SE24 0NS - 553,000
- Leasehold Converted flat
SE24 0NS - 453,000
- Leasehold Converted flat