SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PO1 3FR' order by fulladdress
PO1 3FR - 252,000
- Leasehold Flat/Maisonette
PO1 3FR - 213,000
- Leasehold Purpose built flat
PO1 3FR - 356,000
- Leasehold Purpose built flat
PO1 3FR - 379,000
- Leasehold Flat/Maisonette
PO1 3FR - 446,000
- Leasehold Flat/Maisonette
PO1 3FR - 661,000
- Leasehold Flat/Maisonette
PO1 3FR - 260,000
- Leasehold Flat/Maisonette
PO1 3FR - 254,000
- Leasehold Purpose built flat
PO1 3FR - 232,000
- Leasehold Flat/Maisonette
PO1 3FR - 203,000
- Leasehold Flat/Maisonette
PO1 3FR - 415,000
- Leasehold Flat/Maisonette
PO1 3FR - 356,000
- Leasehold Flat/Maisonette
PO1 3FR - 500,000
- Leasehold Purpose built flat
PO1 3FR - 505,000
- Leasehold Flat/Maisonette
PO1 3FR - 246,000
- Feudal Purpose built flat
PO1 3FR - 261,000
- Leasehold Purpose built flat
PO1 3FR - 204,000
- Leasehold Flat/Maisonette
PO1 3FR - 349,000
- Leasehold Flat/Maisonette
PO1 3FR - 338,000
- Leasehold Flat/Maisonette
PO1 3FR - 315,000
- Leasehold Flat/Maisonette
PO1 3FR - 529,000
- Leasehold Flat/Maisonette
PO1 3FR - 219,000
- Leasehold Flat/Maisonette
PO1 3FR - 244,000
- Leasehold Flat/Maisonette
PO1 3FR - 241,000
- Leasehold Flat/Maisonette
PO1 3FR - 401,000
- Leasehold Flat/Maisonette
PO1 3FR - 383,000
- Leasehold Flat/Maisonette
PO1 3FR - 465,000
- Leasehold Flat/Maisonette
PO1 3FR - 666,000
- Leasehold Flat/Maisonette
PO1 3FR - 234,000
- Leasehold Flat/Maisonette
PO1 3FR - 250,000
- Leasehold Purpose built flat
PO1 3FR - 276,000
- Leasehold Flat/Maisonette
PO1 3FR - 257,000
- Leasehold Flat/Maisonette
PO1 3FR - 415,000
- Leasehold Purpose built flat
PO1 3FR - 336,000
- Leasehold Flat/Maisonette
PO1 3FR - 499,000
- Leasehold Flat/Maisonette
PO1 3FR - 537,000
- Leasehold Flat/Maisonette
PO1 3FR - 285,000
- Leasehold Flat/Maisonette
PO1 3FR - 271,000
- Leasehold Flat/Maisonette
PO1 3FR - 257,000
- Leasehold Flat/Maisonette
PO1 3FR - 342,000
- Leasehold Flat/Maisonette
PO1 3FR - 355,000
- Leasehold Flat/Maisonette
PO1 3FR - 218,000
- Leasehold Purpose built flat
PO1 3FR - 377,000
- Leasehold Flat/Maisonette
PO1 3FR - 683,000
- Leasehold Flat/Maisonette
PO1 3FR - 261,000
- Leasehold Flat/Maisonette
PO1 3FR - 287,000
- Leasehold Flat/Maisonette
PO1 3FR - 238,000
- Leasehold Flat/Maisonette
PO1 3FR - 395,000
- Leasehold Flat/Maisonette
PO1 3FR - 394,000
- Leasehold Purpose built flat
PO1 3FR - 455,000
- Leasehold Purpose built flat
PO1 3FR - 590,000
- Leasehold Purpose built flat
PO1 3FR - 246,000
- Leasehold Flat/Maisonette
PO1 3FR - 294,000
- Leasehold Flat/Maisonette
PO1 3FR - 285,000
- Leasehold Flat/Maisonette
PO1 3FR - 210,000
- Leasehold Flat/Maisonette
PO1 3FR - 366,000
- Leasehold Purpose built flat
PO1 3FR - 389,000
- Leasehold Purpose built flat
PO1 3FR - 476,000
- Leasehold Flat/Maisonette
PO1 3FR - 565,000
- Leasehold Flat/Maisonette
PO1 3FR - 252,000
- Leasehold Flat/Maisonette
PO1 3FR - 262,000
- Leasehold Flat/Maisonette
PO1 3FR - 287,000
- Leasehold Flat/Maisonette
PO1 3FR - 491,000
- Leasehold Purpose built flat
PO1 3FR - 463,000
- Leasehold Purpose built flat
PO1 3FR - 358,000
- Leasehold Flat/Maisonette
PO1 3FR - 514,000
- Leasehold Purpose built flat
PO1 3FR - 258,000
- Leasehold Flat/Maisonette