SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='AL5 5PJ' order by fulladdress
AL5 5PJ - 1,451,000
- Freehold Semi-detached house
AL5 5PJ - 1,149,000
- Freehold Semi-detached house
AL5 5PJ - 1,340,000
- Freehold Semi-detached house
AL5 5PJ - 1,380,000
- Freehold Detached house
AL5 5PJ - 1,013,000
- Freehold Semi-detached house
AL5 5PJ - 1,360,000
- Freehold Semi-detached house
AL5 5PJ - 1,360,000
- Freehold Semi-detached house
AL5 5PJ - 1,104,000
- Freehold Semi-detached house
AL5 5PJ - 1,064,000
- Freehold Semi-detached house
AL5 5PJ - 1,148,000
- Freehold Semi-detached house
AL5 5PJ - 1,159,000
- Freehold Semi-detached house
AL5 5PJ - 1,112,000
- Freehold Semi-detached house
AL5 5PJ - 1,227,000
- Freehold Semi-detached house
AL5 5PJ - 1,043,000
- Freehold Semi-detached house
AL5 5PJ - 1,123,000
- Freehold Semi-detached house
AL5 5PJ - 1,211,000
- Freehold Semi-detached house
AL5 5PJ - 1,170,000
- Freehold Semi-detached house
AL5 5PJ - 897,000
- Freehold Terrace property
AL5 5PJ - 1,172,000
- Freehold Semi-detached house
AL5 5PJ - 1,068,000
- Freehold Semi-detached house
AL5 5PJ - 1,072,000
- Freehold Semi-detached house
AL5 5PJ - 1,165,000
- Freehold Semi-detached house
AL5 5PJ - 1,229,000
- Freehold Semi-detached house
AL5 5PJ - 1,180,000
- Freehold Semi-detached house
AL5 5PJ - 1,299,000
- Freehold Semi-detached house
AL5 5PJ - 1,171,000
- Freehold Semi-detached house
AL5 5PJ - 1,183,000
- Semi-detached house
AL5 5PJ - 1,087,000
- Freehold Semi-detached house
AL5 5PJ - 986,000
- Freehold Semi-detached house
AL5 5PJ - 703,000
- Freehold Semi-detached house
AL5 5PJ - 1,372,000
- Freehold Detached house
AL5 5PJ - 1,551,000
- Freehold Detached house
AL5 5PJ - 1,704,000
- Freehold Detached house
AL5 5PJ - 1,618,000
- Freehold Detached house
AL5 5PJ - 1,189,000
- Freehold Semi-detached house
AL5 5PJ - 388,000
- Leasehold Flat/Maisonette
AL5 5PJ - 404,000
- Leasehold Flat/Maisonette
AL5 5PJ - 392,000
- Leasehold Purpose built flat
AL5 5PJ - 398,000
- Leasehold Flat/Maisonette