SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E8 3FU' order by fulladdress
E8 3FU - 1,028,000
- End terrace house
E8 3FU - 1,025,000
- Mid terrace house
E8 3FU - 776,000
- Leasehold Purpose built flat
E8 3FU - 742,000
- Leasehold Flat/Maisonette
E8 3FU - 829,000
- Purpose built flat
E8 3FU - 826,000
- Leasehold Purpose built flat
E8 3FU - 817,000
- Mid terrace house
E8 3FU - 1,018,000
- Mid terrace house
E8 3FU - 1,015,000
- Mid terrace house
E8 3FU - 969,000
- Mid terrace house
E8 3FU - 857,000
- Freehold Mid terrace house
E8 3FU - 1,040,000
- Freehold Mid terrace house
E8 3FU - 532,000
- Leasehold Purpose built flat
E8 3FU - 537,000
- Leasehold Flat/Maisonette
E8 3FU - 535,000
- Leasehold Purpose built flat
E8 3FU - 711,000
- Leasehold Purpose built flat
E8 3FU - 540,000
- Feudal Purpose built flat
E8 3FU - 658,000
- Leasehold Flat/Maisonette
E8 3FU - 521,000
- Leasehold Purpose built flat
E8 3FU - 514,000
- Leasehold Purpose built flat
E8 3FU - 769,000
- Leasehold Purpose built flat
E8 3FU - 560,000
- Leasehold Flat/Maisonette
E8 3FU - 478,000
- Leasehold Purpose built flat
E8 3FU - 685,000
- Leasehold Purpose built flat
E8 3FU - 679,000
- Leasehold Flat/Maisonette
E8 3FU - 503,000
- Leasehold Purpose built flat
E8 3FU - 700,000
- Leasehold Flat/Maisonette
E8 3FU - 531,000
- Leasehold Purpose built flat
E8 3FU - 840,000
- Leasehold Purpose built flat
E8 3FU - 696,000
- Leasehold Purpose built flat
E8 3FU - 714,000
- Leasehold Purpose built flat
E8 3FU - 775,000
- Leasehold Flat/Maisonette
E8 3FU - 680,000
- Leasehold Purpose built flat
E8 3FU - 532,000
- Leasehold Purpose built flat
E8 3FU - 692,000
- Feudal Purpose built flat
E8 3FU - 682,000
- Leasehold Purpose built flat
E8 3FU - 529,000
- Feudal Purpose built flat
E8 3FU - 725,000
- Leasehold Purpose built flat
E8 3FU - 674,000
- Leasehold Purpose built flat
E8 3FU - 770,000
- Leasehold Purpose built flat