SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP22 4BX' order by fulladdress
HP22 4BX - 385,000
- Freehold End terrace house
HP22 4BX - 366,000
- Freehold Mid terrace house
HP22 4BX - 705,000
- Freehold Detached property
HP22 4BX - 461,000
- Freehold Semi-detached property
HP22 4BX - 551,000
- Freehold Semi-detached property
HP22 4BX - 689,000
- Freehold Detached bungalow
HP22 4BX - 758,000
- Freehold Detached bungalow
HP22 4BX - 623,000
- Freehold Detached bungalow
HP22 4BX - 863,000
- Freehold Detached house
HP22 4BX - 774,000
- Freehold Detached house
HP22 4BX - 829,000
- Freehold Detached house
HP22 4BX - 672,000
- Freehold Detached house
HP22 4BX - 1,025,000
- Freehold Detached house
HP22 4BX - 729,000
- Freehold Detached house
HP22 4BX - 743,000
- Freehold Detached house
HP22 4BX - 728,000
- Freehold Detached property
HP22 4BX - 680,000
- Freehold Detached bungalow
HP22 4BX - 773,000
- Freehold Detached house
HP22 4BX - 724,000
- Freehold Detached house
HP22 4BX - 519,000
- Freehold Semi-detached property
HP22 4BX - 319,000
- Leasehold Semi-detached house
HP22 4BX - 318,000
- Freehold Semi-detached house
HP22 4BX - 308,000
- Leasehold Semi-detached house
HP22 4BX - 320,000
- Leasehold Semi-detached house
HP22 4BX - 618,000
- Freehold Detached property
HP22 4BX - 717,000
- Freehold Detached house
HP22 4BX - 820,000
- Freehold Detached house
HP22 4BX - 986,000
- Freehold Detached house
HP22 4BX - 789,000
- Freehold Detached house
HP22 4BX - 905,000
- Freehold Detached property
HP22 4BX - 498,000
- Freehold Semi-detached house
HP22 4BX - 343,000
- Freehold Semi-detached house
HP22 4BX - 390,000
- Freehold End terrace house
HP22 4BX - 358,000
- Freehold Mid terrace house
HP22 4BX - 364,000
- Freehold End terrace house
HP22 4BX - 329,000
- Freehold End terrace house
HP22 4BX - 691,000
- Freehold Detached house
