SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN3 2PL' order by fulladdress
BN3 2PL - 471,000
- Leasehold Converted flat
BN3 2PL - 620,000
- Leasehold Converted flat
BN3 2PL - 314,000
- Leasehold Flat/Maisonette
BN3 2PL - 327,000
- Leasehold Flat/Maisonette
BN3 2PL - 499,000
- Leasehold Flat/Maisonette
BN3 2PL - 866,000
- Leasehold Converted flat
BN3 2PL - 295,000
- Leasehold Flat/Maisonette
BN3 2PL - 696,000
- Leasehold Converted flat
BN3 2PL - 367,000
- Leasehold Flat/Maisonette
BN3 2PL - 601,000
- Leasehold Converted flat
BN3 2PL - 305,000
- Leasehold Flat/Maisonette
BN3 2PL - 436,000
- Leasehold Converted flat
BN3 2PL - 662,000
- Leasehold Flat/Maisonette
BN3 2PL - 684,000
- Leasehold Flat/Maisonette
BN3 2PL - 453,000
- Leasehold Converted flat
BN3 2PL - 448,000
- Leasehold Converted flat
BN3 2PL - 441,000
- Leasehold Converted flat
BN3 2PL - 576,000
- Leasehold Converted flat
BN3 2PL - 413,000
- Leasehold Flat/Maisonette
BN3 2PL - 260,000
- Leasehold Converted flat
BN3 2PL - 432,000
- Leasehold Flat/Maisonette
BN3 2PL - 453,000
- Leasehold Flat/Maisonette
BN3 2PL - 582,000
- Leasehold Flat/Maisonette
BN3 2PL - 358,000
- Leasehold Flat/Maisonette
BN3 2PL - 424,000
- Leasehold Converted flat
BN3 2PL - 347,000
- Leasehold Flat/Maisonette
BN3 2PL - 375,000
- Leasehold Converted flat
BN3 2PL - 376,000
- Leasehold Flat/Maisonette
BN3 2PL - 382,000
- Leasehold Converted flat
BN3 2PL - 336,000
- Leasehold Converted flat