SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E7 8EG' order by fulladdress
E7 8EG - 388,000
- Freehold Converted flat
E7 8EG - 573,000
- Freehold Terraced
E7 8EG - 620,000
- Freehold Terraced
E7 8EG - 589,000
- Freehold Mid terrace house
E7 8EG - 631,000
- Freehold Terraced
E7 8EG - 575,000
- Freehold Mid terrace house
E7 8EG - 615,000
- Freehold Mid terrace house
E7 8EG - 574,000
- Freehold Mid terrace house
E7 8EG - 623,000
- Freehold Terraced
E7 8EG - 595,000
- Freehold End terrace house
E7 8EG - 568,000
- Mid terrace house
E7 8EG - 641,000
- Freehold Terraced
E7 8EG - 311,000
- Leasehold Converted flat
E7 8EG - 327,000
- Leasehold Converted flat
E7 8EG - 584,000
- Mid terrace house
E7 8EG - 590,000
- Freehold Mid terrace house
E7 8EG - 586,000
- Freehold Mid terrace house
E7 8EG - 563,000
- Freehold Mid terrace house
E7 8EG - 562,000
- Freehold Mid terrace house
E7 8EG - 566,000
- Mid terrace house
E7 8EG - 566,000
- Freehold Terrace property
E7 8EG - 565,000
- Freehold Terraced
E7 8EG - 575,000
- Freehold Mid terrace house
