SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP11 1BX' order by fulladdress
HP11 1BX - 277,000
- Leasehold Flat/Maisonette
HP11 1BX - 447,000
- Leasehold Flat/Maisonette
HP11 1BX - 307,000
- Leasehold Flat/Maisonette
HP11 1BX - 324,000
- Leasehold Purpose built flat
HP11 1BX - 682,000
- Freehold Detached property
HP11 1BX - 583,000
- Freehold Semi-detached house
HP11 1BX - 580,000
- Freehold Semi-detached house
HP11 1BX - 933,000
- Freehold Detached house
HP11 1BX - 328,000
- Leasehold Flat/Maisonette
HP11 1BX - 297,000
- Leasehold Flat/Maisonette
HP11 1BX - 279,000
- Leasehold Flat/Maisonette
HP11 1BX - 306,000
- Feudal Purpose built flat
HP11 1BX - 319,000
- Leasehold Purpose built flat
HP11 1BX - 309,000
- Leasehold Purpose built flat
HP11 1BX - 326,000
- Leasehold Flat/Maisonette
HP11 1BX - 322,000
- Leasehold Purpose built flat
HP11 1BX - 311,000
- Leasehold Purpose built flat
HP11 1BX - 310,000
- Freehold Purpose built flat
HP11 1BX - 811,000
- Freehold Mid terrace house
HP11 1BX - 686,000
- Freehold End terrace house
HP11 1BX - 734,000
- Freehold Semi-detached house
HP11 1BX - 276,000
- Leasehold Flat/Maisonette
HP11 1BX - 685,000
- Freehold Mid terrace house
HP11 1BX - 703,000
- Freehold Semi-detached house
HP11 1BX - 682,000
- Freehold End terrace house
HP11 1BX - 684,000
- Freehold Semi-detached house
HP11 1BX - 692,000
- Freehold Semi-detached house
HP11 1BX - 731,000
- Freehold Semi-detached house
HP11 1BX - 669,000
- Freehold Mid terrace house
HP11 1BX - 733,000
- Freehold End terrace house
HP11 1BX - 757,000
- Freehold Detached house
HP11 1BX - 630,000
- Freehold Semi-detached house
HP11 1BX - 246,000
- Leasehold Purpose built flat
HP11 1BX - 696,000
- Freehold Detached house
HP11 1BX - 691,000
- Freehold End terrace house
HP11 1BX - 733,000
- Freehold Mid terrace house
HP11 1BX - 300,000
- Leasehold Purpose built flat
