SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='L1 8LP' order by fulladdress
L1 8LP - 177,000
- Leasehold Flat/Maisonette
L1 8LP - 227,000
- Leasehold Flat/Maisonette
L1 8LP - 272,000
- Leasehold Flat/Maisonette
L1 8LP - 128,000
- Leasehold Flat/Maisonette
L1 8LP - 166,000
- Leasehold Flat/Maisonette
L1 8LP - 250,000
- Leasehold Purpose built flat
L1 8LP - 237,000
- Leasehold Flat/Maisonette
L1 8LP - 239,000
- Leasehold Flat/Maisonette
L1 8LP - 182,000
- Leasehold Flat/Maisonette
L1 8LP - 112,000
- Leasehold Flat/Maisonette
L1 8LP - 170,000
- Leasehold Flat/Maisonette
L1 8LP - 177,000
- Leasehold Flat/Maisonette
L1 8LP - 245,000
- Leasehold Flat/Maisonette
L1 8LP - 266,000
- Leasehold Flat/Maisonette
L1 8LP - 219,000
- Purpose built flat
L1 8LP - 185,000
- Leasehold Flat/Maisonette
L1 8LP - 240,000
- Leasehold Flat/Maisonette
L1 8LP - 234,000
- Leasehold Purpose built flat
L1 8LP - 236,000
- Leasehold Purpose built flat
L1 8LP - 152,000
- Leasehold Flat/Maisonette
L1 8LP - 117,000
- Leasehold Flat/Maisonette
L1 8LP - 176,000
- Leasehold Flat/Maisonette
L1 8LP - 174,000
- Leasehold Flat/Maisonette
L1 8LP - 249,000
- Leasehold Flat/Maisonette
L1 8LP - 256,000
- Leasehold Flat/Maisonette
L1 8LP - 140,000
- Leasehold Purpose built flat
L1 8LP - 178,000
- Leasehold Flat/Maisonette
L1 8LP - 246,000
- Leasehold Flat/Maisonette
L1 8LP - 267,000
- Leasehold Purpose built flat
L1 8LP - 227,000
- Leasehold Flat/Maisonette
L1 8LP - 116,000
- Leasehold Flat/Maisonette
L1 8LP - 136,000
- Leasehold Purpose built flat
L1 8LP - 155,000
- Leasehold Purpose built flat
L1 8LP - 174,000
- Leasehold Flat/Maisonette
L1 8LP - 172,000
- Leasehold Flat/Maisonette
L1 8LP - 306,000
- Leasehold Flat/Maisonette
L1 8LP - 229,000
- Leasehold Purpose built flat
L1 8LP - 146,000
- Leasehold Flat/Maisonette
L1 8LP - 175,000
- Leasehold Flat/Maisonette
L1 8LP - 164,000
- Leasehold Flat/Maisonette
L1 8LP - 239,000
- Leasehold Flat/Maisonette
L1 8LP - 253,000
- Leasehold Flat/Maisonette
L1 8LP - 171,000
- Leasehold Flat/Maisonette
L1 8LP - 219,000
- Leasehold Flat/Maisonette
L1 8LP - 214,000
- Freehold Flat/Maisonette
L1 8LP - 224,000
- Leasehold Purpose built flat
L1 8LP - 117,000
- Leasehold Flat/Maisonette
L1 8LP - 169,000
- Leasehold Flat/Maisonette
L1 8LP - 176,000
- Leasehold Flat/Maisonette
L1 8LP - 240,000
- Leasehold Flat/Maisonette
L1 8LP - 153,000
- Leasehold Flat/Maisonette
L1 8LP - 193,000
- Leasehold Flat/Maisonette
L1 8LP - 236,000
- Leasehold Purpose built flat
L1 8LP - 246,000
- Leasehold Flat/Maisonette
L1 8LP - 239,000
- Leasehold Flat/Maisonette
L1 8LP - 163,000
- Leasehold Flat/Maisonette
L1 8LP - 188,000
- Leasehold Flat/Maisonette
L1 8LP - 162,000
- Leasehold Purpose built flat
L1 8LP - 224,000
- Leasehold Flat/Maisonette
L1 8LP - 234,000
- Leasehold Flat/Maisonette
L1 8LP - 165,000
- Leasehold Flat/Maisonette
L1 8LP - 183,000
- Leasehold Flat/Maisonette
L1 8LP - 244,000
- Leasehold Flat/Maisonette
L1 8LP - 242,000
- Leasehold Purpose built flat
L1 8LP - 114,000
- Leasehold Flat/Maisonette
L1 8LP - 114,000
- Leasehold Flat/Maisonette
L1 8LP - 171,000
- Leasehold Flat/Maisonette