SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E3 5AD' order by fulladdress
E3 5AD - 2,049,000
- Freehold Terrace property
E3 5AD - 2,201,000
- Freehold Mid terrace house
E3 5AD - 1,966,000
- Freehold Terrace property
E3 5AD - 2,064,000
- Freehold Mid terrace house
E3 5AD - 408,000
- Leasehold Converted flat
E3 5AD - 1,990,000
- Freehold Mid terrace house
E3 5AD - 713,000
- Freehold Converted flat
E3 5AD - 1,886,000
- Freehold Mid terrace house
E3 5AD - 1,383,000
- Freehold Terraced
E3 5AD - 1,859,000
- Freehold Terrace property
E3 5AD - 2,094,000
- Freehold Terraced
E3 5AD - 1,984,000
- Freehold Mid terrace house
E3 5AD - 2,031,000
- Freehold Terraced
E3 5AD - 2,075,000
- Freehold Terraced
E3 5AD - 1,980,000
- Freehold Mid terrace house
E3 5AD - 1,531,000
- Freehold Mid terrace house
E3 5AD - 1,724,000
- Freehold Terraced
E3 5AD - 0
- Freehold Mid terrace house
E3 5AD - 1,912,000
- Terrace property
E3 5AD - 2,252,000
- Freehold Terraced
E3 5AD - 1,941,000
- Freehold Mid terrace house
E3 5AD - 2,140,000
- Freehold Detached house
E3 5AD - 717,000
- Leasehold Flat/Maisonette
E3 5AD - 757,000
- Leasehold Converted flat