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 9HA' order by fulladdress
SE24 9HA - 3,249,000
- Freehold Semi-detached house
SE24 9HA - 3,462,000
- Freehold Semi-detached house
SE24 9HA - 2,604,000
- Freehold Detached property
SE24 9HA - 3,575,000
- Freehold Semi-detached house
SE24 9HA - 701,000
- Leasehold Converted flat
SE24 9HA - 3,593,000
- Freehold Semi-detached property
SE24 9HA - 3,533,000
- Freehold Semi-detached house
SE24 9HA - 2,464,000
- Freehold Detached property
SE24 9HA - 3,649,000
- Freehold Semi-detached house
SE24 9HA - 3,475,000
- Freehold Mid terrace house
SE24 9HA - 3,643,000
- Freehold Semi-detached house
SE24 9HA - 3,662,000
- Freehold Semi-detached house
SE24 9HA - 3,326,000
- Freehold Semi-detached house
SE24 9HA - 3,291,000
- Freehold Semi-detached house
SE24 9HA - 3,773,000
- Freehold Semi-detached house
SE24 9HA - 3,200,000
- Freehold Semi-detached property
SE24 9HA - 4,315,000
- Freehold Semi-detached house
SE24 9HA - 3,901,000
- Freehold Semi-detached property
SE24 9HA - 3,684,000
- Freehold Semi-detached house
SE24 9HA - 3,618,000
- Freehold Semi-detached house
SE24 9HA - 2,721,000
- Freehold Detached house
SE24 9HA - 3,236,000
- Freehold Semi-detached house
SE24 9HA - 3,412,000
- Freehold Semi-detached house
SE24 9HA - 471,000
- Leasehold Converted flat
SE24 9HA - 609,000
- Leasehold Flat/Maisonette
