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 5TG' order by fulladdress
HP22 5TG - 567,000
- Freehold Detached house
HP22 5TG - 590,000
- Freehold Detached house
HP22 5TG - 617,000
- Freehold Detached house
HP22 5TG - 574,000
- Freehold Semi-detached house
HP22 5TG - 644,000
- Freehold Detached bungalow
HP22 5TG - 938,000
- Freehold Detached house
HP22 5TG - 745,000
- Freehold Detached bungalow
HP22 5TG - 433,000
- Freehold Semi-detached bungalow
HP22 5TG - 855,000
- Freehold Detached bungalow
HP22 5TG - 478,000
- Freehold Semi-detached house
HP22 5TG - 717,000
- Freehold Detached house
HP22 5TG - 604,000
- Freehold Semi-detached house
HP22 5TG - 467,000
- Leasehold End terrace house
HP22 5TG - 840,000
- Freehold Detached house
HP22 5TG - 844,000
- Freehold Detached house
HP22 5TG - 870,000
- Freehold Detached property
HP22 5TG - 908,000
- Freehold Detached house
HP22 5TG - 756,000
- Freehold Detached house
HP22 5TG - 750,000
- Freehold Detached house
HP22 5TG - 866,000
- Freehold Detached house
HP22 5TG - 818,000
- Freehold Detached house
HP22 5TG - 900,000
- Freehold Detached house
HP22 5TG - 933,000
- Freehold Detached house
HP22 5TG - 1,333,000
- Freehold Detached house
HP22 5TG - 807,000
- Freehold Detached house
HP22 5TG - 922,000
- Freehold Detached house
HP22 5TG - 729,000
- Freehold Detached property
HP22 5TG - 731,000
- Freehold Detached house
HP22 5TG - 820,000
- Freehold Detached house
HP22 5TG - 829,000
- Freehold Detached bungalow
HP22 5TG - 701,000
- Freehold Semi-detached house
HP22 5TG - 645,000
- Freehold Semi-detached house
HP22 5TG - 622,000
- Freehold Semi-detached property
HP22 5TG - 629,000
- Freehold Semi-detached house
HP22 5TG - 891,000
- Freehold Detached house
HP22 5TG - 794,000
- Freehold Detached bungalow
HP22 5TG - 810,000
- Freehold Detached bungalow
HP22 5TG - 831,000
- Freehold Detached house
